--- /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 <sqldb.h>
+#include <stringpool.h>
+#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__