--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/commands/sql/sqlcmd_open.h	Wed Jun 23 15:52:26 2010 +0100
@@ -0,0 +1,208 @@
+// sqlcmd_open.h
+// 
+// Copyright (c) 2010 Accenture. All rights reserved.
+// This component and the accompanying materials are made available
+// under the terms of the "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:
+// Accenture - Initial contribution
+//
+#ifndef __FSQLCMD_OPEN_H__
+#define __FSQLCMD_OPEN_H__
+
+#include <fshell/ioutils.h>
+
+
+using namespace IoUtils;
+
+////////////////////////////////////////////////////////////////////////////
+class CSqlCmdOpen : public CServerCommandBase
+	{
+public:
+	static CServerCommandBase* NewLC();
+	~CSqlCmdOpen();
+	static const TDesC& NameS();
+private:
+	void ConstructL();
+private: // From CCommandBase.
+	virtual const TDesC& Name() const;
+	virtual const TDesC& Description() const;
+	virtual void ArgumentsL(RCommandArgumentList& aArguments);	
+	virtual void DoRunL();
+private:
+	HBufC* iFileName;
+	};
+
+/////////////////////////////////////////////////////////////////
+
+class CSqlCmdExit : public CServerCommandBase
+	{
+public:
+	static CServerCommandBase* NewLC();
+	~CSqlCmdExit();
+	static const TDesC& NameS();
+private:
+	void ConstructL();
+private: // From CCommandBase.
+	virtual const TDesC& Name() const;
+	virtual const TDesC& Description() const;
+	virtual void DoRunL();
+	};
+
+///////////////////////////////////////////////////////////////////
+
+class CSqlCmdClose : public CServerCommandBase
+	{
+public:
+	static CServerCommandBase* NewLC();
+	~CSqlCmdClose();
+	static const TDesC& NameS();
+private:
+	void ConstructL();
+private: // From CCommandBase.
+	virtual const TDesC& Name() const;
+	virtual const TDesC& Description() const;
+	virtual void DoRunL();
+	};
+
+/////////////////////////////////////////////////////////////////
+
+class CSqlCmdCreate : public CServerCommandBase
+	{
+public:
+	static CServerCommandBase* NewLC();
+	~CSqlCmdCreate();
+	static const TDesC& NameS();
+private:
+	void ConstructL();
+private: // From CCommandBase.
+	virtual const TDesC& Name() const;
+	virtual const TDesC& Description() const;
+	virtual void ArgumentsL(RCommandArgumentList& aArguments);
+	virtual void DoRunL();
+	
+private:
+	HBufC* iFileName;	
+	};
+
+
+//////////////////////////////////////////////////////////////////
+class CSqlCmdExec : public CServerCommandBase
+	{
+public:
+	static CServerCommandBase* NewLC();
+	~CSqlCmdExec();
+	static const TDesC& NameS();
+private:
+	void ConstructL();
+private: // From CCommandBase.
+	virtual const TDesC& Name() const;
+	virtual const TDesC& Description() const;
+	virtual void ArgumentsL(RCommandArgumentList& aArguments);
+	virtual void DoRunL();
+	
+private:
+	HBufC* iExec;	
+	};
+
+//////////////////////////////////////////////////////////////////
+
+class CSqlCmdState : public CServerCommandBase
+	{
+public:
+	static CServerCommandBase* NewLC();
+	~CSqlCmdState();
+	static const TDesC& NameS();
+private:
+	void ConstructL();
+private: // From CCommandBase.
+	virtual const TDesC& Name() const;
+	virtual const TDesC& Description() const;
+	virtual void ArgumentsL(RCommandArgumentList& aArguments);
+	virtual void OptionsL(RCommandOptionList& aOptions);
+	virtual void DoRunL();
+	
+private:
+	HBufC* iOptFileName;	//TEMP file template, used to dump large binary contents
+	RPointerArray<HBufC> iOptParamFile;	//multiple filenames for use with parameter
+	
+	HBufC* iExec;	//the SQL statement
+	//RPointerArray<HBufC> iCmdArgu;	//arguments could be multiple strings	
+		
+	};
+
+/////////////////////////////////////////////////////////////////////
+
+//////////////////////////////////////////////////////////////////
+
+class CSqlCmdAttach : public CServerCommandBase
+	{
+public:
+	static CServerCommandBase* NewLC();
+	~CSqlCmdAttach();
+	static const TDesC& NameS();
+private:
+	void ConstructL();
+private: // From CCommandBase.
+	virtual const TDesC& Name() const;
+	virtual const TDesC& Description() const;
+	virtual void ArgumentsL(RCommandArgumentList& aArguments);
+	void OptionsL(RCommandOptionList& aOptions);
+	virtual void DoRunL();
+	
+private:
+	HBufC* iOptFileName;
+	HBufC* iOptDBName;	//database name
+	};
+
+///////////////////////////////////////////////////////////////////
+
+class CSqlCmdDetach : public CServerCommandBase
+	{
+public:
+	static CServerCommandBase* NewLC();
+	~CSqlCmdDetach();
+	static const TDesC& NameS();
+private:
+	void ConstructL();
+private: // From CCommandBase.
+	virtual const TDesC& Name() const;
+	virtual const TDesC& Description() const;
+	virtual void ArgumentsL(RCommandArgumentList& aArguments);
+	void OptionsL(RCommandOptionList& aOptions);
+	virtual void DoRunL();
+	
+private:
+	HBufC* iOptDBName;	//database name
+	};
+
+/////////////////////////////////////////////////////////////////////
+
+#ifdef SQL_COMPACT
+
+//RSqlDatabase::Compact() is documented in Symbian Developer Library, 
+//but not exists in header file.
+//so just reserved this for future
+class CSqlCmdCompact : public CServerCommandBase
+	{
+public:
+	static CServerCommandBase* NewLC();
+	~CSqlCmdCompact();
+	static const TDesC& NameS();
+private:
+	void ConstructL();
+private: // From CCommandBase.
+	virtual const TDesC& Name() const;
+	virtual const TDesC& Description() const;
+	virtual void ArgumentsL(RCommandArgumentList& aArguments);
+	void OptionsL(RCommandOptionList& aOptions);
+	virtual void DoRunL();
+	
+private:
+	HBufC* iOptDBName;	//database name
+	};
+#endif
+
+#endif // __FSQLCMD_OPEN_H__