/*

* 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