1 /* 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 */ 15 16 #ifndef SQLITE_CORE 17 #define SQLITE_CORE 1 /* Disable the API redefinition in sqlite3ext.h */ 18 #endif 19 #include "sqlite3ext.h" 20 #include "sqliteInt.h" 21 22 #ifndef SQLITE_OMIT_LOAD_EXTENSION 23 /* 24 ** Some API routines are omitted when various features are 25 ** excluded from a build of SQLite. Substitute a NULL pointer 26 ** for any missing APIs. 27 */ 28 #ifndef SQLITE_ENABLE_COLUMN_METADATA 29 # define sqlite3_column_database_name 0 30 # define sqlite3_column_database_name16 0 31 # define sqlite3_column_table_name 0 32 # define sqlite3_column_table_name16 0 33 # define sqlite3_column_origin_name 0 34 # define sqlite3_column_origin_name16 0 35 #endif 36 37 #ifdef SQLITE_OMIT_AUTHORIZATION 38 # define sqlite3_set_authorizer 0 39 #endif 40 41 #ifdef SQLITE_OMIT_UTF16 42 # define sqlite3_bind_text16 0 43 # define sqlite3_collation_needed16 0 44 # define sqlite3_column_decltype16 0 45 # define sqlite3_column_name16 0 46 # define sqlite3_column_text16 0 47 # define sqlite3_complete16 0 48 # define sqlite3_create_collation16 0 49 # define sqlite3_create_function16 0 50 # define sqlite3_errmsg16 0 51 # define sqlite3_open16 0 52 # define sqlite3_prepare16 0 53 # define sqlite3_prepare16_v2 0 54 # define sqlite3_prepare16_v3 0 55 # define sqlite3_result_error16 0 56 # define sqlite3_result_text16 0 57 # define sqlite3_result_text16be 0 58 # define sqlite3_result_text16le 0 59 # define sqlite3_value_text16 0 60 # define sqlite3_value_text16be 0 61 # define sqlite3_value_text16le 0 62 # define sqlite3_column_database_name16 0 63 # define sqlite3_column_table_name16 0 64 # define sqlite3_column_origin_name16 0 65 #endif 66 67 #ifdef SQLITE_OMIT_COMPLETE 68 # define sqlite3_complete 0 69 # define sqlite3_complete16 0 70 #endif 71 72 #ifdef SQLITE_OMIT_DECLTYPE 73 # define sqlite3_column_decltype16 0 74 # define sqlite3_column_decltype 0 75 #endif 76 77 #ifdef SQLITE_OMIT_PROGRESS_CALLBACK 78 # define sqlite3_progress_handler 0 79 #endif 80 81 #ifdef SQLITE_OMIT_VIRTUALTABLE 82 # define sqlite3_create_module 0 83 # define sqlite3_create_module_v2 0 84 # define sqlite3_declare_vtab 0 85 # define sqlite3_vtab_config 0 86 # define sqlite3_vtab_on_conflict 0 87 # define sqlite3_vtab_collation 0 88 #endif 89 90 #ifdef SQLITE_OMIT_SHARED_CACHE 91 # define sqlite3_enable_shared_cache 0 92 #endif 93 94 #if defined(SQLITE_OMIT_TRACE) || defined(SQLITE_OMIT_DEPRECATED) 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 104 #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 111 #define sqlite3_blob_reopen 0 112 #endif 113 114 #if defined(SQLITE_OMIT_TRACE) 115 # define sqlite3_trace_v2 0 116 #endif 117 118 /* 119 ** The following structure contains pointers to all SQLite API routines. 120 ** A pointer to this structure is passed into extensions when they are 121 ** loaded so that the extension can make calls back into the SQLite 122 ** library. 123 ** 124 ** When adding new APIs, add them to the bottom of this structure 125 ** in order to preserve backwards compatibility. 126 ** 127 ** Extensions that use newer APIs should first call the 128 ** sqlite3_libversion_number() to make sure that the API they 129 ** intend to use is supported by the library. Extensions should 130 ** also check to make sure that the pointer to the function is 131 ** not NULL before calling it. 132 */ 133 static const sqlite3_api_routines sqlite3Apis = { 134 sqlite3_aggregate_context, 135 #ifndef SQLITE_OMIT_DEPRECATED 136 sqlite3_aggregate_count, 137 #else 138 0, 139 #endif 140 sqlite3_bind_blob, 141 sqlite3_bind_double, 142 sqlite3_bind_int, 143 sqlite3_bind_int64, 144 sqlite3_bind_null, 145 sqlite3_bind_parameter_count, 146 sqlite3_bind_parameter_index, 147 sqlite3_bind_parameter_name, 148 sqlite3_bind_text, 149 sqlite3_bind_text16, 150 sqlite3_bind_value, 151 sqlite3_busy_handler, 152 sqlite3_busy_timeout, 153 sqlite3_changes, 154 sqlite3_close, 155 sqlite3_collation_needed, 156 sqlite3_collation_needed16, 157 sqlite3_column_blob, 158 sqlite3_column_bytes, 159 sqlite3_column_bytes16, 160 sqlite3_column_count, 161 sqlite3_column_database_name, 162 sqlite3_column_database_name16, 163 sqlite3_column_decltype, 164 sqlite3_column_decltype16, 165 sqlite3_column_double, 166 sqlite3_column_int, 167 sqlite3_column_int64, 168 sqlite3_column_name, 169 sqlite3_column_name16, 170 sqlite3_column_origin_name, 171 sqlite3_column_origin_name16, 172 sqlite3_column_table_name, 173 sqlite3_column_table_name16, 174 sqlite3_column_text, 175 sqlite3_column_text16, 176 sqlite3_column_type, 177 sqlite3_column_value, 178 sqlite3_commit_hook, 179 sqlite3_complete, 180 sqlite3_complete16, 181 sqlite3_create_collation, 182 sqlite3_create_collation16, 183 sqlite3_create_function, 184 sqlite3_create_function16, 185 sqlite3_create_module, 186 sqlite3_data_count, 187 sqlite3_db_handle, 188 sqlite3_declare_vtab, 189 sqlite3_enable_shared_cache, 190 sqlite3_errcode, 191 sqlite3_errmsg, 192 sqlite3_errmsg16, 193 sqlite3_exec, 194 #ifndef SQLITE_OMIT_DEPRECATED 195 sqlite3_expired, 196 #else 197 0, 198 #endif 199 sqlite3_finalize, 200 sqlite3_free, 201 sqlite3_free_table, 202 sqlite3_get_autocommit, 203 sqlite3_get_auxdata, 204 sqlite3_get_table, 205 0, /* Was sqlite3_global_recover(), but that function is deprecated */ 206 sqlite3_interrupt, 207 sqlite3_last_insert_rowid, 208 sqlite3_libversion, 209 sqlite3_libversion_number, 210 sqlite3_malloc, 211 sqlite3_mprintf, 212 sqlite3_open, 213 sqlite3_open16, 214 sqlite3_prepare, 215 sqlite3_prepare16, 216 sqlite3_profile, 217 sqlite3_progress_handler, 218 sqlite3_realloc, 219 sqlite3_reset, 220 sqlite3_result_blob, 221 sqlite3_result_double, 222 sqlite3_result_error, 223 sqlite3_result_error16, 224 sqlite3_result_int, 225 sqlite3_result_int64, 226 sqlite3_result_null, 227 sqlite3_result_text, 228 sqlite3_result_text16, 229 sqlite3_result_text16be, 230 sqlite3_result_text16le, 231 sqlite3_result_value, 232 sqlite3_rollback_hook, 233 sqlite3_set_authorizer, 234 sqlite3_set_auxdata, 235 sqlite3_snprintf, 236 sqlite3_step, 237 sqlite3_table_column_metadata, 238 #ifndef SQLITE_OMIT_DEPRECATED 239 sqlite3_thread_cleanup, 240 #else 241 0, 242 #endif 243 sqlite3_total_changes, 244 sqlite3_trace, 245 #ifndef SQLITE_OMIT_DEPRECATED 246 sqlite3_transfer_bindings, 247 #else 248 0, 249 #endif 250 sqlite3_update_hook, 251 sqlite3_user_data, 252 sqlite3_value_blob, 253 sqlite3_value_bytes, 254 sqlite3_value_bytes16, 255 sqlite3_value_double, 256 sqlite3_value_int, 257 sqlite3_value_int64, 258 sqlite3_value_numeric_type, 259 sqlite3_value_text, 260 sqlite3_value_text16, 261 sqlite3_value_text16be, 262 sqlite3_value_text16le, 263 sqlite3_value_type, 264 sqlite3_vmprintf, 265 /* 266 ** The original API set ends here. All extensions can call any 267 ** of the APIs above provided that the pointer is not NULL. But 268 ** before calling APIs that follow, extension should check the 269 ** sqlite3_libversion_number() to make sure they are dealing with 270 ** a library that is new enough to support that API. 271 ************************************************************************* 272 */ 273 sqlite3_overload_function, 274 275 /* 276 ** Added after 3.3.13 277 */ 278 sqlite3_prepare_v2, 279 sqlite3_prepare16_v2, 280 sqlite3_clear_bindings, 281 282 /* 283 ** Added for 3.4.1 284 */ 285 sqlite3_create_module_v2, 286 287 /* 288 ** Added for 3.5.0 289 */ 290 sqlite3_bind_zeroblob, 291 sqlite3_blob_bytes, 292 sqlite3_blob_close, 293 sqlite3_blob_open, 294 sqlite3_blob_read, 295 sqlite3_blob_write, 296 sqlite3_create_collation_v2, 297 sqlite3_file_control, 298 sqlite3_memory_highwater, 299 sqlite3_memory_used, 300 #ifdef SQLITE_MUTEX_OMIT 301 0, 302 0, 303 0, 304 0, 305 0, 306 #else 307 sqlite3_mutex_alloc, 308 sqlite3_mutex_enter, 309 sqlite3_mutex_free, 310 sqlite3_mutex_leave, 311 sqlite3_mutex_try, 312 #endif 313 sqlite3_open_v2, 314 sqlite3_release_memory, 315 sqlite3_result_error_nomem, 316 sqlite3_result_error_toobig, 317 sqlite3_sleep, 318 sqlite3_soft_heap_limit, 319 sqlite3_vfs_find, 320 sqlite3_vfs_register, 321 sqlite3_vfs_unregister, 322 323 /* 324 ** Added for 3.5.8 325 */ 326 sqlite3_threadsafe, 327 sqlite3_result_zeroblob, 328 sqlite3_result_error_code, 329 sqlite3_test_control, 330 sqlite3_randomness, 331 sqlite3_context_db_handle, 332 333 /* 334 ** Added for 3.6.0 335 */ 336 sqlite3_extended_result_codes, 337 sqlite3_limit, 338 sqlite3_next_stmt, 339 sqlite3_sql, 340 sqlite3_status, 341 342 /* 343 ** Added for 3.7.4 344 */ 345 sqlite3_backup_finish, 346 sqlite3_backup_init, 347 sqlite3_backup_pagecount, 348 sqlite3_backup_remaining, 349 sqlite3_backup_step, 350 #ifndef SQLITE_OMIT_COMPILEOPTION_DIAGS 351 sqlite3_compileoption_get, 352 sqlite3_compileoption_used, 353 #else 354 0, 355 0, 356 #endif 357 sqlite3_create_function_v2, 358 sqlite3_db_config, 359 sqlite3_db_mutex, 360 sqlite3_db_status, 361 sqlite3_extended_errcode, 362 sqlite3_log, 363 sqlite3_soft_heap_limit64, 364 sqlite3_sourceid, 365 sqlite3_stmt_status, 366 sqlite3_strnicmp, 367 #ifdef SQLITE_ENABLE_UNLOCK_NOTIFY 368 sqlite3_unlock_notify, 369 #else 370 0, 371 #endif 372 #ifndef SQLITE_OMIT_WAL 373 sqlite3_wal_autocheckpoint, 374 sqlite3_wal_checkpoint, 375 sqlite3_wal_hook, 376 #else 377 0, 378 0, 379 0, 380 #endif 381 sqlite3_blob_reopen, 382 sqlite3_vtab_config, 383 sqlite3_vtab_on_conflict, 384 sqlite3_close_v2, 385 sqlite3_db_filename, 386 sqlite3_db_readonly, 387 sqlite3_db_release_memory, 388 sqlite3_errstr, 389 sqlite3_stmt_busy, 390 sqlite3_stmt_readonly, 391 sqlite3_stricmp, 392 sqlite3_uri_boolean, 393 sqlite3_uri_int64, 394 sqlite3_uri_parameter, 395 sqlite3_vsnprintf, 396 sqlite3_wal_checkpoint_v2, 397 /* Version 3.8.7 and later */ 398 sqlite3_auto_extension, 399 sqlite3_bind_blob64, 400 sqlite3_bind_text64, 401 sqlite3_cancel_auto_extension, 402 sqlite3_load_extension, 403 sqlite3_malloc64, 404 sqlite3_msize, 405 sqlite3_realloc64, 406 sqlite3_reset_auto_extension, 407 sqlite3_result_blob64, 408 sqlite3_result_text64, 409 sqlite3_strglob, 410 /* Version 3.8.11 and later */ 411 (sqlite3_value*(*)(const sqlite3_value*))sqlite3_value_dup, 412 sqlite3_value_free, 413 sqlite3_result_zeroblob64, 414 sqlite3_bind_zeroblob64, 415 /* Version 3.9.0 and later */ 416 sqlite3_value_subtype, 417 sqlite3_result_subtype, 418 /* Version 3.10.0 and later */ 419 sqlite3_status64, 420 sqlite3_strlike, 421 sqlite3_db_cacheflush, 422 /* Version 3.12.0 and later */ 423 sqlite3_system_errno, 424 /* Version 3.14.0 and later */ 425 sqlite3_trace_v2, 426 sqlite3_expanded_sql, 427 /* Version 3.18.0 and later */ 428 sqlite3_set_last_insert_rowid, 429 /* Version 3.20.0 and later */ 430 sqlite3_prepare_v3, 431 sqlite3_prepare16_v3, 432 sqlite3_bind_pointer, 433 sqlite3_result_pointer, 434 sqlite3_value_pointer, 435 /* Version 3.22.0 and later */ 436 sqlite3_vtab_nochange, 437 sqlite3_value_nochange, 438 sqlite3_vtab_collation, 439 /* Version 3.24.0 and later */ 440 sqlite3_keyword_count, 441 sqlite3_keyword_name, 442 sqlite3_keyword_check, 443 sqlite3_str_new, 444 sqlite3_str_finish, 445 sqlite3_str_appendf, 446 sqlite3_str_vappendf, 447 sqlite3_str_append, 448 sqlite3_str_appendall, 449 sqlite3_str_appendchar, 450 sqlite3_str_reset, 451 sqlite3_str_errcode, 452 sqlite3_str_length, 453 sqlite3_str_value, 454 /* Version 3.25.0 and later */ 455 sqlite3_create_window_function, 456 /* Version 3.26.0 and later */ 457 #ifdef SQLITE_ENABLE_NORMALIZE 458 sqlite3_normalized_sql, 459 #else 460 0, 461 #endif 462 /* Version 3.28.0 and later */ 463 sqlite3_stmt_isexplain, 464 sqlite3_value_frombind, 465 /* Version 3.30.0 and later */ 466 #ifndef SQLITE_OMIT_VIRTUALTABLE 467 sqlite3_drop_modules, 468 #else 469 0, 470 #endif 471 /* Version 3.31.0 and later */ 472 sqlite3_hard_heap_limit64, 473 sqlite3_uri_key, 474 sqlite3_filename_database, 475 sqlite3_filename_journal, 476 sqlite3_filename_wal, 477 /* Version 3.32.0 and later */ 478 sqlite3_create_filename, 479 sqlite3_free_filename, 480 sqlite3_database_file_object, 481 /* Version 3.34.0 and later */ 482 sqlite3_txn_state, 483 /* Version 3.36.1 and later */ 484 sqlite3_changes64, 485 sqlite3_total_changes64, 486 /* Version 3.37.0 and later */ 487 sqlite3_autovacuum_pages, 488 /* Version 3.38.0 and later */ 489 sqlite3_error_offset, 490 #ifndef SQLITE_OMIT_VIRTUALTABLE 491 sqlite3_vtab_rhs_value, 492 sqlite3_vtab_distinct, 493 sqlite3_vtab_in, 494 sqlite3_vtab_in_first, 495 sqlite3_vtab_in_next, 496 #else 497 0, 498 0, 499 0, 500 0, 501 0, 502 #endif 503 /* Version 3.39.0 and later */ 504 #ifndef SQLITE_OMIT_DESERIALIZE 505 sqlite3_deserialize, 506 sqlite3_serialize, 507 #else 508 0, 509 0, 510 #endif 511 sqlite3_db_name, 512 /* Version 3.40.0 and later */ 513 sqlite3_value_type 514 }; 515 516 /* True if x is the directory separator character 517 */ 518 #if SQLITE_OS_WIN 519 # define DirSep(X) ((X)=='/'||(X)=='\\') 520 #else 521 # define DirSep(X) ((X)=='/') 522 #endif 523 524 /* 525 ** Attempt to load an SQLite extension library contained in the file 526 ** zFile. The entry point is zProc. zProc may be 0 in which case a 527 ** default entry point name (sqlite3_extension_init) is used. Use 528 ** of the default name is recommended. 529 ** 530 ** Return SQLITE_OK on success and SQLITE_ERROR if something goes wrong. 531 ** 532 ** If an error occurs and pzErrMsg is not 0, then fill *pzErrMsg with 533 ** error message text. The calling function should free this memory 534 ** by calling sqlite3DbFree(db, ). 535 */ 536 static int sqlite3LoadExtension( 537 sqlite3 *db, /* Load the extension into this database connection */ 538 const char *zFile, /* Name of the shared library containing extension */ 539 const char *zProc, /* Entry point. Use "sqlite3_extension_init" if 0 */ 540 char **pzErrMsg /* Put error message here if not 0 */ 541 ){ 542 sqlite3_vfs *pVfs = db->pVfs; 543 void *handle; 544 sqlite3_loadext_entry xInit; 545 char *zErrmsg = 0; 546 const char *zEntry; 547 char *zAltEntry = 0; 548 void **aHandle; 549 u64 nMsg = strlen(zFile); 550 int ii; 551 int rc; 552 553 /* Shared library endings to try if zFile cannot be loaded as written */ 554 static const char *azEndings[] = { 555 #if SQLITE_OS_WIN 556 "dll" 557 #elif defined(__APPLE__) 558 "dylib" 559 #else 560 "so" 561 #endif 562 }; 563 564 565 if( pzErrMsg ) *pzErrMsg = 0; 566 567 /* Ticket #1863. To avoid a creating security problems for older 568 ** applications that relink against newer versions of SQLite, the 569 ** ability to run load_extension is turned off by default. One 570 ** must call either sqlite3_enable_load_extension(db) or 571 ** sqlite3_db_config(db, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION, 1, 0) 572 ** to turn on extension loading. 573 */ 574 if( (db->flags & SQLITE_LoadExtension)==0 ){ 575 if( pzErrMsg ){ 576 *pzErrMsg = sqlite3_mprintf("not authorized"); 577 } 578 return SQLITE_ERROR; 579 } 580 581 zEntry = zProc ? zProc : "sqlite3_extension_init"; 582 583 /* tag-20210611-1. Some dlopen() implementations will segfault if given 584 ** an oversize filename. Most filesystems have a pathname limit of 4K, 585 ** so limit the extension filename length to about twice that. 586 ** https://sqlite.org/forum/forumpost/08a0d6d9bf */ 587 if( nMsg>SQLITE_MAX_PATHLEN ) goto extension_not_found; 588 589 handle = sqlite3OsDlOpen(pVfs, zFile); 590 #if SQLITE_OS_UNIX || SQLITE_OS_WIN 591 for(ii=0; ii<ArraySize(azEndings) && handle==0; ii++){ 592 char *zAltFile = sqlite3_mprintf("%s.%s", zFile, azEndings[ii]); 593 if( zAltFile==0 ) return SQLITE_NOMEM_BKPT; 594 handle = sqlite3OsDlOpen(pVfs, zAltFile); 595 sqlite3_free(zAltFile); 596 } 597 #endif 598 if( handle==0 ) goto extension_not_found; 599 xInit = (sqlite3_loadext_entry)sqlite3OsDlSym(pVfs, handle, zEntry); 600 601 /* If no entry point was specified and the default legacy 602 ** entry point name "sqlite3_extension_init" was not found, then 603 ** construct an entry point name "sqlite3_X_init" where the X is 604 ** replaced by the lowercase value of every ASCII alphabetic 605 ** character in the filename after the last "/" upto the first ".", 606 ** and eliding the first three characters if they are "lib". 607 ** Examples: 608 ** 609 ** /usr/local/lib/libExample5.4.3.so ==> sqlite3_example_init 610 ** C:/lib/mathfuncs.dll ==> sqlite3_mathfuncs_init 611 */ 612 if( xInit==0 && zProc==0 ){ 613 int iFile, iEntry, c; 614 int ncFile = sqlite3Strlen30(zFile); 615 zAltEntry = sqlite3_malloc64(ncFile+30); 616 if( zAltEntry==0 ){ 617 sqlite3OsDlClose(pVfs, handle); 618 return SQLITE_NOMEM_BKPT; 619 } 620 memcpy(zAltEntry, "sqlite3_", 8); 621 for(iFile=ncFile-1; iFile>=0 && !DirSep(zFile[iFile]); iFile--){} 622 iFile++; 623 if( sqlite3_strnicmp(zFile+iFile, "lib", 3)==0 ) iFile += 3; 624 for(iEntry=8; (c = zFile[iFile])!=0 && c!='.'; iFile++){ 625 if( sqlite3Isalpha(c) ){ 626 zAltEntry[iEntry++] = (char)sqlite3UpperToLower[(unsigned)c]; 627 } 628 } 629 memcpy(zAltEntry+iEntry, "_init", 6); 630 zEntry = zAltEntry; 631 xInit = (sqlite3_loadext_entry)sqlite3OsDlSym(pVfs, handle, zEntry); 632 } 633 if( xInit==0 ){ 634 if( pzErrMsg ){ 635 nMsg += strlen(zEntry) + 300; 636 *pzErrMsg = zErrmsg = sqlite3_malloc64(nMsg); 637 if( zErrmsg ){ 638 assert( nMsg<0x7fffffff ); /* zErrmsg would be NULL if not so */ 639 sqlite3_snprintf((int)nMsg, zErrmsg, 640 "no entry point [%s] in shared library [%s]", zEntry, zFile); 641 sqlite3OsDlError(pVfs, nMsg-1, zErrmsg); 642 } 643 } 644 sqlite3OsDlClose(pVfs, handle); 645 sqlite3_free(zAltEntry); 646 return SQLITE_ERROR; 647 } 648 sqlite3_free(zAltEntry); 649 rc = xInit(db, &zErrmsg, &sqlite3Apis); 650 if( rc ){ 651 if( rc==SQLITE_OK_LOAD_PERMANENTLY ) return SQLITE_OK; 652 if( pzErrMsg ){ 653 *pzErrMsg = sqlite3_mprintf("error during initialization: %s", zErrmsg); 654 } 655 sqlite3_free(zErrmsg); 656 sqlite3OsDlClose(pVfs, handle); 657 return SQLITE_ERROR; 658 } 659 660 /* Append the new shared library handle to the db->aExtension array. */ 661 aHandle = sqlite3DbMallocZero(db, sizeof(handle)*(db->nExtension+1)); 662 if( aHandle==0 ){ 663 return SQLITE_NOMEM_BKPT; 664 } 665 if( db->nExtension>0 ){ 666 memcpy(aHandle, db->aExtension, sizeof(handle)*db->nExtension); 667 } 668 sqlite3DbFree(db, db->aExtension); 669 db->aExtension = aHandle; 670 671 db->aExtension[db->nExtension++] = handle; 672 return SQLITE_OK; 673 674 extension_not_found: 675 if( pzErrMsg ){ 676 nMsg += 300; 677 *pzErrMsg = zErrmsg = sqlite3_malloc64(nMsg); 678 if( zErrmsg ){ 679 assert( nMsg<0x7fffffff ); /* zErrmsg would be NULL if not so */ 680 sqlite3_snprintf((int)nMsg, zErrmsg, 681 "unable to open shared library [%.*s]", SQLITE_MAX_PATHLEN, zFile); 682 sqlite3OsDlError(pVfs, nMsg-1, zErrmsg); 683 } 684 } 685 return SQLITE_ERROR; 686 } 687 int sqlite3_load_extension( 688 sqlite3 *db, /* Load the extension into this database connection */ 689 const char *zFile, /* Name of the shared library containing extension */ 690 const char *zProc, /* Entry point. Use "sqlite3_extension_init" if 0 */ 691 char **pzErrMsg /* Put error message here if not 0 */ 692 ){ 693 int rc; 694 sqlite3_mutex_enter(db->mutex); 695 rc = sqlite3LoadExtension(db, zFile, zProc, pzErrMsg); 696 rc = sqlite3ApiExit(db, rc); 697 sqlite3_mutex_leave(db->mutex); 698 return rc; 699 } 700 701 /* 702 ** Call this routine when the database connection is closing in order 703 ** to clean up loaded extensions 704 */ 705 void sqlite3CloseExtensions(sqlite3 *db){ 706 int i; 707 assert( sqlite3_mutex_held(db->mutex) ); 708 for(i=0; i<db->nExtension; i++){ 709 sqlite3OsDlClose(db->pVfs, db->aExtension[i]); 710 } 711 sqlite3DbFree(db, db->aExtension); 712 } 713 714 /* 715 ** Enable or disable extension loading. Extension loading is disabled by 716 ** default so as not to open security holes in older applications. 717 */ 718 int sqlite3_enable_load_extension(sqlite3 *db, int onoff){ 719 sqlite3_mutex_enter(db->mutex); 720 if( onoff ){ 721 db->flags |= SQLITE_LoadExtension|SQLITE_LoadExtFunc; 722 }else{ 723 db->flags &= ~(u64)(SQLITE_LoadExtension|SQLITE_LoadExtFunc); 724 } 725 sqlite3_mutex_leave(db->mutex); 726 return SQLITE_OK; 727 } 728 729 #endif /* !defined(SQLITE_OMIT_LOAD_EXTENSION) */ 730 731 /* 732 ** The following object holds the list of automatically loaded 733 ** extensions. 734 ** 735 ** This list is shared across threads. The SQLITE_MUTEX_STATIC_MAIN 736 ** mutex must be held while accessing this list. 737 */ 738 typedef struct sqlite3AutoExtList sqlite3AutoExtList; 739 static SQLITE_WSD struct sqlite3AutoExtList { 740 u32 nExt; /* Number of entries in aExt[] */ 741 void (**aExt)(void); /* Pointers to the extension init functions */ 742 } sqlite3Autoext = { 0, 0 }; 743 744 /* The "wsdAutoext" macro will resolve to the autoextension 745 ** state vector. If writable static data is unsupported on the target, 746 ** we have to locate the state vector at run-time. In the more common 747 ** case where writable static data is supported, wsdStat can refer directly 748 ** to the "sqlite3Autoext" state vector declared above. 749 */ 750 #ifdef SQLITE_OMIT_WSD 751 # define wsdAutoextInit \ 752 sqlite3AutoExtList *x = &GLOBAL(sqlite3AutoExtList,sqlite3Autoext) 753 # define wsdAutoext x[0] 754 #else 755 # define wsdAutoextInit 756 # define wsdAutoext sqlite3Autoext 757 #endif 758 759 760 /* 761 ** Register a statically linked extension that is automatically 762 ** loaded by every new database connection. 763 */ 764 int sqlite3_auto_extension( 765 void (*xInit)(void) 766 ){ 767 int rc = SQLITE_OK; 768 #ifndef SQLITE_OMIT_AUTOINIT 769 rc = sqlite3_initialize(); 770 if( rc ){ 771 return rc; 772 }else 773 #endif 774 { 775 u32 i; 776 #if SQLITE_THREADSAFE 777 sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MAIN); 778 #endif 779 wsdAutoextInit; 780 sqlite3_mutex_enter(mutex); 781 for(i=0; i<wsdAutoext.nExt; i++){ 782 if( wsdAutoext.aExt[i]==xInit ) break; 783 } 784 if( i==wsdAutoext.nExt ){ 785 u64 nByte = (wsdAutoext.nExt+1)*sizeof(wsdAutoext.aExt[0]); 786 void (**aNew)(void); 787 aNew = sqlite3_realloc64(wsdAutoext.aExt, nByte); 788 if( aNew==0 ){ 789 rc = SQLITE_NOMEM_BKPT; 790 }else{ 791 wsdAutoext.aExt = aNew; 792 wsdAutoext.aExt[wsdAutoext.nExt] = xInit; 793 wsdAutoext.nExt++; 794 } 795 } 796 sqlite3_mutex_leave(mutex); 797 assert( (rc&0xff)==rc ); 798 return rc; 799 } 800 } 801 802 /* 803 ** Cancel a prior call to sqlite3_auto_extension. Remove xInit from the 804 ** set of routines that is invoked for each new database connection, if it 805 ** is currently on the list. If xInit is not on the list, then this 806 ** routine is a no-op. 807 ** 808 ** Return 1 if xInit was found on the list and removed. Return 0 if xInit 809 ** was not on the list. 810 */ 811 int sqlite3_cancel_auto_extension( 812 void (*xInit)(void) 813 ){ 814 #if SQLITE_THREADSAFE 815 sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MAIN); 816 #endif 817 int i; 818 int n = 0; 819 wsdAutoextInit; 820 sqlite3_mutex_enter(mutex); 821 for(i=(int)wsdAutoext.nExt-1; i>=0; i--){ 822 if( wsdAutoext.aExt[i]==xInit ){ 823 wsdAutoext.nExt--; 824 wsdAutoext.aExt[i] = wsdAutoext.aExt[wsdAutoext.nExt]; 825 n++; 826 break; 827 } 828 } 829 sqlite3_mutex_leave(mutex); 830 return n; 831 } 832 833 /* 834 ** Reset the automatic extension loading mechanism. 835 */ 836 void sqlite3_reset_auto_extension(void){ 837 #ifndef SQLITE_OMIT_AUTOINIT 838 if( sqlite3_initialize()==SQLITE_OK ) 839 #endif 840 { 841 #if SQLITE_THREADSAFE 842 sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MAIN); 843 #endif 844 wsdAutoextInit; 845 sqlite3_mutex_enter(mutex); 846 sqlite3_free(wsdAutoext.aExt); 847 wsdAutoext.aExt = 0; 848 wsdAutoext.nExt = 0; 849 sqlite3_mutex_leave(mutex); 850 } 851 } 852 853 /* 854 ** Load all automatic extensions. 855 ** 856 ** If anything goes wrong, set an error in the database connection. 857 */ 858 void sqlite3AutoLoadExtensions(sqlite3 *db){ 859 u32 i; 860 int go = 1; 861 int rc; 862 sqlite3_loadext_entry xInit; 863 864 wsdAutoextInit; 865 if( wsdAutoext.nExt==0 ){ 866 /* Common case: early out without every having to acquire a mutex */ 867 return; 868 } 869 for(i=0; go; i++){ 870 char *zErrmsg; 871 #if SQLITE_THREADSAFE 872 sqlite3_mutex *mutex = sqlite3MutexAlloc(SQLITE_MUTEX_STATIC_MAIN); 873 #endif 874 #ifdef SQLITE_OMIT_LOAD_EXTENSION 875 const sqlite3_api_routines *pThunk = 0; 876 #else 877 const sqlite3_api_routines *pThunk = &sqlite3Apis; 878 #endif 879 sqlite3_mutex_enter(mutex); 880 if( i>=wsdAutoext.nExt ){ 881 xInit = 0; 882 go = 0; 883 }else{ 884 xInit = (sqlite3_loadext_entry)wsdAutoext.aExt[i]; 885 } 886 sqlite3_mutex_leave(mutex); 887 zErrmsg = 0; 888 if( xInit && (rc = xInit(db, &zErrmsg, pThunk))!=0 ){ 889 sqlite3ErrorWithMsg(db, rc, 890 "automatic extension loading failed: %s", zErrmsg); 891 go = 0; 892 } 893 sqlite3_free(zErrmsg); 894 } 895 } 896