/*

 * 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