1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/os/persistentdata/persistentstorage/sql/SRC/Client/SqlDbSession.h	Fri Jun 15 03:10:57 2012 +0200
     1.3 @@ -0,0 +1,91 @@
     1.4 +// Copyright (c) 2005-2009 Nokia Corporation and/or its subsidiary(-ies).
     1.5 +// All rights reserved.
     1.6 +// This component and the accompanying materials are made available
     1.7 +// under the terms of "Eclipse Public License v1.0"
     1.8 +// which accompanies this distribution, and is available
     1.9 +// at the URL "http://www.eclipse.org/legal/epl-v10.html".
    1.10 +//
    1.11 +// Initial Contributors:
    1.12 +// Nokia Corporation - initial contribution.
    1.13 +//
    1.14 +// Contributors:
    1.15 +//
    1.16 +// Description:
    1.17 +//
    1.18 +
    1.19 +#ifndef __SQLDBSESSION_H__
    1.20 +#define __SQLDBSESSION_H__
    1.21 +
    1.22 +#include <sqldb.h>			//RSqlDatabase::TIsolationLevel
    1.23 +#include "SqlUtil.h"		//TSqlSrvFunction
    1.24 +
    1.25 +//Forward declarations
    1.26 +struct sqlite3;
    1.27 +class RSqlStatementSession;
    1.28 +class TSqlResourceTestData;
    1.29 +class CSqlSecurityPolicy;
    1.30 +class RSqlBufFlat;
    1.31 +class TSqlFhCmdFunctor;
    1.32 +
    1.33 +///////////////////////////////////////////////////////////////////////////////////////////////////////////////
    1.34 +//////////////////////                RSqlDbSession           /////////////////////////////////////////////////
    1.35 +///////////////////////////////////////////////////////////////////////////////////////////////////////////////
    1.36 +
    1.37 +/**
    1.38 +RSqlDbSession class is used for establishing a connection with the database server.
    1.39 +It can be used also for: 
    1.40 + - executing SQL statements or a set of SQL statements, separated with ";";
    1.41 + - attaching/detaching databases;
    1.42 + - copying databases;
    1.43 + - deleting databases;
    1.44 + - retrieving last error messages;
    1.45 + 
    1.46 +@internalComponent
    1.47 +*/
    1.48 +NONSHARABLE_CLASS(RSqlDbSession) : public RSessionBase
    1.49 +	{
    1.50 +	//RSqlDbSession class hides all details about the communication with the database server.
    1.51 +	//No database specific header files should be seen or used outside the session class.
    1.52 +	
    1.53 +	friend class RSqlStatementSession;
    1.54 +	friend class TSqlResourceTestData;
    1.55 +	
    1.56 +public:	
    1.57 +	inline RSqlDbSession();
    1.58 +	TInt Connect(TSqlSrvFunction aFunction, const TDesC& aDbFileName, const TDesC8& aSecurityPolicyData, const TDesC8* aConfig);
    1.59 +	TInt Attach(const TDesC& aDbFileName, const TDesC& aDbName);
    1.60 +	inline TInt Detach(const TDesC& aDbName);
    1.61 +	static TInt CopyDatabase(const TDesC& aSrcDbFileName, const TDesC& aDestDbFileName);
    1.62 +	static TInt DeleteDatabase(const TDesC& aDbFileName);
    1.63 +	TPtrC LastErrorMessage();
    1.64 +	TInt64 LastInsertedRowId(); 
    1.65 +	inline TInt Exec(const TDesC& aSqlStmt);
    1.66 +	inline TInt Exec(const TDesC8& aSqlStmt);
    1.67 +	inline void Exec(const TDesC& aSqlStmt, TRequestStatus& aStatus);
    1.68 +	inline void Exec(const TDesC8& aSqlStmt, TRequestStatus& aStatus);
    1.69 +	inline TInt SetIsolationLevel(RSqlDatabase::TIsolationLevel aIsolationLevel);
    1.70 +	TInt GetSecurityPolicy(RSqlBufFlat& aSecurityPolicyBuf);
    1.71 +	inline TInt ExecScalarFullSelect(const TDesC& aSqlStmt, TSqlColumnType aType, TDes8& aRes);
    1.72 +	inline TInt ExecScalarFullSelect(const TDesC8& aSqlStmt, TSqlColumnType aType, TDes8& aRes);
    1.73 +	void Close();
    1.74 +
    1.75 +	inline TInt SendReceive(TInt aFunction);
    1.76 +	inline void SendReceive(TInt aFunction, TRequestStatus& aStatus);
    1.77 +	inline TInt SendReceive(TInt aFunction,const TIpcArgs& aArgs);
    1.78 +	inline void SendReceive(TInt aFunction,const TIpcArgs& aArgs, TRequestStatus& aStatus);
    1.79 +
    1.80 +private:
    1.81 +	enum TDbfAction {EDbfCreate, EDbfOpen};
    1.82 +	TInt DoCreateSession();
    1.83 +	TInt InitResourceTestData();
    1.84 +	TInt CreateAndSendFileHandle(TSqlFhCmdFunctor& aFhCmdSender, TDbfAction aDbfAction);
    1.85 +	TInt DoConnect(TSqlSrvFunction aFunction, const TDesC& aDbFileName, const TDesC8& aSecurityPolicyData, const TDesC8* aConfig);
    1.86 +	
    1.87 +private:
    1.88 +	HBufC*	iLastErrorMessage;
    1.89 +
    1.90 +	};
    1.91 +
    1.92 +#include "SqlDbSession.inl"
    1.93 +
    1.94 +#endif //__SQLDBSESSION_H__