// 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__