diff -r fd64c38c277d -r b46a585f6909 phonebookengines_old/contactsmodel/cntplsql/inc/cntsqlprovider.h
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/phonebookengines_old/contactsmodel/cntplsql/inc/cntsqlprovider.h	Fri Jun 11 13:29:23 2010 +0300
@@ -0,0 +1,164 @@
+/**
+* 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 "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:
+*
+*/
+
+
+
+/**
+ @file
+ @internalComponent
+ @released
+*/
+
+#ifndef __CNTSQLPROVIDER_H__
+#define __CNTSQLPROVIDER_H__
+
+#include "cntsqlprovider.h"
+
+#include <e32cmn.h>
+#include <e32base.h>
+#include <badesca.h>
+
+/**
+Enumeration defining sql statement type.
+
+@internalComponent
+@released
+*/
+enum TCntSqlStatement
+	{
+	EInsert,
+	EUpdate,
+	EDelete,
+	ESelect	
+	};
+	
+/**
+Class used to build a sql statement class. It holds the statement type and the 
+database table against which sql statement is run
+
+@internalComponent
+@released
+*/
+NONSHARABLE_CLASS(TCntSqlStatementType)
+	{
+public:
+	TCntSqlStatementType(TCntSqlStatement aSqlStatement, const TDesC& aTableName);
+	void SetSqlStatement(TCntSqlStatement aSqlStatement);
+	TCntSqlStatement SqlStatement() const;
+	const TDesC& TableName() const;
+private:
+	TCntSqlStatement iSqlStatement;
+	const TDesC& iTableName;
+	};	
+
+/**
+An abstract object representing a sql statement.
+
+@internalComponent
+@released
+*/
+NONSHARABLE_CLASS(CCntSqlStatement) : public CBase
+	{
+public:
+	virtual TDesC& SqlStringL() = 0;
+	void SetParamL(const TDesC& aParam, const TDesC& aValue);
+	void SetConditionL(const TDesC& aCondition);
+	void ClearCondition();
+	TInt ParameterIndex(const TDesC& aParam) const;
+	void Reset();
+	~CCntSqlStatement();
+	
+protected:
+	void ConstructL(const TDesC& aTableName);
+	
+protected:
+	HBufC* 			iTableName;
+	CDesCArrayFlat*	iParams;		
+	CDesCArrayFlat*	iValues;
+	HBufC*			iCondition;
+	HBufC*			iSqlString;
+	TBool			iProcessed;
+	};
+
+/**
+Concrete implementation for sql update statement.
+
+@internalComponent
+@released
+*/	
+NONSHARABLE_CLASS(CCntSqlUpdate) : public CCntSqlStatement
+	{
+public:
+	static CCntSqlUpdate* NewL(const TDesC& aTableName);
+	TDesC& SqlStringL();
+	};
+
+/**
+Concrete implementation for sql delete statement.
+
+@internalComponent
+@released
+*/		
+NONSHARABLE_CLASS(CCntSqlDelete) : public CCntSqlStatement
+	{
+public:
+	static CCntSqlDelete* NewL(const TDesC& aTableName);
+	TDesC& SqlStringL();
+	};
+
+
+/**
+Concrete implementation for sql insert statement.
+
+@internalComponent
+@released
+*/	
+NONSHARABLE_CLASS(CCntSqlInsert) : public CCntSqlStatement
+	{
+public:
+	static CCntSqlInsert* NewL(const TDesC& aTableName);
+	TDesC& SqlStringL();
+	};
+	
+
+/**
+Concrete implementation for sql select statement.
+
+@internalComponent
+@released
+*/		
+NONSHARABLE_CLASS(CCntSqlSelect) : public CCntSqlStatement
+	{
+public:
+	static CCntSqlSelect* NewL(const TDesC& aTableName);
+	TDesC& SqlStringL();
+	};
+	
+/**
+Factory class. Used to build CCntSqlStatement objects based on statement type provided
+
+@internalComponent
+@released
+*/
+NONSHARABLE_CLASS(TSqlProvider)
+	{
+public:
+	static CCntSqlStatement* GetSqlStatementL(TCntSqlStatementType aStatementType);		
+	};	
+
+#endif //__CNTSQLPROVIDER_H__
+