--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/smf/smfcredentialmgr/smfcredmgrserver/inc/smfcredmgrdbuser.h Wed Jun 23 19:51:49 2010 +0530
@@ -0,0 +1,190 @@
+/**
+ * Copyright (c) 2010 Sasken Communication Technologies Ltd.
+ * All rights reserved.
+ * This component and the accompanying materials are made available
+ * under the terms of the "Eclipse Public License v1.0"
+ * which accompanies this distribution, and is available
+ * at the URL "http://www.eclipse.org/legal/epl-v10.html"
+ *
+ * Initial Contributors:
+ * Pritam Roy Biswas, Sasken Communication Technologies Ltd - Initial contribution
+ *
+ * Description:
+ * This header provides a handle to use the data-base operations like insertion, query etc. which
+ * is used by the Credential Manager Server Sessions to operate on
+ * Credential Manager Server Database
+ */
+#ifndef SMFCREDMGRDBUSER_H_
+#define SMFCREDMGRDBUSER_H_
+
+#include <sqldb.h>
+#include <e32base.h>
+#include <f32file.h>
+#include "smfcredmgrserversession.h"
+
+//INSERTION
+_LIT(KBegin , "BEGIN");
+_LIT(KCommit, "COMMIT");
+_LIT(KRollback, "ROLLBACK");
+_LIT(KSmfPluginIDTableInsert, "INSERT INTO PluginIDTable(PluginId, AuthAppId, IsEnabled) VALUES(:Val1, :Val2, :Val3)");
+_LIT(KSmfURLTableInsert, "INSERT INTO URLTable(AuthAppId, URL) VALUES(:Val1, :Val2)");
+_LIT(KSmfRegTokenValidityTableInsert, "INSERT INTO RegTokenValidityTable(RegistrationToken, AuthAppId, Validity) VALUES(:Val1, :Val2, :Val3)");
+_LIT(KSmfAuthParamsTableInsert, "INSERT INTO AuthParamsTable(AuthAppId, AuthKey, AuthSecret) VALUES(:Val1, :Val2, :Val3)");
+//READ
+_LIT(KSmfDbReadValidity, "SELECT Validity FROM RegTokenValidityTable WHERE AuthAppId = :iID");
+_LIT(KSmfDbReadRegistrationToken, "SELECT RegistrationToken FROM RegTokenValidityTable WHERE AuthAppId = :iID");
+_LIT(KSmfDbReadAuthTokens, "SELECT AuthKey, AuthSecret FROM AuthParamsTable WHERE AuthAppId = :iID");
+_LIT(KSmfDbReadPluginID, "SELECT PluginId, IsEnabled FROM PluginIDTable WHERE AuthAppId = :iID");
+_LIT(KSmfDbReadURL, "SELECT URL FROM URLTable WHERE AuthAppId = :iID");
+_LIT(KSmfDbReadAuthAppIdInPluginTable, "SELECT AuthAppId FROM PluginIDTable WHERE PluginId = :iID");
+_LIT(KSmfDbReadFlagInPluginTable, "SELECT IsEnabled FROM PluginIDTable WHERE PluginId = :iID");
+_LIT(KSmfDbReadAuthAppIdInRegTokenTable, "SELECT AuthAppId, Validity FROM RegTokenValidityTable WHERE RegistrationToken = :iID");
+//UPDATE
+_LIT( KUpdatePluginID, "UPDATE PluginIDTable SET PluginId =:iText, IsEnabled =:iFlag WHERE PluginId = :iID");
+
+/**
+ * The class to use the server database i.e insert table in Db, query from Db.
+ */
+class CSmfCredMgrDbUser : public CBase
+ {
+public:
+ /**
+ * New functions
+ * @param aSession the session object using this class
+ */
+ static CSmfCredMgrDbUser* NewL(CSmfCredMgrServerSession* aSession);
+ static CSmfCredMgrDbUser* NewLC(CSmfCredMgrServerSession* aSession);
+
+ /**
+ * Destructor
+ */
+ ~CSmfCredMgrDbUser();
+
+public:
+ /**
+ * Method to insert PluginIDTable
+ * @param aPluginID ID of the plugin
+ * @param aAuthAppId ID of the Authentication app associated with the plugin
+ * @param aEnableFlag a flag to indicate if the plugin is enabled,
+ * i.e aEnableFlag =0 for disabled plugin
+ */
+ TInt PluginIDTableInsert(const TDesC& aPluginID, const TDesC& aAuthAppId,
+ TBool aEnableFlag);
+
+ /**
+ * Method to insert URLTable
+ * @param aAuthAppId ID of the Authentication app associated with the URLs
+ * @param aURL the URL to be stored
+ */
+ TInt URLTableInsert(const TDesC& aAuthAppId, const TDesC& aURL);
+
+ /**
+ * Method to insert RegTokenValidityTable
+ * @param aRegToken the Registration token for the authentication app
+ * @param aAuthAppId ID of the Authentication app
+ * @param aValidity time by which the set will expire
+ */
+ TInt RegTokenValidityTableInsert(const TDesC& aRegToken,
+ const TDesC& aAuthAppId, const TUint aValidity);
+ /**
+ * Method to insert AuthParamsTable
+ * @param aAuthAppId ID of the Authentication app
+ * @param aKey The Key
+ * @param aSecret The Secret
+ */
+ TInt AuthParamsTableInsert(const TDesC& aAuthAppId, const TDesC& aKey,
+ const TDesC& aSecret);
+
+ /**
+ * Method to fetch all the plugins associated with the registration token
+ * @param aRegToken the Registration token of the authentication app
+ * @param aArray The array to be updated with plugin ids
+ */
+ void fetchPluginList(const TDesC& aRegToken, RPointerArray<HBufC>& aArray);
+
+ /**
+ * Method to Key-Secret pairs of the Authentication app
+ * @param aAuthAppId ID of the Authentication app
+ * @param aArray The array containing the key-secret pair
+ */
+ void readAuthTokens(const TDesC& aAuthAppId, RArray<TSmfAuthToken>& aArray);
+
+ /**
+ * Method to fetch all the URLs associated with the Authentication app
+ * @param aAuthAppId ID of the Authentication app
+ * @param aArray The array to be updated with URLs
+ */
+ void readURL(const TDesC& aAuthAppId, RPointerArray<HBufC>& aArray);
+
+ /**
+ * Method to fetch Validity of the Authentication app
+ * @param aAuthAppId ID of the Authentication app
+ * @param aValidity time by which the Auth set will expire
+ */
+ void readValidity(const TDesC& aAuthAppId, TInt64& aValidity);
+
+ /**
+ * Method to fetch Registration token of the Authentication app from RegTokenValidityTable
+ * @param aAuthAppId ID of the Authentication app
+ * @param aRegToken the Registration token of the authentication app
+ */
+ void readRegistrationToken(const TDesC& aAuthAppId, TDesC& aRegToken);
+
+ /**
+ * Method to fetch Authentication app ID from RegTokenValidityTable
+ * @param aRegToken the Registration token of the authentication app
+ * @param aAuthAppId ID of the Authentication app
+ */
+ void readAuthAppIdInRegTokenTable(const TDesC& aRegToken, TDes& aAuthAppId);
+
+ /**
+ * Method to fetch Authentication app ID from PluginIDTable
+ * @param aPluginID the ID of the plugin
+ * @param aAuthAppId ID of the Authentication app
+ */
+ void readAuthAppIdInPluginIdTable(const TDesC& aPluginID, TDes& aAuthAppId);
+
+ /**
+ * Method to read the IsEnabled flag from plugin Id table
+ * @param aPluginID the ID of the plugin
+ * @param aFlag flag that indicates the plugin id is enables or disabled
+ */
+ void readFlagInPluginIdTable(const TDesC& aPluginID, TInt& aFlag);
+
+ /**
+ * Method to change a plugin id in plugin Id table
+ * @param aNewPluginID the ID of the new plugin
+ * @param aFlag flag that indicates the plugin id is enables or disabled
+ * @param aOldPluginID the ID of the plugin to be replaced
+ */
+ TInt updatePlugin(const TDesC& aPluginID, const TBool& aFlag,
+ const TDesC& aOldPluginID);
+
+ /**
+ * Method to fetch a plugin id associated with Authentication App id, it is
+ * called internally by fetchPluginList().
+ * @param aAuthAppId ID of the Authentication app
+ * @param aArray The array to be updated with plugin ids
+ */
+ void readPluginId(const TDesC& aAuthAppId, RPointerArray<HBufC>& aArray);
+
+private:
+ /**
+ * constructor
+ */
+ CSmfCredMgrDbUser(CSmfCredMgrServerSession* aSession);
+
+ /**
+ * Two phase constructor
+ */
+ void ConstructL();
+
+private:
+ //data
+ RFs iFileSession;
+ TFileName iDbFilePathName;
+ RSqlDatabase iDataBase;
+ CSmfCredMgrServerSession* iSession;
+ };
+
+#endif /* SMFCREDMGRDBUSER_H_ */