diff -r 000000000000 -r b16258d2340f applayerpluginsandutils/uripermissionservices/server/inc/dbaccessor.h --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/applayerpluginsandutils/uripermissionservices/server/inc/dbaccessor.h Tue Feb 02 01:09:52 2010 +0200 @@ -0,0 +1,76 @@ +// 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 __DBACCESSOR_H__ +#define __DBACCESSOR_H__ + + +class MDBTransaction + { + public: + /** + Bind the parameter for the query statement + */ + virtual void BindTextL ( TInt aParamPos, const TDesC8& aParamValue ) = 0; + + virtual void BindIntL ( TInt aParamPos, TInt aParamValue ) = 0; + /** + Execute the query and returns the record set. + */ + virtual TInt ExecuteL () = 0; + + /** + Get the column value by passing the column index + */ + virtual TPtrC8 ColumnTextL ( TInt aFieldPos ) = 0; + virtual TInt ColumnIntL ( TInt aFieldPos ) = 0; + + /** + Move to the next record. Returns EFalse in the case of end of record + */ + virtual TBool Next () = 0; + + /** + Cleanup the object + */ + virtual void Release () = 0; + }; + +class MDBAccessor + { + public: + /** + Prepare the transaction and returns a transaction object + */ + virtual MDBTransaction* PrepareTransactionL ( const TDesC8& aQueryStmt ) = 0; + /** + Function does a scalar query and returns the result value + */ + virtual TInt ExecuteScalarQueryL ( const TDesC8& aQueryStmt ) = 0; + /** + The following methods are used for BEGIN/COMMIT/ROLLBACK transaction + with the database + */ + virtual void BeginTransactionL () = 0; + virtual void CommitTransactionL () = 0; + virtual void RollbackTransaction () = 0; + + /** + Cleanup the object + */ + virtual void Release () = 0; + }; + +#endif // __SQLDBACCESSOR_H__