1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
|
/*
* Copyright (C) 2006, 2007, 2008 Apple Inc. All rights reserved.
* Copyright (C) 2007 Justin Haygood (jhaygood@reaktix.com)
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions
* are met:
* 1. Redistributions of source code must retain the above copyright
* notice, this list of conditions and the following disclaimer.
* 2. Redistributions in binary form must reproduce the above copyright
* notice, this list of conditions and the following disclaimer in the
* documentation and/or other materials provided with the distribution.
*
* THIS SOFTWARE IS PROVIDED BY APPLE COMPUTER, INC. ``AS IS'' AND ANY
* EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
* PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL APPLE COMPUTER, INC. OR
* CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
* PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
* OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
* OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/
#ifndef SQLDatabase_h
#define SQLDatabase_h
#include "PlatformString.h"
#include <wtf/Threading.h>
#if COMPILER(MSVC)
#pragma warning(disable: 4800)
#endif
struct sqlite3;
namespace WebCore {
class DatabaseAuthorizer;
class SQLiteStatement;
class SQLiteTransaction;
extern const int SQLResultDone;
extern const int SQLResultError;
extern const int SQLResultOk;
extern const int SQLResultRow;
extern const int SQLResultSchema;
extern const int SQLResultFull;
class SQLiteDatabase : public Noncopyable {
friend class SQLiteTransaction;
public:
SQLiteDatabase();
~SQLiteDatabase();
bool open(const String& filename);
bool isOpen() const { return m_db; }
void close();
bool executeCommand(const String&);
bool returnsAtLeastOneResult(const String&);
bool tableExists(const String&);
void clearAllTables();
void runVacuumCommand();
bool transactionInProgress() const { return m_transactionInProgress; }
int64_t lastInsertRowID();
int lastChanges();
void setBusyTimeout(int ms);
void setBusyHandler(int(*)(void*, int));
void setFullsync(bool);
// Gets/sets the maximum size in bytes
// Depending on per-database attributes, the size will only be settable in units that are the page size of the database, which is established at creation
// These chunks will never be anything other than 512, 1024, 2048, 4096, 8192, 16384, or 32768 bytes in size.
// setMaximumSize() will round the size down to the next smallest chunk if the passed size doesn't align.
int64_t maximumSize();
void setMaximumSize(int64_t);
// The SQLite SYNCHRONOUS pragma can be either FULL, NORMAL, or OFF
// FULL - Any writing calls to the DB block until the data is actually on the disk surface
// NORMAL - SQLite pauses at some critical moments when writing, but much less than FULL
// OFF - Calls return immediately after the data has been passed to disk
enum SynchronousPragma { SyncOff = 0, SyncNormal = 1, SyncFull = 2 };
void setSynchronous(SynchronousPragma);
int lastError();
const char* lastErrorMsg();
sqlite3* sqlite3Handle() const {
ASSERT(currentThread() == m_openingThread);
return m_db;
}
void setAuthorizer(PassRefPtr<DatabaseAuthorizer>);
// (un)locks the database like a mutex
void lock();
void unlock();
private:
static int authorizerFunction(void*, int, const char*, const char*, const char*, const char*);
void enableAuthorizer(bool enable);
int pageSize();
sqlite3* m_db;
int m_lastError;
int m_pageSize;
bool m_transactionInProgress;
Mutex m_authorizerLock;
RefPtr<DatabaseAuthorizer> m_authorizer;
Mutex m_lockingMutex;
ThreadIdentifier m_openingThread;
}; // class SQLiteDatabase
} // namespace WebCore
#endif
|
