1 // Copyright (c) 2006-2009 Nokia Corporation and/or its subsidiary(-ies).

     2 // All rights reserved.

     3 // This component and the accompanying materials are made available

     4 // under the terms of "Eclipse Public License v1.0"

     5 // which accompanies this distribution, and is available

     6 // at the URL "http://www.eclipse.org/legal/epl-v10.html".

     7 //

     8 // Initial Contributors:

     9 // Nokia Corporation - initial contribution.

    10 //

    11 // Contributors:

    12 //

    13 // Description:

    14 // dscdatabase.h

    15 // 

    16 //

    17 

    18 #ifndef __DSCDATABASE_H__

    19 #define __DSCDATABASE_H__

    20 

    21 #include <sqldb.h>

    22 #include <startupproperties.h>

    23 #include <startup.hrh>

    24 #include "dscstoredefs.h"

    25 

    26 

    27 //Classes referenced

    28 class CDscItem;

    29 

    30 /** A database of DSC items

    31 	@internalComponent 

    32 	@released

    33 	*/

    34 class CDscDatabase: public CBase

    35 	{

    36 public:

    37 

    38 	static CDscDatabase* NewL();

    39 	~CDscDatabase();

    40 	

    41 

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

    43 	void DeleteDscL(const TUid& aDscId);

    44 	TBool DscExistsL(const TUid& aDscId) const;

    45 

    46 	void AddItemL (CDscItem& aItem, TDscPosition aPos);

    47 	void ReadItemL( CDscItem& aItem);

    48 	void DeleteItemL( const CDscItem& aItem);

    49 

    50 	void UpdateItemL( const CDscItem& aItem);

    51 	TBool ItemExistsL(const CDscItem& aItem) const;

    52 

    53 	void EnumOpenLC(const TUid& aDscId);

    54 

    55 	CDscItem* EnumReadNextL();

    56 	void EnumClose();

    57 

    58 private:

    59 	CDscDatabase();

    60 	void ConstructL();

    61 	void OpenDatabaseL();

    62 	void CreateTablesL();

    63 

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

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

    66 	TInt GetItemIdL(TDscPosition aPos, RSqlStatement& aStmt);

    67 	void PrintSqlCmd(const TDesC& aMess) const;

    68 	void VerifyDataL(const CDscItem& aItem);

    69 

    70 	void Rollback();

    71 	void DatabaseBeginLC();

    72 	void DatabaseCommitLP();

    73 	static void CleanupDatabaseRollback(TAny *aDatabase);

    74 	static void CleanupEnumRollback(TAny *aDatabase);

    75 	void EnumBeginLC();

    76 	TInt ConvertErrCode(TInt aErr) const;

    77 	//help, destroy DSC database

    78 	TInt DeleteDb();

    79 	void GetDatabaseNameL(TDes& aDatabaseName);

    80 	

    81 private:

    82 	mutable RSqlDatabase iDatabase;

    83 	RSqlStatement iStmt;

    84 	TBool iIsEnumOpened;

    85 	};

    86 

    87 #endif // __DSCDATABASE_H__