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