|
sl@0
|
1 |
// Copyright (c) 2005-2009 Nokia Corporation and/or its subsidiary(-ies).
|
|
sl@0
|
2 |
// All rights reserved.
|
|
sl@0
|
3 |
// This component and the accompanying materials are made available
|
|
sl@0
|
4 |
// under the terms of "Eclipse Public License v1.0"
|
|
sl@0
|
5 |
// which accompanies this distribution, and is available
|
|
sl@0
|
6 |
// at the URL "http://www.eclipse.org/legal/epl-v10.html".
|
|
sl@0
|
7 |
//
|
|
sl@0
|
8 |
// Initial Contributors:
|
|
sl@0
|
9 |
// Nokia Corporation - initial contribution.
|
|
sl@0
|
10 |
//
|
|
sl@0
|
11 |
// Contributors:
|
|
sl@0
|
12 |
//
|
|
sl@0
|
13 |
// Description:
|
|
sl@0
|
14 |
//
|
|
sl@0
|
15 |
|
|
sl@0
|
16 |
#ifndef __SQLDATABASEIMPL_H__
|
|
sl@0
|
17 |
#define __SQLDATABASEIMPL_H__
|
|
sl@0
|
18 |
|
|
sl@0
|
19 |
#include <sqldb.h> //RSqlDatabase::TIsolationLevel, TSqlColumnType
|
|
sl@0
|
20 |
#include "SqlDbSession.h" //RSqlDbSession, TSqlSrvFunction (via included SqlUtil.h)
|
|
sl@0
|
21 |
|
|
sl@0
|
22 |
//Forward declarations
|
|
sl@0
|
23 |
class CSqlSecurityPolicy;
|
|
sl@0
|
24 |
|
|
sl@0
|
25 |
/**
|
|
sl@0
|
26 |
CSqlDatabaseImpl implements RSqlDatabase.
|
|
sl@0
|
27 |
|
|
sl@0
|
28 |
It can be used for:
|
|
sl@0
|
29 |
- establishing a connection with the database;
|
|
sl@0
|
30 |
- attaching/detaching a database to/from the existing connection;
|
|
sl@0
|
31 |
- executing SQL statements or a set of SQL statements, separated with ";";
|
|
sl@0
|
32 |
- deleting databases;
|
|
sl@0
|
33 |
- retrieving last error messages;
|
|
sl@0
|
34 |
- setting the isolation level;
|
|
sl@0
|
35 |
- returning the database security policy;
|
|
sl@0
|
36 |
|
|
sl@0
|
37 |
@see RSqlDatabase
|
|
sl@0
|
38 |
|
|
sl@0
|
39 |
@internalComponent
|
|
sl@0
|
40 |
*/
|
|
sl@0
|
41 |
NONSHARABLE_CLASS(CSqlDatabaseImpl) : public CBase
|
|
sl@0
|
42 |
{
|
|
sl@0
|
43 |
public:
|
|
sl@0
|
44 |
static CSqlDatabaseImpl* NewL(TSqlSrvFunction aFunction, const TDesC& aDbFileName,
|
|
sl@0
|
45 |
const CSqlSecurityPolicy* aSecurityPolicy, const TDesC8* aConfig = NULL);
|
|
sl@0
|
46 |
virtual ~CSqlDatabaseImpl();
|
|
sl@0
|
47 |
inline TInt Attach(const TDesC& aDbFileName, const TDesC& aDbName);
|
|
sl@0
|
48 |
inline TInt Detach(const TDesC& aDbName);
|
|
sl@0
|
49 |
static inline TInt Copy(const TDesC& aSrcDbFileName, const TDesC& aDestDbFileName);
|
|
sl@0
|
50 |
static inline TInt Delete(const TDesC& aDbFileName);
|
|
sl@0
|
51 |
CSqlSecurityPolicy* CloneSecurityPolicyL();
|
|
sl@0
|
52 |
inline TInt SetIsolationLevel(RSqlDatabase::TIsolationLevel aIsolationLevel);
|
|
sl@0
|
53 |
inline TInt Exec(const TDesC16& aSqlStmt);
|
|
sl@0
|
54 |
inline TInt Exec(const TDesC8& aSqlStmt);
|
|
sl@0
|
55 |
inline void Exec(const TDesC16& aSqlStmt, TRequestStatus& aStatus);
|
|
sl@0
|
56 |
inline void Exec(const TDesC8& aSqlStmt, TRequestStatus& aStatus);
|
|
sl@0
|
57 |
inline TPtrC LastErrorMessage();
|
|
sl@0
|
58 |
inline TInt64 LastInsertedRowId();
|
|
sl@0
|
59 |
inline RSqlDbSession& Session();
|
|
sl@0
|
60 |
inline TInt ExecScalarFullSelectL(const TDesC16& aSqlStmt, TSqlColumnType aType, TDes8& aRes);
|
|
sl@0
|
61 |
inline TInt ExecScalarFullSelectL(const TDesC8& aSqlStmt, TSqlColumnType aType, TDes8& aRes);
|
|
sl@0
|
62 |
inline TBool InTransaction();
|
|
sl@0
|
63 |
inline TInt Size();
|
|
sl@0
|
64 |
inline TInt Size(RSqlDatabase::TSize& aSize, const TDesC& aDbName);
|
|
sl@0
|
65 |
TInt Compact(TInt aSize, const TDesC& aDbName);
|
|
sl@0
|
66 |
void Compact(TInt aSize, const TDesC& aDbName, TRequestStatus& aStatus);
|
|
sl@0
|
67 |
|
|
sl@0
|
68 |
private:
|
|
sl@0
|
69 |
inline CSqlDatabaseImpl();
|
|
sl@0
|
70 |
void ConstructL(TSqlSrvFunction aFunction, const TDesC& aDbFileName,
|
|
sl@0
|
71 |
const CSqlSecurityPolicy* aSecurityPolicy = NULL, const TDesC8* aConfig = NULL);
|
|
sl@0
|
72 |
|
|
sl@0
|
73 |
private:
|
|
sl@0
|
74 |
RSqlDbSession iDbSession;
|
|
sl@0
|
75 |
|
|
sl@0
|
76 |
};
|
|
sl@0
|
77 |
|
|
sl@0
|
78 |
#include "SqlDatabaseImpl.inl"
|
|
sl@0
|
79 |
|
|
sl@0
|
80 |
#endif //__SQLDATABASEIMPL_H__
|