| OLD | NEW | 
|---|
|  | (Empty) | 
| 1 /* |  | 
| 2  * Copyright (C) 2006, 2007, 2008 Apple Inc. All rights reserved. |  | 
| 3  * Copyright (C) 2007 Justin Haygood (jhaygood@reaktix.com) |  | 
| 4  * |  | 
| 5  * Redistribution and use in source and binary forms, with or without |  | 
| 6  * modification, are permitted provided that the following conditions |  | 
| 7  * are met: |  | 
| 8  * 1. Redistributions of source code must retain the above copyright |  | 
| 9  *    notice, this list of conditions and the following disclaimer. |  | 
| 10  * 2. Redistributions in binary form must reproduce the above copyright |  | 
| 11  *    notice, this list of conditions and the following disclaimer in the |  | 
| 12  *    documentation and/or other materials provided with the distribution. |  | 
| 13  * |  | 
| 14  * THIS SOFTWARE IS PROVIDED BY APPLE COMPUTER, INC. ``AS IS'' AND ANY |  | 
| 15  * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE |  | 
| 16  * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR |  | 
| 17  * PURPOSE ARE DISCLAIMED.  IN NO EVENT SHALL APPLE COMPUTER, INC. OR |  | 
| 18  * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, |  | 
| 19  * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, |  | 
| 20  * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR |  | 
| 21  * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY |  | 
| 22  * OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT |  | 
| 23  * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE |  | 
| 24  * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |  | 
| 25  */ |  | 
| 26 |  | 
| 27 #ifndef SQLiteDatabase_h |  | 
| 28 #define SQLiteDatabase_h |  | 
| 29 |  | 
| 30 #include "wtf/Threading.h" |  | 
| 31 #include "wtf/ThreadingPrimitives.h" |  | 
| 32 #include "wtf/text/CString.h" |  | 
| 33 #include "wtf/text/WTFString.h" |  | 
| 34 |  | 
| 35 #if COMPILER(MSVC) |  | 
| 36 #pragma warning(disable: 4800) |  | 
| 37 #endif |  | 
| 38 |  | 
| 39 struct sqlite3; |  | 
| 40 |  | 
| 41 namespace WebCore { |  | 
| 42 |  | 
| 43 class DatabaseAuthorizer; |  | 
| 44 class SQLiteStatement; |  | 
| 45 class SQLiteTransaction; |  | 
| 46 |  | 
| 47 extern const int SQLResultDone; |  | 
| 48 extern const int SQLResultError; |  | 
| 49 extern const int SQLResultOk; |  | 
| 50 extern const int SQLResultRow; |  | 
| 51 extern const int SQLResultSchema; |  | 
| 52 extern const int SQLResultFull; |  | 
| 53 extern const int SQLResultInterrupt; |  | 
| 54 extern const int SQLResultConstraint; |  | 
| 55 |  | 
| 56 class SQLiteDatabase { |  | 
| 57     WTF_MAKE_NONCOPYABLE(SQLiteDatabase); |  | 
| 58     friend class SQLiteTransaction; |  | 
| 59 public: |  | 
| 60     SQLiteDatabase(); |  | 
| 61     ~SQLiteDatabase(); |  | 
| 62 |  | 
| 63     bool open(const String& filename, bool forWebSQLDatabase = false); |  | 
| 64     bool isOpen() const { return m_db; } |  | 
| 65     void close(); |  | 
| 66     void interrupt(); |  | 
| 67     bool isInterrupted(); |  | 
| 68 |  | 
| 69     void updateLastChangesCount(); |  | 
| 70 |  | 
| 71     bool executeCommand(const String&); |  | 
| 72     bool returnsAtLeastOneResult(const String&); |  | 
| 73 |  | 
| 74     bool tableExists(const String&); |  | 
| 75     void clearAllTables(); |  | 
| 76     int runVacuumCommand(); |  | 
| 77     int runIncrementalVacuumCommand(); |  | 
| 78 |  | 
| 79     bool transactionInProgress() const { return m_transactionInProgress; } |  | 
| 80 |  | 
| 81     int64_t lastInsertRowID(); |  | 
| 82     int lastChanges(); |  | 
| 83 |  | 
| 84     void setBusyTimeout(int ms); |  | 
| 85     void setBusyHandler(int(*)(void*, int)); |  | 
| 86 |  | 
| 87     void setFullsync(bool); |  | 
| 88 |  | 
| 89     // Gets/sets the maximum size in bytes |  | 
| 90     // Depending on per-database attributes, the size will only be settable in u
     nits that are the page size of the database, which is established at creation |  | 
| 91     // These chunks will never be anything other than 512, 1024, 2048, 4096, 819
     2, 16384, or 32768 bytes in size. |  | 
| 92     // setMaximumSize() will round the size down to the next smallest chunk if t
     he passed size doesn't align. |  | 
| 93     int64_t maximumSize(); |  | 
| 94     void setMaximumSize(int64_t); |  | 
| 95 |  | 
| 96     // Gets the number of unused bytes in the database file. |  | 
| 97     int64_t freeSpaceSize(); |  | 
| 98     int64_t totalSize(); |  | 
| 99 |  | 
| 100     // The SQLite SYNCHRONOUS pragma can be either FULL, NORMAL, or OFF |  | 
| 101     // FULL - Any writing calls to the DB block until the data is actually on th
     e disk surface |  | 
| 102     // NORMAL - SQLite pauses at some critical moments when writing, but much le
     ss than FULL |  | 
| 103     // OFF - Calls return immediately after the data has been passed to disk |  | 
| 104     enum SynchronousPragma { SyncOff = 0, SyncNormal = 1, SyncFull = 2 }; |  | 
| 105     void setSynchronous(SynchronousPragma); |  | 
| 106 |  | 
| 107     int lastError(); |  | 
| 108     const char* lastErrorMsg(); |  | 
| 109 |  | 
| 110     sqlite3* sqlite3Handle() const { |  | 
| 111         ASSERT(m_sharable || currentThread() == m_openingThread || !m_db); |  | 
| 112         return m_db; |  | 
| 113     } |  | 
| 114 |  | 
| 115     void setAuthorizer(PassRefPtr<DatabaseAuthorizer>); |  | 
| 116 |  | 
| 117     Mutex& databaseMutex() { return m_lockingMutex; } |  | 
| 118     bool isAutoCommitOn() const; |  | 
| 119 |  | 
| 120     // The SQLite AUTO_VACUUM pragma can be either NONE, FULL, or INCREMENTAL. |  | 
| 121     // NONE - SQLite does not do any vacuuming |  | 
| 122     // FULL - SQLite moves all empty pages to the end of the DB file and truncat
     es |  | 
| 123     //        the file to remove those pages after every transaction. This optio
     n |  | 
| 124     //        requires SQLite to store additional information about each page in |  | 
| 125     //        the database file. |  | 
| 126     // INCREMENTAL - SQLite stores extra information for each page in the databa
     se |  | 
| 127     //               file, but removes the empty pages only when PRAGMA INCREMAN
     TAL_VACUUM |  | 
| 128     //               is called. |  | 
| 129     enum AutoVacuumPragma { AutoVacuumNone = 0, AutoVacuumFull = 1, AutoVacuumIn
     cremental = 2 }; |  | 
| 130     bool turnOnIncrementalAutoVacuum(); |  | 
| 131 |  | 
| 132     // Set this flag to allow access from multiple threads.  Not all multi-threa
     ded accesses are safe! |  | 
| 133     // See http://www.sqlite.org/cvstrac/wiki?p=MultiThreading for more info. |  | 
| 134 #ifndef NDEBUG |  | 
| 135     void disableThreadingChecks(); |  | 
| 136 #else |  | 
| 137     void disableThreadingChecks() {} |  | 
| 138 #endif |  | 
| 139 |  | 
| 140 private: |  | 
| 141     static int authorizerFunction(void*, int, const char*, const char*, const ch
     ar*, const char*); |  | 
| 142 |  | 
| 143     void enableAuthorizer(bool enable); |  | 
| 144 |  | 
| 145     int pageSize(); |  | 
| 146 |  | 
| 147     sqlite3* m_db; |  | 
| 148     int m_pageSize; |  | 
| 149 |  | 
| 150     bool m_transactionInProgress; |  | 
| 151     bool m_sharable; |  | 
| 152 |  | 
| 153     Mutex m_authorizerLock; |  | 
| 154     RefPtr<DatabaseAuthorizer> m_authorizer; |  | 
| 155 |  | 
| 156     Mutex m_lockingMutex; |  | 
| 157     ThreadIdentifier m_openingThread; |  | 
| 158 |  | 
| 159     Mutex m_databaseClosingMutex; |  | 
| 160     bool m_interrupted; |  | 
| 161 |  | 
| 162     int m_openError; |  | 
| 163     CString m_openErrorMessage; |  | 
| 164 |  | 
| 165     int m_lastChangesCount; |  | 
| 166 }; |  | 
| 167 |  | 
| 168 } // namespace WebCore |  | 
| 169 |  | 
| 170 #endif |  | 
| OLD | NEW | 
|---|