persistentstorage/sql/SRC/Client/SqlDbSession.h
changeset 0 08ec8eefde2f
child 23 26645d81f48d
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/persistentstorage/sql/SRC/Client/SqlDbSession.h	Fri Jan 22 11:06:30 2010 +0200
@@ -0,0 +1,92 @@
+// Copyright (c) 2005-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:
+//
+
+#ifndef __SQLDBSESSION_H__
+#define __SQLDBSESSION_H__
+
+#include <sqldb.h>			//RSqlDatabase::TIsolationLevel
+#include "SqlUtil.h"		//TSqlSrvFunction
+#include "UTraceSql.h"
+
+//Forward declarations
+struct sqlite3;
+class RSqlStatementSession;
+class TSqlResourceTestData;
+class CSqlSecurityPolicy;
+class RSqlBufFlat;
+class TSqlFhCmdFunctor;
+
+///////////////////////////////////////////////////////////////////////////////////////////////////////////////
+//////////////////////                RSqlDbSession           /////////////////////////////////////////////////
+///////////////////////////////////////////////////////////////////////////////////////////////////////////////
+
+/**
+RSqlDbSession class is used for establishing a connection with the database server.
+It can be used also for: 
+ - executing SQL statements or a set of SQL statements, separated with ";";
+ - attaching/detaching databases;
+ - copying databases;
+ - deleting databases;
+ - retrieving last error messages;
+ 
+@internalComponent
+*/
+NONSHARABLE_CLASS(RSqlDbSession) : public RSessionBase
+	{
+	//RSqlDbSession class hides all details about the communication with the database server.
+	//No database specific header files should be seen or used outside the session class.
+	
+	friend class RSqlStatementSession;
+	friend class TSqlResourceTestData;
+	
+public:	
+	inline RSqlDbSession();
+	TInt Connect(TSqlSrvFunction aFunction, const TDesC& aDbFileName, const TDesC8& aSecurityPolicyData, const TDesC8* aConfig);
+	TInt Attach(const TDesC& aDbFileName, const TDesC& aDbName);
+	inline TInt Detach(const TDesC& aDbName);
+	static TInt CopyDatabase(const TDesC& aSrcDbFileName, const TDesC& aDestDbFileName);
+	static TInt DeleteDatabase(const TDesC& aDbFileName);
+	TPtrC LastErrorMessage();
+	TInt64 LastInsertedRowId(); 
+	inline TInt Exec(const TDesC& aSqlStmt);
+	inline TInt Exec(const TDesC8& aSqlStmt);
+	inline void Exec(const TDesC& aSqlStmt, TRequestStatus& aStatus);
+	inline void Exec(const TDesC8& aSqlStmt, TRequestStatus& aStatus);
+	inline TInt SetIsolationLevel(RSqlDatabase::TIsolationLevel aIsolationLevel);
+	TInt GetSecurityPolicy(RSqlBufFlat& aSecurityPolicyBuf);
+	inline TInt ExecScalarFullSelect(const TDesC& aSqlStmt, TSqlColumnType aType, TDes8& aRes);
+	inline TInt ExecScalarFullSelect(const TDesC8& aSqlStmt, TSqlColumnType aType, TDes8& aRes);
+	void Close();
+
+	inline TInt SendReceive(TInt aFunction);
+	inline void SendReceive(TInt aFunction, TRequestStatus& aStatus);
+	inline TInt SendReceive(TInt aFunction,const TIpcArgs& aArgs);
+	inline void SendReceive(TInt aFunction,const TIpcArgs& aArgs, TRequestStatus& aStatus);
+
+private:
+	enum TDbfAction {EDbfCreate, EDbfOpen};
+	TInt DoCreateSession();
+	TInt InitResourceTestData();
+	TInt CreateAndSendFileHandle(TSqlFhCmdFunctor& aFhCmdSender, TDbfAction aDbfAction);
+	TInt DoConnect(TSqlSrvFunction aFunction, const TDesC& aDbFileName, const TDesC8& aSecurityPolicyData, const TDesC8* aConfig);
+	
+private:
+	HBufC*	iLastErrorMessage;
+
+	};
+
+#include "SqlDbSession.inl"
+
+#endif //__SQLDBSESSION_H__