diff -r 000000000000 -r b16258d2340f applayerpluginsandutils/uripermissionservices/server/inc/sqldbaccessor.h --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/applayerpluginsandutils/uripermissionservices/server/inc/sqldbaccessor.h Tue Feb 02 01:09:52 2010 +0200 @@ -0,0 +1,68 @@ +// Copyright (c) 2007-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: +// + +#ifndef __SQLDBACCESSOR_H__ +#define __SQLDBACCESSOR_H__ + +#include +#include +#include "dbaccessor.h" + +const TInt KMaxDbStmtLen = 1024; + +_LIT8 (KUriTblName, "URITbl"); +_LIT8 (KUriPropsTblName, "URIPropertiesTbl"); +_LIT8 (KViewName, "URIView"); +_LIT8 (KTriggerInsertView, "ViewInsert"); +_LIT8 (KTriggerUpdateView, "ViewUpdate"); +_LIT8 (KTriggerDeleteView, "ViewDelete"); +_LIT8 (KTldTblName, "TLDTbl"); +_LIT8 (KTldTblIndex, "TldIndex"); + +/** +This class implements the operation that will be performed on the SQL storage. This class +inherits from MDBAccessor class. It manages the SQL operations like creating tables, view and +triggers. +*/ +class CSqlDbAccessor : private CBase, public MDBAccessor + { + public: + static MDBAccessor* NewL ( const RStringPool& aStringPool ); + // Methods from MDBAccessor + MDBTransaction* PrepareTransactionL ( const TDesC8& aQueryStmt ); + TInt ExecuteScalarQueryL ( const TDesC8& aQueryStmt ); + void ExecuteL ( const TDesC8& aStmt ); + void BeginTransactionL (); + void CommitTransactionL (); + void RollbackTransaction (); + void Release (); + private: + CSqlDbAccessor (); + ~CSqlDbAccessor (); + + void ConstructL ( const RStringPool& aStringPool ); + + void InitializeL (); + void CreateL ( const RStringPool& aStringPool ); + void CreateSchemaL ( const RStringPool& aStringPool ); + + void CreateTableL ( const RStringPool& aStringPool ); + void CreateViewL (); + void CreateTriggerL (); + private: + RSqlDatabase iDatabase; + }; + +#endif // __SQLDBACCESSOR_H__