380 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
380 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
381 |
381 |
382 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
382 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
383 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
383 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
384 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
384 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
385 |
385 |
386 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
386 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
387 { |
387 { |
388 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
388 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
389 if (!sqlReadStatement.IsNull(0)) |
389 if (!sqlReadStatement.IsNull(0)) |
390 { |
390 { |
607 RSqlStatement sqlReadStatement; |
607 RSqlStatement sqlReadStatement; |
608 TInt paramIndex(KErrNone); |
608 TInt paramIndex(KErrNone); |
609 |
609 |
610 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadFlagInPluginTable); |
610 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadFlagInPluginTable); |
611 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
611 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
612 |
612 |
613 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
613 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
614 err = sqlReadStatement.BindText(paramIndex, aPluginID); |
614 err = sqlReadStatement.BindText(paramIndex, aPluginID); |
615 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
615 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
616 |
616 |
617 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
617 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
618 { |
618 { |
619 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
619 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
620 if (!sqlReadStatement.IsNull(0)) |
620 if (!sqlReadStatement.IsNull(0)) |
621 { |
621 { |
656 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
656 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
657 |
657 |
658 paramIndex = sqlStatement.ParameterIndex(_L(":iFlag")); |
658 paramIndex = sqlStatement.ParameterIndex(_L(":iFlag")); |
659 err = sqlStatement.BindInt(paramIndex, aFlag); |
659 err = sqlStatement.BindInt(paramIndex, aFlag); |
660 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
660 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
661 |
661 |
662 paramIndex = sqlStatement.ParameterIndex(_L(":iID")); |
662 paramIndex = sqlStatement.ParameterIndex(_L(":iID")); |
663 err = sqlStatement.BindText(paramIndex, OldPluginBuf); |
663 err = sqlStatement.BindText(paramIndex, OldPluginBuf); |
664 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
664 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
665 |
665 |
666 err = db.Exec(KBegin); |
666 err = db.Exec(KBegin); |
667 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
667 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
668 err = sqlStatement.Exec(); |
668 err = sqlStatement.Exec(); |
669 if (KSqlErrConstraint == err) |
669 if (KSqlErrConstraint == err) |
670 { |
670 { |
709 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadPluginID); |
709 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadPluginID); |
710 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
710 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
711 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
711 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
712 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
712 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
713 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
713 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
714 |
714 |
715 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
715 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
716 { |
716 { |
717 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
717 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
718 if (!sqlReadStatement.IsNull(0)) |
718 if (!sqlReadStatement.IsNull(0)) |
719 { |
719 { |
732 __ASSERT_DEBUG( 0, User::Invariant()); |
732 __ASSERT_DEBUG( 0, User::Invariant()); |
733 } |
733 } |
734 } |
734 } |
735 sqlReadStatement.Close(); |
735 sqlReadStatement.Close(); |
736 } |
736 } |
|
737 |
|
738 void CSmfCredMgrDbUser::checkServiceAuthenticationL(const TDesC& aAuthAppId, |
|
739 TBool& isAuthorised ) |
|
740 { |
|
741 TInt err(KErrNone); |
|
742 isAuthorised = EFalse; |
|
743 |
|
744 RSqlStatement sqlReadStatement; |
|
745 TInt paramIndex(KErrNone); |
|
746 |
|
747 err = sqlReadStatement.Prepare(iDataBase, KSmfDbReadAuthTokens); |
|
748 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
749 paramIndex = sqlReadStatement.ParameterIndex(_L(":iID")); |
|
750 err = sqlReadStatement.BindText(paramIndex, aAuthAppId); |
|
751 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
752 while ((err = sqlReadStatement.Next()) == KSqlAtRow) |
|
753 { |
|
754 //sometimes sqlStmt.Next returns KSqlAtRow even if no row is present |
|
755 if (!sqlReadStatement.IsNull(0)) |
|
756 { |
|
757 // Element found means some key sets are |
|
758 // available in the database for this auth app |
|
759 isAuthorised = ETrue; |
|
760 break; |
|
761 } |
|
762 else |
|
763 { |
|
764 __ASSERT_DEBUG( 0, User::Invariant()); |
|
765 } |
|
766 } |
|
767 sqlReadStatement.Close(); |
|
768 } |
|
769 |
|
770 bool CSmfCredMgrDbUser::deleteAuthDataSetL( const TDesC& aAuthAppId ) |
|
771 { |
|
772 TInt err(KErrNone); |
|
773 TBool deleted = EFalse; |
|
774 |
|
775 RSqlStatement sqlDeleteStatement; |
|
776 TInt paramIndex(KErrNone); |
|
777 |
|
778 err = sqlDeleteStatement.Prepare(iDataBase, KSmfDbDeleteAuthTokens); |
|
779 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
780 paramIndex = sqlDeleteStatement.ParameterIndex(_L(":iID")); |
|
781 err = sqlDeleteStatement.BindText(paramIndex, aAuthAppId); |
|
782 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
783 |
|
784 err = sqlDeleteStatement.Exec(); |
|
785 |
|
786 if(err >= 0) |
|
787 deleted = ETrue; |
|
788 |
|
789 sqlDeleteStatement.Close(); |
|
790 |
|
791 return deleted; |
|
792 } |
|
793 |
|
794 bool CSmfCredMgrDbUser::deletePluginListL( const TDesC& aAuthAppId ) |
|
795 { |
|
796 TInt err(KErrNone); |
|
797 TBool deleted = EFalse; |
|
798 |
|
799 RSqlStatement sqlDeleteStatement; |
|
800 TInt paramIndex(KErrNone); |
|
801 |
|
802 err = sqlDeleteStatement.Prepare(iDataBase, KSmfDbDeletePluginList); |
|
803 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
804 paramIndex = sqlDeleteStatement.ParameterIndex(_L(":iID")); |
|
805 err = sqlDeleteStatement.BindText(paramIndex, aAuthAppId); |
|
806 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
807 |
|
808 err = sqlDeleteStatement.Exec(); |
|
809 |
|
810 if(err >= 0) |
|
811 deleted = ETrue; |
|
812 |
|
813 sqlDeleteStatement.Close(); |
|
814 |
|
815 return deleted; |
|
816 } |
|
817 |
|
818 bool CSmfCredMgrDbUser::deleteRegTokenValidityL( const TDesC& aAuthAppId ) |
|
819 { |
|
820 TInt err(KErrNone); |
|
821 TBool deleted = EFalse; |
|
822 |
|
823 RSqlStatement sqlDeleteStatement; |
|
824 TInt paramIndex(KErrNone); |
|
825 |
|
826 err = sqlDeleteStatement.Prepare(iDataBase, KSmfDbDeleteRegTokenValidity); |
|
827 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
828 paramIndex = sqlDeleteStatement.ParameterIndex(_L(":iID")); |
|
829 err = sqlDeleteStatement.BindText(paramIndex, aAuthAppId); |
|
830 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
831 |
|
832 err = sqlDeleteStatement.Exec(); |
|
833 |
|
834 if(err >= 0) |
|
835 deleted = ETrue; |
|
836 |
|
837 sqlDeleteStatement.Close(); |
|
838 |
|
839 return deleted; |
|
840 } |
|
841 |
|
842 bool CSmfCredMgrDbUser::deleteURLListL( const TDesC& aAuthAppId ) |
|
843 { |
|
844 TInt err(KErrNone); |
|
845 TBool deleted = EFalse; |
|
846 |
|
847 RSqlStatement sqlDeleteStatement; |
|
848 TInt paramIndex(KErrNone); |
|
849 |
|
850 err = sqlDeleteStatement.Prepare(iDataBase, KSmfDbDeleteURLList); |
|
851 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
852 paramIndex = sqlDeleteStatement.ParameterIndex(_L(":iID")); |
|
853 err = sqlDeleteStatement.BindText(paramIndex, aAuthAppId); |
|
854 __ASSERT_DEBUG( (err >= KErrNone), User::Invariant()); |
|
855 |
|
856 err = sqlDeleteStatement.Exec(); |
|
857 |
|
858 if(err >= 0) |
|
859 deleted = ETrue; |
|
860 |
|
861 sqlDeleteStatement.Close(); |
|
862 |
|
863 return deleted; |
|
864 } |