--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/authorisation/userpromptservice/database/inc/upsdb.h	Thu Sep 10 14:01:51 2009 +0300
@@ -0,0 +1,119 @@
+/*
+* Copyright (c) 2007-2009 Nokia Corporation and/or its subsidiary(-ies).
+* All rights reserved.
+* This component and the accompanying materials are made available
+* under the terms of the License "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:
+* Nokia Corporation - initial contribution.
+*
+* Contributors:
+*
+* Description: 
+* Defines a read-only interface for UPS Database and classes to keep filter and record objects.
+*
+*/
+
+
+/**
+ @file
+ @publishedPartner
+ @released
+*/
+ 
+#ifndef UPSDB_H
+#define UPSDB_H
+
+#include <s32file.h>
+#include <d32dbms.h>
+#include <ups/upstypes.h>
+
+namespace UserPromptService
+{
+
+_LIT(KDecisionViewPanic,"UpsDbView");
+
+NONSHARABLE_CLASS(CDecisionView):public CActive
+/**
+   Stores a handle to a view object and provides a method to retrieve a record from the view.
+ */
+ 	{	
+ 	friend class CDecisionDb;
+ 	friend class CDecisionDbW;
+ 	
+public:	
+ 	IMPORT_C static CDecisionView *NewLC();
+ 	
+ 	~CDecisionView();
+ 	
+	IMPORT_C void EvaluateView(TRequestStatus& aStatus);	
+ 	IMPORT_C CDecisionRecord* NextDecisionL();
+
+protected:
+ 	CDecisionView();
+ 	static CDecisionRecord* GenerateRecordL(RDbRowSet& aRowSet, CDbColSet* aColSet);	
+	/**
+		From CActive. Handles an evaluation request completion event and evaluate next part if required.
+	 */
+	void RunL();	
+	/**
+		From CActive. Cancels evaluation.
+	 */
+	void DoCancel();	
+	/**
+		From CActive. Handles errors.
+	 */
+	TInt RunError(TInt aError);
+	 	
+private:
+	/**
+	   Handle to the view object generated from an SQL query
+	 */
+	RDbView iDbView;	
+	/**
+	   Pointer to the decision database column set definition
+	 */
+	CDbColSet *iColSet;	
+	/**
+	   Copy of the status variable of the client which requested the evaluation service
+	 */
+	TRequestStatus* iClientStatus;
+ 	};
+
+
+NONSHARABLE_CLASS(CDecisionDb):public CBase
+/**
+	A read-only interface for UPS decision database. Provide methods to query database.
+ */
+	{
+public:
+	IMPORT_C CDecisionView *CreateViewL(CDecisionFilter& aFilter);
+	
+	~CDecisionDb();
+
+protected:
+	CDecisionDb();
+	void CreateSqlStatementLC(CDecisionFilter& aFilter, RBuf& aSql);	
+	void DoubleSingleQuotesL(const TDesC& aSource, RBuf& aDestination);
+	
+private:
+	const TDesC* GetComparisonOperator(const TUint32& aFlag) const;
+	void AppendQueryInteger(const TUint32& aValue, TDes& aSql, TBool& aMultiple, const TUint32& aFlag, const TUint32& aSetCol, const TDesC& aColName);
+	void AppendQueryStringL(const TDesC& aValue, TDes& aSql, TBool& aMultiple, const TUint32& aFlag, const TUint32& aSetCol, const TDesC& aColName);
+	
+protected:
+	/**
+	 * Handle to the decision store database
+	 */
+	RDbStoreDatabase iDatabase;
+	/**
+	 * Pointer to the database file storage object
+	 */
+	CFileStore* iStore;	
+	};
+
+}//namespace UserPromptService
+
+#endif //UPSDB_H