sl@0: // Copyright (c) 2005-2009 Nokia Corporation and/or its subsidiary(-ies).
sl@0: // All rights reserved.
sl@0: // This component and the accompanying materials are made available
sl@0: // under the terms of "Eclipse Public License v1.0"
sl@0: // which accompanies this distribution, and is available
sl@0: // at the URL "http://www.eclipse.org/legal/epl-v10.html".
sl@0: //
sl@0: // Initial Contributors:
sl@0: // Nokia Corporation - initial contribution.
sl@0: //
sl@0: // Contributors:
sl@0: //
sl@0: // Description:
sl@0: //
sl@0: 
sl@0: #ifndef __SQLDATABASEIMPL_H__
sl@0: #define __SQLDATABASEIMPL_H__
sl@0: 
sl@0: #include <sqldb.h>				//RSqlDatabase::TIsolationLevel, TSqlColumnType
sl@0: #include "SqlDbSession.h"		//RSqlDbSession, TSqlSrvFunction (via included SqlUtil.h)
sl@0: 
sl@0: //Forward declarations
sl@0: class CSqlSecurityPolicy;
sl@0: 
sl@0: /**
sl@0: CSqlDatabaseImpl implements RSqlDatabase.
sl@0: 
sl@0: It can be used for:
sl@0:  - establishing a connection with the database;
sl@0:  - attaching/detaching a database to/from the existing connection;
sl@0:  - executing SQL statements or a set of SQL statements, separated with ";";
sl@0:  - deleting databases;
sl@0:  - retrieving last error messages;
sl@0:  - setting the isolation level;
sl@0:  - returning the database security policy;
sl@0: 
sl@0: @see RSqlDatabase
sl@0: 
sl@0: @internalComponent
sl@0: */
sl@0: NONSHARABLE_CLASS(CSqlDatabaseImpl) : public CBase
sl@0: 	{
sl@0: public:
sl@0: 	static CSqlDatabaseImpl* NewL(TSqlSrvFunction aFunction, const TDesC& aDbFileName, 
sl@0: 								  const CSqlSecurityPolicy* aSecurityPolicy, const TDesC8* aConfig = NULL);
sl@0: 	virtual ~CSqlDatabaseImpl();
sl@0: 	inline TInt Attach(const TDesC& aDbFileName, const TDesC& aDbName);
sl@0: 	inline TInt Detach(const TDesC& aDbName);
sl@0: 	static inline TInt Copy(const TDesC& aSrcDbFileName, const TDesC& aDestDbFileName);
sl@0: 	static inline TInt Delete(const TDesC& aDbFileName);
sl@0: 	CSqlSecurityPolicy* CloneSecurityPolicyL();
sl@0: 	inline TInt SetIsolationLevel(RSqlDatabase::TIsolationLevel aIsolationLevel);
sl@0: 	inline TInt Exec(const TDesC16& aSqlStmt);
sl@0: 	inline TInt Exec(const TDesC8& aSqlStmt);
sl@0: 	inline void Exec(const TDesC16& aSqlStmt, TRequestStatus& aStatus);
sl@0: 	inline void Exec(const TDesC8& aSqlStmt, TRequestStatus& aStatus);
sl@0: 	inline TPtrC LastErrorMessage();
sl@0: 	inline TInt64 LastInsertedRowId(); 
sl@0: 	inline RSqlDbSession& Session();
sl@0: 	inline TInt ExecScalarFullSelectL(const TDesC16& aSqlStmt, TSqlColumnType aType, TDes8& aRes);
sl@0: 	inline TInt ExecScalarFullSelectL(const TDesC8& aSqlStmt, TSqlColumnType aType, TDes8& aRes);
sl@0: 	inline TBool InTransaction();
sl@0: 	inline TInt Size();
sl@0: 	inline TInt Size(RSqlDatabase::TSize& aSize, const TDesC& aDbName);
sl@0: 	TInt Compact(TInt aSize, const TDesC& aDbName);
sl@0: 	void Compact(TInt aSize, const TDesC& aDbName, TRequestStatus& aStatus);
sl@0: 		
sl@0: private:
sl@0: 	inline CSqlDatabaseImpl();
sl@0: 	void ConstructL(TSqlSrvFunction aFunction, const TDesC& aDbFileName, 
sl@0: 					const CSqlSecurityPolicy* aSecurityPolicy = NULL, const TDesC8* aConfig = NULL);
sl@0: 
sl@0: private:
sl@0: 	RSqlDbSession 		iDbSession;
sl@0: 	
sl@0: 	};
sl@0: 
sl@0: #include "SqlDatabaseImpl.inl"
sl@0: 
sl@0: #endif //__SQLDATABASEIMPL_H__