// Copyright (c) 2001-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: Neeraj Nayan

//

// Description: The class provides interface to read/write header and

// body entry from the database.

//

#ifndef __MSVMESSAGEDBADAPTER_H__

#define __MSVMESSAGEDBADAPTER_H__

/**

 * HEADER FILES

 */

#include <msvstd.h>

#include <sqldb.h>

#include <msvapi.h>

/**

 * FORWARD DECLARATIONS

 */

class CMsvDBAdapter;

/**

@internalComponent

@prototype

*/

NONSHARABLE_CLASS (CMsvMessageDBAdapter) : public CBase

	{

public:

	struct CFieldClass;

	struct CHeaderMetaData;

	~CMsvMessageDBAdapter();

	static CMsvMessageDBAdapter* NewL(CMsvDBAdapter* aDBAdapter,TBool aDbInCurrentDrive = EFalse);

	TBool IsHeaderTableExistsL(const TUid& aMtmId);

	void CreateHeaderTableL(const TUid& aMtmId, const RPointerArray<CFieldPair>& aFieldDetails, TPtrC& aErrorMessage);

	void CreateHeaderEntryL(const TUid& aMtmId, TMsvId aEntryId, const RPointerArray<CHeaderFields>& iFieldPairList);

	void LoadHeaderEntryL(const TUid& aMtmId, TMsvId aEntryId, RPointerArray<CHeaderFields>& aFieldPairList);

	void DeleteHeaderEntryL(const TUid& aMtmId, TMsvId aEntryId);

	void CopyHeaderEntryL(const TUid& aMtmId, const TMsvId& aSrcEntryId, const TMsvId& aDestEntryId);

	void UpdateHeaderEntryL(const TUid& aMtmId, TMsvId aEntryId, const RPointerArray<CHeaderFields>& aFieldPairList);

	TBool CheckHeaderTableAndStdColumnFields(const TUid& aMtmId, TInt aHeaderFilelds);

	TBool DoesAnyStoreExistsL(TMsvId aId, TUid aMtmId);

private:

	void ConstructL(TBool aDbInCurrentDrive);

	void UpdateMetadataStructureL(TUint aDriveId);

	CMsvMessageDBAdapter(CMsvDBAdapter* aDBAdapter);

	inline TInt GetMetadataEntryIndex(const TUid& aMtmId);

	void DoCreateHeaderEntryL(const TUid& aMtmId, TMsvId aEntryId, const RPointerArray<CHeaderFields>& aFieldPairList, TInt aMetadataEntryIndex);

 	void DoUpdateHeaderEntryL(const TUid& aMtmId, TMsvId aEntryId, CHeaderFields* aHeaderFields, TInt aMetadataEntryIndex);

 	void DoProcessHeaderEntryL(const TUid& aMtmId, TMsvId aEntryId, const RPointerArray<CHeaderFields>& aFieldPairList, RArray<TInt>& aUidList);

 	void DoInsertHeaderEntryL(const TUid& aMtmId, TMsvId aEntryId, CHeaderFields* aHeaderFields, TInt aMetadataEntryIndex);

	void CheckStdColumnsAdded(HBufC* aFieldName, TInt& aColStatus);

	void DoLoadHeaderEntryL(RSqlStatement& aSqlStmt, const RPointerArray<CFieldClass>& aMetadataList, RPointerArray<CHeaderFields>& aFieldPairList);

	void DoCreateHeaderTableCreationQueryL(const RPointerArray<CFieldPair>& aFieldDetails, RBuf16& aHeaderTableQuery, CHeaderMetaData*& aHeaderMetaData);

// DATA		

private:

	// Hold information for a column in the header table.

	struct CFieldClass

		{

		~CFieldClass()

			{

			delete iName;

			}

		TSqlColumnType iType;		// Column Type

		HBufC* iName;				// Column Name

		};

	// Holds information for a header table.

	struct CHeaderMetaData

		{

		CHeaderMetaData()

			{

			iStdColumnStatus = 0;

			}

		~CHeaderMetaData()

			{

			iFieldList.ResetAndDestroy();

			}

		RPointerArray<CFieldClass> iFieldList;		// Column details

		TInt iStdColumnStatus;						// Status of standard columns in the header table.

		TUid iMtmId;								// MTM id of the header table.

		};

	CMsvDBAdapter* iDBAdapter;

	RSqlDatabase& iDatabaseRef;

	// Header metadata structure. The object holds a separate 

	// CHeaderMetaData entry for each header table in the database. 

	RPointerArray<CHeaderMetaData> iHeaderDataList;

	TBool iNonAttachedDrive;

	friend class CMsvDBAdapter;

#if (defined SYMBIAN_MESSAGESTORE_UNIT_TESTCODE)

	friend class CTestMessageDbAdapter;

	friend class CTestMsvServer;

#endif

	};

/*

 * GetMetadataEntryIndex()

 * 

 * @param aMtmId: MtmId to identify the header table.

 * @return index: Index in the metadata structure

 *

 * The function returns the index of the header metadata information

 * in the metadata structure. If the header information is not 

 * present in the metadata structure, it reads the metadata structure

 * from the database and return the index.

 */ 

inline TInt CMsvMessageDBAdapter::GetMetadataEntryIndex(const TUid& aMtmId)

	{

	// Check header structure in metadata structure.

	for(TInt index=0; index<iHeaderDataList.Count(); index++)

		{

		if(iHeaderDataList[index]->iMtmId == aMtmId)

			{

			return index;

			}

		}	

	return KErrNotFound;

	}

#endif		// #ifndef __MSVMESSAGEDBADAPTER_H__