1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/os/persistentdata/persistentstorage/sql/SRC/Server/SqlSrvStatementUtil.h	Fri Jun 15 03:10:57 2012 +0200
     1.3 @@ -0,0 +1,59 @@
     1.4 +// Copyright (c) 2006-2009 Nokia Corporation and/or its subsidiary(-ies).
     1.5 +// All rights reserved.
     1.6 +// This component and the accompanying materials are made available
     1.7 +// under the terms of "Eclipse Public License v1.0"
     1.8 +// which accompanies this distribution, and is available
     1.9 +// at the URL "http://www.eclipse.org/legal/epl-v10.html".
    1.10 +//
    1.11 +// Initial Contributors:
    1.12 +// Nokia Corporation - initial contribution.
    1.13 +//
    1.14 +// Contributors:
    1.15 +//
    1.16 +// Description:
    1.17 +// Global sql statement related functions
    1.18 +// 
    1.19 +//
    1.20 +
    1.21 +#ifndef __SQLSRVSTATEMENTUTIL_H__
    1.22 +#define __SQLSRVSTATEMENTUTIL_H__
    1.23 +
    1.24 +#include <e32std.h>
    1.25 +
    1.26 +//This header file contains useful utility function declarations.
    1.27 +//These functions are used for accessging directly the SQLITE interface functions.
    1.28 +
    1.29 +//Forward declarations
    1.30 +struct sqlite3;
    1.31 +struct sqlite3_stmt;
    1.32 +struct sqlite3_context;
    1.33 +struct Mem;
    1.34 +typedef struct Mem sqlite3_value;
    1.35 +
    1.36 +TInt CreateDbHandle16(const TDesC& aFileNameZ, sqlite3*& aDbHandle);
    1.37 +TInt CreateDbHandle8(const TDesC8& aFileNameZ, sqlite3*& aDbHandle);
    1.38 +inline void CloseDbHandle(sqlite3* aDbHandle);
    1.39 +inline void CloseDbCleanup(void* aDbHandle);
    1.40 +TPtrC GetFirstSqlStmt(TPtr& aString);
    1.41 +TInt DbExecStmt16(sqlite3 *aDbHandle, TDes16& aSqlStmt);
    1.42 +TInt DbExecStmt8(sqlite3 *aDbHandle, const TDesC8& aSqlStmt);
    1.43 +
    1.44 +sqlite3_stmt* StmtPrepare16L(sqlite3* aDbHandle, const TDesC16& aSqlStmt);
    1.45 +TInt StmtPrepare8(sqlite3* aDbHandle, const TDesC8& aSqlStmt, sqlite3_stmt*& aStmtHandle);
    1.46 +sqlite3_stmt* StmtPrepare8L(sqlite3* aDbHandle, const TDesC8& aSqlStmt);
    1.47 +TInt FinalizeStmtHandle(sqlite3_stmt* aStmtHandle);
    1.48 +TInt StmtExec(sqlite3_stmt* aStmtHandle);
    1.49 +TInt StmtNext(sqlite3_stmt* aStmtHandle);
    1.50 +TInt StmtReset(sqlite3_stmt* aStmtHandle);
    1.51 +
    1.52 +TInt DbPageCount(sqlite3* aDbHandle, const TDesC& aDbName, TInt& aPageCount);
    1.53 +TInt DbPageSize(sqlite3* aDbHandle, const TDesC& aDbName, TInt& aPageSize);
    1.54 +TInt DbCacheSize(sqlite3* aDbHandle, const TDesC& aDbName, TInt& aCacheSize);
    1.55 +TInt DbEncoding(sqlite3* aDbHandle, const TDesC& aDbName, TDes8& aEncoding);
    1.56 +TInt DbFreePageCount(sqlite3* aDbHandle, const TDesC& aDbName, TInt& aPageCount);
    1.57 +TInt DbVacuumMode(sqlite3* aDbHandle, const TDesC& aDbName, TInt& aVacuumMode);
    1.58 +TInt DbCompact(sqlite3* aDbHandle, const TDesC& aDbName, TInt aPageCount, TInt& aProcessedPageCount, TInt aMaxTime = 0);
    1.59 +
    1.60 +#include "SqlSrvStatementUtil.inl"
    1.61 +
    1.62 +#endif//__SQLSRVSTATEMENTUTIL_H__