blob: b4b981e5481164c555bd3a8fed11762cfa71f1f4 [file] [log] [blame]
drh1e397f82006-06-08 15:28:43 +00001/*
2** 2006 June 7
3**
4** The author disclaims copyright to this source code. In place of
5** a legal notice, here is a blessing:
6**
7** 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.
10**
11*************************************************************************
12** This file contains code used to dynamically load extensions into
13** the SQLite library.
14*/
drh1e397f82006-06-08 15:28:43 +000015
danielk19777c9aaa72008-01-01 05:49:07 +000016#ifndef SQLITE_CORE
17 #define SQLITE_CORE 1 /* Disable the API redefinition in sqlite3ext.h */
18#endif
drh1e397f82006-06-08 15:28:43 +000019#include "sqlite3ext.h"
drhf1952c52006-06-08 15:48:00 +000020#include "sqliteInt.h"
drh1e397f82006-06-08 15:28:43 +000021#include <string.h>
drh1e397f82006-06-08 15:28:43 +000022
mlcreech9323f762008-03-19 23:52:34 +000023#ifndef SQLITE_OMIT_LOAD_EXTENSION
24
drh70df4fe2006-06-13 15:12:21 +000025/*
26** Some API routines are omitted when various features are
27** excluded from a build of SQLite. Substitute a NULL pointer
28** for any missing APIs.
29*/
drh1e397f82006-06-08 15:28:43 +000030#ifndef SQLITE_ENABLE_COLUMN_METADATA
31# define sqlite3_column_database_name 0
32# define sqlite3_column_database_name16 0
33# define sqlite3_column_table_name 0
34# define sqlite3_column_table_name16 0
35# define sqlite3_column_origin_name 0
36# define sqlite3_column_origin_name16 0
drh1e397f82006-06-08 15:28:43 +000037#endif
38
danielk19774b2688a2006-06-20 11:01:07 +000039#ifdef SQLITE_OMIT_AUTHORIZATION
drhaf304692007-04-23 23:56:31 +000040# define sqlite3_set_authorizer 0
danielk19774b2688a2006-06-20 11:01:07 +000041#endif
42
43#ifdef SQLITE_OMIT_UTF16
drhaf304692007-04-23 23:56:31 +000044# define sqlite3_bind_text16 0
45# define sqlite3_collation_needed16 0
46# define sqlite3_column_decltype16 0
47# define sqlite3_column_name16 0
48# define sqlite3_column_text16 0
49# define sqlite3_complete16 0
50# define sqlite3_create_collation16 0
51# define sqlite3_create_function16 0
52# define sqlite3_errmsg16 0
53# define sqlite3_open16 0
54# define sqlite3_prepare16 0
55# define sqlite3_prepare16_v2 0
56# define sqlite3_result_error16 0
57# define sqlite3_result_text16 0
58# define sqlite3_result_text16be 0
59# define sqlite3_result_text16le 0
60# define sqlite3_value_text16 0
61# define sqlite3_value_text16be 0
62# define sqlite3_value_text16le 0
63# define sqlite3_column_database_name16 0
64# define sqlite3_column_table_name16 0
65# define sqlite3_column_origin_name16 0
danielk19774b2688a2006-06-20 11:01:07 +000066#endif
67
68#ifdef SQLITE_OMIT_COMPLETE
69# define sqlite3_complete 0
70# define sqlite3_complete16 0
71#endif
72
danbb2b4412011-04-06 17:54:31 +000073#ifdef SQLITE_OMIT_DECLTYPE
74# define sqlite3_column_decltype16 0
75# define sqlite3_column_decltype 0
76#endif
77
danielk19774b2688a2006-06-20 11:01:07 +000078#ifdef SQLITE_OMIT_PROGRESS_CALLBACK
79# define sqlite3_progress_handler 0
80#endif
81
82#ifdef SQLITE_OMIT_VIRTUALTABLE
83# define sqlite3_create_module 0
danielk1977b7865fb2007-06-27 11:10:03 +000084# define sqlite3_create_module_v2 0
danielk19774b2688a2006-06-20 11:01:07 +000085# define sqlite3_declare_vtab 0
dan0ea25172011-06-28 07:15:43 +000086# define sqlite3_vtab_config 0
87# define sqlite3_vtab_on_conflict 0
danielk19774b2688a2006-06-20 11:01:07 +000088#endif
89
drhe31a1fb2007-01-26 13:08:24 +000090#ifdef SQLITE_OMIT_SHARED_CACHE
91# define sqlite3_enable_shared_cache 0
92#endif
93
94#ifdef SQLITE_OMIT_TRACE
95# define sqlite3_profile 0
96# define sqlite3_trace 0
97#endif
98
99#ifdef SQLITE_OMIT_GET_TABLE
100# define sqlite3_free_table 0
101# define sqlite3_get_table 0
102#endif
103
danielk1977a15db352007-09-14 16:20:00 +0000104#ifdef SQLITE_OMIT_INCRBLOB
105#define sqlite3_bind_zeroblob 0
106#define sqlite3_blob_bytes 0
107#define sqlite3_blob_close 0
108#define sqlite3_blob_open 0
109#define sqlite3_blob_read 0
110#define sqlite3_blob_write 0
dan0ea25172011-06-28 07:15:43 +0000111#define sqlite3_blob_reopen 0
danielk1977a15db352007-09-14 16:20:00 +0000112#endif
113
drh70df4fe2006-06-13 15:12:21 +0000114/*
115** The following structure contains pointers to all SQLite API routines.
116** A pointer to this structure is passed into extensions when they are
117** loaded so that the extension can make calls back into the SQLite
118** library.
119**
120** When adding new APIs, add them to the bottom of this structure
121** in order to preserve backwards compatibility.
122**
123** Extensions that use newer APIs should first call the
124** sqlite3_libversion_number() to make sure that the API they
125** intend to use is supported by the library. Extensions should
126** also check to make sure that the pointer to the function is
127** not NULL before calling it.
128*/
drhde244782008-04-10 16:01:10 +0000129static const sqlite3_api_routines sqlite3Apis = {
drh1e397f82006-06-08 15:28:43 +0000130 sqlite3_aggregate_context,
shaneeec556d2008-10-12 00:27:53 +0000131#ifndef SQLITE_OMIT_DEPRECATED
drh1e397f82006-06-08 15:28:43 +0000132 sqlite3_aggregate_count,
shaneeec556d2008-10-12 00:27:53 +0000133#else
134 0,
135#endif
drh1e397f82006-06-08 15:28:43 +0000136 sqlite3_bind_blob,
137 sqlite3_bind_double,
138 sqlite3_bind_int,
139 sqlite3_bind_int64,
140 sqlite3_bind_null,
141 sqlite3_bind_parameter_count,
142 sqlite3_bind_parameter_index,
143 sqlite3_bind_parameter_name,
144 sqlite3_bind_text,
145 sqlite3_bind_text16,
drhc1be6322006-06-27 00:14:27 +0000146 sqlite3_bind_value,
drh1e397f82006-06-08 15:28:43 +0000147 sqlite3_busy_handler,
148 sqlite3_busy_timeout,
149 sqlite3_changes,
150 sqlite3_close,
151 sqlite3_collation_needed,
152 sqlite3_collation_needed16,
153 sqlite3_column_blob,
154 sqlite3_column_bytes,
155 sqlite3_column_bytes16,
156 sqlite3_column_count,
157 sqlite3_column_database_name,
158 sqlite3_column_database_name16,
159 sqlite3_column_decltype,
160 sqlite3_column_decltype16,
161 sqlite3_column_double,
162 sqlite3_column_int,
163 sqlite3_column_int64,
164 sqlite3_column_name,
165 sqlite3_column_name16,
166 sqlite3_column_origin_name,
167 sqlite3_column_origin_name16,
168 sqlite3_column_table_name,
169 sqlite3_column_table_name16,
170 sqlite3_column_text,
171 sqlite3_column_text16,
172 sqlite3_column_type,
danielk1977d6e8dd02006-06-15 15:38:41 +0000173 sqlite3_column_value,
drh1e397f82006-06-08 15:28:43 +0000174 sqlite3_commit_hook,
175 sqlite3_complete,
176 sqlite3_complete16,
177 sqlite3_create_collation,
178 sqlite3_create_collation16,
179 sqlite3_create_function,
180 sqlite3_create_function16,
danielk1977d6e8dd02006-06-15 15:38:41 +0000181 sqlite3_create_module,
drh1e397f82006-06-08 15:28:43 +0000182 sqlite3_data_count,
183 sqlite3_db_handle,
danielk1977d6e8dd02006-06-15 15:38:41 +0000184 sqlite3_declare_vtab,
drh1e397f82006-06-08 15:28:43 +0000185 sqlite3_enable_shared_cache,
186 sqlite3_errcode,
187 sqlite3_errmsg,
188 sqlite3_errmsg16,
189 sqlite3_exec,
shaneeec556d2008-10-12 00:27:53 +0000190#ifndef SQLITE_OMIT_DEPRECATED
drh1e397f82006-06-08 15:28:43 +0000191 sqlite3_expired,
shaneeec556d2008-10-12 00:27:53 +0000192#else
193 0,
194#endif
drh1e397f82006-06-08 15:28:43 +0000195 sqlite3_finalize,
196 sqlite3_free,
197 sqlite3_free_table,
198 sqlite3_get_autocommit,
199 sqlite3_get_auxdata,
200 sqlite3_get_table,
drhe31a1fb2007-01-26 13:08:24 +0000201 0, /* Was sqlite3_global_recover(), but that function is deprecated */
drh1e397f82006-06-08 15:28:43 +0000202 sqlite3_interrupt,
203 sqlite3_last_insert_rowid,
204 sqlite3_libversion,
205 sqlite3_libversion_number,
drh28dd4792006-06-26 21:35:44 +0000206 sqlite3_malloc,
drh1e397f82006-06-08 15:28:43 +0000207 sqlite3_mprintf,
208 sqlite3_open,
209 sqlite3_open16,
210 sqlite3_prepare,
211 sqlite3_prepare16,
212 sqlite3_profile,
213 sqlite3_progress_handler,
drh28dd4792006-06-26 21:35:44 +0000214 sqlite3_realloc,
drh1e397f82006-06-08 15:28:43 +0000215 sqlite3_reset,
216 sqlite3_result_blob,
217 sqlite3_result_double,
218 sqlite3_result_error,
219 sqlite3_result_error16,
220 sqlite3_result_int,
221 sqlite3_result_int64,
222 sqlite3_result_null,
223 sqlite3_result_text,
224 sqlite3_result_text16,
225 sqlite3_result_text16be,
226 sqlite3_result_text16le,
227 sqlite3_result_value,
228 sqlite3_rollback_hook,
229 sqlite3_set_authorizer,
230 sqlite3_set_auxdata,
231 sqlite3_snprintf,
232 sqlite3_step,
233 sqlite3_table_column_metadata,
shaneeec556d2008-10-12 00:27:53 +0000234#ifndef SQLITE_OMIT_DEPRECATED
drh1e397f82006-06-08 15:28:43 +0000235 sqlite3_thread_cleanup,
shaneeec556d2008-10-12 00:27:53 +0000236#else
237 0,
238#endif
drh1e397f82006-06-08 15:28:43 +0000239 sqlite3_total_changes,
240 sqlite3_trace,
shaneeec556d2008-10-12 00:27:53 +0000241#ifndef SQLITE_OMIT_DEPRECATED
drh1e397f82006-06-08 15:28:43 +0000242 sqlite3_transfer_bindings,
shaneeec556d2008-10-12 00:27:53 +0000243#else
244 0,
245#endif
drh1e397f82006-06-08 15:28:43 +0000246 sqlite3_update_hook,
247 sqlite3_user_data,
248 sqlite3_value_blob,
249 sqlite3_value_bytes,
250 sqlite3_value_bytes16,
251 sqlite3_value_double,
252 sqlite3_value_int,
253 sqlite3_value_int64,
254 sqlite3_value_numeric_type,
255 sqlite3_value_text,
256 sqlite3_value_text16,
257 sqlite3_value_text16be,
258 sqlite3_value_text16le,
259 sqlite3_value_type,
260 sqlite3_vmprintf,
drh70df4fe2006-06-13 15:12:21 +0000261 /*
262 ** The original API set ends here. All extensions can call any
263 ** of the APIs above provided that the pointer is not NULL. But
264 ** before calling APIs that follow, extension should check the
265 ** sqlite3_libversion_number() to make sure they are dealing with
266 ** a library that is new enough to support that API.
267 *************************************************************************
268 */
shess74093102006-09-22 23:38:21 +0000269 sqlite3_overload_function,
drh6d54da02007-03-25 19:08:46 +0000270
271 /*
272 ** Added after 3.3.13
273 */
274 sqlite3_prepare_v2,
275 sqlite3_prepare16_v2,
drha92993c2007-03-29 18:46:00 +0000276 sqlite3_clear_bindings,
drh6bf0ae72007-07-20 10:33:58 +0000277
278 /*
279 ** Added for 3.4.1
280 */
281 sqlite3_create_module_v2,
282
drh428e2822007-08-30 16:23:19 +0000283 /*
284 ** Added for 3.5.0
285 */
286 sqlite3_bind_zeroblob,
287 sqlite3_blob_bytes,
288 sqlite3_blob_close,
289 sqlite3_blob_open,
290 sqlite3_blob_read,
291 sqlite3_blob_write,
292 sqlite3_create_collation_v2,
drhcc6bb3e2007-08-31 16:11:35 +0000293 sqlite3_file_control,
drh428e2822007-08-30 16:23:19 +0000294 sqlite3_memory_highwater,
295 sqlite3_memory_used,
drh18472fa2008-10-07 15:25:48 +0000296#ifdef SQLITE_MUTEX_OMIT
drhad3e78b2007-08-30 20:09:27 +0000297 0,
298 0,
299 0,
300 0,
301 0,
302#else
drh61f6dc62007-08-30 17:15:37 +0000303 sqlite3_mutex_alloc,
304 sqlite3_mutex_enter,
305 sqlite3_mutex_free,
306 sqlite3_mutex_leave,
307 sqlite3_mutex_try,
drhad3e78b2007-08-30 20:09:27 +0000308#endif
drh428e2822007-08-30 16:23:19 +0000309 sqlite3_open_v2,
310 sqlite3_release_memory,
311 sqlite3_result_error_nomem,
312 sqlite3_result_error_toobig,
313 sqlite3_sleep,
314 sqlite3_soft_heap_limit,
315 sqlite3_vfs_find,
316 sqlite3_vfs_register,
317 sqlite3_vfs_unregister,
drh2fa18682008-03-19 14:15:34 +0000318
319 /*
320 ** Added for 3.5.8
321 */
drhe5dd20a2008-03-19 19:55:55 +0000322 sqlite3_threadsafe,
323 sqlite3_result_zeroblob,
324 sqlite3_result_error_code,
325 sqlite3_test_control,
drh2fa18682008-03-19 14:15:34 +0000326 sqlite3_randomness,
drhfa4a4b92008-03-19 21:45:51 +0000327 sqlite3_context_db_handle,
drh8b6abed2008-06-19 15:06:24 +0000328
329 /*
330 ** Added for 3.6.0
331 */
332 sqlite3_extended_result_codes,
333 sqlite3_limit,
334 sqlite3_next_stmt,
335 sqlite3_sql,
336 sqlite3_status,
drhfd7ebbf2010-10-11 13:12:04 +0000337
338 /*
339 ** Added for 3.7.4
340 */
341 sqlite3_backup_finish,
342 sqlite3_backup_init,
343 sqlite3_backup_pagecount,
344 sqlite3_backup_remaining,
345 sqlite3_backup_step,
drh4e49c772010-10-11 17:57:41 +0000346#ifndef SQLITE_OMIT_COMPILEOPTION_DIAGS
drhfd7ebbf2010-10-11 13:12:04 +0000347 sqlite3_compileoption_get,
348 sqlite3_compileoption_used,
drh4e49c772010-10-11 17:57:41 +0000349#else
350 0,
351 0,
352#endif
drhfd7ebbf2010-10-11 13:12:04 +0000353 sqlite3_create_function_v2,
354 sqlite3_db_config,
355 sqlite3_db_mutex,
356 sqlite3_db_status,
357 sqlite3_extended_errcode,
358 sqlite3_log,
359 sqlite3_soft_heap_limit64,
360 sqlite3_sourceid,
361 sqlite3_stmt_status,
362 sqlite3_strnicmp,
drh4e49c772010-10-11 17:57:41 +0000363#ifdef SQLITE_ENABLE_UNLOCK_NOTIFY
drhfd7ebbf2010-10-11 13:12:04 +0000364 sqlite3_unlock_notify,
drh4e49c772010-10-11 17:57:41 +0000365#else
366 0,
367#endif
368#ifndef SQLITE_OMIT_WAL
drhfd7ebbf2010-10-11 13:12:04 +0000369 sqlite3_wal_autocheckpoint,
370 sqlite3_wal_checkpoint,
371 sqlite3_wal_hook,
drh4e49c772010-10-11 17:57:41 +0000372#else
373 0,
374 0,
375 0,
376#endif
dan0ea25172011-06-28 07:15:43 +0000377 sqlite3_blob_reopen,
378 sqlite3_vtab_config,
379 sqlite3_vtab_on_conflict,
drh1d59d032013-03-01 23:40:26 +0000380 sqlite3_close_v2,
381 sqlite3_db_filename,
382 sqlite3_db_readonly,
383 sqlite3_db_release_memory,
384 sqlite3_errstr,
385 sqlite3_stmt_busy,
386 sqlite3_stmt_readonly,
387 sqlite3_stricmp,
388 sqlite3_uri_boolean,
389 sqlite3_uri_int64,
390 sqlite3_uri_parameter,
391 sqlite3_vsnprintf,
drh0807cc22014-09-09 18:41:32 +0000392 sqlite3_wal_checkpoint_v2,
393 /* Version 3.8.7 and later */
394 sqlite3_auto_extension,
395 sqlite3_bind_blob64,
drhbbf483f2014-09-09 20:30:24 +0000396 sqlite3_bind_text64,
drh0807cc22014-09-09 18:41:32 +0000397 sqlite3_cancel_auto_extension,
398 sqlite3_load_extension,
399 sqlite3_malloc64,
400 sqlite3_msize,
401 sqlite3_realloc64,
402 sqlite3_reset_auto_extension,
403 sqlite3_result_blob64,
drhbbf483f2014-09-09 20:30:24 +0000404 sqlite3_result_text64,
drhf5ed7ad2015-06-15 14:43:25 +0000405 sqlite3_strglob,
406 /* Version 3.8.11 and later */
407 (sqlite3_value*(*)(const sqlite3_value*))sqlite3_value_dup,
drh6bacdc22015-07-24 17:14:03 +0000408 sqlite3_value_free,
dan80c03022015-07-24 17:36:34 +0000409 sqlite3_result_zeroblob64,
drhcf94f172015-09-10 20:40:21 +0000410 sqlite3_bind_zeroblob64,
411 /* Version 3.8.12 and later */
412 sqlite3_value_subtype,
413 sqlite3_result_subtype
drh1e397f82006-06-08 15:28:43 +0000414};
415
drh70df4fe2006-06-13 15:12:21 +0000416/*
drh1e397f82006-06-08 15:28:43 +0000417** Attempt to load an SQLite extension library contained in the file
drh428397c2006-06-17 13:21:32 +0000418** zFile. The entry point is zProc. zProc may be 0 in which case a
419** default entry point name (sqlite3_extension_init) is used. Use
420** of the default name is recommended.
drh1e397f82006-06-08 15:28:43 +0000421**
422** Return SQLITE_OK on success and SQLITE_ERROR if something goes wrong.
423**
424** If an error occurs and pzErrMsg is not 0, then fill *pzErrMsg with
425** error message text. The calling function should free this memory
drh633e6d52008-07-28 19:34:53 +0000426** by calling sqlite3DbFree(db, ).
drh1e397f82006-06-08 15:28:43 +0000427*/
drhb21c8cd2007-08-21 19:33:56 +0000428static int sqlite3LoadExtension(
drh1e397f82006-06-08 15:28:43 +0000429 sqlite3 *db, /* Load the extension into this database connection */
430 const char *zFile, /* Name of the shared library containing extension */
drh428397c2006-06-17 13:21:32 +0000431 const char *zProc, /* Entry point. Use "sqlite3_extension_init" if 0 */
drh1e397f82006-06-08 15:28:43 +0000432 char **pzErrMsg /* Put error message here if not 0 */
433){
danielk1977b4b47412007-08-17 15:53:36 +0000434 sqlite3_vfs *pVfs = db->pVfs;
drh761df872006-12-21 01:29:22 +0000435 void *handle;
drh1e397f82006-06-08 15:28:43 +0000436 int (*xInit)(sqlite3*,char**,const sqlite3_api_routines*);
437 char *zErrmsg = 0;
drhc288e442013-04-18 22:56:42 +0000438 const char *zEntry;
439 char *zAltEntry = 0;
drh761df872006-12-21 01:29:22 +0000440 void **aHandle;
drhf3cdcdc2015-04-29 16:50:28 +0000441 u64 nMsg = 300 + sqlite3Strlen30(zFile);
drhc288e442013-04-18 22:56:42 +0000442 int ii;
443
444 /* Shared library endings to try if zFile cannot be loaded as written */
445 static const char *azEndings[] = {
446#if SQLITE_OS_WIN
447 "dll"
448#elif defined(__APPLE__)
449 "dylib"
450#else
451 "so"
452#endif
453 };
454
drh1e397f82006-06-08 15:28:43 +0000455
drh7aaa8782009-05-20 02:40:45 +0000456 if( pzErrMsg ) *pzErrMsg = 0;
457
drhc2e87a32006-06-27 15:16:14 +0000458 /* Ticket #1863. To avoid a creating security problems for older
459 ** applications that relink against newer versions of SQLite, the
460 ** ability to run load_extension is turned off by default. One
461 ** must call sqlite3_enable_load_extension() to turn on extension
462 ** loading. Otherwise you get the following error.
463 */
464 if( (db->flags & SQLITE_LoadExtension)==0 ){
465 if( pzErrMsg ){
466 *pzErrMsg = sqlite3_mprintf("not authorized");
467 }
468 return SQLITE_ERROR;
469 }
470
drhc288e442013-04-18 22:56:42 +0000471 zEntry = zProc ? zProc : "sqlite3_extension_init";
drh1e397f82006-06-08 15:28:43 +0000472
danielk1977b4b47412007-08-17 15:53:36 +0000473 handle = sqlite3OsDlOpen(pVfs, zFile);
drhc288e442013-04-18 22:56:42 +0000474#if SQLITE_OS_UNIX || SQLITE_OS_WIN
475 for(ii=0; ii<ArraySize(azEndings) && handle==0; ii++){
476 char *zAltFile = sqlite3_mprintf("%s.%s", zFile, azEndings[ii]);
477 if( zAltFile==0 ) return SQLITE_NOMEM;
478 handle = sqlite3OsDlOpen(pVfs, zAltFile);
479 sqlite3_free(zAltFile);
480 }
481#endif
drh1e397f82006-06-08 15:28:43 +0000482 if( handle==0 ){
483 if( pzErrMsg ){
drhf3cdcdc2015-04-29 16:50:28 +0000484 *pzErrMsg = zErrmsg = sqlite3_malloc64(nMsg);
drh50d654d2009-06-03 01:24:54 +0000485 if( zErrmsg ){
486 sqlite3_snprintf(nMsg, zErrmsg,
487 "unable to open shared library [%s]", zFile);
488 sqlite3OsDlError(pVfs, nMsg-1, zErrmsg);
drh50d654d2009-06-03 01:24:54 +0000489 }
drh1e397f82006-06-08 15:28:43 +0000490 }
491 return SQLITE_ERROR;
492 }
493 xInit = (int(*)(sqlite3*,char**,const sqlite3_api_routines*))
drhc288e442013-04-18 22:56:42 +0000494 sqlite3OsDlSym(pVfs, handle, zEntry);
495
496 /* If no entry point was specified and the default legacy
497 ** entry point name "sqlite3_extension_init" was not found, then
498 ** construct an entry point name "sqlite3_X_init" where the X is
499 ** replaced by the lowercase value of every ASCII alphabetic
500 ** character in the filename after the last "/" upto the first ".",
501 ** and eliding the first three characters if they are "lib".
502 ** Examples:
503 **
504 ** /usr/local/lib/libExample5.4.3.so ==> sqlite3_example_init
505 ** C:/lib/mathfuncs.dll ==> sqlite3_mathfuncs_init
506 */
507 if( xInit==0 && zProc==0 ){
508 int iFile, iEntry, c;
509 int ncFile = sqlite3Strlen30(zFile);
drhf3cdcdc2015-04-29 16:50:28 +0000510 zAltEntry = sqlite3_malloc64(ncFile+30);
drhc288e442013-04-18 22:56:42 +0000511 if( zAltEntry==0 ){
512 sqlite3OsDlClose(pVfs, handle);
513 return SQLITE_NOMEM;
514 }
515 memcpy(zAltEntry, "sqlite3_", 8);
516 for(iFile=ncFile-1; iFile>=0 && zFile[iFile]!='/'; iFile--){}
517 iFile++;
518 if( sqlite3_strnicmp(zFile+iFile, "lib", 3)==0 ) iFile += 3;
519 for(iEntry=8; (c = zFile[iFile])!=0 && c!='.'; iFile++){
520 if( sqlite3Isalpha(c) ){
521 zAltEntry[iEntry++] = (char)sqlite3UpperToLower[(unsigned)c];
522 }
523 }
524 memcpy(zAltEntry+iEntry, "_init", 6);
525 zEntry = zAltEntry;
526 xInit = (int(*)(sqlite3*,char**,const sqlite3_api_routines*))
527 sqlite3OsDlSym(pVfs, handle, zEntry);
528 }
drh1e397f82006-06-08 15:28:43 +0000529 if( xInit==0 ){
530 if( pzErrMsg ){
drhc288e442013-04-18 22:56:42 +0000531 nMsg += sqlite3Strlen30(zEntry);
drhf3cdcdc2015-04-29 16:50:28 +0000532 *pzErrMsg = zErrmsg = sqlite3_malloc64(nMsg);
drh50d654d2009-06-03 01:24:54 +0000533 if( zErrmsg ){
534 sqlite3_snprintf(nMsg, zErrmsg,
drhc288e442013-04-18 22:56:42 +0000535 "no entry point [%s] in shared library [%s]", zEntry, zFile);
drh50d654d2009-06-03 01:24:54 +0000536 sqlite3OsDlError(pVfs, nMsg-1, zErrmsg);
drh50d654d2009-06-03 01:24:54 +0000537 }
drh1e397f82006-06-08 15:28:43 +0000538 }
drhc288e442013-04-18 22:56:42 +0000539 sqlite3OsDlClose(pVfs, handle);
540 sqlite3_free(zAltEntry);
drh1e397f82006-06-08 15:28:43 +0000541 return SQLITE_ERROR;
drhc288e442013-04-18 22:56:42 +0000542 }
543 sqlite3_free(zAltEntry);
544 if( xInit(db, &zErrmsg, &sqlite3Apis) ){
drh1e397f82006-06-08 15:28:43 +0000545 if( pzErrMsg ){
546 *pzErrMsg = sqlite3_mprintf("error during initialization: %s", zErrmsg);
547 }
548 sqlite3_free(zErrmsg);
danielk1977b4b47412007-08-17 15:53:36 +0000549 sqlite3OsDlClose(pVfs, handle);
drh1e397f82006-06-08 15:28:43 +0000550 return SQLITE_ERROR;
551 }
danielk197769e777f2006-06-14 10:38:02 +0000552
553 /* Append the new shared library handle to the db->aExtension array. */
drh701bb3b2008-08-02 03:50:39 +0000554 aHandle = sqlite3DbMallocZero(db, sizeof(handle)*(db->nExtension+1));
danielk197769e777f2006-06-14 10:38:02 +0000555 if( aHandle==0 ){
556 return SQLITE_NOMEM;
557 }
558 if( db->nExtension>0 ){
drh701bb3b2008-08-02 03:50:39 +0000559 memcpy(aHandle, db->aExtension, sizeof(handle)*db->nExtension);
danielk197769e777f2006-06-14 10:38:02 +0000560 }
drh633e6d52008-07-28 19:34:53 +0000561 sqlite3DbFree(db, db->aExtension);
danielk197769e777f2006-06-14 10:38:02 +0000562 db->aExtension = aHandle;
563
drh701bb3b2008-08-02 03:50:39 +0000564 db->aExtension[db->nExtension++] = handle;
drh1e397f82006-06-08 15:28:43 +0000565 return SQLITE_OK;
drh1e397f82006-06-08 15:28:43 +0000566}
drhb21c8cd2007-08-21 19:33:56 +0000567int sqlite3_load_extension(
568 sqlite3 *db, /* Load the extension into this database connection */
569 const char *zFile, /* Name of the shared library containing extension */
570 const char *zProc, /* Entry point. Use "sqlite3_extension_init" if 0 */
571 char **pzErrMsg /* Put error message here if not 0 */
572){
573 int rc;
574 sqlite3_mutex_enter(db->mutex);
575 rc = sqlite3LoadExtension(db, zFile, zProc, pzErrMsg);
drh7aaa8782009-05-20 02:40:45 +0000576 rc = sqlite3ApiExit(db, rc);
drhb21c8cd2007-08-21 19:33:56 +0000577 sqlite3_mutex_leave(db->mutex);
578 return rc;
579}
drhf1952c52006-06-08 15:48:00 +0000580
581/*
582** Call this routine when the database connection is closing in order
583** to clean up loaded extensions
584*/
585void sqlite3CloseExtensions(sqlite3 *db){
586 int i;
drhb21c8cd2007-08-21 19:33:56 +0000587 assert( sqlite3_mutex_held(db->mutex) );
drhf1952c52006-06-08 15:48:00 +0000588 for(i=0; i<db->nExtension; i++){
danielk1977b4b47412007-08-17 15:53:36 +0000589 sqlite3OsDlClose(db->pVfs, db->aExtension[i]);
drhf1952c52006-06-08 15:48:00 +0000590 }
drh633e6d52008-07-28 19:34:53 +0000591 sqlite3DbFree(db, db->aExtension);
drhf1952c52006-06-08 15:48:00 +0000592}
593
drhc2e87a32006-06-27 15:16:14 +0000594/*
595** Enable or disable extension loading. Extension loading is disabled by
596** default so as not to open security holes in older applications.
597*/
598int sqlite3_enable_load_extension(sqlite3 *db, int onoff){
drhb21c8cd2007-08-21 19:33:56 +0000599 sqlite3_mutex_enter(db->mutex);
drhc2e87a32006-06-27 15:16:14 +0000600 if( onoff ){
601 db->flags |= SQLITE_LoadExtension;
602 }else{
603 db->flags &= ~SQLITE_LoadExtension;
604 }
drhb21c8cd2007-08-21 19:33:56 +0000605 sqlite3_mutex_leave(db->mutex);
drhc2e87a32006-06-27 15:16:14 +0000606 return SQLITE_OK;
607}
608
drhcaa639f2008-03-20 00:32:20 +0000609#endif /* SQLITE_OMIT_LOAD_EXTENSION */
drh984bfaa2008-03-19 16:08:53 +0000610
611/*
drhcaa639f2008-03-20 00:32:20 +0000612** The auto-extension code added regardless of whether or not extension
613** loading is supported. We need a dummy sqlite3Apis pointer for that
614** code if regular extension loading is not available. This is that
615** dummy pointer.
drh984bfaa2008-03-19 16:08:53 +0000616*/
drhcaa639f2008-03-20 00:32:20 +0000617#ifdef SQLITE_OMIT_LOAD_EXTENSION
drhde244782008-04-10 16:01:10 +0000618static const sqlite3_api_routines sqlite3Apis = { 0 };
drh984bfaa2008-03-19 16:08:53 +0000619#endif
620
621
drh1409be62006-08-23 20:07:20 +0000622/*
drh605264d2007-08-21 15:13:19 +0000623** The following object holds the list of automatically loaded
624** extensions.
drh1409be62006-08-23 20:07:20 +0000625**
drh605264d2007-08-21 15:13:19 +0000626** This list is shared across threads. The SQLITE_MUTEX_STATIC_MASTER
627** mutex must be held while accessing this list.
drh1409be62006-08-23 20:07:20 +0000628*/
drh1875f7a2008-12-08 18:19:17 +0000629typedef struct sqlite3AutoExtList sqlite3AutoExtList;
630static SQLITE_WSD struct sqlite3AutoExtList {
drhf3cdcdc2015-04-29 16:50:28 +0000631 u32 nExt; /* Number of entries in aExt[] */
drh1875f7a2008-12-08 18:19:17 +0000632 void (**aExt)(void); /* Pointers to the extension init functions */
drh78f82d12008-09-02 00:52:52 +0000633} sqlite3Autoext = { 0, 0 };
634
635/* The "wsdAutoext" macro will resolve to the autoextension
636** state vector. If writable static data is unsupported on the target,
637** we have to locate the state vector at run-time. In the more common
638** case where writable static data is supported, wsdStat can refer directly
639** to the "sqlite3Autoext" state vector declared above.
640*/
641#ifdef SQLITE_OMIT_WSD
642# define wsdAutoextInit \
drh1875f7a2008-12-08 18:19:17 +0000643 sqlite3AutoExtList *x = &GLOBAL(sqlite3AutoExtList,sqlite3Autoext)
drh78f82d12008-09-02 00:52:52 +0000644# define wsdAutoext x[0]
645#else
646# define wsdAutoextInit
647# define wsdAutoext sqlite3Autoext
648#endif
drh1409be62006-08-23 20:07:20 +0000649
650
651/*
652** Register a statically linked extension that is automatically
653** loaded by every new database connection.
654*/
drh1875f7a2008-12-08 18:19:17 +0000655int sqlite3_auto_extension(void (*xInit)(void)){
danielk197700f0faf2008-07-08 14:17:35 +0000656 int rc = SQLITE_OK;
drh40257ff2008-06-13 18:24:27 +0000657#ifndef SQLITE_OMIT_AUTOINIT
danielk197700f0faf2008-07-08 14:17:35 +0000658 rc = sqlite3_initialize();
drh40257ff2008-06-13 18:24:27 +0000659 if( rc ){
660 return rc;
661 }else
drhe265b082008-05-01 17:03:49 +0000662#endif
drh40257ff2008-06-13 18:24:27 +0000663 {
drh6a412b82015-04-30 12:31:49 +0000664 u32 i;
drh18472fa2008-10-07 15:25:48 +0000665#if SQLITE_THREADSAFE
danielk197759f8c082008-06-18 17:09:10 +0000666 sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MASTER);
drh40257ff2008-06-13 18:24:27 +0000667#endif
drh78f82d12008-09-02 00:52:52 +0000668 wsdAutoextInit;
drh40257ff2008-06-13 18:24:27 +0000669 sqlite3_mutex_enter(mutex);
drh78f82d12008-09-02 00:52:52 +0000670 for(i=0; i<wsdAutoext.nExt; i++){
671 if( wsdAutoext.aExt[i]==xInit ) break;
drh1409be62006-08-23 20:07:20 +0000672 }
drh78f82d12008-09-02 00:52:52 +0000673 if( i==wsdAutoext.nExt ){
drhf3cdcdc2015-04-29 16:50:28 +0000674 u64 nByte = (wsdAutoext.nExt+1)*sizeof(wsdAutoext.aExt[0]);
drh1875f7a2008-12-08 18:19:17 +0000675 void (**aNew)(void);
drhf3cdcdc2015-04-29 16:50:28 +0000676 aNew = sqlite3_realloc64(wsdAutoext.aExt, nByte);
drh40257ff2008-06-13 18:24:27 +0000677 if( aNew==0 ){
678 rc = SQLITE_NOMEM;
679 }else{
drh78f82d12008-09-02 00:52:52 +0000680 wsdAutoext.aExt = aNew;
681 wsdAutoext.aExt[wsdAutoext.nExt] = xInit;
682 wsdAutoext.nExt++;
drh40257ff2008-06-13 18:24:27 +0000683 }
684 }
685 sqlite3_mutex_leave(mutex);
686 assert( (rc&0xff)==rc );
687 return rc;
drh1409be62006-08-23 20:07:20 +0000688 }
drh1409be62006-08-23 20:07:20 +0000689}
690
691/*
drh425e27d2013-07-15 17:02:28 +0000692** Cancel a prior call to sqlite3_auto_extension. Remove xInit from the
693** set of routines that is invoked for each new database connection, if it
694** is currently on the list. If xInit is not on the list, then this
695** routine is a no-op.
696**
697** Return 1 if xInit was found on the list and removed. Return 0 if xInit
698** was not on the list.
699*/
700int sqlite3_cancel_auto_extension(void (*xInit)(void)){
701#if SQLITE_THREADSAFE
702 sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MASTER);
703#endif
704 int i;
705 int n = 0;
706 wsdAutoextInit;
707 sqlite3_mutex_enter(mutex);
drh6a412b82015-04-30 12:31:49 +0000708 for(i=(int)wsdAutoext.nExt-1; i>=0; i--){
drh425e27d2013-07-15 17:02:28 +0000709 if( wsdAutoext.aExt[i]==xInit ){
710 wsdAutoext.nExt--;
711 wsdAutoext.aExt[i] = wsdAutoext.aExt[wsdAutoext.nExt];
712 n++;
713 break;
714 }
715 }
716 sqlite3_mutex_leave(mutex);
717 return n;
718}
719
720/*
drh1409be62006-08-23 20:07:20 +0000721** Reset the automatic extension loading mechanism.
722*/
723void sqlite3_reset_auto_extension(void){
drh40257ff2008-06-13 18:24:27 +0000724#ifndef SQLITE_OMIT_AUTOINIT
725 if( sqlite3_initialize()==SQLITE_OK )
drhe265b082008-05-01 17:03:49 +0000726#endif
drh40257ff2008-06-13 18:24:27 +0000727 {
drh18472fa2008-10-07 15:25:48 +0000728#if SQLITE_THREADSAFE
danielk197759f8c082008-06-18 17:09:10 +0000729 sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MASTER);
drh40257ff2008-06-13 18:24:27 +0000730#endif
drh78f82d12008-09-02 00:52:52 +0000731 wsdAutoextInit;
drh40257ff2008-06-13 18:24:27 +0000732 sqlite3_mutex_enter(mutex);
drh78f82d12008-09-02 00:52:52 +0000733 sqlite3_free(wsdAutoext.aExt);
734 wsdAutoext.aExt = 0;
735 wsdAutoext.nExt = 0;
drh40257ff2008-06-13 18:24:27 +0000736 sqlite3_mutex_leave(mutex);
737 }
drh1409be62006-08-23 20:07:20 +0000738}
739
740/*
741** Load all automatic extensions.
drh7aaa8782009-05-20 02:40:45 +0000742**
743** If anything goes wrong, set an error in the database connection.
drh1409be62006-08-23 20:07:20 +0000744*/
drh7aaa8782009-05-20 02:40:45 +0000745void sqlite3AutoLoadExtensions(sqlite3 *db){
drh6a412b82015-04-30 12:31:49 +0000746 u32 i;
drh1409be62006-08-23 20:07:20 +0000747 int go = 1;
drhe5077c12011-12-13 04:08:36 +0000748 int rc;
drh1409be62006-08-23 20:07:20 +0000749 int (*xInit)(sqlite3*,char**,const sqlite3_api_routines*);
750
drh78f82d12008-09-02 00:52:52 +0000751 wsdAutoextInit;
752 if( wsdAutoext.nExt==0 ){
drh1409be62006-08-23 20:07:20 +0000753 /* Common case: early out without every having to acquire a mutex */
drh7aaa8782009-05-20 02:40:45 +0000754 return;
drh1409be62006-08-23 20:07:20 +0000755 }
756 for(i=0; go; i++){
drh7aaa8782009-05-20 02:40:45 +0000757 char *zErrmsg;
drh18472fa2008-10-07 15:25:48 +0000758#if SQLITE_THREADSAFE
danielk197759f8c082008-06-18 17:09:10 +0000759 sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MASTER);
drhe265b082008-05-01 17:03:49 +0000760#endif
danielk1977b4b47412007-08-17 15:53:36 +0000761 sqlite3_mutex_enter(mutex);
drh78f82d12008-09-02 00:52:52 +0000762 if( i>=wsdAutoext.nExt ){
drh1409be62006-08-23 20:07:20 +0000763 xInit = 0;
764 go = 0;
765 }else{
766 xInit = (int(*)(sqlite3*,char**,const sqlite3_api_routines*))
drh78f82d12008-09-02 00:52:52 +0000767 wsdAutoext.aExt[i];
drh1409be62006-08-23 20:07:20 +0000768 }
danielk1977b4b47412007-08-17 15:53:36 +0000769 sqlite3_mutex_leave(mutex);
drh7aaa8782009-05-20 02:40:45 +0000770 zErrmsg = 0;
drhe5077c12011-12-13 04:08:36 +0000771 if( xInit && (rc = xInit(db, &zErrmsg, &sqlite3Apis))!=0 ){
drh13f40da2014-08-22 18:00:11 +0000772 sqlite3ErrorWithMsg(db, rc,
drh1409be62006-08-23 20:07:20 +0000773 "automatic extension loading failed: %s", zErrmsg);
774 go = 0;
drh1409be62006-08-23 20:07:20 +0000775 }
drh7aaa8782009-05-20 02:40:45 +0000776 sqlite3_free(zErrmsg);
drh1409be62006-08-23 20:07:20 +0000777 }
drh1409be62006-08-23 20:07:20 +0000778}