375 |
375 |
376 RSqlStatement sqlReadStatement; |
376 RSqlStatement sqlReadStatement; |
377 TInt paramIndex(KErrNone); |
377 TInt paramIndex(KErrNone); |
378 |
378 |
379 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadAuthTokens); |
379 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadAuthTokens); |
|
380 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
381 |
380 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
382 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
381 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
383 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
382 |
384 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
385 |
383 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
386 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
384 { |
387 { |
385 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
388 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
386 if (!sqlReadStatement.IsNull(0)) |
389 if (!sqlReadStatement.IsNull(0)) |
387 { |
390 { |
422 |
425 |
423 RSqlStatement sqlReadStatement; |
426 RSqlStatement sqlReadStatement; |
424 TInt paramIndex(KErrNone); |
427 TInt paramIndex(KErrNone); |
425 |
428 |
426 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadURL); |
429 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadURL); |
|
430 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
427 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
431 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
428 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
432 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
|
433 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
429 |
434 |
430 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
435 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
431 { |
436 { |
432 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
437 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
433 if (!sqlReadStatement.IsNull(0)) |
438 if (!sqlReadStatement.IsNull(0)) |
457 |
462 |
458 RSqlStatement sqlReadStatement; |
463 RSqlStatement sqlReadStatement; |
459 TInt paramIndex(KErrNone); |
464 TInt paramIndex(KErrNone); |
460 |
465 |
461 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadValidity); |
466 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadValidity); |
|
467 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
462 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
468 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
463 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
469 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
|
470 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
464 |
471 |
465 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
472 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
466 { |
473 { |
467 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
474 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
468 if (!sqlReadStatement.IsNull(0)) |
475 if (!sqlReadStatement.IsNull(0)) |
490 |
497 |
491 RSqlStatement sqlReadStatement; |
498 RSqlStatement sqlReadStatement; |
492 TInt paramIndex(KErrNone); |
499 TInt paramIndex(KErrNone); |
493 |
500 |
494 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadRegistrationToken); |
501 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadRegistrationToken); |
|
502 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
503 |
495 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
504 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
496 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
505 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
|
506 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
497 |
507 |
498 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
508 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
499 { |
509 { |
500 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
510 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
501 if (!sqlReadStatement.IsNull(0)) |
511 if (!sqlReadStatement.IsNull(0)) |
525 TInt paramIndex(KErrNone); |
535 TInt paramIndex(KErrNone); |
526 TInt64 duration; |
536 TInt64 duration; |
527 TBuf<KMaxBufSize> tokenBuf(aRegToken); |
537 TBuf<KMaxBufSize> tokenBuf(aRegToken); |
528 err = sqlReadStatement.Prepare(iDataBase, |
538 err = sqlReadStatement.Prepare(iDataBase, |
529 KSmfDbReadAuthAppIdInRegTokenTable); |
539 KSmfDbReadAuthAppIdInRegTokenTable); |
|
540 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
541 |
530 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
542 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
531 err = sqlReadStatement.BindText(paramIndex, tokenBuf); |
543 err = sqlReadStatement.BindText(paramIndex, tokenBuf); |
|
544 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
532 |
545 |
533 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
546 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
534 { |
547 { |
535 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
548 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
536 if (!sqlReadStatement.IsNull(0)) |
549 if (!sqlReadStatement.IsNull(0)) |
562 |
575 |
563 RSqlStatement sqlReadStatement; |
576 RSqlStatement sqlReadStatement; |
564 TInt paramIndex(KErrNone); |
577 TInt paramIndex(KErrNone); |
565 |
578 |
566 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadAuthAppIdInPluginTable); |
579 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadAuthAppIdInPluginTable); |
|
580 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
567 |
581 |
568 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
582 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
569 err = sqlReadStatement.BindText(paramIndex, aPluginID); |
583 err = sqlReadStatement.BindText(paramIndex, aPluginID); |
|
584 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
570 |
585 |
571 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
586 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
572 { |
587 { |
573 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
588 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
574 if (!sqlReadStatement.IsNull(0)) |
589 if (!sqlReadStatement.IsNull(0)) |
591 |
606 |
592 RSqlStatement sqlReadStatement; |
607 RSqlStatement sqlReadStatement; |
593 TInt paramIndex(KErrNone); |
608 TInt paramIndex(KErrNone); |
594 |
609 |
595 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadFlagInPluginTable); |
610 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadFlagInPluginTable); |
596 |
611 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
612 |
597 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
613 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
598 err = sqlReadStatement.BindText(paramIndex, aPluginID); |
614 err = sqlReadStatement.BindText(paramIndex, aPluginID); |
599 |
615 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
616 |
600 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
617 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
601 { |
618 { |
602 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
619 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
603 if (!sqlReadStatement.IsNull(0)) |
620 if (!sqlReadStatement.IsNull(0)) |
604 { |
621 { |
630 |
647 |
631 err = db.Open(iDbFilePathName); |
648 err = db.Open(iDbFilePathName); |
632 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
649 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
633 |
650 |
634 err = sqlStatement.Prepare(db, KUpdatePluginID); |
651 err = sqlStatement.Prepare(db, KUpdatePluginID); |
|
652 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
635 |
653 |
636 paramIndex = sqlStatement.ParameterIndex(_L(":iText")); |
654 paramIndex = sqlStatement.ParameterIndex(_L(":iText")); |
637 err = sqlStatement.BindText(paramIndex, newPluginBuf); |
655 err = sqlStatement.BindText(paramIndex, newPluginBuf); |
|
656 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
638 |
657 |
639 paramIndex = sqlStatement.ParameterIndex(_L(":iFlag")); |
658 paramIndex = sqlStatement.ParameterIndex(_L(":iFlag")); |
640 err = sqlStatement.BindInt(paramIndex, aFlag); |
659 err = sqlStatement.BindInt(paramIndex, aFlag); |
641 |
660 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
661 |
642 paramIndex = sqlStatement.ParameterIndex(_L(":iID")); |
662 paramIndex = sqlStatement.ParameterIndex(_L(":iID")); |
643 err = sqlStatement.BindText(paramIndex, OldPluginBuf); |
663 err = sqlStatement.BindText(paramIndex, OldPluginBuf); |
644 |
664 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
665 |
645 err = db.Exec(KBegin); |
666 err = db.Exec(KBegin); |
646 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
667 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
647 err = sqlStatement.Exec(); |
668 err = sqlStatement.Exec(); |
648 if (KSqlErrConstraint == err) |
669 if (KSqlErrConstraint == err) |
649 { |
670 { |
684 RSqlStatement sqlReadStatement; |
705 RSqlStatement sqlReadStatement; |
685 TInt paramIndex(KErrNone); |
706 TInt paramIndex(KErrNone); |
686 TInt flag; |
707 TInt flag; |
687 |
708 |
688 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadPluginID); |
709 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadPluginID); |
|
710 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
689 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
711 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
690 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
712 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
691 |
713 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
714 |
692 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
715 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
693 { |
716 { |
694 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
717 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
695 if (!sqlReadStatement.IsNull(0)) |
718 if (!sqlReadStatement.IsNull(0)) |
696 { |
719 { |