// sqlsrv.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 __SQLSRV_H__

#define __SQLSRV_H__

//  Include Files

#include <fshell/common.mmh>

#include <fshell/ioutils.h>

#include <SqlDb.h>

//class CSqlShared;

//class CLineEditor;

using namespace IoUtils;

class CCmdSqlSrv : public CServerBase

	{

public:

	static const TDesC* ColumnTypeToString(TSqlColumnType aType);

	static void StripWrapDoubleQuote(HBufC& aText);

	void PrintTime(const TTime& aTime, TBool aNewline);	

	static CCommandBase* NewLC();

	static CCmdSqlSrv* GetServer();	

	~CCmdSqlSrv();

	TInt NextCommandId();

	//SQL commands

	void SqlCreateL(TDesC& aFilename, CServerCommandBase* aCommand);

	void SqlOpenL(TDesC& aFilename, CServerCommandBase* aCommand);

	void SqlExecL(TDesC& aStatement, CServerCommandBase* aCommand);

	void SqlStateL(TDesC& aStatement, RPointerArray<HBufC> &aOptParamFile, CServerCommandBase* aCommand, 

			TDesC* aTempFileTemplate = NULL);

	void SqlClose(CServerCommandBase* aCommand);

	void SqlAttachL(TDesC& aFilename, TDesC& aDateBaseName, CServerCommandBase* aCommand);

	void SqlDetachL(TDesC& aDateBaseName, CServerCommandBase* aCommand);

#ifdef SQL_COMPACT	

	void SqlCompactL(TDesC* aDateBaseName, CServerCommandBase* aCommand);

#endif

	///////////////////////////////////

	void ReportResult(const TServerCommandId& aId, const TDesC& aName, TRefByValue<const TDesC> aFmt, ...);

	//////////////////////////////////

	void ParseResultL(RSqlStatement& aState, CServerCommandBase* aCommand, TDesC* aTempFileTemplate);

private:

	CCmdSqlSrv();

	void ConstructL();

	void MakeTempFilename(TDes& aTmpFile, TDesC& aTemplate);

private:

	enum TPrintPostfix

		{

		ENone,

		ENewLine

		};

	void DoPrintf(TRefByValue<const TDesC> aFmt, ...);

	void DoPrintf(TRefByValue<const TDesC8> aFmt, ...);

	void DoPrintList(TRefByValue<const TDesC> aFmt, VA_LIST& aList, TPrintPostfix aPostfix = ENone);

	void DoPrintList(TRefByValue<const TDesC8> aFmt, VA_LIST& aList, TPrintPostfix aPostfix = ENone);

	void DoPrint(const TDesC& aDes, TPrintPostfix aPostfix = ENone);

private: // From CCommandBase.

	virtual const TDesC& Name() const;

	virtual const TDesC& Description() const;

	virtual void ArgumentsL(RCommandArgumentList& aArguments);

	virtual void OptionsL(RCommandOptionList& aOptions);

private: // From CServerBase.

	virtual void InitializeL();

	virtual void Report(const TServerCommandId& aId, const TDesC& aDes);

	virtual void Report(const TServerCommandId& aId, const TDesC8& aDes);

	virtual void ReportWarning(const TServerCommandId& aId, const TDesC& aDes);

	virtual void ReportError(const TServerCommandId& aId, TInt aError, const TDesC& aDes);

private:

	RSqlDatabase	iSqlDb;

	TBool			iDatabaseOpened;	//when database is created or opened, set this to ETrue

	TBool iExit;

	TBuf<512> iLine;

	TInt iExitReason;

	TBool iLineRead;

	TInt iNextCommandId;

	TInt iTmpFileNo;	

private:

	//use this static variable to make sure only one instance exists

	static CCmdSqlSrv*	iOnlyInstance;

	};

#endif //__SQLSRV_H__