// Copyright (c) 2006-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:

//

// Description:

// dscdatabase.h

// 

//

#ifndef __DSCDATABASE_H__

#define __DSCDATABASE_H__

#include <sqldb.h>

#include <startupproperties.h>

#include <startup.hrh>

#include "dscstoredefs.h"

//Classes referenced

class CDscItem;

/** A database of DSC items

	@internalComponent 

	@released

	*/

class CDscDatabase: public CBase

	{

public:

	static CDscDatabase* NewL();

	~CDscDatabase();

	void CreateDscL(const TUid& aDscId,  const TDesC& aDescription);

	void DeleteDscL(const TUid& aDscId);

	TBool DscExistsL(const TUid& aDscId) const;

	void AddItemL (CDscItem& aItem, TDscPosition aPos);

	void ReadItemL( CDscItem& aItem);

	void DeleteItemL( const CDscItem& aItem);

	void UpdateItemL( const CDscItem& aItem);

	TBool ItemExistsL(const CDscItem& aItem) const;

	void EnumOpenLC(const TUid& aDscId);

	CDscItem* EnumReadNextL();

	void EnumClose();

private:

	CDscDatabase();

	void ConstructL();

	void OpenDatabaseL();

	void CreateTablesL();

	TBool QueryItemL(RSqlStatement& aStmt,  const CDscItem& aItem) const;

	void ReadDscItemL(RSqlStatement& aStmt, CDscItem& aItem);

	TInt GetItemIdL(TDscPosition aPos, RSqlStatement& aStmt);

	void PrintSqlCmd(const TDesC& aMess) const;

	void VerifyDataL(const CDscItem& aItem);

	void Rollback();

	void DatabaseBeginLC();

	void DatabaseCommitLP();

	static void CleanupDatabaseRollback(TAny *aDatabase);

	static void CleanupEnumRollback(TAny *aDatabase);

	void EnumBeginLC();

	TInt ConvertErrCode(TInt aErr) const;

	//help, destroy DSC database

	TInt DeleteDb();

	void GetDatabaseNameL(TDes& aDatabaseName);

private:

	mutable RSqlDatabase iDatabase;

	RSqlStatement iStmt;

	TBool iIsEnumOpened;

	};

#endif // __DSCDATABASE_H__