18e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project/* 28e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * Copyright (C) 2006, 2007, 2008 Apple Inc. All rights reserved. 38e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * Copyright (C) 2007 Justin Haygood (jhaygood@reaktix.com) 48e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * 58e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * Redistribution and use in source and binary forms, with or without 68e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * modification, are permitted provided that the following conditions 78e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * are met: 88e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * 1. Redistributions of source code must retain the above copyright 98e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * notice, this list of conditions and the following disclaimer. 108e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * 2. Redistributions in binary form must reproduce the above copyright 118e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * notice, this list of conditions and the following disclaimer in the 128e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * documentation and/or other materials provided with the distribution. 138e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * 148e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * THIS SOFTWARE IS PROVIDED BY APPLE COMPUTER, INC. ``AS IS'' AND ANY 158e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE 168e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR 178e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL APPLE COMPUTER, INC. OR 188e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, 198e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, 208e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR 218e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY 228e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT 238e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE 248e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. 258e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project */ 268e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 27cac0f67c402d107cdb10971b95719e2ff9c7c76bSteve Block#ifndef SQLiteDatabase_h 28cac0f67c402d107cdb10971b95719e2ff9c7c76bSteve Block#define SQLiteDatabase_h 298e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 308e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project#include "PlatformString.h" 318e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project#include <wtf/Threading.h> 328e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 338e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project#if COMPILER(MSVC) 348e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project#pragma warning(disable: 4800) 358e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project#endif 368e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 378e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Projectstruct sqlite3; 388e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 398e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Projectnamespace WebCore { 408e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 418e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Projectclass DatabaseAuthorizer; 428e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Projectclass SQLiteStatement; 438e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Projectclass SQLiteTransaction; 448e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 458e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Projectextern const int SQLResultDone; 468e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Projectextern const int SQLResultError; 478e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Projectextern const int SQLResultOk; 488e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Projectextern const int SQLResultRow; 498e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Projectextern const int SQLResultSchema; 508e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Projectextern const int SQLResultFull; 518e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 528e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Projectclass SQLiteDatabase : public Noncopyable { 538e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project friend class SQLiteTransaction; 548e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Projectpublic: 558e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project SQLiteDatabase(); 568e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project ~SQLiteDatabase(); 578e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 588e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project bool open(const String& filename); 598e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project bool isOpen() const { return m_db; } 608e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project void close(); 618e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 628e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project bool executeCommand(const String&); 638e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project bool returnsAtLeastOneResult(const String&); 648e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 658e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project bool tableExists(const String&); 668e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project void clearAllTables(); 678e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project void runVacuumCommand(); 688e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 698e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project bool transactionInProgress() const { return m_transactionInProgress; } 708e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 718e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project int64_t lastInsertRowID(); 728e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project int lastChanges(); 738e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 748e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project void setBusyTimeout(int ms); 758e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project void setBusyHandler(int(*)(void*, int)); 768e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 778e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project void setFullsync(bool); 788e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 798e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project // Gets/sets the maximum size in bytes 808e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project // 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 818e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project // These chunks will never be anything other than 512, 1024, 2048, 4096, 8192, 16384, or 32768 bytes in size. 828e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project // setMaximumSize() will round the size down to the next smallest chunk if the passed size doesn't align. 838e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project int64_t maximumSize(); 848e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project void setMaximumSize(int64_t); 858e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 86c60802dd50f86c37e0596d41c3ef6fc2c8804da4Andrei Popescu // Gets the number of unused bytes in the database file. 87c60802dd50f86c37e0596d41c3ef6fc2c8804da4Andrei Popescu int64_t freeSpaceSize(); 88c60802dd50f86c37e0596d41c3ef6fc2c8804da4Andrei Popescu 898e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project // The SQLite SYNCHRONOUS pragma can be either FULL, NORMAL, or OFF 908e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project // FULL - Any writing calls to the DB block until the data is actually on the disk surface 918e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project // NORMAL - SQLite pauses at some critical moments when writing, but much less than FULL 928e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project // OFF - Calls return immediately after the data has been passed to disk 938e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project enum SynchronousPragma { SyncOff = 0, SyncNormal = 1, SyncFull = 2 }; 948e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project void setSynchronous(SynchronousPragma); 958e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 968e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project int lastError(); 978e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project const char* lastErrorMsg(); 988e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 998e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project sqlite3* sqlite3Handle() const { 1008e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project ASSERT(currentThread() == m_openingThread); 1018e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project return m_db; 1028e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project } 1038e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 1048e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project void setAuthorizer(PassRefPtr<DatabaseAuthorizer>); 1058e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 1068e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project // (un)locks the database like a mutex 1078e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project void lock(); 1088e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project void unlock(); 1098a0914b749bbe7da7768e07a7db5c6d4bb09472bSteve Block bool isAutoCommitOn() const; 1108e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 1118e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Projectprivate: 1128e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project static int authorizerFunction(void*, int, const char*, const char*, const char*, const char*); 1138e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 1148e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project void enableAuthorizer(bool enable); 1158e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 1168e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project int pageSize(); 1178e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 1188e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project sqlite3* m_db; 1198e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project int m_lastError; 1208e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project int m_pageSize; 1218e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 1228e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project bool m_transactionInProgress; 1238e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 1248e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project Mutex m_authorizerLock; 1258e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project RefPtr<DatabaseAuthorizer> m_authorizer; 1268e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 1278e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project Mutex m_lockingMutex; 1288e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project ThreadIdentifier m_openingThread; 1298e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 1308e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project}; // class SQLiteDatabase 1318e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 1328e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project} // namespace WebCore 1338e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project 1348e35f3cfc7fba1d1c829dc557ebad6409cbe16a2The Android Open Source Project#endif 135