blob: d1533cfeb5409502cceadb052db87e5a5d27041b [file] [log] [blame]
drh75897232000-05-29 14:26:00 +00001/*
drhb19a2bc2001-09-16 00:13:26 +00002** 2001 September 15
drh75897232000-05-29 14:26:00 +00003**
drhb19a2bc2001-09-16 00:13:26 +00004** The author disclaims copyright to this source code. In place of
5** a legal notice, here is a blessing:
drh75897232000-05-29 14:26:00 +00006**
drhb19a2bc2001-09-16 00:13:26 +00007** May you do good and not evil.
8** May you find forgiveness for yourself and forgive others.
9** May you share freely, never taking more than you give.
drh75897232000-05-29 14:26:00 +000010**
11*************************************************************************
12** Main file for the SQLite library. The routines in this file
13** implement the programmer interface to the library. Routines in
14** other files are for internal use by SQLite and should not be
15** accessed by users of the library.
16**
danielk197762c14b32008-11-19 09:05:26 +000017** $Id: main.c,v 1.514 2008/11/19 09:05:27 danielk1977 Exp $
drh75897232000-05-29 14:26:00 +000018*/
19#include "sqliteInt.h"
drhce9079c2002-05-15 14:17:44 +000020#include <ctype.h>
drh58f1c8b2008-05-26 20:19:25 +000021
drh820a9062008-01-31 13:35:48 +000022#ifdef SQLITE_ENABLE_FTS3
23# include "fts3.h"
24#endif
drh58f1c8b2008-05-26 20:19:25 +000025#ifdef SQLITE_ENABLE_RTREE
26# include "rtree.h"
27#endif
danielk19771c826652008-09-08 08:08:09 +000028#ifdef SQLITE_ENABLE_ICU
29# include "sqliteicu.h"
30#endif
drh75897232000-05-29 14:26:00 +000031
32/*
drhb217a572000-08-22 13:40:18 +000033** The version of the library
34*/
danielk197724b03fd2004-05-10 10:34:34 +000035const char sqlite3_version[] = SQLITE_VERSION;
drh4aec8b62004-08-28 16:19:00 +000036const char *sqlite3_libversion(void){ return sqlite3_version; }
danielk197799ba19e2005-02-05 07:33:34 +000037int sqlite3_libversion_number(void){ return SQLITE_VERSION_NUMBER; }
drhb67e8bf2007-08-30 20:09:48 +000038int sqlite3_threadsafe(void){ return SQLITE_THREADSAFE; }
drhb217a572000-08-22 13:40:18 +000039
drhe265b082008-05-01 17:03:49 +000040#if !defined(SQLITE_OMIT_TRACE) && defined(SQLITE_ENABLE_IOTRACE)
drhb217a572000-08-22 13:40:18 +000041/*
drhb0603412007-02-28 04:47:26 +000042** If the following function pointer is not NULL and if
43** SQLITE_ENABLE_IOTRACE is enabled, then messages describing
44** I/O active are written using this function. These messages
45** are intended for debugging activity only.
46*/
mlcreech3a00f902008-03-04 17:45:01 +000047void (*sqlite3IoTrace)(const char*, ...) = 0;
drhe265b082008-05-01 17:03:49 +000048#endif
drhb0603412007-02-28 04:47:26 +000049
50/*
drha16313e2007-03-30 11:29:32 +000051** If the following global variable points to a string which is the
52** name of a directory, then that directory will be used to store
53** temporary files.
54**
55** See also the "PRAGMA temp_store_directory" SQL command.
56*/
57char *sqlite3_temp_directory = 0;
58
drhc5499be2008-04-01 15:06:33 +000059/*
drh40257ff2008-06-13 18:24:27 +000060** Initialize SQLite.
61**
62** This routine must be called to initialize the memory allocation,
drh93ed56d2008-08-12 15:21:11 +000063** VFS, and mutex subsystems prior to doing any serious work with
drh40257ff2008-06-13 18:24:27 +000064** SQLite. But as long as you do not compile with SQLITE_OMIT_AUTOINIT
65** this routine will be called automatically by key routines such as
66** sqlite3_open().
67**
68** This routine is a no-op except on its very first call for the process,
69** or for the first call after a call to sqlite3_shutdown.
drh93ed56d2008-08-12 15:21:11 +000070**
71** The first thread to call this routine runs the initialization to
72** completion. If subsequent threads call this routine before the first
73** thread has finished the initialization process, then the subsequent
74** threads must block until the first thread finishes with the initialization.
75**
76** The first thread might call this routine recursively. Recursive
77** calls to this routine should not block, of course. Otherwise the
78** initialization process would never complete.
79**
80** Let X be the first thread to enter this routine. Let Y be some other
81** thread. Then while the initial invocation of this routine by X is
82** incomplete, it is required that:
83**
84** * Calls to this routine from Y must block until the outer-most
85** call by X completes.
86**
87** * Recursive calls to this routine from thread X return immediately
88** without blocking.
drh40257ff2008-06-13 18:24:27 +000089*/
90int sqlite3_initialize(void){
danielk1977075c23a2008-09-01 18:34:20 +000091 sqlite3_mutex *pMaster; /* The main static mutex */
92 int rc; /* Result code */
93
94#ifdef SQLITE_OMIT_WSD
danielk1977a8f83bf2008-09-02 16:22:28 +000095 rc = sqlite3_wsd_init(4096, 24);
danielk1977075c23a2008-09-01 18:34:20 +000096 if( rc!=SQLITE_OK ){
97 return rc;
98 }
99#endif
danielk197771bc31c2008-06-26 08:29:34 +0000100
drh93ed56d2008-08-12 15:21:11 +0000101 /* If SQLite is already completely initialized, then this call
102 ** to sqlite3_initialize() should be a no-op. But the initialization
103 ** must be complete. So isInit must not be set until the very end
104 ** of this routine.
105 */
danielk1977075c23a2008-09-01 18:34:20 +0000106 if( sqlite3GlobalConfig.isInit ) return SQLITE_OK;
danielk197771bc31c2008-06-26 08:29:34 +0000107
drh93ed56d2008-08-12 15:21:11 +0000108 /* Make sure the mutex subsystem is initialized. If unable to
109 ** initialize the mutex subsystem, return early with the error.
110 ** If the system is so sick that we are unable to allocate a mutex,
111 ** there is not much SQLite is going to be able to do.
112 **
113 ** The mutex subsystem must take care of serializing its own
114 ** initialization.
115 */
danielk1977d0251742008-06-18 18:57:42 +0000116 rc = sqlite3MutexInit();
drh93ed56d2008-08-12 15:21:11 +0000117 if( rc ) return rc;
danielk197771bc31c2008-06-26 08:29:34 +0000118
drh93ed56d2008-08-12 15:21:11 +0000119 /* Initialize the malloc() system and the recursive pInitMutex mutex.
120 ** This operation is protected by the STATIC_MASTER mutex. Note that
121 ** MutexAlloc() is called for a static mutex prior to initializing the
122 ** malloc subsystem - this implies that the allocation of a static
123 ** mutex must not require support from the malloc subsystem.
124 */
125 pMaster = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MASTER);
126 sqlite3_mutex_enter(pMaster);
danielk1977075c23a2008-09-01 18:34:20 +0000127 if( !sqlite3GlobalConfig.isMallocInit ){
drh93ed56d2008-08-12 15:21:11 +0000128 rc = sqlite3MallocInit();
129 }
drh40257ff2008-06-13 18:24:27 +0000130 if( rc==SQLITE_OK ){
danielk1977075c23a2008-09-01 18:34:20 +0000131 sqlite3GlobalConfig.isMallocInit = 1;
132 if( !sqlite3GlobalConfig.pInitMutex ){
133 sqlite3GlobalConfig.pInitMutex = sqlite3MutexAlloc(SQLITE_MUTEX_RECURSIVE);
134 if( sqlite3GlobalConfig.bCoreMutex && !sqlite3GlobalConfig.pInitMutex ){
drh93ed56d2008-08-12 15:21:11 +0000135 rc = SQLITE_NOMEM;
drh40257ff2008-06-13 18:24:27 +0000136 }
137 }
danielk197777eb5bb2008-09-22 17:22:19 +0000138 }
139 if( rc==SQLITE_OK ){
danielk1977075c23a2008-09-01 18:34:20 +0000140 sqlite3GlobalConfig.nRefInitMutex++;
drh93ed56d2008-08-12 15:21:11 +0000141 }
142 sqlite3_mutex_leave(pMaster);
danielk197771bc31c2008-06-26 08:29:34 +0000143
drh93ed56d2008-08-12 15:21:11 +0000144 /* If unable to initialize the malloc subsystem, then return early.
145 ** There is little hope of getting SQLite to run if the malloc
146 ** subsystem cannot be initialized.
147 */
148 if( rc!=SQLITE_OK ){
149 return rc;
150 }
151
152 /* Do the rest of the initialization under the recursive mutex so
153 ** that we will be able to handle recursive calls into
154 ** sqlite3_initialize(). The recursive calls normally come through
155 ** sqlite3_os_init() when it invokes sqlite3_vfs_register(), but other
156 ** recursive calls might also be possible.
157 */
danielk1977075c23a2008-09-01 18:34:20 +0000158 sqlite3_mutex_enter(sqlite3GlobalConfig.pInitMutex);
danielk1977502b4e02008-09-02 14:07:24 +0000159 if( sqlite3GlobalConfig.isInit==0 && sqlite3GlobalConfig.inProgress==0 ){
danielk1977075c23a2008-09-01 18:34:20 +0000160 FuncDefHash *pHash = &GLOBAL(FuncDefHash, sqlite3GlobalFunctions);
danielk1977502b4e02008-09-02 14:07:24 +0000161 sqlite3GlobalConfig.inProgress = 1;
danielk1977075c23a2008-09-01 18:34:20 +0000162 memset(pHash, 0, sizeof(sqlite3GlobalFunctions));
drh70a8ca32008-08-21 18:49:27 +0000163 sqlite3RegisterGlobalFunctions();
danielk197771bc31c2008-06-26 08:29:34 +0000164 rc = sqlite3_os_init();
danielk19778c0a7912008-08-20 14:49:23 +0000165 if( rc==SQLITE_OK ){
166 rc = sqlite3PcacheInitialize();
danielk19775b775292008-09-02 09:38:06 +0000167 sqlite3PCacheBufferSetup( sqlite3GlobalConfig.pPage,
168 sqlite3GlobalConfig.szPage, sqlite3GlobalConfig.nPage);
danielk19778c0a7912008-08-20 14:49:23 +0000169 }
danielk1977502b4e02008-09-02 14:07:24 +0000170 sqlite3GlobalConfig.inProgress = 0;
danielk1977075c23a2008-09-01 18:34:20 +0000171 sqlite3GlobalConfig.isInit = (rc==SQLITE_OK ? 1 : 0);
drh40257ff2008-06-13 18:24:27 +0000172 }
danielk1977075c23a2008-09-01 18:34:20 +0000173 sqlite3_mutex_leave(sqlite3GlobalConfig.pInitMutex);
shanedfb7b372008-07-22 05:13:30 +0000174
drh93ed56d2008-08-12 15:21:11 +0000175 /* Go back under the static mutex and clean up the recursive
176 ** mutex to prevent a resource leak.
177 */
178 sqlite3_mutex_enter(pMaster);
danielk1977075c23a2008-09-01 18:34:20 +0000179 sqlite3GlobalConfig.nRefInitMutex--;
180 if( sqlite3GlobalConfig.nRefInitMutex<=0 ){
181 assert( sqlite3GlobalConfig.nRefInitMutex==0 );
182 sqlite3_mutex_free(sqlite3GlobalConfig.pInitMutex);
183 sqlite3GlobalConfig.pInitMutex = 0;
drh93ed56d2008-08-12 15:21:11 +0000184 }
185 sqlite3_mutex_leave(pMaster);
186
187 /* The following is just a sanity check to make sure SQLite has
188 ** been compiled correctly. It is important to run this code, but
189 ** we don't want to run it too often and soak up CPU cycles for no
190 ** reason. So we run it once during initialization.
191 */
shanedfb7b372008-07-22 05:13:30 +0000192#ifndef NDEBUG
193 /* This section of code's only "output" is via assert() statements. */
194 if ( rc==SQLITE_OK ){
195 u64 x = (((u64)1)<<63)-1;
196 double y;
197 assert(sizeof(x)==8);
198 assert(sizeof(x)==sizeof(y));
199 memcpy(&y, &x, 8);
200 assert( sqlite3IsNaN(y) );
201 }
202#endif
203
drh40257ff2008-06-13 18:24:27 +0000204 return rc;
205}
206
207/*
208** Undo the effects of sqlite3_initialize(). Must not be called while
209** there are outstanding database connections or memory allocations or
210** while any part of SQLite is otherwise in use in any thread. This
211** routine is not threadsafe. Not by a long shot.
212*/
213int sqlite3_shutdown(void){
danielk1977075c23a2008-09-01 18:34:20 +0000214 sqlite3GlobalConfig.isMallocInit = 0;
danielk19778c0a7912008-08-20 14:49:23 +0000215 sqlite3PcacheShutdown();
danielk1977075c23a2008-09-01 18:34:20 +0000216 if( sqlite3GlobalConfig.isInit ){
danielk1977fb437272008-07-08 12:02:35 +0000217 sqlite3_os_end();
218 }
drh1b67f3c2008-10-10 17:41:28 +0000219 sqlite3MallocEnd();
drh1b67f3c2008-10-10 17:41:28 +0000220 sqlite3MutexEnd();
danielk1977075c23a2008-09-01 18:34:20 +0000221 sqlite3GlobalConfig.isInit = 0;
drh40257ff2008-06-13 18:24:27 +0000222 return SQLITE_OK;
223}
224
225/*
226** This API allows applications to modify the global configuration of
227** the SQLite library at run-time.
228**
229** This routine should only be called when there are no outstanding
230** database connections or memory allocations. This routine is not
231** threadsafe. Failure to heed these warnings can lead to unpredictable
232** behavior.
233*/
234int sqlite3_config(int op, ...){
235 va_list ap;
236 int rc = SQLITE_OK;
237
238 /* sqlite3_config() shall return SQLITE_MISUSE if it is invoked while
239 ** the SQLite library is in use. */
danielk1977075c23a2008-09-01 18:34:20 +0000240 if( sqlite3GlobalConfig.isInit ) return SQLITE_MISUSE;
drh40257ff2008-06-13 18:24:27 +0000241
242 va_start(ap, op);
243 switch( op ){
drh18472fa2008-10-07 15:25:48 +0000244
245 /* Mutex configuration options are only available in a threadsafe
246 ** compile.
247 */
248#if SQLITE_THREADSAFE
drh40257ff2008-06-13 18:24:27 +0000249 case SQLITE_CONFIG_SINGLETHREAD: {
250 /* Disable all mutexing */
danielk1977075c23a2008-09-01 18:34:20 +0000251 sqlite3GlobalConfig.bCoreMutex = 0;
252 sqlite3GlobalConfig.bFullMutex = 0;
drh40257ff2008-06-13 18:24:27 +0000253 break;
254 }
255 case SQLITE_CONFIG_MULTITHREAD: {
256 /* Disable mutexing of database connections */
257 /* Enable mutexing of core data structures */
danielk1977075c23a2008-09-01 18:34:20 +0000258 sqlite3GlobalConfig.bCoreMutex = 1;
259 sqlite3GlobalConfig.bFullMutex = 0;
drh40257ff2008-06-13 18:24:27 +0000260 break;
261 }
262 case SQLITE_CONFIG_SERIALIZED: {
263 /* Enable all mutexing */
danielk1977075c23a2008-09-01 18:34:20 +0000264 sqlite3GlobalConfig.bCoreMutex = 1;
265 sqlite3GlobalConfig.bFullMutex = 1;
drh40257ff2008-06-13 18:24:27 +0000266 break;
267 }
drh18472fa2008-10-07 15:25:48 +0000268 case SQLITE_CONFIG_MUTEX: {
269 /* Specify an alternative mutex implementation */
270 sqlite3GlobalConfig.mutex = *va_arg(ap, sqlite3_mutex_methods*);
271 break;
272 }
273 case SQLITE_CONFIG_GETMUTEX: {
274 /* Retrieve the current mutex implementation */
275 *va_arg(ap, sqlite3_mutex_methods*) = sqlite3GlobalConfig.mutex;
276 break;
277 }
278#endif
279
280
drh40257ff2008-06-13 18:24:27 +0000281 case SQLITE_CONFIG_MALLOC: {
282 /* Specify an alternative malloc implementation */
danielk1977075c23a2008-09-01 18:34:20 +0000283 sqlite3GlobalConfig.m = *va_arg(ap, sqlite3_mem_methods*);
drh40257ff2008-06-13 18:24:27 +0000284 break;
285 }
drh33589792008-06-18 13:27:46 +0000286 case SQLITE_CONFIG_GETMALLOC: {
danielk197757e5ea92008-06-24 19:02:55 +0000287 /* Retrieve the current malloc() implementation */
danielk1977075c23a2008-09-01 18:34:20 +0000288 if( sqlite3GlobalConfig.m.xMalloc==0 ) sqlite3MemSetDefault();
289 *va_arg(ap, sqlite3_mem_methods*) = sqlite3GlobalConfig.m;
drh33589792008-06-18 13:27:46 +0000290 break;
291 }
drhfec00ea2008-06-14 16:56:21 +0000292 case SQLITE_CONFIG_MEMSTATUS: {
drh40257ff2008-06-13 18:24:27 +0000293 /* Enable or disable the malloc status collection */
danielk1977075c23a2008-09-01 18:34:20 +0000294 sqlite3GlobalConfig.bMemstat = va_arg(ap, int);
drh40257ff2008-06-13 18:24:27 +0000295 break;
296 }
drh33589792008-06-18 13:27:46 +0000297 case SQLITE_CONFIG_SCRATCH: {
298 /* Designate a buffer for scratch memory space */
danielk1977075c23a2008-09-01 18:34:20 +0000299 sqlite3GlobalConfig.pScratch = va_arg(ap, void*);
300 sqlite3GlobalConfig.szScratch = va_arg(ap, int);
301 sqlite3GlobalConfig.nScratch = va_arg(ap, int);
drh33589792008-06-18 13:27:46 +0000302 break;
303 }
304 case SQLITE_CONFIG_PAGECACHE: {
305 /* Designate a buffer for scratch memory space */
danielk1977075c23a2008-09-01 18:34:20 +0000306 sqlite3GlobalConfig.pPage = va_arg(ap, void*);
307 sqlite3GlobalConfig.szPage = va_arg(ap, int);
308 sqlite3GlobalConfig.nPage = va_arg(ap, int);
drh33589792008-06-18 13:27:46 +0000309 break;
310 }
danielk19775099be52008-06-27 13:27:03 +0000311
danielk1977bc2ca9e2008-11-13 14:28:28 +0000312 case SQLITE_CONFIG_PCACHE: {
313 /* Specify an alternative malloc implementation */
314 sqlite3GlobalConfig.pcache = *va_arg(ap, sqlite3_pcache_methods*);
315 break;
316 }
317
drhb232c232008-11-19 01:20:26 +0000318 case SQLITE_CONFIG_GETPCACHE: {
319 if( sqlite3GlobalConfig.pcache.xInit==0 ){
320 sqlite3PCacheSetDefault();
321 }
322 *va_arg(ap, sqlite3_pcache_methods*) = sqlite3GlobalConfig.pcache;
323 break;
324 }
325
drh5d414832008-07-15 14:47:18 +0000326#if defined(SQLITE_ENABLE_MEMSYS3) || defined(SQLITE_ENABLE_MEMSYS5)
drh33589792008-06-18 13:27:46 +0000327 case SQLITE_CONFIG_HEAP: {
danielk19775099be52008-06-27 13:27:03 +0000328 /* Designate a buffer for heap memory space */
danielk1977075c23a2008-09-01 18:34:20 +0000329 sqlite3GlobalConfig.pHeap = va_arg(ap, void*);
330 sqlite3GlobalConfig.nHeap = va_arg(ap, int);
331 sqlite3GlobalConfig.mnReq = va_arg(ap, int);
danielk19775099be52008-06-27 13:27:03 +0000332
danielk1977075c23a2008-09-01 18:34:20 +0000333 if( sqlite3GlobalConfig.pHeap==0 ){
drh8a42cbd2008-07-10 18:13:42 +0000334 /* If the heap pointer is NULL, then restore the malloc implementation
335 ** back to NULL pointers too. This will cause the malloc to go
336 ** back to its default implementation when sqlite3_initialize() is
337 ** run.
338 */
danielk1977075c23a2008-09-01 18:34:20 +0000339 memset(&sqlite3GlobalConfig.m, 0, sizeof(sqlite3GlobalConfig.m));
drh8a42cbd2008-07-10 18:13:42 +0000340 }else{
341 /* The heap pointer is not NULL, then install one of the
342 ** mem5.c/mem3.c methods. If neither ENABLE_MEMSYS3 nor
343 ** ENABLE_MEMSYS5 is defined, return an error.
344 ** the default case and return an error.
345 */
danielk19775099be52008-06-27 13:27:03 +0000346#ifdef SQLITE_ENABLE_MEMSYS3
danielk1977075c23a2008-09-01 18:34:20 +0000347 sqlite3GlobalConfig.m = *sqlite3MemGetMemsys3();
drh8a42cbd2008-07-10 18:13:42 +0000348#endif
349#ifdef SQLITE_ENABLE_MEMSYS5
danielk1977075c23a2008-09-01 18:34:20 +0000350 sqlite3GlobalConfig.m = *sqlite3MemGetMemsys5();
drh8a42cbd2008-07-10 18:13:42 +0000351#endif
drh8a42cbd2008-07-10 18:13:42 +0000352 }
danielk19775099be52008-06-27 13:27:03 +0000353 break;
354 }
drh5d414832008-07-15 14:47:18 +0000355#endif
danielk19775099be52008-06-27 13:27:03 +0000356
drh633e6d52008-07-28 19:34:53 +0000357 case SQLITE_CONFIG_LOOKASIDE: {
danielk1977075c23a2008-09-01 18:34:20 +0000358 sqlite3GlobalConfig.szLookaside = va_arg(ap, int);
359 sqlite3GlobalConfig.nLookaside = va_arg(ap, int);
drh633e6d52008-07-28 19:34:53 +0000360 break;
361 }
362
drh40257ff2008-06-13 18:24:27 +0000363 default: {
364 rc = SQLITE_ERROR;
365 break;
366 }
367 }
368 va_end(ap);
369 return rc;
370}
371
372/*
drh633e6d52008-07-28 19:34:53 +0000373** Set up the lookaside buffers for a database connection.
374** Return SQLITE_OK on success.
375** If lookaside is already active, return SQLITE_BUSY.
drhe9d1c722008-08-04 20:13:26 +0000376**
377** The sz parameter is the number of bytes in each lookaside slot.
378** The cnt parameter is the number of slots. If pStart is NULL the
379** space for the lookaside memory is obtained from sqlite3_malloc().
380** If pStart is not NULL then it is sz*cnt bytes of memory to use for
381** the lookaside memory.
drh633e6d52008-07-28 19:34:53 +0000382*/
drhe9d1c722008-08-04 20:13:26 +0000383static int setupLookaside(sqlite3 *db, void *pBuf, int sz, int cnt){
drh633e6d52008-07-28 19:34:53 +0000384 void *pStart;
385 if( db->lookaside.nOut ){
386 return SQLITE_BUSY;
387 }
388 if( sz<0 ) sz = 0;
389 if( cnt<0 ) cnt = 0;
drhe9d1c722008-08-04 20:13:26 +0000390 if( pBuf==0 ){
drh63820332008-08-08 14:33:12 +0000391 sz = (sz + 7)&~7;
drhe9d1c722008-08-04 20:13:26 +0000392 sqlite3BeginBenignMalloc();
393 pStart = sqlite3Malloc( sz*cnt );
394 sqlite3EndBenignMalloc();
395 }else{
drh63820332008-08-08 14:33:12 +0000396 sz = sz&~7;
drhe9d1c722008-08-04 20:13:26 +0000397 pStart = pBuf;
398 }
399 if( db->lookaside.bMalloced ){
400 sqlite3_free(db->lookaside.pStart);
401 }
drh4cfb22f2008-08-01 18:47:01 +0000402 db->lookaside.pStart = pStart;
403 db->lookaside.pFree = 0;
404 db->lookaside.sz = sz;
drhe9d1c722008-08-04 20:13:26 +0000405 db->lookaside.bMalloced = pBuf==0;
drh633e6d52008-07-28 19:34:53 +0000406 if( pStart ){
407 int i;
408 LookasideSlot *p;
drh633e6d52008-07-28 19:34:53 +0000409 p = (LookasideSlot*)pStart;
410 for(i=cnt-1; i>=0; i--){
411 p->pNext = db->lookaside.pFree;
412 db->lookaside.pFree = p;
413 p = (LookasideSlot*)&((u8*)p)[sz];
414 }
415 db->lookaside.pEnd = p;
416 db->lookaside.bEnabled = 1;
drh4cfb22f2008-08-01 18:47:01 +0000417 }else{
418 db->lookaside.pEnd = 0;
419 db->lookaside.bEnabled = 0;
drh633e6d52008-07-28 19:34:53 +0000420 }
421 return SQLITE_OK;
422}
423
424/*
drh4413d0e2008-11-04 13:46:27 +0000425** Return the mutex associated with a database connection.
426*/
427sqlite3_mutex *sqlite3_db_mutex(sqlite3 *db){
428 return db->mutex;
429}
430
431/*
drh633e6d52008-07-28 19:34:53 +0000432** Configuration settings for an individual database connection
433*/
434int sqlite3_db_config(sqlite3 *db, int op, ...){
435 va_list ap;
drh6480aad2008-08-01 16:31:14 +0000436 int rc;
drh633e6d52008-07-28 19:34:53 +0000437 va_start(ap, op);
438 switch( op ){
drhe9d1c722008-08-04 20:13:26 +0000439 case SQLITE_DBCONFIG_LOOKASIDE: {
440 void *pBuf = va_arg(ap, void*);
drh633e6d52008-07-28 19:34:53 +0000441 int sz = va_arg(ap, int);
442 int cnt = va_arg(ap, int);
drhe9d1c722008-08-04 20:13:26 +0000443 rc = setupLookaside(db, pBuf, sz, cnt);
drh633e6d52008-07-28 19:34:53 +0000444 break;
445 }
drh6480aad2008-08-01 16:31:14 +0000446 default: {
447 rc = SQLITE_ERROR;
448 break;
449 }
drh633e6d52008-07-28 19:34:53 +0000450 }
451 va_end(ap);
452 return rc;
453}
454
455/*
drhc5499be2008-04-01 15:06:33 +0000456** Routine needed to support the testcase() macro.
457*/
458#ifdef SQLITE_COVERAGE_TEST
459void sqlite3Coverage(int x){
460 static int dummy = 0;
461 dummy += x;
462}
463#endif
464
drha16313e2007-03-30 11:29:32 +0000465
466/*
drh9b5adfa2008-01-20 23:19:56 +0000467** Return true if the buffer z[0..n-1] contains all spaces.
468*/
469static int allSpaces(const char *z, int n){
drh5f3a3672008-04-15 04:02:40 +0000470 while( n>0 && z[n-1]==' ' ){ n--; }
drh9b5adfa2008-01-20 23:19:56 +0000471 return n==0;
472}
473
474/*
drhd3d39e92004-05-20 22:16:29 +0000475** This is the default collating function named "BINARY" which is always
476** available.
drh9b5adfa2008-01-20 23:19:56 +0000477**
478** If the padFlag argument is not NULL then space padding at the end
479** of strings is ignored. This implements the RTRIM collation.
drhd3d39e92004-05-20 22:16:29 +0000480*/
danielk19772c336542005-01-13 02:14:23 +0000481static int binCollFunc(
drh9b5adfa2008-01-20 23:19:56 +0000482 void *padFlag,
drhd3d39e92004-05-20 22:16:29 +0000483 int nKey1, const void *pKey1,
484 int nKey2, const void *pKey2
485){
486 int rc, n;
487 n = nKey1<nKey2 ? nKey1 : nKey2;
488 rc = memcmp(pKey1, pKey2, n);
489 if( rc==0 ){
drh9b5adfa2008-01-20 23:19:56 +0000490 if( padFlag
491 && allSpaces(((char*)pKey1)+n, nKey1-n)
492 && allSpaces(((char*)pKey2)+n, nKey2-n)
493 ){
494 /* Leave rc unchanged at 0 */
495 }else{
496 rc = nKey1 - nKey2;
497 }
drhd3d39e92004-05-20 22:16:29 +0000498 }
499 return rc;
500}
501
502/*
danielk1977dc1bdc42004-06-11 10:51:27 +0000503** Another built-in collating sequence: NOCASE.
504**
505** This collating sequence is intended to be used for "case independant
506** comparison". SQLite's knowledge of upper and lower case equivalents
507** extends only to the 26 characters used in the English language.
508**
509** At the moment there is only a UTF-8 implementation.
danielk19770202b292004-06-09 09:55:16 +0000510*/
511static int nocaseCollatingFunc(
512 void *NotUsed,
513 int nKey1, const void *pKey1,
514 int nKey2, const void *pKey2
515){
516 int r = sqlite3StrNICmp(
drh208f80a2004-08-29 20:08:58 +0000517 (const char *)pKey1, (const char *)pKey2, (nKey1<nKey2)?nKey1:nKey2);
danielk197762c14b32008-11-19 09:05:26 +0000518 UNUSED_PARAMETER(NotUsed);
danielk19770202b292004-06-09 09:55:16 +0000519 if( 0==r ){
520 r = nKey1-nKey2;
521 }
522 return r;
523}
524
525/*
drhaf9ff332002-01-16 21:00:27 +0000526** Return the ROWID of the most recent insert
527*/
drh9bb575f2004-09-06 17:24:11 +0000528sqlite_int64 sqlite3_last_insert_rowid(sqlite3 *db){
drhaf9ff332002-01-16 21:00:27 +0000529 return db->lastRowid;
530}
531
532/*
danielk197724b03fd2004-05-10 10:34:34 +0000533** Return the number of changes in the most recent call to sqlite3_exec().
drhc8d30ac2002-04-12 10:08:59 +0000534*/
drh9bb575f2004-09-06 17:24:11 +0000535int sqlite3_changes(sqlite3 *db){
drhc8d30ac2002-04-12 10:08:59 +0000536 return db->nChange;
537}
538
rdcf146a772004-02-25 22:51:06 +0000539/*
danielk1977b28af712004-06-21 06:50:26 +0000540** Return the number of changes since the database handle was opened.
rdcf146a772004-02-25 22:51:06 +0000541*/
danielk1977b28af712004-06-21 06:50:26 +0000542int sqlite3_total_changes(sqlite3 *db){
543 return db->nTotalChange;
rdcb0c374f2004-02-20 22:53:38 +0000544}
545
drhc8d30ac2002-04-12 10:08:59 +0000546/*
drh50e5dad2001-09-15 00:57:28 +0000547** Close an existing SQLite database
548*/
drh9bb575f2004-09-06 17:24:11 +0000549int sqlite3_close(sqlite3 *db){
drh8e0a2f92002-02-23 23:45:45 +0000550 HashElem *i;
drh001bbcb2003-03-19 03:14:00 +0000551 int j;
danielk19775c4c7782004-06-16 10:39:23 +0000552
553 if( !db ){
danielk197796d81f92004-06-19 03:33:57 +0000554 return SQLITE_OK;
danielk19775c4c7782004-06-16 10:39:23 +0000555 }
drh7e8b8482008-01-23 03:03:05 +0000556 if( !sqlite3SafetyCheckSickOrOk(db) ){
danielk1977e35ee192004-06-26 09:50:11 +0000557 return SQLITE_MISUSE;
558 }
drh605264d2007-08-21 15:13:19 +0000559 sqlite3_mutex_enter(db->mutex);
danielk1977e35ee192004-06-26 09:50:11 +0000560
danielk19771f723bd2005-05-26 12:37:29 +0000561#ifdef SQLITE_SSE
drh37527852006-03-16 16:19:56 +0000562 {
563 extern void sqlite3SseCleanup(sqlite3*);
564 sqlite3SseCleanup(db);
565 }
danielk19771f723bd2005-05-26 12:37:29 +0000566#endif
567
drhffc13f62006-07-30 20:50:44 +0000568 sqlite3ResetInternalSchema(db, 0);
danielk1977a04a34f2007-04-16 15:06:25 +0000569
danielk197701256832007-04-18 14:24:32 +0000570 /* If a transaction is open, the ResetInternalSchema() call above
571 ** will not have called the xDisconnect() method on any virtual
572 ** tables in the db->aVTrans[] array. The following sqlite3VtabRollback()
573 ** call will do so. We need to do this before the check for active
574 ** SQL statements below, as the v-table implementation may be storing
575 ** some prepared statements internally.
576 */
577 sqlite3VtabRollback(db);
578
danielk1977a04a34f2007-04-16 15:06:25 +0000579 /* If there are any outstanding VMs, return SQLITE_BUSY. */
danielk197796d81f92004-06-19 03:33:57 +0000580 if( db->pVdbe ){
581 sqlite3Error(db, SQLITE_BUSY,
582 "Unable to close due to unfinalised statements");
drh27641702007-08-22 02:56:42 +0000583 sqlite3_mutex_leave(db->mutex);
danielk197796d81f92004-06-19 03:33:57 +0000584 return SQLITE_BUSY;
585 }
drh7e8b8482008-01-23 03:03:05 +0000586 assert( sqlite3SafetyCheckSickOrOk(db) );
danielk1977e0048402004-06-15 16:51:01 +0000587
drh001bbcb2003-03-19 03:14:00 +0000588 for(j=0; j<db->nDb; j++){
drh4d189ca2004-02-12 18:46:38 +0000589 struct Db *pDb = &db->aDb[j];
590 if( pDb->pBt ){
danielk19774adee202004-05-08 08:23:19 +0000591 sqlite3BtreeClose(pDb->pBt);
drh4d189ca2004-02-12 18:46:38 +0000592 pDb->pBt = 0;
danielk1977311019b2006-01-10 07:14:23 +0000593 if( j!=1 ){
594 pDb->pSchema = 0;
595 }
drh113088e2003-03-20 01:16:58 +0000596 }
drhf57b3392001-10-08 13:22:32 +0000597 }
danielk19774adee202004-05-08 08:23:19 +0000598 sqlite3ResetInternalSchema(db, 0);
drh1c2d8412003-03-31 00:30:47 +0000599 assert( db->nDb<=2 );
600 assert( db->aDb==db->aDbStatic );
drh70a8ca32008-08-21 18:49:27 +0000601 for(j=0; j<ArraySize(db->aFunc.a); j++){
602 FuncDef *pNext, *pHash, *p;
603 for(p=db->aFunc.a[j]; p; p=pHash){
604 pHash = p->pHash;
605 while( p ){
606 pNext = p->pNext;
607 sqlite3DbFree(db, p);
608 p = pNext;
609 }
drh8e0a2f92002-02-23 23:45:45 +0000610 }
611 }
danielk1977d8123362004-06-12 09:25:12 +0000612 for(i=sqliteHashFirst(&db->aCollSeq); i; i=sqliteHashNext(i)){
danielk1977466be562004-06-10 02:16:01 +0000613 CollSeq *pColl = (CollSeq *)sqliteHashData(i);
danielk1977a9808b32007-05-07 09:32:45 +0000614 /* Invoke any destructors registered for collation sequence user data. */
615 for(j=0; j<3; j++){
616 if( pColl[j].xDel ){
617 pColl[j].xDel(pColl[j].pUser);
618 }
619 }
drh633e6d52008-07-28 19:34:53 +0000620 sqlite3DbFree(db, pColl);
danielk1977466be562004-06-10 02:16:01 +0000621 }
danielk1977d8123362004-06-12 09:25:12 +0000622 sqlite3HashClear(&db->aCollSeq);
drhb9bb7c12006-06-11 23:41:55 +0000623#ifndef SQLITE_OMIT_VIRTUALTABLE
danielk1977d1ab1ba2006-06-15 04:28:13 +0000624 for(i=sqliteHashFirst(&db->aModule); i; i=sqliteHashNext(i)){
625 Module *pMod = (Module *)sqliteHashData(i);
danielk1977832a58a2007-06-22 15:21:15 +0000626 if( pMod->xDestroy ){
627 pMod->xDestroy(pMod->pAux);
628 }
drh633e6d52008-07-28 19:34:53 +0000629 sqlite3DbFree(db, pMod);
danielk1977d1ab1ba2006-06-15 04:28:13 +0000630 }
drhb9bb7c12006-06-11 23:41:55 +0000631 sqlite3HashClear(&db->aModule);
632#endif
danielk1977466be562004-06-10 02:16:01 +0000633
danielk19776622cce2004-05-20 11:00:52 +0000634 sqlite3Error(db, SQLITE_OK, 0); /* Deallocates any cached error strings. */
danielk1977bfd6cce2004-06-18 04:24:54 +0000635 if( db->pErr ){
636 sqlite3ValueFree(db->pErr);
637 }
drhf1952c52006-06-08 15:48:00 +0000638 sqlite3CloseExtensions(db);
danielk197796d81f92004-06-19 03:33:57 +0000639
640 db->magic = SQLITE_MAGIC_ERROR;
danielk1977311019b2006-01-10 07:14:23 +0000641
642 /* The temp-database schema is allocated differently from the other schema
643 ** objects (using sqliteMalloc() directly, instead of sqlite3BtreeSchema()).
644 ** So it needs to be freed here. Todo: Why not roll the temp schema into
645 ** the same sqliteMalloc() as the one that allocates the database
646 ** structure?
647 */
drh633e6d52008-07-28 19:34:53 +0000648 sqlite3DbFree(db, db->aDb[1].pSchema);
drh605264d2007-08-21 15:13:19 +0000649 sqlite3_mutex_leave(db->mutex);
drh7e8b8482008-01-23 03:03:05 +0000650 db->magic = SQLITE_MAGIC_CLOSED;
drh605264d2007-08-21 15:13:19 +0000651 sqlite3_mutex_free(db->mutex);
drh4150ebf2008-10-11 15:38:29 +0000652 assert( db->lookaside.nOut==0 ); /* Fails on a lookaside memory leak */
drhe9d1c722008-08-04 20:13:26 +0000653 if( db->lookaside.bMalloced ){
654 sqlite3_free(db->lookaside.pStart);
655 }
drh17435752007-08-16 04:30:38 +0000656 sqlite3_free(db);
danielk197796d81f92004-06-19 03:33:57 +0000657 return SQLITE_OK;
drh75897232000-05-29 14:26:00 +0000658}
659
660/*
drh001bbcb2003-03-19 03:14:00 +0000661** Rollback all database files.
662*/
drh9bb575f2004-09-06 17:24:11 +0000663void sqlite3RollbackAll(sqlite3 *db){
drh001bbcb2003-03-19 03:14:00 +0000664 int i;
danielk1977f3f06bb2005-12-16 15:24:28 +0000665 int inTrans = 0;
drhe30f4422007-08-21 16:15:55 +0000666 assert( sqlite3_mutex_held(db->mutex) );
danielk19772d1d86f2008-06-20 14:59:51 +0000667 sqlite3BeginBenignMalloc();
drh001bbcb2003-03-19 03:14:00 +0000668 for(i=0; i<db->nDb; i++){
669 if( db->aDb[i].pBt ){
danielk1977f3f06bb2005-12-16 15:24:28 +0000670 if( sqlite3BtreeIsInTrans(db->aDb[i].pBt) ){
671 inTrans = 1;
672 }
danielk19774adee202004-05-08 08:23:19 +0000673 sqlite3BtreeRollback(db->aDb[i].pBt);
drh001bbcb2003-03-19 03:14:00 +0000674 db->aDb[i].inTrans = 0;
675 }
676 }
danielk1977a298e902006-06-22 09:53:48 +0000677 sqlite3VtabRollback(db);
danielk19772d1d86f2008-06-20 14:59:51 +0000678 sqlite3EndBenignMalloc();
danielk1977ae72d982007-10-03 08:46:44 +0000679
danielk197771fd80b2005-12-16 06:54:01 +0000680 if( db->flags&SQLITE_InternChanges ){
danielk1977ea4d9e22007-08-13 15:28:33 +0000681 sqlite3ExpirePreparedStatements(db);
danielk197771fd80b2005-12-16 06:54:01 +0000682 sqlite3ResetInternalSchema(db, 0);
683 }
684
685 /* If one has been configured, invoke the rollback-hook callback */
danielk1977f3f06bb2005-12-16 15:24:28 +0000686 if( db->xRollbackCallback && (inTrans || !db->autoCommit) ){
danielk197771fd80b2005-12-16 06:54:01 +0000687 db->xRollbackCallback(db->pRollbackArg);
688 }
drh001bbcb2003-03-19 03:14:00 +0000689}
690
691/*
drhc22bd472002-05-10 13:14:07 +0000692** Return a static string that describes the kind of error specified in the
693** argument.
drh247be432002-05-10 05:44:55 +0000694*/
danielk1977f20b21c2004-05-31 23:56:42 +0000695const char *sqlite3ErrStr(int rc){
drhc22bd472002-05-10 13:14:07 +0000696 const char *z;
drh4ac285a2006-09-15 07:28:50 +0000697 switch( rc & 0xff ){
drhc60d0442004-09-30 13:43:13 +0000698 case SQLITE_ROW:
699 case SQLITE_DONE:
drhc22bd472002-05-10 13:14:07 +0000700 case SQLITE_OK: z = "not an error"; break;
701 case SQLITE_ERROR: z = "SQL logic error or missing database"; break;
drhc22bd472002-05-10 13:14:07 +0000702 case SQLITE_PERM: z = "access permission denied"; break;
703 case SQLITE_ABORT: z = "callback requested query abort"; break;
704 case SQLITE_BUSY: z = "database is locked"; break;
705 case SQLITE_LOCKED: z = "database table is locked"; break;
706 case SQLITE_NOMEM: z = "out of memory"; break;
707 case SQLITE_READONLY: z = "attempt to write a readonly database"; break;
708 case SQLITE_INTERRUPT: z = "interrupted"; break;
709 case SQLITE_IOERR: z = "disk I/O error"; break;
710 case SQLITE_CORRUPT: z = "database disk image is malformed"; break;
drh2db0bbc2005-08-11 02:10:18 +0000711 case SQLITE_FULL: z = "database or disk is full"; break;
drhc22bd472002-05-10 13:14:07 +0000712 case SQLITE_CANTOPEN: z = "unable to open database file"; break;
drhc22bd472002-05-10 13:14:07 +0000713 case SQLITE_EMPTY: z = "table contains no data"; break;
714 case SQLITE_SCHEMA: z = "database schema has changed"; break;
drh023ae032007-05-08 12:12:16 +0000715 case SQLITE_TOOBIG: z = "String or BLOB exceeded size limit"; break;
drhc22bd472002-05-10 13:14:07 +0000716 case SQLITE_CONSTRAINT: z = "constraint failed"; break;
717 case SQLITE_MISMATCH: z = "datatype mismatch"; break;
718 case SQLITE_MISUSE: z = "library routine called out of sequence";break;
drh65594042008-05-05 16:56:34 +0000719 case SQLITE_NOLFS: z = "large file support is disabled"; break;
drhed6c8672003-01-12 18:02:16 +0000720 case SQLITE_AUTH: z = "authorization denied"; break;
jplyon892f6712003-06-12 08:59:00 +0000721 case SQLITE_FORMAT: z = "auxiliary database format error"; break;
drhb08153d2004-11-20 20:18:55 +0000722 case SQLITE_RANGE: z = "bind or column index out of range"; break;
drhc602f9a2004-02-12 19:01:04 +0000723 case SQLITE_NOTADB: z = "file is encrypted or is not a database";break;
drhc22bd472002-05-10 13:14:07 +0000724 default: z = "unknown error"; break;
drh247be432002-05-10 05:44:55 +0000725 }
drhc22bd472002-05-10 13:14:07 +0000726 return z;
drh247be432002-05-10 05:44:55 +0000727}
728
729/*
drh2dfbbca2000-07-28 14:32:48 +0000730** This routine implements a busy callback that sleeps and tries
731** again until a timeout value is reached. The timeout value is
732** an integer number of milliseconds passed in as the first
733** argument.
734*/
drhdaffd0e2001-04-11 14:28:42 +0000735static int sqliteDefaultBusyCallback(
drh97903fe2005-05-24 20:19:57 +0000736 void *ptr, /* Database connection */
drh2dfbbca2000-07-28 14:32:48 +0000737 int count /* Number of times table has been busy */
738){
danielk197729bafea2008-06-26 10:41:19 +0000739#if SQLITE_OS_WIN || (defined(HAVE_USLEEP) && HAVE_USLEEP)
drhee570fa2005-04-28 12:06:05 +0000740 static const u8 delays[] =
741 { 1, 2, 5, 10, 15, 20, 25, 25, 25, 50, 50, 100 };
742 static const u8 totals[] =
743 { 0, 1, 3, 8, 18, 33, 53, 78, 103, 128, 178, 228 };
drhd1bec472004-01-15 13:29:31 +0000744# define NDELAY (sizeof(delays)/sizeof(delays[0]))
danielk1977b4b47412007-08-17 15:53:36 +0000745 sqlite3 *db = (sqlite3 *)ptr;
746 int timeout = db->busyTimeout;
drh97903fe2005-05-24 20:19:57 +0000747 int delay, prior;
drh2dfbbca2000-07-28 14:32:48 +0000748
drhee570fa2005-04-28 12:06:05 +0000749 assert( count>=0 );
750 if( count < NDELAY ){
751 delay = delays[count];
752 prior = totals[count];
drhd1bec472004-01-15 13:29:31 +0000753 }else{
754 delay = delays[NDELAY-1];
drh68cb6192005-05-06 22:05:56 +0000755 prior = totals[NDELAY-1] + delay*(count-(NDELAY-1));
drh2dfbbca2000-07-28 14:32:48 +0000756 }
drhd1bec472004-01-15 13:29:31 +0000757 if( prior + delay > timeout ){
758 delay = timeout - prior;
drh2dfbbca2000-07-28 14:32:48 +0000759 if( delay<=0 ) return 0;
760 }
danielk19772a6bdf62007-08-20 16:07:00 +0000761 sqlite3OsSleep(db->pVfs, delay*1000);
drh2dfbbca2000-07-28 14:32:48 +0000762 return 1;
763#else
drh482ea182007-08-20 11:12:40 +0000764 sqlite3 *db = (sqlite3 *)ptr;
drh3f737082005-06-14 02:24:31 +0000765 int timeout = ((sqlite3 *)ptr)->busyTimeout;
drh2dfbbca2000-07-28 14:32:48 +0000766 if( (count+1)*1000 > timeout ){
767 return 0;
768 }
drh482ea182007-08-20 11:12:40 +0000769 sqlite3OsSleep(db->pVfs, 1000000);
drh2dfbbca2000-07-28 14:32:48 +0000770 return 1;
771#endif
772}
773
774/*
drha4afb652005-07-09 02:16:02 +0000775** Invoke the given busy handler.
776**
777** This routine is called when an operation failed with a lock.
778** If this routine returns non-zero, the lock is retried. If it
779** returns 0, the operation aborts with an SQLITE_BUSY error.
780*/
781int sqlite3InvokeBusyHandler(BusyHandler *p){
782 int rc;
drh34004ce2008-07-11 16:15:17 +0000783 if( NEVER(p==0) || p->xFunc==0 || p->nBusy<0 ) return 0;
drha4afb652005-07-09 02:16:02 +0000784 rc = p->xFunc(p->pArg, p->nBusy);
785 if( rc==0 ){
786 p->nBusy = -1;
787 }else{
788 p->nBusy++;
789 }
790 return rc;
791}
792
793/*
drh2dfbbca2000-07-28 14:32:48 +0000794** This routine sets the busy callback for an Sqlite database to the
795** given callback function with the given argument.
796*/
danielk1977f9d64d22004-06-19 08:18:07 +0000797int sqlite3_busy_handler(
798 sqlite3 *db,
danielk19772a764eb2004-06-12 01:43:26 +0000799 int (*xBusy)(void*,int),
drh2dfbbca2000-07-28 14:32:48 +0000800 void *pArg
801){
drhe30f4422007-08-21 16:15:55 +0000802 sqlite3_mutex_enter(db->mutex);
danielk197724162fe2004-06-04 06:22:00 +0000803 db->busyHandler.xFunc = xBusy;
804 db->busyHandler.pArg = pArg;
drha4afb652005-07-09 02:16:02 +0000805 db->busyHandler.nBusy = 0;
drhe30f4422007-08-21 16:15:55 +0000806 sqlite3_mutex_leave(db->mutex);
danielk1977f9d64d22004-06-19 08:18:07 +0000807 return SQLITE_OK;
drh2dfbbca2000-07-28 14:32:48 +0000808}
809
danielk1977348bb5d2003-10-18 09:37:26 +0000810#ifndef SQLITE_OMIT_PROGRESS_CALLBACK
811/*
812** This routine sets the progress callback for an Sqlite database to the
813** given callback function with the given argument. The progress callback will
814** be invoked every nOps opcodes.
815*/
danielk197724b03fd2004-05-10 10:34:34 +0000816void sqlite3_progress_handler(
drh9bb575f2004-09-06 17:24:11 +0000817 sqlite3 *db,
danielk1977348bb5d2003-10-18 09:37:26 +0000818 int nOps,
819 int (*xProgress)(void*),
820 void *pArg
821){
drhbd0b1b52008-07-07 19:52:09 +0000822 sqlite3_mutex_enter(db->mutex);
823 if( nOps>0 ){
824 db->xProgress = xProgress;
825 db->nProgressOps = nOps;
826 db->pProgressArg = pArg;
827 }else{
828 db->xProgress = 0;
829 db->nProgressOps = 0;
830 db->pProgressArg = 0;
danielk1977348bb5d2003-10-18 09:37:26 +0000831 }
drhbd0b1b52008-07-07 19:52:09 +0000832 sqlite3_mutex_leave(db->mutex);
danielk1977348bb5d2003-10-18 09:37:26 +0000833}
834#endif
835
836
drh2dfbbca2000-07-28 14:32:48 +0000837/*
838** This routine installs a default busy handler that waits for the
839** specified number of milliseconds before returning 0.
840*/
danielk1977f9d64d22004-06-19 08:18:07 +0000841int sqlite3_busy_timeout(sqlite3 *db, int ms){
drh2dfbbca2000-07-28 14:32:48 +0000842 if( ms>0 ){
drh97903fe2005-05-24 20:19:57 +0000843 db->busyTimeout = ms;
844 sqlite3_busy_handler(db, sqliteDefaultBusyCallback, (void*)db);
drh2dfbbca2000-07-28 14:32:48 +0000845 }else{
danielk197724b03fd2004-05-10 10:34:34 +0000846 sqlite3_busy_handler(db, 0, 0);
drh2dfbbca2000-07-28 14:32:48 +0000847 }
danielk1977f9d64d22004-06-19 08:18:07 +0000848 return SQLITE_OK;
drh2dfbbca2000-07-28 14:32:48 +0000849}
drh4c504392000-10-16 22:06:40 +0000850
851/*
852** Cause any pending operation to stop at its earliest opportunity.
853*/
drh9bb575f2004-09-06 17:24:11 +0000854void sqlite3_interrupt(sqlite3 *db){
drhbd0b1b52008-07-07 19:52:09 +0000855 db->u1.isInterrupted = 1;
drh4c504392000-10-16 22:06:40 +0000856}
drhfa86c412002-02-02 15:01:15 +0000857
drhfa86c412002-02-02 15:01:15 +0000858
859/*
danielk1977771151b2006-01-17 13:21:40 +0000860** This function is exactly the same as sqlite3_create_function(), except
861** that it is designed to be called by internal code. The difference is
862** that if a malloc() fails in sqlite3_create_function(), an error code
863** is returned and the mallocFailed flag cleared.
drhfa86c412002-02-02 15:01:15 +0000864*/
danielk1977771151b2006-01-17 13:21:40 +0000865int sqlite3CreateFunc(
danielk197765904932004-05-26 06:18:37 +0000866 sqlite3 *db,
867 const char *zFunctionName,
868 int nArg,
danielk1977d8123362004-06-12 09:25:12 +0000869 int enc,
danielk197765904932004-05-26 06:18:37 +0000870 void *pUserData,
871 void (*xFunc)(sqlite3_context*,int,sqlite3_value **),
872 void (*xStep)(sqlite3_context*,int,sqlite3_value **),
873 void (*xFinal)(sqlite3_context*)
drh8e0a2f92002-02-23 23:45:45 +0000874){
drh0bce8352002-02-28 00:41:10 +0000875 FuncDef *p;
drh4b59ab52002-08-24 18:24:51 +0000876 int nName;
danielk197765904932004-05-26 06:18:37 +0000877
drhe30f4422007-08-21 16:15:55 +0000878 assert( sqlite3_mutex_held(db->mutex) );
drhc60d0442004-09-30 13:43:13 +0000879 if( zFunctionName==0 ||
danielk1977398eae72004-05-26 06:58:43 +0000880 (xFunc && (xFinal || xStep)) ||
881 (!xFunc && (xFinal && !xStep)) ||
882 (!xFunc && (!xFinal && xStep)) ||
drh24b58dd2008-07-07 14:50:14 +0000883 (nArg<-1 || nArg>SQLITE_MAX_FUNCTION_ARG) ||
drh0a687d12008-07-08 14:52:07 +0000884 (255<(nName = sqlite3Strlen(db, zFunctionName))) ){
drhbadf7a72006-06-14 15:35:36 +0000885 sqlite3Error(db, SQLITE_ERROR, "bad parameters");
danielk197765904932004-05-26 06:18:37 +0000886 return SQLITE_ERROR;
887 }
danielk1977d8123362004-06-12 09:25:12 +0000888
danielk197793758c82005-01-21 08:13:14 +0000889#ifndef SQLITE_OMIT_UTF16
danielk1977d8123362004-06-12 09:25:12 +0000890 /* If SQLITE_UTF16 is specified as the encoding type, transform this
891 ** to one of SQLITE_UTF16LE or SQLITE_UTF16BE using the
892 ** SQLITE_UTF16NATIVE macro. SQLITE_UTF16 is not used internally.
893 **
894 ** If SQLITE_ANY is specified, add three versions of the function
895 ** to the hash table.
896 */
897 if( enc==SQLITE_UTF16 ){
898 enc = SQLITE_UTF16NATIVE;
899 }else if( enc==SQLITE_ANY ){
900 int rc;
danielk1977771151b2006-01-17 13:21:40 +0000901 rc = sqlite3CreateFunc(db, zFunctionName, nArg, SQLITE_UTF8,
danielk1977f9d64d22004-06-19 08:18:07 +0000902 pUserData, xFunc, xStep, xFinal);
drhe30f4422007-08-21 16:15:55 +0000903 if( rc==SQLITE_OK ){
904 rc = sqlite3CreateFunc(db, zFunctionName, nArg, SQLITE_UTF16LE,
905 pUserData, xFunc, xStep, xFinal);
906 }
907 if( rc!=SQLITE_OK ){
908 return rc;
909 }
danielk1977d8123362004-06-12 09:25:12 +0000910 enc = SQLITE_UTF16BE;
911 }
danielk197793758c82005-01-21 08:13:14 +0000912#else
913 enc = SQLITE_UTF8;
914#endif
danielk19779636c4e2005-01-25 04:27:54 +0000915
916 /* Check if an existing function is being overridden or deleted. If so,
917 ** and there are active VMs, then return SQLITE_BUSY. If a function
918 ** is being overridden/deleted but there are no active VMs, allow the
919 ** operation to continue but invalidate all precompiled statements.
920 */
921 p = sqlite3FindFunction(db, zFunctionName, nName, nArg, enc, 0);
922 if( p && p->iPrefEnc==enc && p->nArg==nArg ){
923 if( db->activeVdbeCnt ){
924 sqlite3Error(db, SQLITE_BUSY,
925 "Unable to delete/modify user-function due to active statements");
drh17435752007-08-16 04:30:38 +0000926 assert( !db->mallocFailed );
danielk19779636c4e2005-01-25 04:27:54 +0000927 return SQLITE_BUSY;
928 }else{
929 sqlite3ExpirePreparedStatements(db);
930 }
931 }
danielk197765904932004-05-26 06:18:37 +0000932
danielk1977d8123362004-06-12 09:25:12 +0000933 p = sqlite3FindFunction(db, zFunctionName, nName, nArg, enc, 1);
danielk1977fa18bec2007-09-03 11:04:22 +0000934 assert(p || db->mallocFailed);
935 if( !p ){
936 return SQLITE_NOMEM;
danielk1977771151b2006-01-17 13:21:40 +0000937 }
danielk1977fa18bec2007-09-03 11:04:22 +0000938 p->flags = 0;
939 p->xFunc = xFunc;
940 p->xStep = xStep;
941 p->xFinalize = xFinal;
942 p->pUserData = pUserData;
943 p->nArg = nArg;
danielk197765904932004-05-26 06:18:37 +0000944 return SQLITE_OK;
945}
danielk1977771151b2006-01-17 13:21:40 +0000946
947/*
948** Create new user functions.
949*/
950int sqlite3_create_function(
951 sqlite3 *db,
952 const char *zFunctionName,
953 int nArg,
954 int enc,
955 void *p,
956 void (*xFunc)(sqlite3_context*,int,sqlite3_value **),
957 void (*xStep)(sqlite3_context*,int,sqlite3_value **),
958 void (*xFinal)(sqlite3_context*)
959){
960 int rc;
drhe30f4422007-08-21 16:15:55 +0000961 sqlite3_mutex_enter(db->mutex);
danielk1977771151b2006-01-17 13:21:40 +0000962 rc = sqlite3CreateFunc(db, zFunctionName, nArg, enc, p, xFunc, xStep, xFinal);
drhe30f4422007-08-21 16:15:55 +0000963 rc = sqlite3ApiExit(db, rc);
964 sqlite3_mutex_leave(db->mutex);
965 return rc;
danielk1977771151b2006-01-17 13:21:40 +0000966}
967
danielk197793758c82005-01-21 08:13:14 +0000968#ifndef SQLITE_OMIT_UTF16
danielk197765904932004-05-26 06:18:37 +0000969int sqlite3_create_function16(
970 sqlite3 *db,
971 const void *zFunctionName,
972 int nArg,
973 int eTextRep,
danielk1977771151b2006-01-17 13:21:40 +0000974 void *p,
danielk197765904932004-05-26 06:18:37 +0000975 void (*xFunc)(sqlite3_context*,int,sqlite3_value**),
976 void (*xStep)(sqlite3_context*,int,sqlite3_value**),
977 void (*xFinal)(sqlite3_context*)
978){
979 int rc;
drhaf9a7c22005-12-15 03:04:10 +0000980 char *zFunc8;
drhe30f4422007-08-21 16:15:55 +0000981 sqlite3_mutex_enter(db->mutex);
drh17435752007-08-16 04:30:38 +0000982 assert( !db->mallocFailed );
danielk19771e536952007-08-16 10:09:01 +0000983 zFunc8 = sqlite3Utf16to8(db, zFunctionName, -1);
danielk1977771151b2006-01-17 13:21:40 +0000984 rc = sqlite3CreateFunc(db, zFunc8, nArg, eTextRep, p, xFunc, xStep, xFinal);
drh633e6d52008-07-28 19:34:53 +0000985 sqlite3DbFree(db, zFunc8);
drhe30f4422007-08-21 16:15:55 +0000986 rc = sqlite3ApiExit(db, rc);
987 sqlite3_mutex_leave(db->mutex);
988 return rc;
drh8e0a2f92002-02-23 23:45:45 +0000989}
danielk197793758c82005-01-21 08:13:14 +0000990#endif
drhc9b84a12002-06-20 11:36:48 +0000991
drhb7481e72006-09-16 21:45:14 +0000992
993/*
994** Declare that a function has been overloaded by a virtual table.
995**
996** If the function already exists as a regular global function, then
997** this routine is a no-op. If the function does not exist, then create
998** a new one that always throws a run-time error.
999**
1000** When virtual tables intend to provide an overloaded function, they
1001** should call this routine to make sure the global function exists.
1002** A global function must exist in order for name resolution to work
1003** properly.
1004*/
1005int sqlite3_overload_function(
1006 sqlite3 *db,
1007 const char *zName,
1008 int nArg
1009){
drh0a687d12008-07-08 14:52:07 +00001010 int nName = sqlite3Strlen(db, zName);
drhe30f4422007-08-21 16:15:55 +00001011 int rc;
1012 sqlite3_mutex_enter(db->mutex);
drhb7481e72006-09-16 21:45:14 +00001013 if( sqlite3FindFunction(db, zName, nName, nArg, SQLITE_UTF8, 0)==0 ){
1014 sqlite3CreateFunc(db, zName, nArg, SQLITE_UTF8,
1015 0, sqlite3InvalidFunction, 0, 0);
1016 }
drhe30f4422007-08-21 16:15:55 +00001017 rc = sqlite3ApiExit(db, SQLITE_OK);
1018 sqlite3_mutex_leave(db->mutex);
1019 return rc;
drhb7481e72006-09-16 21:45:14 +00001020}
1021
drh19e2d372005-08-29 23:00:03 +00001022#ifndef SQLITE_OMIT_TRACE
drhc9b84a12002-06-20 11:36:48 +00001023/*
drh18de4822003-01-16 16:28:53 +00001024** Register a trace function. The pArg from the previously registered trace
1025** is returned.
1026**
1027** A NULL trace function means that no tracing is executes. A non-NULL
1028** trace is a pointer to a function that is invoked at the start of each
drh19e2d372005-08-29 23:00:03 +00001029** SQL statement.
drh18de4822003-01-16 16:28:53 +00001030*/
drh9bb575f2004-09-06 17:24:11 +00001031void *sqlite3_trace(sqlite3 *db, void (*xTrace)(void*,const char*), void *pArg){
drhe30f4422007-08-21 16:15:55 +00001032 void *pOld;
1033 sqlite3_mutex_enter(db->mutex);
1034 pOld = db->pTraceArg;
drh18de4822003-01-16 16:28:53 +00001035 db->xTrace = xTrace;
1036 db->pTraceArg = pArg;
drhe30f4422007-08-21 16:15:55 +00001037 sqlite3_mutex_leave(db->mutex);
drh18de4822003-01-16 16:28:53 +00001038 return pOld;
drh0d1a6432003-04-03 15:46:04 +00001039}
drh19e2d372005-08-29 23:00:03 +00001040/*
1041** Register a profile function. The pArg from the previously registered
1042** profile function is returned.
1043**
1044** A NULL profile function means that no profiling is executes. A non-NULL
1045** profile is a pointer to a function that is invoked at the conclusion of
1046** each SQL statement that is run.
1047*/
1048void *sqlite3_profile(
1049 sqlite3 *db,
1050 void (*xProfile)(void*,const char*,sqlite_uint64),
1051 void *pArg
1052){
drhe30f4422007-08-21 16:15:55 +00001053 void *pOld;
1054 sqlite3_mutex_enter(db->mutex);
1055 pOld = db->pProfileArg;
drh19e2d372005-08-29 23:00:03 +00001056 db->xProfile = xProfile;
1057 db->pProfileArg = pArg;
drhe30f4422007-08-21 16:15:55 +00001058 sqlite3_mutex_leave(db->mutex);
drh19e2d372005-08-29 23:00:03 +00001059 return pOld;
1060}
1061#endif /* SQLITE_OMIT_TRACE */
paulb0208cc2003-04-13 18:26:49 +00001062
drhaa940ea2004-01-15 02:44:03 +00001063/*** EXPERIMENTAL ***
1064**
1065** Register a function to be invoked when a transaction comments.
danielk197771fd80b2005-12-16 06:54:01 +00001066** If the invoked function returns non-zero, then the commit becomes a
drhaa940ea2004-01-15 02:44:03 +00001067** rollback.
1068*/
danielk197724b03fd2004-05-10 10:34:34 +00001069void *sqlite3_commit_hook(
drh9bb575f2004-09-06 17:24:11 +00001070 sqlite3 *db, /* Attach the hook to this database */
drhaa940ea2004-01-15 02:44:03 +00001071 int (*xCallback)(void*), /* Function to invoke on each commit */
1072 void *pArg /* Argument to the function */
1073){
drhe30f4422007-08-21 16:15:55 +00001074 void *pOld;
1075 sqlite3_mutex_enter(db->mutex);
1076 pOld = db->pCommitArg;
drhaa940ea2004-01-15 02:44:03 +00001077 db->xCommitCallback = xCallback;
1078 db->pCommitArg = pArg;
drhe30f4422007-08-21 16:15:55 +00001079 sqlite3_mutex_leave(db->mutex);
drhaa940ea2004-01-15 02:44:03 +00001080 return pOld;
1081}
1082
danielk197794eb6a12005-12-15 15:22:08 +00001083/*
1084** Register a callback to be invoked each time a row is updated,
1085** inserted or deleted using this database connection.
1086*/
danielk197771fd80b2005-12-16 06:54:01 +00001087void *sqlite3_update_hook(
danielk197794eb6a12005-12-15 15:22:08 +00001088 sqlite3 *db, /* Attach the hook to this database */
1089 void (*xCallback)(void*,int,char const *,char const *,sqlite_int64),
1090 void *pArg /* Argument to the function */
1091){
drhe30f4422007-08-21 16:15:55 +00001092 void *pRet;
1093 sqlite3_mutex_enter(db->mutex);
1094 pRet = db->pUpdateArg;
danielk197794eb6a12005-12-15 15:22:08 +00001095 db->xUpdateCallback = xCallback;
1096 db->pUpdateArg = pArg;
drhe30f4422007-08-21 16:15:55 +00001097 sqlite3_mutex_leave(db->mutex);
danielk197771fd80b2005-12-16 06:54:01 +00001098 return pRet;
danielk197794eb6a12005-12-15 15:22:08 +00001099}
1100
danielk197771fd80b2005-12-16 06:54:01 +00001101/*
1102** Register a callback to be invoked each time a transaction is rolled
1103** back by this database connection.
1104*/
1105void *sqlite3_rollback_hook(
1106 sqlite3 *db, /* Attach the hook to this database */
1107 void (*xCallback)(void*), /* Callback function */
1108 void *pArg /* Argument to the function */
1109){
drhe30f4422007-08-21 16:15:55 +00001110 void *pRet;
1111 sqlite3_mutex_enter(db->mutex);
1112 pRet = db->pRollbackArg;
danielk197771fd80b2005-12-16 06:54:01 +00001113 db->xRollbackCallback = xCallback;
1114 db->pRollbackArg = pArg;
drhe30f4422007-08-21 16:15:55 +00001115 sqlite3_mutex_leave(db->mutex);
danielk197771fd80b2005-12-16 06:54:01 +00001116 return pRet;
1117}
drhaa940ea2004-01-15 02:44:03 +00001118
paulb0208cc2003-04-13 18:26:49 +00001119/*
drh13bff812003-04-15 01:19:47 +00001120** This routine is called to create a connection to a database BTree
1121** driver. If zFilename is the name of a file, then that file is
1122** opened and used. If zFilename is the magic name ":memory:" then
1123** the database is stored in memory (and is thus forgotten as soon as
1124** the connection is closed.) If zFilename is NULL then the database
drh84bfda42005-07-15 13:05:21 +00001125** is a "virtual" database for transient use only and is deleted as
1126** soon as the connection is closed.
drh90f5ecb2004-07-22 01:19:35 +00001127**
drh84bfda42005-07-15 13:05:21 +00001128** A virtual database can be either a disk file (that is automatically
1129** deleted when the file is closed) or it an be held entirely in memory,
danielk1977b06a0b62008-06-26 10:54:12 +00001130** depending on the values of the SQLITE_TEMP_STORE compile-time macro and the
drh90f5ecb2004-07-22 01:19:35 +00001131** db->temp_store variable, according to the following chart:
1132**
danielk1977b06a0b62008-06-26 10:54:12 +00001133** SQLITE_TEMP_STORE db->temp_store Location of temporary database
1134** ----------------- -------------- ------------------------------
1135** 0 any file
1136** 1 1 file
1137** 1 2 memory
1138** 1 0 file
1139** 2 1 file
1140** 2 2 memory
1141** 2 0 memory
1142** 3 any memory
paulb0208cc2003-04-13 18:26:49 +00001143*/
danielk19774adee202004-05-08 08:23:19 +00001144int sqlite3BtreeFactory(
drh9bb575f2004-09-06 17:24:11 +00001145 const sqlite3 *db, /* Main database when opening aux otherwise 0 */
paulb0208cc2003-04-13 18:26:49 +00001146 const char *zFilename, /* Name of the file containing the BTree database */
1147 int omitJournal, /* if TRUE then do not journal this file */
1148 int nCache, /* How many pages in the page cache */
drh33f4e022007-09-03 15:19:34 +00001149 int vfsFlags, /* Flags passed through to vfsOpen */
danielk19774adee202004-05-08 08:23:19 +00001150 Btree **ppBtree /* Pointer to new Btree object written here */
1151){
drh33f4e022007-09-03 15:19:34 +00001152 int btFlags = 0;
drh90f5ecb2004-07-22 01:19:35 +00001153 int rc;
danielk19774adee202004-05-08 08:23:19 +00001154
drhe30f4422007-08-21 16:15:55 +00001155 assert( sqlite3_mutex_held(db->mutex) );
drheec983e2004-05-08 10:11:36 +00001156 assert( ppBtree != 0);
danielk19774adee202004-05-08 08:23:19 +00001157 if( omitJournal ){
drh33f4e022007-09-03 15:19:34 +00001158 btFlags |= BTREE_OMIT_JOURNAL;
paulb0208cc2003-04-13 18:26:49 +00001159 }
drh7bec5052005-02-06 02:45:41 +00001160 if( db->flags & SQLITE_NoReadlock ){
drh33f4e022007-09-03 15:19:34 +00001161 btFlags |= BTREE_NO_READLOCK;
drh7bec5052005-02-06 02:45:41 +00001162 }
drh90f5ecb2004-07-22 01:19:35 +00001163 if( zFilename==0 ){
danielk1977b06a0b62008-06-26 10:54:12 +00001164#if SQLITE_TEMP_STORE==0
drh22ac46d2004-08-14 18:34:54 +00001165 /* Do nothing */
drh90f5ecb2004-07-22 01:19:35 +00001166#endif
danielk197703aded42004-11-22 05:26:27 +00001167#ifndef SQLITE_OMIT_MEMORYDB
danielk1977b06a0b62008-06-26 10:54:12 +00001168#if SQLITE_TEMP_STORE==1
drh22ac46d2004-08-14 18:34:54 +00001169 if( db->temp_store==2 ) zFilename = ":memory:";
drh90f5ecb2004-07-22 01:19:35 +00001170#endif
danielk1977b06a0b62008-06-26 10:54:12 +00001171#if SQLITE_TEMP_STORE==2
drh22ac46d2004-08-14 18:34:54 +00001172 if( db->temp_store!=1 ) zFilename = ":memory:";
drh90f5ecb2004-07-22 01:19:35 +00001173#endif
danielk1977b06a0b62008-06-26 10:54:12 +00001174#if SQLITE_TEMP_STORE==3
drh22ac46d2004-08-14 18:34:54 +00001175 zFilename = ":memory:";
drh90f5ecb2004-07-22 01:19:35 +00001176#endif
danielk197703aded42004-11-22 05:26:27 +00001177#endif /* SQLITE_OMIT_MEMORYDB */
drh90f5ecb2004-07-22 01:19:35 +00001178 }
danielk19774adee202004-05-08 08:23:19 +00001179
drh33f4e022007-09-03 15:19:34 +00001180 if( (vfsFlags & SQLITE_OPEN_MAIN_DB)!=0 && (zFilename==0 || *zFilename==0) ){
1181 vfsFlags = (vfsFlags & ~SQLITE_OPEN_MAIN_DB) | SQLITE_OPEN_TEMP_DB;
1182 }
1183 rc = sqlite3BtreeOpen(zFilename, (sqlite3 *)db, ppBtree, btFlags, vfsFlags);
danielk1977171bfed2008-06-23 09:50:50 +00001184
1185 /* If the B-Tree was successfully opened, set the pager-cache size to the
1186 ** default value. Except, if the call to BtreeOpen() returned a handle
1187 ** open on an existing shared pager-cache, do not change the pager-cache
1188 ** size.
1189 */
1190 if( rc==SQLITE_OK && 0==sqlite3BtreeSchema(*ppBtree, 0, 0) ){
drh90f5ecb2004-07-22 01:19:35 +00001191 sqlite3BtreeSetCacheSize(*ppBtree, nCache);
1192 }
1193 return rc;
paulb0208cc2003-04-13 18:26:49 +00001194}
danielk19774adee202004-05-08 08:23:19 +00001195
danielk19774ad17132004-05-21 01:47:26 +00001196/*
1197** Return UTF-8 encoded English language explanation of the most recent
1198** error.
1199*/
danielk19776622cce2004-05-20 11:00:52 +00001200const char *sqlite3_errmsg(sqlite3 *db){
drhc60d0442004-09-30 13:43:13 +00001201 const char *z;
danielk1977ae7fc492007-03-29 15:00:52 +00001202 if( !db ){
danielk1977f20b21c2004-05-31 23:56:42 +00001203 return sqlite3ErrStr(SQLITE_NOMEM);
danielk19774ad17132004-05-21 01:47:26 +00001204 }
drhd55d57e2008-07-07 17:53:07 +00001205 if( !sqlite3SafetyCheckSickOrOk(db) ){
danielk1977e35ee192004-06-26 09:50:11 +00001206 return sqlite3ErrStr(SQLITE_MISUSE);
1207 }
drh27641702007-08-22 02:56:42 +00001208 sqlite3_mutex_enter(db->mutex);
drh86f8c192007-08-22 00:39:19 +00001209 assert( !db->mallocFailed );
drh2646da72005-12-09 20:02:05 +00001210 z = (char*)sqlite3_value_text(db->pErr);
danielk1977131c8bc2008-05-22 13:56:17 +00001211 assert( !db->mallocFailed );
drhc60d0442004-09-30 13:43:13 +00001212 if( z==0 ){
1213 z = sqlite3ErrStr(db->errCode);
danielk19776622cce2004-05-20 11:00:52 +00001214 }
drhe30f4422007-08-21 16:15:55 +00001215 sqlite3_mutex_leave(db->mutex);
drhc60d0442004-09-30 13:43:13 +00001216 return z;
danielk19776622cce2004-05-20 11:00:52 +00001217}
1218
drh6c626082004-11-14 21:56:29 +00001219#ifndef SQLITE_OMIT_UTF16
danielk19774ad17132004-05-21 01:47:26 +00001220/*
1221** Return UTF-16 encoded English language explanation of the most recent
1222** error.
1223*/
danielk19776622cce2004-05-20 11:00:52 +00001224const void *sqlite3_errmsg16(sqlite3 *db){
danielk1977bfd6cce2004-06-18 04:24:54 +00001225 /* Because all the characters in the string are in the unicode
1226 ** range 0x00-0xFF, if we pad the big-endian string with a
1227 ** zero byte, we can obtain the little-endian string with
1228 ** &big_endian[1].
1229 */
drh57196282004-10-06 15:41:16 +00001230 static const char outOfMemBe[] = {
danielk1977bfd6cce2004-06-18 04:24:54 +00001231 0, 'o', 0, 'u', 0, 't', 0, ' ',
1232 0, 'o', 0, 'f', 0, ' ',
1233 0, 'm', 0, 'e', 0, 'm', 0, 'o', 0, 'r', 0, 'y', 0, 0, 0
1234 };
drh57196282004-10-06 15:41:16 +00001235 static const char misuseBe [] = {
danielk1977e35ee192004-06-26 09:50:11 +00001236 0, 'l', 0, 'i', 0, 'b', 0, 'r', 0, 'a', 0, 'r', 0, 'y', 0, ' ',
1237 0, 'r', 0, 'o', 0, 'u', 0, 't', 0, 'i', 0, 'n', 0, 'e', 0, ' ',
1238 0, 'c', 0, 'a', 0, 'l', 0, 'l', 0, 'e', 0, 'd', 0, ' ',
1239 0, 'o', 0, 'u', 0, 't', 0, ' ',
1240 0, 'o', 0, 'f', 0, ' ',
1241 0, 's', 0, 'e', 0, 'q', 0, 'u', 0, 'e', 0, 'n', 0, 'c', 0, 'e', 0, 0, 0
1242 };
danielk19774ad17132004-05-21 01:47:26 +00001243
drhc60d0442004-09-30 13:43:13 +00001244 const void *z;
danielk1977ae7fc492007-03-29 15:00:52 +00001245 if( !db ){
drhc60d0442004-09-30 13:43:13 +00001246 return (void *)(&outOfMemBe[SQLITE_UTF16NATIVE==SQLITE_UTF16LE?1:0]);
1247 }
drhd55d57e2008-07-07 17:53:07 +00001248 if( !sqlite3SafetyCheckSickOrOk(db) ){
drhc60d0442004-09-30 13:43:13 +00001249 return (void *)(&misuseBe[SQLITE_UTF16NATIVE==SQLITE_UTF16LE?1:0]);
1250 }
drhe30f4422007-08-21 16:15:55 +00001251 sqlite3_mutex_enter(db->mutex);
1252 assert( !db->mallocFailed );
drhc60d0442004-09-30 13:43:13 +00001253 z = sqlite3_value_text16(db->pErr);
1254 if( z==0 ){
drhb21c8cd2007-08-21 19:33:56 +00001255 sqlite3ValueSetStr(db->pErr, -1, sqlite3ErrStr(db->errCode),
drhc60d0442004-09-30 13:43:13 +00001256 SQLITE_UTF8, SQLITE_STATIC);
1257 z = sqlite3_value_text16(db->pErr);
1258 }
danielk1977131c8bc2008-05-22 13:56:17 +00001259 /* A malloc() may have failed within the call to sqlite3_value_text16()
1260 ** above. If this is the case, then the db->mallocFailed flag needs to
1261 ** be cleared before returning. Do this directly, instead of via
1262 ** sqlite3ApiExit(), to avoid setting the database handle error message.
1263 */
1264 db->mallocFailed = 0;
drhe30f4422007-08-21 16:15:55 +00001265 sqlite3_mutex_leave(db->mutex);
drhc60d0442004-09-30 13:43:13 +00001266 return z;
danielk19776622cce2004-05-20 11:00:52 +00001267}
drh6c626082004-11-14 21:56:29 +00001268#endif /* SQLITE_OMIT_UTF16 */
danielk19776622cce2004-05-20 11:00:52 +00001269
drhc60d0442004-09-30 13:43:13 +00001270/*
danielk19777ddad962005-12-12 06:53:03 +00001271** Return the most recent error code generated by an SQLite routine. If NULL is
1272** passed to this function, we assume a malloc() failed during sqlite3_open().
drhc60d0442004-09-30 13:43:13 +00001273*/
danielk19776622cce2004-05-20 11:00:52 +00001274int sqlite3_errcode(sqlite3 *db){
danielk19777c36d072008-01-31 15:31:01 +00001275 if( db && !sqlite3SafetyCheckSickOrOk(db) ){
drhc60d0442004-09-30 13:43:13 +00001276 return SQLITE_MISUSE;
1277 }
drh01495b92008-01-23 12:52:40 +00001278 if( !db || db->mallocFailed ){
1279 return SQLITE_NOMEM;
1280 }
drh4ac285a2006-09-15 07:28:50 +00001281 return db->errCode & db->errMask;
danielk19776622cce2004-05-20 11:00:52 +00001282}
drh99dfe5e2008-10-30 15:03:15 +00001283int sqlite3_extended_errcode(sqlite3 *db){
1284 if( db && !sqlite3SafetyCheckSickOrOk(db) ){
1285 return SQLITE_MISUSE;
1286 }
1287 if( !db || db->mallocFailed ){
1288 return SQLITE_NOMEM;
1289 }
1290 return db->errCode;
1291}
danielk19776622cce2004-05-20 11:00:52 +00001292
drh0e819f92006-02-01 13:50:41 +00001293/*
1294** Create a new collating function for database "db". The name is zName
1295** and the encoding is enc.
1296*/
danielk19779a30cf62006-01-18 04:26:07 +00001297static int createCollation(
1298 sqlite3* db,
1299 const char *zName,
1300 int enc,
1301 void* pCtx,
danielk1977a9808b32007-05-07 09:32:45 +00001302 int(*xCompare)(void*,int,const void*,int,const void*),
1303 void(*xDel)(void*)
danielk19779a30cf62006-01-18 04:26:07 +00001304){
1305 CollSeq *pColl;
drh7d9bd4e2006-02-16 18:16:36 +00001306 int enc2;
drh0a687d12008-07-08 14:52:07 +00001307 int nName;
danielk19779a30cf62006-01-18 04:26:07 +00001308
drhe30f4422007-08-21 16:15:55 +00001309 assert( sqlite3_mutex_held(db->mutex) );
danielk19779a30cf62006-01-18 04:26:07 +00001310
1311 /* If SQLITE_UTF16 is specified as the encoding type, transform this
1312 ** to one of SQLITE_UTF16LE or SQLITE_UTF16BE using the
1313 ** SQLITE_UTF16NATIVE macro. SQLITE_UTF16 is not used internally.
1314 */
drh7d9bd4e2006-02-16 18:16:36 +00001315 enc2 = enc & ~SQLITE_UTF16_ALIGNED;
1316 if( enc2==SQLITE_UTF16 ){
1317 enc2 = SQLITE_UTF16NATIVE;
danielk19779a30cf62006-01-18 04:26:07 +00001318 }
drh7d9bd4e2006-02-16 18:16:36 +00001319 if( (enc2&~3)!=0 ){
drhd55d57e2008-07-07 17:53:07 +00001320 return SQLITE_MISUSE;
danielk19779a30cf62006-01-18 04:26:07 +00001321 }
1322
1323 /* Check if this call is removing or replacing an existing collation
1324 ** sequence. If so, and there are active VMs, return busy. If there
1325 ** are no active VMs, invalidate any pre-compiled statements.
1326 */
drh0a687d12008-07-08 14:52:07 +00001327 nName = sqlite3Strlen(db, zName);
1328 pColl = sqlite3FindCollSeq(db, (u8)enc2, zName, nName, 0);
danielk19779a30cf62006-01-18 04:26:07 +00001329 if( pColl && pColl->xCmp ){
1330 if( db->activeVdbeCnt ){
1331 sqlite3Error(db, SQLITE_BUSY,
1332 "Unable to delete/modify collation sequence due to active statements");
1333 return SQLITE_BUSY;
1334 }
1335 sqlite3ExpirePreparedStatements(db);
danielk1977a9808b32007-05-07 09:32:45 +00001336
1337 /* If collation sequence pColl was created directly by a call to
1338 ** sqlite3_create_collation, and not generated by synthCollSeq(),
1339 ** then any copies made by synthCollSeq() need to be invalidated.
1340 ** Also, collation destructor - CollSeq.xDel() - function may need
1341 ** to be called.
1342 */
1343 if( (pColl->enc & ~SQLITE_UTF16_ALIGNED)==enc2 ){
drh0a687d12008-07-08 14:52:07 +00001344 CollSeq *aColl = sqlite3HashFind(&db->aCollSeq, zName, nName);
danielk1977a9808b32007-05-07 09:32:45 +00001345 int j;
1346 for(j=0; j<3; j++){
1347 CollSeq *p = &aColl[j];
1348 if( p->enc==pColl->enc ){
1349 if( p->xDel ){
1350 p->xDel(p->pUser);
1351 }
1352 p->xCmp = 0;
1353 }
1354 }
1355 }
danielk19779a30cf62006-01-18 04:26:07 +00001356 }
1357
drh0a687d12008-07-08 14:52:07 +00001358 pColl = sqlite3FindCollSeq(db, (u8)enc2, zName, nName, 1);
danielk19779a30cf62006-01-18 04:26:07 +00001359 if( pColl ){
1360 pColl->xCmp = xCompare;
1361 pColl->pUser = pCtx;
danielk1977a9808b32007-05-07 09:32:45 +00001362 pColl->xDel = xDel;
drh7d9bd4e2006-02-16 18:16:36 +00001363 pColl->enc = enc2 | (enc & SQLITE_UTF16_ALIGNED);
danielk19779a30cf62006-01-18 04:26:07 +00001364 }
1365 sqlite3Error(db, SQLITE_OK, 0);
1366 return SQLITE_OK;
1367}
1368
1369
danielk19776622cce2004-05-20 11:00:52 +00001370/*
drhbb4957f2008-03-20 14:03:29 +00001371** This array defines hard upper bounds on limit values. The
1372** initializer must be kept in sync with the SQLITE_LIMIT_*
1373** #defines in sqlite3.h.
1374*/
drhb1a6c3c2008-03-20 16:30:17 +00001375static const int aHardLimit[] = {
drhbb4957f2008-03-20 14:03:29 +00001376 SQLITE_MAX_LENGTH,
1377 SQLITE_MAX_SQL_LENGTH,
1378 SQLITE_MAX_COLUMN,
1379 SQLITE_MAX_EXPR_DEPTH,
1380 SQLITE_MAX_COMPOUND_SELECT,
1381 SQLITE_MAX_VDBE_OP,
1382 SQLITE_MAX_FUNCTION_ARG,
1383 SQLITE_MAX_ATTACHED,
drhbb4957f2008-03-20 14:03:29 +00001384 SQLITE_MAX_LIKE_PATTERN_LENGTH,
1385 SQLITE_MAX_VARIABLE_NUMBER,
1386};
1387
1388/*
1389** Make sure the hard limits are set to reasonable values
1390*/
1391#if SQLITE_MAX_LENGTH<100
1392# error SQLITE_MAX_LENGTH must be at least 100
1393#endif
1394#if SQLITE_MAX_SQL_LENGTH<100
1395# error SQLITE_MAX_SQL_LENGTH must be at least 100
1396#endif
1397#if SQLITE_MAX_SQL_LENGTH>SQLITE_MAX_LENGTH
1398# error SQLITE_MAX_SQL_LENGTH must not be greater than SQLITE_MAX_LENGTH
1399#endif
drhbb4957f2008-03-20 14:03:29 +00001400#if SQLITE_MAX_COMPOUND_SELECT<2
1401# error SQLITE_MAX_COMPOUND_SELECT must be at least 2
1402#endif
1403#if SQLITE_MAX_VDBE_OP<40
1404# error SQLITE_MAX_VDBE_OP must be at least 40
1405#endif
drhe82f5d02008-10-07 19:53:14 +00001406#if SQLITE_MAX_FUNCTION_ARG<0 || SQLITE_MAX_FUNCTION_ARG>1000
1407# error SQLITE_MAX_FUNCTION_ARG must be between 0 and 1000
drhbb4957f2008-03-20 14:03:29 +00001408#endif
danielk19777b7e23b2008-08-20 16:21:12 +00001409#if SQLITE_MAX_ATTACHED<0 || SQLITE_MAX_ATTACHED>30
1410# error SQLITE_MAX_ATTACHED must be between 0 and 30
drhbb4957f2008-03-20 14:03:29 +00001411#endif
drhbb4957f2008-03-20 14:03:29 +00001412#if SQLITE_MAX_LIKE_PATTERN_LENGTH<1
1413# error SQLITE_MAX_LIKE_PATTERN_LENGTH must be at least 1
1414#endif
1415#if SQLITE_MAX_VARIABLE_NUMBER<1
1416# error SQLITE_MAX_VARIABLE_NUMBER must be at least 1
1417#endif
drh70a8ca32008-08-21 18:49:27 +00001418#if SQLITE_MAX_COLUMN>32767
1419# error SQLITE_MAX_COLUMN must not exceed 32767
1420#endif
drhbb4957f2008-03-20 14:03:29 +00001421
1422
1423/*
1424** Change the value of a limit. Report the old value.
1425** If an invalid limit index is supplied, report -1.
1426** Make no changes but still report the old value if the
1427** new limit is negative.
1428**
1429** A new lower limit does not shrink existing constructs.
1430** It merely prevents new constructs that exceed the limit
1431** from forming.
1432*/
1433int sqlite3_limit(sqlite3 *db, int limitId, int newLimit){
1434 int oldLimit;
drh521cc842008-04-15 02:36:33 +00001435 if( limitId<0 || limitId>=SQLITE_N_LIMIT ){
drhbb4957f2008-03-20 14:03:29 +00001436 return -1;
1437 }
1438 oldLimit = db->aLimit[limitId];
1439 if( newLimit>=0 ){
drhf47ce562008-03-20 18:00:49 +00001440 if( newLimit>aHardLimit[limitId] ){
drhbb4957f2008-03-20 14:03:29 +00001441 newLimit = aHardLimit[limitId];
1442 }
1443 db->aLimit[limitId] = newLimit;
1444 }
1445 return oldLimit;
1446}
1447
1448/*
danielk19774ad17132004-05-21 01:47:26 +00001449** This routine does the work of opening a database on behalf of
1450** sqlite3_open() and sqlite3_open16(). The database filename "zFilename"
drhee570fa2005-04-28 12:06:05 +00001451** is UTF-8 encoded.
danielk19774ad17132004-05-21 01:47:26 +00001452*/
1453static int openDatabase(
1454 const char *zFilename, /* Database filename UTF-8 encoded */
drh605264d2007-08-21 15:13:19 +00001455 sqlite3 **ppDb, /* OUT: Returned database handle */
1456 unsigned flags, /* Operational flags */
1457 const char *zVfs /* Name of the VFS to use */
danielk19774ad17132004-05-21 01:47:26 +00001458){
1459 sqlite3 *db;
danielk1977da184232006-01-05 11:34:32 +00001460 int rc;
drhd64fe2f2005-08-28 17:00:23 +00001461 CollSeq *pColl;
drh039963a2008-09-03 00:43:15 +00001462 int isThreadsafe;
danielk19774ad17132004-05-21 01:47:26 +00001463
drh40257ff2008-06-13 18:24:27 +00001464#ifndef SQLITE_OMIT_AUTOINIT
1465 rc = sqlite3_initialize();
1466 if( rc ) return rc;
1467#endif
1468
drh039963a2008-09-03 00:43:15 +00001469 if( sqlite3GlobalConfig.bCoreMutex==0 ){
danielk19779a6284c2008-07-10 17:52:49 +00001470 isThreadsafe = 0;
drh039963a2008-09-03 00:43:15 +00001471 }else if( flags & SQLITE_OPEN_NOMUTEX ){
1472 isThreadsafe = 0;
1473 }else if( flags & SQLITE_OPEN_FULLMUTEX ){
1474 isThreadsafe = 1;
1475 }else{
1476 isThreadsafe = sqlite3GlobalConfig.bFullMutex;
danielk19779a6284c2008-07-10 17:52:49 +00001477 }
1478
drha4267dc2008-02-19 15:20:44 +00001479 /* Remove harmful bits from the flags parameter */
1480 flags &= ~( SQLITE_OPEN_DELETEONCLOSE |
1481 SQLITE_OPEN_MAIN_DB |
1482 SQLITE_OPEN_TEMP_DB |
1483 SQLITE_OPEN_TRANSIENT_DB |
1484 SQLITE_OPEN_MAIN_JOURNAL |
1485 SQLITE_OPEN_TEMP_JOURNAL |
1486 SQLITE_OPEN_SUBJOURNAL |
danielk19779a6284c2008-07-10 17:52:49 +00001487 SQLITE_OPEN_MASTER_JOURNAL |
drh039963a2008-09-03 00:43:15 +00001488 SQLITE_OPEN_NOMUTEX |
1489 SQLITE_OPEN_FULLMUTEX
drha4267dc2008-02-19 15:20:44 +00001490 );
1491
danielk19774ad17132004-05-21 01:47:26 +00001492 /* Allocate the sqlite data structure */
drh17435752007-08-16 04:30:38 +00001493 db = sqlite3MallocZero( sizeof(sqlite3) );
danielk19774ad17132004-05-21 01:47:26 +00001494 if( db==0 ) goto opendb_out;
drh039963a2008-09-03 00:43:15 +00001495 if( isThreadsafe ){
danielk197759f8c082008-06-18 17:09:10 +00001496 db->mutex = sqlite3MutexAlloc(SQLITE_MUTEX_RECURSIVE);
1497 if( db->mutex==0 ){
1498 sqlite3_free(db);
1499 db = 0;
1500 goto opendb_out;
1501 }
drh605264d2007-08-21 15:13:19 +00001502 }
drh27641702007-08-22 02:56:42 +00001503 sqlite3_mutex_enter(db->mutex);
drh4ac285a2006-09-15 07:28:50 +00001504 db->errMask = 0xff;
danielk19774ad17132004-05-21 01:47:26 +00001505 db->priorNewRowid = 0;
danielk19774ad17132004-05-21 01:47:26 +00001506 db->nDb = 2;
drh153c62c2007-08-24 03:51:33 +00001507 db->magic = SQLITE_MAGIC_BUSY;
danielk19774ad17132004-05-21 01:47:26 +00001508 db->aDb = db->aDbStatic;
drh633e6d52008-07-28 19:34:53 +00001509
drhbb4957f2008-03-20 14:03:29 +00001510 assert( sizeof(db->aLimit)==sizeof(aHardLimit) );
1511 memcpy(db->aLimit, aHardLimit, sizeof(db->aLimit));
danielk19771d850a72004-05-31 08:26:49 +00001512 db->autoCommit = 1;
drhddac25c2007-12-05 01:38:23 +00001513 db->nextAutovac = -1;
danielk1977f653d782008-03-20 11:04:21 +00001514 db->nextPagesize = 0;
drh76fe8032006-07-11 14:17:51 +00001515 db->flags |= SQLITE_ShortColNames
1516#if SQLITE_DEFAULT_FILE_FORMAT<4
1517 | SQLITE_LegacyFileFmt
1518#endif
drh56424db2007-03-27 22:24:11 +00001519#ifdef SQLITE_ENABLE_LOAD_EXTENSION
1520 | SQLITE_LoadExtension
1521#endif
drh76fe8032006-07-11 14:17:51 +00001522 ;
drh1b67f3c2008-10-10 17:41:28 +00001523 sqlite3HashInit(&db->aCollSeq, 0);
drhb9bb7c12006-06-11 23:41:55 +00001524#ifndef SQLITE_OMIT_VIRTUALTABLE
drh1b67f3c2008-10-10 17:41:28 +00001525 sqlite3HashInit(&db->aModule, 0);
drhb9bb7c12006-06-11 23:41:55 +00001526#endif
danielk1977da184232006-01-05 11:34:32 +00001527
danielk197795c8a542007-09-01 06:51:27 +00001528 db->pVfs = sqlite3_vfs_find(zVfs);
1529 if( !db->pVfs ){
1530 rc = SQLITE_ERROR;
drhafc91042008-02-21 02:09:45 +00001531 sqlite3Error(db, rc, "no such vfs: %s", zVfs);
danielk197795c8a542007-09-01 06:51:27 +00001532 goto opendb_out;
1533 }
1534
danielk19770202b292004-06-09 09:55:16 +00001535 /* Add the default collation sequence BINARY. BINARY works for both UTF-8
1536 ** and UTF-16, so add a version for each to avoid any unnecessary
1537 ** conversions. The only error that can occur here is a malloc() failure.
1538 */
drhafc91042008-02-21 02:09:45 +00001539 createCollation(db, "BINARY", SQLITE_UTF8, 0, binCollFunc, 0);
1540 createCollation(db, "BINARY", SQLITE_UTF16BE, 0, binCollFunc, 0);
1541 createCollation(db, "BINARY", SQLITE_UTF16LE, 0, binCollFunc, 0);
1542 createCollation(db, "RTRIM", SQLITE_UTF8, (void*)1, binCollFunc, 0);
drh77db4c02008-03-18 13:01:38 +00001543 if( db->mallocFailed ){
danielk19770202b292004-06-09 09:55:16 +00001544 goto opendb_out;
1545 }
drh77db4c02008-03-18 13:01:38 +00001546 db->pDfltColl = sqlite3FindCollSeq(db, SQLITE_UTF8, "BINARY", 6, 0);
1547 assert( db->pDfltColl!=0 );
danielk19770202b292004-06-09 09:55:16 +00001548
1549 /* Also add a UTF-8 case-insensitive collation sequence. */
danielk1977a9808b32007-05-07 09:32:45 +00001550 createCollation(db, "NOCASE", SQLITE_UTF8, 0, nocaseCollatingFunc, 0);
danielk19770202b292004-06-09 09:55:16 +00001551
drhd64fe2f2005-08-28 17:00:23 +00001552 /* Set flags on the built-in collating sequences */
1553 db->pDfltColl->type = SQLITE_COLL_BINARY;
1554 pColl = sqlite3FindCollSeq(db, SQLITE_UTF8, "NOCASE", 6, 0);
1555 if( pColl ){
1556 pColl->type = SQLITE_COLL_NOCASE;
1557 }
1558
danielk19774ad17132004-05-21 01:47:26 +00001559 /* Open the backend database driver */
drh33f4e022007-09-03 15:19:34 +00001560 db->openFlags = flags;
1561 rc = sqlite3BtreeFactory(db, zFilename, 0, SQLITE_DEFAULT_CACHE_SIZE,
1562 flags | SQLITE_OPEN_MAIN_DB,
drhc797d4d2007-05-08 01:08:49 +00001563 &db->aDb[0].pBt);
danielk19774ad17132004-05-21 01:47:26 +00001564 if( rc!=SQLITE_OK ){
danielk197745e60aa2008-09-23 17:39:26 +00001565 if( rc==SQLITE_IOERR_NOMEM ){
1566 rc = SQLITE_NOMEM;
1567 }
danielk19774ad17132004-05-21 01:47:26 +00001568 sqlite3Error(db, rc, 0);
danielk19774ad17132004-05-21 01:47:26 +00001569 goto opendb_out;
1570 }
drh17435752007-08-16 04:30:38 +00001571 db->aDb[0].pSchema = sqlite3SchemaGet(db, db->aDb[0].pBt);
1572 db->aDb[1].pSchema = sqlite3SchemaGet(db, 0);
danielk197714db2662006-01-09 16:12:04 +00001573
drh03b808a2006-03-13 15:06:05 +00001574
danielk197753c0f742005-03-29 03:10:59 +00001575 /* The default safety_level for the main database is 'full'; for the temp
1576 ** database it is 'NONE'. This matches the pager layer defaults.
1577 */
1578 db->aDb[0].zName = "main";
danielk197791cf71b2004-06-26 06:37:06 +00001579 db->aDb[0].safety_level = 3;
danielk197753c0f742005-03-29 03:10:59 +00001580#ifndef SQLITE_OMIT_TEMPDB
1581 db->aDb[1].zName = "temp";
danielk197791cf71b2004-06-26 06:37:06 +00001582 db->aDb[1].safety_level = 1;
danielk197753c0f742005-03-29 03:10:59 +00001583#endif
1584
danielk1977832a58a2007-06-22 15:21:15 +00001585 db->magic = SQLITE_MAGIC_OPEN;
drh17435752007-08-16 04:30:38 +00001586 if( db->mallocFailed ){
danielk1977832a58a2007-06-22 15:21:15 +00001587 goto opendb_out;
1588 }
1589
danielk19778e227872004-06-07 07:52:17 +00001590 /* Register all built-in functions, but do not attempt to read the
1591 ** database schema yet. This is delayed until the first time the database
1592 ** is accessed.
1593 */
danielk1977832a58a2007-06-22 15:21:15 +00001594 sqlite3Error(db, SQLITE_OK, 0);
1595 sqlite3RegisterBuiltinFunctions(db);
danielk19774ad17132004-05-21 01:47:26 +00001596
drh1409be62006-08-23 20:07:20 +00001597 /* Load automatic extensions - extensions that have been registered
1598 ** using the sqlite3_automatic_extension() API.
1599 */
drhf533acc2006-12-19 18:57:11 +00001600 (void)sqlite3AutoLoadExtensions(db);
danielk1977832a58a2007-06-22 15:21:15 +00001601 if( sqlite3_errcode(db)!=SQLITE_OK ){
1602 goto opendb_out;
1603 }
drh1409be62006-08-23 20:07:20 +00001604
drhaa29c132006-09-02 13:58:06 +00001605#ifdef SQLITE_ENABLE_FTS1
drh17435752007-08-16 04:30:38 +00001606 if( !db->mallocFailed ){
drhaa29c132006-09-02 13:58:06 +00001607 extern int sqlite3Fts1Init(sqlite3*);
danielk1977832a58a2007-06-22 15:21:15 +00001608 rc = sqlite3Fts1Init(db);
drhaa29c132006-09-02 13:58:06 +00001609 }
1610#endif
1611
shessa26cf572006-10-19 20:27:58 +00001612#ifdef SQLITE_ENABLE_FTS2
drh17435752007-08-16 04:30:38 +00001613 if( !db->mallocFailed && rc==SQLITE_OK ){
shessa26cf572006-10-19 20:27:58 +00001614 extern int sqlite3Fts2Init(sqlite3*);
danielk1977832a58a2007-06-22 15:21:15 +00001615 rc = sqlite3Fts2Init(db);
shessa26cf572006-10-19 20:27:58 +00001616 }
1617#endif
1618
shess69c4ae22007-08-20 17:37:47 +00001619#ifdef SQLITE_ENABLE_FTS3
1620 if( !db->mallocFailed && rc==SQLITE_OK ){
shess69c4ae22007-08-20 17:37:47 +00001621 rc = sqlite3Fts3Init(db);
1622 }
1623#endif
1624
danielk197783852ac2007-05-06 16:04:11 +00001625#ifdef SQLITE_ENABLE_ICU
drh17435752007-08-16 04:30:38 +00001626 if( !db->mallocFailed && rc==SQLITE_OK ){
danielk1977832a58a2007-06-22 15:21:15 +00001627 rc = sqlite3IcuInit(db);
danielk197783852ac2007-05-06 16:04:11 +00001628 }
1629#endif
danielk1977ebaecc12008-05-26 18:41:54 +00001630
1631#ifdef SQLITE_ENABLE_RTREE
1632 if( !db->mallocFailed && rc==SQLITE_OK){
danielk1977ebaecc12008-05-26 18:41:54 +00001633 rc = sqlite3RtreeInit(db);
1634 }
1635#endif
1636
danielk1977832a58a2007-06-22 15:21:15 +00001637 sqlite3Error(db, rc, 0);
danielk197783852ac2007-05-06 16:04:11 +00001638
drh8fd5bd32007-04-02 16:40:37 +00001639 /* -DSQLITE_DEFAULT_LOCKING_MODE=1 makes EXCLUSIVE the default locking
1640 ** mode. -DSQLITE_DEFAULT_LOCKING_MODE=0 make NORMAL the default locking
1641 ** mode. Doing nothing at all also makes NORMAL the default.
1642 */
1643#ifdef SQLITE_DEFAULT_LOCKING_MODE
1644 db->dfltLockMode = SQLITE_DEFAULT_LOCKING_MODE;
1645 sqlite3PagerLockingMode(sqlite3BtreePager(db->aDb[0].pBt),
1646 SQLITE_DEFAULT_LOCKING_MODE);
1647#endif
1648
drh633e6d52008-07-28 19:34:53 +00001649 /* Enable the lookaside-malloc subsystem */
drh1b67f3c2008-10-10 17:41:28 +00001650 setupLookaside(db, 0, sqlite3GlobalConfig.szLookaside,
1651 sqlite3GlobalConfig.nLookaside);
drh633e6d52008-07-28 19:34:53 +00001652
danielk19774ad17132004-05-21 01:47:26 +00001653opendb_out:
drhafc91042008-02-21 02:09:45 +00001654 if( db ){
danielk1977075c23a2008-09-01 18:34:20 +00001655 assert( db->mutex!=0 || isThreadsafe==0 || sqlite3GlobalConfig.bFullMutex==0 );
drhf3a65f72007-08-22 20:18:21 +00001656 sqlite3_mutex_leave(db->mutex);
1657 }
danielk197759633ae2008-08-27 19:01:57 +00001658 rc = sqlite3_errcode(db);
1659 if( rc==SQLITE_NOMEM ){
danielk19777ddad962005-12-12 06:53:03 +00001660 sqlite3_close(db);
1661 db = 0;
danielk197759633ae2008-08-27 19:01:57 +00001662 }else if( rc!=SQLITE_OK ){
1663 db->magic = SQLITE_MAGIC_SICK;
danielk197713073932004-06-30 11:54:06 +00001664 }
danielk19774ad17132004-05-21 01:47:26 +00001665 *ppDb = db;
danielk197754f01982006-01-18 15:25:17 +00001666 return sqlite3ApiExit(0, rc);
danielk19774ad17132004-05-21 01:47:26 +00001667}
1668
1669/*
1670** Open a new database handle.
1671*/
danielk197780290862004-05-22 09:21:21 +00001672int sqlite3_open(
danielk19774ad17132004-05-21 01:47:26 +00001673 const char *zFilename,
danielk19774f057f92004-06-08 00:02:33 +00001674 sqlite3 **ppDb
danielk19774ad17132004-05-21 01:47:26 +00001675){
drh605264d2007-08-21 15:13:19 +00001676 return openDatabase(zFilename, ppDb,
1677 SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, 0);
1678}
1679int sqlite3_open_v2(
drh428e2822007-08-30 16:23:19 +00001680 const char *filename, /* Database filename (UTF-8) */
drh605264d2007-08-21 15:13:19 +00001681 sqlite3 **ppDb, /* OUT: SQLite db handle */
1682 int flags, /* Flags */
1683 const char *zVfs /* Name of VFS module to use */
1684){
1685 return openDatabase(filename, ppDb, flags, zVfs);
danielk197783ab5a82004-05-21 11:39:05 +00001686}
1687
drh6c626082004-11-14 21:56:29 +00001688#ifndef SQLITE_OMIT_UTF16
danielk19774ad17132004-05-21 01:47:26 +00001689/*
1690** Open a new database handle.
1691*/
1692int sqlite3_open16(
1693 const void *zFilename,
danielk19774f057f92004-06-08 00:02:33 +00001694 sqlite3 **ppDb
danielk19774ad17132004-05-21 01:47:26 +00001695){
danielk1977bfd6cce2004-06-18 04:24:54 +00001696 char const *zFilename8; /* zFilename encoded in UTF-8 instead of UTF-16 */
danielk1977bfd6cce2004-06-18 04:24:54 +00001697 sqlite3_value *pVal;
drh40257ff2008-06-13 18:24:27 +00001698 int rc;
danielk19774ad17132004-05-21 01:47:26 +00001699
danielk19777ddad962005-12-12 06:53:03 +00001700 assert( zFilename );
danielk19774ad17132004-05-21 01:47:26 +00001701 assert( ppDb );
danielk1977bfd6cce2004-06-18 04:24:54 +00001702 *ppDb = 0;
drh40257ff2008-06-13 18:24:27 +00001703#ifndef SQLITE_OMIT_AUTOINIT
1704 rc = sqlite3_initialize();
1705 if( rc ) return rc;
1706#endif
danielk19771e536952007-08-16 10:09:01 +00001707 pVal = sqlite3ValueNew(0);
drhb21c8cd2007-08-21 19:33:56 +00001708 sqlite3ValueSetStr(pVal, -1, zFilename, SQLITE_UTF16NATIVE, SQLITE_STATIC);
1709 zFilename8 = sqlite3ValueText(pVal, SQLITE_UTF8);
danielk1977bfd6cce2004-06-18 04:24:54 +00001710 if( zFilename8 ){
drh605264d2007-08-21 15:13:19 +00001711 rc = openDatabase(zFilename8, ppDb,
1712 SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, 0);
drhafc91042008-02-21 02:09:45 +00001713 assert( *ppDb || rc==SQLITE_NOMEM );
danielk1977f51bf482008-04-28 16:19:35 +00001714 if( rc==SQLITE_OK && !DbHasProperty(*ppDb, 0, DB_SchemaLoaded) ){
danielk1977fb103a82008-04-03 16:28:24 +00001715 ENC(*ppDb) = SQLITE_UTF16NATIVE;
danielk1977bfd6cce2004-06-18 04:24:54 +00001716 }
drh40257ff2008-06-13 18:24:27 +00001717 }else{
1718 rc = SQLITE_NOMEM;
danielk19774ad17132004-05-21 01:47:26 +00001719 }
danielk19777ddad962005-12-12 06:53:03 +00001720 sqlite3ValueFree(pVal);
danielk19778e227872004-06-07 07:52:17 +00001721
danielk197754f01982006-01-18 15:25:17 +00001722 return sqlite3ApiExit(0, rc);
danielk19774ad17132004-05-21 01:47:26 +00001723}
drh6c626082004-11-14 21:56:29 +00001724#endif /* SQLITE_OMIT_UTF16 */
danielk19774ad17132004-05-21 01:47:26 +00001725
danielk1977106bb232004-05-21 10:08:53 +00001726/*
danielk1977d8123362004-06-12 09:25:12 +00001727** Register a new collation sequence with the database handle db.
1728*/
danielk19770202b292004-06-09 09:55:16 +00001729int sqlite3_create_collation(
1730 sqlite3* db,
1731 const char *zName,
danielk1977466be562004-06-10 02:16:01 +00001732 int enc,
danielk19770202b292004-06-09 09:55:16 +00001733 void* pCtx,
1734 int(*xCompare)(void*,int,const void*,int,const void*)
1735){
danielk19779a30cf62006-01-18 04:26:07 +00001736 int rc;
drhe30f4422007-08-21 16:15:55 +00001737 sqlite3_mutex_enter(db->mutex);
drh17435752007-08-16 04:30:38 +00001738 assert( !db->mallocFailed );
danielk1977a9808b32007-05-07 09:32:45 +00001739 rc = createCollation(db, zName, enc, pCtx, xCompare, 0);
drhe30f4422007-08-21 16:15:55 +00001740 rc = sqlite3ApiExit(db, rc);
1741 sqlite3_mutex_leave(db->mutex);
1742 return rc;
danielk1977a9808b32007-05-07 09:32:45 +00001743}
1744
1745/*
1746** Register a new collation sequence with the database handle db.
1747*/
danielk1977a393c032007-05-07 14:58:53 +00001748int sqlite3_create_collation_v2(
danielk1977a9808b32007-05-07 09:32:45 +00001749 sqlite3* db,
1750 const char *zName,
1751 int enc,
1752 void* pCtx,
1753 int(*xCompare)(void*,int,const void*,int,const void*),
1754 void(*xDel)(void*)
1755){
1756 int rc;
drhe30f4422007-08-21 16:15:55 +00001757 sqlite3_mutex_enter(db->mutex);
drh17435752007-08-16 04:30:38 +00001758 assert( !db->mallocFailed );
danielk1977a9808b32007-05-07 09:32:45 +00001759 rc = createCollation(db, zName, enc, pCtx, xCompare, xDel);
drhe30f4422007-08-21 16:15:55 +00001760 rc = sqlite3ApiExit(db, rc);
1761 sqlite3_mutex_leave(db->mutex);
1762 return rc;
danielk19770202b292004-06-09 09:55:16 +00001763}
1764
drh6c626082004-11-14 21:56:29 +00001765#ifndef SQLITE_OMIT_UTF16
danielk1977d8123362004-06-12 09:25:12 +00001766/*
1767** Register a new collation sequence with the database handle db.
1768*/
danielk19770202b292004-06-09 09:55:16 +00001769int sqlite3_create_collation16(
1770 sqlite3* db,
mihailimbda2e622008-06-23 11:23:14 +00001771 const void *zName,
danielk1977466be562004-06-10 02:16:01 +00001772 int enc,
danielk19770202b292004-06-09 09:55:16 +00001773 void* pCtx,
1774 int(*xCompare)(void*,int,const void*,int,const void*)
1775){
danielk19779a30cf62006-01-18 04:26:07 +00001776 int rc = SQLITE_OK;
drh01495b92008-01-23 12:52:40 +00001777 char *zName8;
drhe30f4422007-08-21 16:15:55 +00001778 sqlite3_mutex_enter(db->mutex);
drh17435752007-08-16 04:30:38 +00001779 assert( !db->mallocFailed );
danielk19771e536952007-08-16 10:09:01 +00001780 zName8 = sqlite3Utf16to8(db, zName, -1);
danielk19779a30cf62006-01-18 04:26:07 +00001781 if( zName8 ){
danielk1977a9808b32007-05-07 09:32:45 +00001782 rc = createCollation(db, zName8, enc, pCtx, xCompare, 0);
drh633e6d52008-07-28 19:34:53 +00001783 sqlite3DbFree(db, zName8);
danielk19779a30cf62006-01-18 04:26:07 +00001784 }
drhe30f4422007-08-21 16:15:55 +00001785 rc = sqlite3ApiExit(db, rc);
1786 sqlite3_mutex_leave(db->mutex);
1787 return rc;
danielk19770202b292004-06-09 09:55:16 +00001788}
drh6c626082004-11-14 21:56:29 +00001789#endif /* SQLITE_OMIT_UTF16 */
danielk19777cedc8d2004-06-10 10:50:08 +00001790
danielk1977d8123362004-06-12 09:25:12 +00001791/*
1792** Register a collation sequence factory callback with the database handle
1793** db. Replace any previously installed collation sequence factory.
1794*/
danielk19777cedc8d2004-06-10 10:50:08 +00001795int sqlite3_collation_needed(
1796 sqlite3 *db,
1797 void *pCollNeededArg,
1798 void(*xCollNeeded)(void*,sqlite3*,int eTextRep,const char*)
1799){
drhe30f4422007-08-21 16:15:55 +00001800 sqlite3_mutex_enter(db->mutex);
danielk19777cedc8d2004-06-10 10:50:08 +00001801 db->xCollNeeded = xCollNeeded;
1802 db->xCollNeeded16 = 0;
1803 db->pCollNeededArg = pCollNeededArg;
drhe30f4422007-08-21 16:15:55 +00001804 sqlite3_mutex_leave(db->mutex);
danielk19777cedc8d2004-06-10 10:50:08 +00001805 return SQLITE_OK;
1806}
danielk1977d8123362004-06-12 09:25:12 +00001807
drh6c626082004-11-14 21:56:29 +00001808#ifndef SQLITE_OMIT_UTF16
danielk1977d8123362004-06-12 09:25:12 +00001809/*
1810** Register a collation sequence factory callback with the database handle
1811** db. Replace any previously installed collation sequence factory.
1812*/
danielk19777cedc8d2004-06-10 10:50:08 +00001813int sqlite3_collation_needed16(
1814 sqlite3 *db,
1815 void *pCollNeededArg,
1816 void(*xCollNeeded16)(void*,sqlite3*,int eTextRep,const void*)
1817){
drhe30f4422007-08-21 16:15:55 +00001818 sqlite3_mutex_enter(db->mutex);
danielk19777cedc8d2004-06-10 10:50:08 +00001819 db->xCollNeeded = 0;
1820 db->xCollNeeded16 = xCollNeeded16;
1821 db->pCollNeededArg = pCollNeededArg;
drhe30f4422007-08-21 16:15:55 +00001822 sqlite3_mutex_leave(db->mutex);
danielk19777cedc8d2004-06-10 10:50:08 +00001823 return SQLITE_OK;
1824}
drh6c626082004-11-14 21:56:29 +00001825#endif /* SQLITE_OMIT_UTF16 */
danielk19776b456a22005-03-21 04:04:02 +00001826
1827#ifndef SQLITE_OMIT_GLOBALRECOVER
shaneeec556d2008-10-12 00:27:53 +00001828#ifndef SQLITE_OMIT_DEPRECATED
danielk19776b456a22005-03-21 04:04:02 +00001829/*
danielk19777ddad962005-12-12 06:53:03 +00001830** This function is now an anachronism. It used to be used to recover from a
1831** malloc() failure, but SQLite now does this automatically.
danielk19776b456a22005-03-21 04:04:02 +00001832*/
drh7d97efb2007-10-12 19:35:48 +00001833int sqlite3_global_recover(void){
danielk1977261919c2005-12-06 12:52:59 +00001834 return SQLITE_OK;
danielk19776b456a22005-03-21 04:04:02 +00001835}
1836#endif
shaneeec556d2008-10-12 00:27:53 +00001837#endif
drh3e1d8e62005-05-26 16:23:34 +00001838
1839/*
1840** Test to see whether or not the database connection is in autocommit
1841** mode. Return TRUE if it is and FALSE if not. Autocommit mode is on
1842** by default. Autocommit is disabled by a BEGIN statement and reenabled
1843** by the next COMMIT or ROLLBACK.
1844**
1845******* THIS IS AN EXPERIMENTAL API AND IS SUBJECT TO CHANGE ******
1846*/
1847int sqlite3_get_autocommit(sqlite3 *db){
1848 return db->autoCommit;
1849}
drh49285702005-09-17 15:20:26 +00001850
1851#ifdef SQLITE_DEBUG
1852/*
1853** The following routine is subtituted for constant SQLITE_CORRUPT in
1854** debugging builds. This provides a way to set a breakpoint for when
1855** corruption is first detected.
1856*/
1857int sqlite3Corrupt(void){
1858 return SQLITE_CORRUPT;
1859}
1860#endif
drh7c1817e2006-01-10 13:58:48 +00001861
shaneeec556d2008-10-12 00:27:53 +00001862#ifndef SQLITE_OMIT_DEPRECATED
drh6f7adc82006-01-11 21:41:20 +00001863/*
1864** This is a convenience routine that makes sure that all thread-specific
1865** data for this thread has been deallocated.
drhdce8bdb2007-08-16 13:01:44 +00001866**
1867** SQLite no longer uses thread-specific data so this routine is now a
1868** no-op. It is retained for historical compatibility.
drh6f7adc82006-01-11 21:41:20 +00001869*/
1870void sqlite3_thread_cleanup(void){
drh6f7adc82006-01-11 21:41:20 +00001871}
shaneeec556d2008-10-12 00:27:53 +00001872#endif
danielk1977deb802c2006-02-09 13:43:28 +00001873
1874/*
1875** Return meta information about a specific column of a database table.
1876** See comment in sqlite3.h (sqlite.h.in) for details.
1877*/
1878#ifdef SQLITE_ENABLE_COLUMN_METADATA
1879int sqlite3_table_column_metadata(
1880 sqlite3 *db, /* Connection handle */
1881 const char *zDbName, /* Database name or NULL */
1882 const char *zTableName, /* Table name */
1883 const char *zColumnName, /* Column name */
1884 char const **pzDataType, /* OUTPUT: Declared data type */
1885 char const **pzCollSeq, /* OUTPUT: Collation sequence name */
1886 int *pNotNull, /* OUTPUT: True if NOT NULL constraint exists */
1887 int *pPrimaryKey, /* OUTPUT: True if column part of PK */
drh9be07162008-06-16 20:51:15 +00001888 int *pAutoinc /* OUTPUT: True if column is auto-increment */
danielk1977deb802c2006-02-09 13:43:28 +00001889){
1890 int rc;
1891 char *zErrMsg = 0;
1892 Table *pTab = 0;
1893 Column *pCol = 0;
1894 int iCol;
1895
1896 char const *zDataType = 0;
1897 char const *zCollSeq = 0;
1898 int notnull = 0;
1899 int primarykey = 0;
1900 int autoinc = 0;
1901
1902 /* Ensure the database schema has been loaded */
drhe30f4422007-08-21 16:15:55 +00001903 sqlite3_mutex_enter(db->mutex);
drha0af99f2008-04-16 00:49:12 +00001904 (void)sqlite3SafetyOn(db);
drh3cb3edc2008-03-07 21:37:19 +00001905 sqlite3BtreeEnterAll(db);
danielk1977deb802c2006-02-09 13:43:28 +00001906 rc = sqlite3Init(db, &zErrMsg);
drh3cb3edc2008-03-07 21:37:19 +00001907 sqlite3BtreeLeaveAll(db);
danielk1977deb802c2006-02-09 13:43:28 +00001908 if( SQLITE_OK!=rc ){
1909 goto error_out;
1910 }
1911
1912 /* Locate the table in question */
1913 pTab = sqlite3FindTable(db, zTableName, zDbName);
1914 if( !pTab || pTab->pSelect ){
1915 pTab = 0;
1916 goto error_out;
1917 }
1918
1919 /* Find the column for which info is requested */
1920 if( sqlite3IsRowid(zColumnName) ){
1921 iCol = pTab->iPKey;
1922 if( iCol>=0 ){
1923 pCol = &pTab->aCol[iCol];
1924 }
1925 }else{
1926 for(iCol=0; iCol<pTab->nCol; iCol++){
1927 pCol = &pTab->aCol[iCol];
1928 if( 0==sqlite3StrICmp(pCol->zName, zColumnName) ){
1929 break;
1930 }
1931 }
1932 if( iCol==pTab->nCol ){
1933 pTab = 0;
1934 goto error_out;
1935 }
1936 }
1937
1938 /* The following block stores the meta information that will be returned
1939 ** to the caller in local variables zDataType, zCollSeq, notnull, primarykey
1940 ** and autoinc. At this point there are two possibilities:
1941 **
1942 ** 1. The specified column name was rowid", "oid" or "_rowid_"
1943 ** and there is no explicitly declared IPK column.
1944 **
1945 ** 2. The table is not a view and the column name identified an
1946 ** explicitly declared column. Copy meta information from *pCol.
1947 */
1948 if( pCol ){
1949 zDataType = pCol->zType;
1950 zCollSeq = pCol->zColl;
drh9be07162008-06-16 20:51:15 +00001951 notnull = pCol->notNull!=0;
1952 primarykey = pCol->isPrimKey!=0;
drh7d10d5a2008-08-20 16:35:10 +00001953 autoinc = pTab->iPKey==iCol && (pTab->tabFlags & TF_Autoincrement)!=0;
danielk1977deb802c2006-02-09 13:43:28 +00001954 }else{
1955 zDataType = "INTEGER";
1956 primarykey = 1;
1957 }
1958 if( !zCollSeq ){
1959 zCollSeq = "BINARY";
1960 }
1961
1962error_out:
drh01495b92008-01-23 12:52:40 +00001963 (void)sqlite3SafetyOff(db);
danielk1977deb802c2006-02-09 13:43:28 +00001964
1965 /* Whether the function call succeeded or failed, set the output parameters
1966 ** to whatever their local counterparts contain. If an error did occur,
1967 ** this has the effect of zeroing all output parameters.
1968 */
1969 if( pzDataType ) *pzDataType = zDataType;
1970 if( pzCollSeq ) *pzCollSeq = zCollSeq;
1971 if( pNotNull ) *pNotNull = notnull;
1972 if( pPrimaryKey ) *pPrimaryKey = primarykey;
1973 if( pAutoinc ) *pAutoinc = autoinc;
1974
1975 if( SQLITE_OK==rc && !pTab ){
drh633e6d52008-07-28 19:34:53 +00001976 sqlite3DbFree(db, zErrMsg);
drh118640b2008-07-16 14:02:32 +00001977 zErrMsg = sqlite3MPrintf(db, "no such table column: %s.%s", zTableName,
drhf089aa42008-07-08 19:34:06 +00001978 zColumnName);
danielk1977deb802c2006-02-09 13:43:28 +00001979 rc = SQLITE_ERROR;
1980 }
1981 sqlite3Error(db, rc, (zErrMsg?"%s":0), zErrMsg);
drh633e6d52008-07-28 19:34:53 +00001982 sqlite3DbFree(db, zErrMsg);
drhe30f4422007-08-21 16:15:55 +00001983 rc = sqlite3ApiExit(db, rc);
1984 sqlite3_mutex_leave(db->mutex);
drhf9cb7f52006-06-27 20:06:44 +00001985 return rc;
1986}
drhe30f4422007-08-21 16:15:55 +00001987#endif
drhf9cb7f52006-06-27 20:06:44 +00001988
1989/*
1990** Sleep for a little while. Return the amount of time slept.
1991*/
1992int sqlite3_sleep(int ms){
danielk1977b4b47412007-08-17 15:53:36 +00001993 sqlite3_vfs *pVfs;
drhe30f4422007-08-21 16:15:55 +00001994 int rc;
drhd677b3d2007-08-20 22:48:41 +00001995 pVfs = sqlite3_vfs_find(0);
drh40257ff2008-06-13 18:24:27 +00001996 if( pVfs==0 ) return 0;
danielk1977fee2d252007-08-18 10:59:19 +00001997
1998 /* This function works in milliseconds, but the underlying OsSleep()
1999 ** API uses microseconds. Hence the 1000's.
2000 */
drhe30f4422007-08-21 16:15:55 +00002001 rc = (sqlite3OsSleep(pVfs, 1000*ms)/1000);
drhe30f4422007-08-21 16:15:55 +00002002 return rc;
drhf9cb7f52006-06-27 20:06:44 +00002003}
drh4ac285a2006-09-15 07:28:50 +00002004
2005/*
2006** Enable or disable the extended result codes.
2007*/
2008int sqlite3_extended_result_codes(sqlite3 *db, int onoff){
drhe30f4422007-08-21 16:15:55 +00002009 sqlite3_mutex_enter(db->mutex);
drh4ac285a2006-09-15 07:28:50 +00002010 db->errMask = onoff ? 0xffffffff : 0xff;
drhe30f4422007-08-21 16:15:55 +00002011 sqlite3_mutex_leave(db->mutex);
drh4ac285a2006-09-15 07:28:50 +00002012 return SQLITE_OK;
2013}
drhcc6bb3e2007-08-31 16:11:35 +00002014
2015/*
2016** Invoke the xFileControl method on a particular database.
2017*/
2018int sqlite3_file_control(sqlite3 *db, const char *zDbName, int op, void *pArg){
2019 int rc = SQLITE_ERROR;
2020 int iDb;
2021 sqlite3_mutex_enter(db->mutex);
2022 if( zDbName==0 ){
2023 iDb = 0;
2024 }else{
2025 for(iDb=0; iDb<db->nDb; iDb++){
2026 if( strcmp(db->aDb[iDb].zName, zDbName)==0 ) break;
2027 }
2028 }
2029 if( iDb<db->nDb ){
2030 Btree *pBtree = db->aDb[iDb].pBt;
2031 if( pBtree ){
2032 Pager *pPager;
drh55176252008-01-22 14:50:16 +00002033 sqlite3_file *fd;
drhcc6bb3e2007-08-31 16:11:35 +00002034 sqlite3BtreeEnter(pBtree);
2035 pPager = sqlite3BtreePager(pBtree);
drh55176252008-01-22 14:50:16 +00002036 assert( pPager!=0 );
2037 fd = sqlite3PagerFile(pPager);
2038 assert( fd!=0 );
2039 if( fd->pMethods ){
2040 rc = sqlite3OsFileControl(fd, op, pArg);
drhcc6bb3e2007-08-31 16:11:35 +00002041 }
2042 sqlite3BtreeLeave(pBtree);
2043 }
2044 }
2045 sqlite3_mutex_leave(db->mutex);
2046 return rc;
2047}
drhed13d982008-01-31 14:43:24 +00002048
2049/*
2050** Interface to the testing logic.
2051*/
2052int sqlite3_test_control(int op, ...){
drhed13d982008-01-31 14:43:24 +00002053 int rc = 0;
drh3088d592008-03-21 16:45:47 +00002054#ifndef SQLITE_OMIT_BUILTIN_TEST
drh2fa18682008-03-19 14:15:34 +00002055 va_list ap;
drhed13d982008-01-31 14:43:24 +00002056 va_start(ap, op);
2057 switch( op ){
danielk1977d09414c2008-06-19 18:17:49 +00002058
2059 /*
drh984bfaa2008-03-19 16:08:53 +00002060 ** Save the current state of the PRNG.
2061 */
drh2fa18682008-03-19 14:15:34 +00002062 case SQLITE_TESTCTRL_PRNG_SAVE: {
2063 sqlite3PrngSaveState();
2064 break;
2065 }
drh984bfaa2008-03-19 16:08:53 +00002066
2067 /*
2068 ** Restore the state of the PRNG to the last state saved using
2069 ** PRNG_SAVE. If PRNG_SAVE has never before been called, then
2070 ** this verb acts like PRNG_RESET.
2071 */
drh2fa18682008-03-19 14:15:34 +00002072 case SQLITE_TESTCTRL_PRNG_RESTORE: {
2073 sqlite3PrngRestoreState();
2074 break;
2075 }
drh984bfaa2008-03-19 16:08:53 +00002076
2077 /*
2078 ** Reset the PRNG back to its uninitialized state. The next call
2079 ** to sqlite3_randomness() will reseed the PRNG using a single call
2080 ** to the xRandomness method of the default VFS.
2081 */
drh2fa18682008-03-19 14:15:34 +00002082 case SQLITE_TESTCTRL_PRNG_RESET: {
2083 sqlite3PrngResetState();
2084 break;
2085 }
drh3088d592008-03-21 16:45:47 +00002086
2087 /*
2088 ** sqlite3_test_control(BITVEC_TEST, size, program)
2089 **
2090 ** Run a test against a Bitvec object of size. The program argument
2091 ** is an array of integers that defines the test. Return -1 on a
2092 ** memory allocation error, 0 on success, or non-zero for an error.
2093 ** See the sqlite3BitvecBuiltinTest() for additional information.
2094 */
2095 case SQLITE_TESTCTRL_BITVEC_TEST: {
2096 int sz = va_arg(ap, int);
2097 int *aProg = va_arg(ap, int*);
2098 rc = sqlite3BitvecBuiltinTest(sz, aProg);
2099 break;
2100 }
danielk19772d1d86f2008-06-20 14:59:51 +00002101
2102 /*
2103 ** sqlite3_test_control(BENIGN_MALLOC_HOOKS, xBegin, xEnd)
2104 **
2105 ** Register hooks to call to indicate which malloc() failures
2106 ** are benign.
2107 */
2108 case SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS: {
danielk1977ca026792008-06-23 14:15:52 +00002109 typedef void (*void_function)(void);
2110 void_function xBenignBegin;
2111 void_function xBenignEnd;
2112 xBenignBegin = va_arg(ap, void_function);
2113 xBenignEnd = va_arg(ap, void_function);
danielk19772d1d86f2008-06-20 14:59:51 +00002114 sqlite3BenignMallocHooks(xBenignBegin, xBenignEnd);
2115 break;
2116 }
drhed13d982008-01-31 14:43:24 +00002117 }
2118 va_end(ap);
drh3088d592008-03-21 16:45:47 +00002119#endif /* SQLITE_OMIT_BUILTIN_TEST */
danielk19777c36d072008-01-31 15:31:01 +00002120 return rc;
drhed13d982008-01-31 14:43:24 +00002121}