11e397f8fSdrh /* 21e397f8fSdrh ** 2006 June 7 31e397f8fSdrh ** 41e397f8fSdrh ** The author disclaims copyright to this source code. In place of 51e397f8fSdrh ** a legal notice, here is a blessing: 61e397f8fSdrh ** 71e397f8fSdrh ** May you do good and not evil. 81e397f8fSdrh ** May you find forgiveness for yourself and forgive others. 91e397f8fSdrh ** May you share freely, never taking more than you give. 101e397f8fSdrh ** 111e397f8fSdrh ************************************************************************* 121e397f8fSdrh ** This header file defines the SQLite interface for use by 131e397f8fSdrh ** shared libraries that want to be imported as extensions into 141e397f8fSdrh ** an SQLite instance. Shared libraries that intend to be loaded 151e397f8fSdrh ** as extensions by SQLite should #include this file instead of 161e397f8fSdrh ** sqlite3.h. 171e397f8fSdrh ** 18*73bdf077Sdrh ** @(#) $Id: sqlite3ext.h,v 1.6 2006/08/15 14:21:16 drh Exp $ 191e397f8fSdrh */ 201e397f8fSdrh #ifndef _SQLITE3EXT_H_ 211e397f8fSdrh #define _SQLITE3EXT_H_ 22*73bdf077Sdrh #include "sqlite3.h" 231e397f8fSdrh 241e397f8fSdrh typedef struct sqlite3_api_routines sqlite3_api_routines; 251e397f8fSdrh 261e397f8fSdrh /* 271e397f8fSdrh ** The following structure hold pointers to all of the SQLite API 281e397f8fSdrh ** routines. 291e397f8fSdrh */ 301e397f8fSdrh struct sqlite3_api_routines { 311e397f8fSdrh void * (*aggregate_context)(sqlite3_context*,int nBytes); 321e397f8fSdrh int (*aggregate_count)(sqlite3_context*); 331e397f8fSdrh int (*bind_blob)(sqlite3_stmt*,int,const void*,int n,void(*)(void*)); 341e397f8fSdrh int (*bind_double)(sqlite3_stmt*,int,double); 351e397f8fSdrh int (*bind_int)(sqlite3_stmt*,int,int); 361e397f8fSdrh int (*bind_int64)(sqlite3_stmt*,int,sqlite_int64); 371e397f8fSdrh int (*bind_null)(sqlite3_stmt*,int); 381e397f8fSdrh int (*bind_parameter_count)(sqlite3_stmt*); 391e397f8fSdrh int (*bind_parameter_index)(sqlite3_stmt*,const char*zName); 401e397f8fSdrh const char * (*bind_parameter_name)(sqlite3_stmt*,int); 411e397f8fSdrh int (*bind_text)(sqlite3_stmt*,int,const char*,int n,void(*)(void*)); 421e397f8fSdrh int (*bind_text16)(sqlite3_stmt*,int,const void*,int,void(*)(void*)); 43c1be6324Sdrh int (*bind_value)(sqlite3_stmt*,int,const sqlite3_value*); 441e397f8fSdrh int (*busy_handler)(sqlite3*,int(*)(void*,int),void*); 451e397f8fSdrh int (*busy_timeout)(sqlite3*,int ms); 461e397f8fSdrh int (*changes)(sqlite3*); 471e397f8fSdrh int (*close)(sqlite3*); 481e397f8fSdrh int (*collation_needed)(sqlite3*,void*,void(*)(void*,sqlite3*,int eTextRep,const char*)); 491e397f8fSdrh int (*collation_needed16)(sqlite3*,void*,void(*)(void*,sqlite3*,int eTextRep,const void*)); 501e397f8fSdrh const void * (*column_blob)(sqlite3_stmt*,int iCol); 511e397f8fSdrh int (*column_bytes)(sqlite3_stmt*,int iCol); 521e397f8fSdrh int (*column_bytes16)(sqlite3_stmt*,int iCol); 531e397f8fSdrh int (*column_count)(sqlite3_stmt*pStmt); 541e397f8fSdrh const char * (*column_database_name)(sqlite3_stmt*,int); 551e397f8fSdrh const void * (*column_database_name16)(sqlite3_stmt*,int); 561e397f8fSdrh const char * (*column_decltype)(sqlite3_stmt*,int i); 571e397f8fSdrh const void * (*column_decltype16)(sqlite3_stmt*,int); 581e397f8fSdrh double (*column_double)(sqlite3_stmt*,int iCol); 591e397f8fSdrh int (*column_int)(sqlite3_stmt*,int iCol); 601e397f8fSdrh sqlite_int64 (*column_int64)(sqlite3_stmt*,int iCol); 611e397f8fSdrh const char * (*column_name)(sqlite3_stmt*,int); 621e397f8fSdrh const void * (*column_name16)(sqlite3_stmt*,int); 631e397f8fSdrh const char * (*column_origin_name)(sqlite3_stmt*,int); 641e397f8fSdrh const void * (*column_origin_name16)(sqlite3_stmt*,int); 651e397f8fSdrh const char * (*column_table_name)(sqlite3_stmt*,int); 661e397f8fSdrh const void * (*column_table_name16)(sqlite3_stmt*,int); 671e397f8fSdrh const unsigned char * (*column_text)(sqlite3_stmt*,int iCol); 681e397f8fSdrh const void * (*column_text16)(sqlite3_stmt*,int iCol); 691e397f8fSdrh int (*column_type)(sqlite3_stmt*,int iCol); 70d6e8dd00Sdanielk1977 sqlite3_value* (*column_value)(sqlite3_stmt*,int iCol); 711e397f8fSdrh void * (*commit_hook)(sqlite3*,int(*)(void*),void*); 721e397f8fSdrh int (*complete)(const char*sql); 731e397f8fSdrh int (*complete16)(const void*sql); 741e397f8fSdrh int (*create_collation)(sqlite3*,const char*,int,void*,int(*)(void*,int,const void*,int,const void*)); 751e397f8fSdrh int (*create_collation16)(sqlite3*,const char*,int,void*,int(*)(void*,int,const void*,int,const void*)); 761e397f8fSdrh int (*create_function)(sqlite3*,const char*,int,int,void*,void (*xFunc)(sqlite3_context*,int,sqlite3_value**),void (*xStep)(sqlite3_context*,int,sqlite3_value**),void (*xFinal)(sqlite3_context*)); 771e397f8fSdrh int (*create_function16)(sqlite3*,const void*,int,int,void*,void (*xFunc)(sqlite3_context*,int,sqlite3_value**),void (*xStep)(sqlite3_context*,int,sqlite3_value**),void (*xFinal)(sqlite3_context*)); 789c41938fSdrh int (*create_module)(sqlite3*,const char*,const sqlite3_module*,void*); 791e397f8fSdrh int (*data_count)(sqlite3_stmt*pStmt); 801e397f8fSdrh sqlite3 * (*db_handle)(sqlite3_stmt*); 81d6e8dd00Sdanielk1977 int (*declare_vtab)(sqlite3*,const char*); 821e397f8fSdrh int (*enable_shared_cache)(int); 831e397f8fSdrh int (*errcode)(sqlite3*db); 841e397f8fSdrh const char * (*errmsg)(sqlite3*); 851e397f8fSdrh const void * (*errmsg16)(sqlite3*); 861e397f8fSdrh int (*exec)(sqlite3*,const char*,sqlite3_callback,void*,char**); 871e397f8fSdrh int (*expired)(sqlite3_stmt*); 881e397f8fSdrh int (*finalize)(sqlite3_stmt*pStmt); 89c1be6324Sdrh void (*free)(void*); 901e397f8fSdrh void (*free_table)(char**result); 911e397f8fSdrh int (*get_autocommit)(sqlite3*); 921e397f8fSdrh void * (*get_auxdata)(sqlite3_context*,int); 931e397f8fSdrh int (*get_table)(sqlite3*,const char*,char***,int*,int*,char**); 941e397f8fSdrh int (*global_recover)(void); 951e397f8fSdrh void (*interrupt)(sqlite3*); 961e397f8fSdrh sqlite_int64 (*last_insert_rowid)(sqlite3*); 971e397f8fSdrh const char * (*libversion)(void); 981e397f8fSdrh int (*libversion_number)(void); 9928dd479cSdrh void *(*malloc)(int); 1001e397f8fSdrh char * (*mprintf)(const char*,...); 1011e397f8fSdrh int (*open)(const char*,sqlite3**); 1021e397f8fSdrh int (*open16)(const void*,sqlite3**); 1031e397f8fSdrh int (*prepare)(sqlite3*,const char*,int,sqlite3_stmt**,const char**); 1041e397f8fSdrh int (*prepare16)(sqlite3*,const void*,int,sqlite3_stmt**,const void**); 1051e397f8fSdrh void * (*profile)(sqlite3*,void(*)(void*,const char*,sqlite_uint64),void*); 1061e397f8fSdrh void (*progress_handler)(sqlite3*,int,int(*)(void*),void*); 10728dd479cSdrh void *(*realloc)(void*,int); 1081e397f8fSdrh int (*reset)(sqlite3_stmt*pStmt); 1091e397f8fSdrh void (*result_blob)(sqlite3_context*,const void*,int,void(*)(void*)); 1101e397f8fSdrh void (*result_double)(sqlite3_context*,double); 1111e397f8fSdrh void (*result_error)(sqlite3_context*,const char*,int); 1121e397f8fSdrh void (*result_error16)(sqlite3_context*,const void*,int); 1131e397f8fSdrh void (*result_int)(sqlite3_context*,int); 1141e397f8fSdrh void (*result_int64)(sqlite3_context*,sqlite_int64); 1151e397f8fSdrh void (*result_null)(sqlite3_context*); 1161e397f8fSdrh void (*result_text)(sqlite3_context*,const char*,int,void(*)(void*)); 1171e397f8fSdrh void (*result_text16)(sqlite3_context*,const void*,int,void(*)(void*)); 1181e397f8fSdrh void (*result_text16be)(sqlite3_context*,const void*,int,void(*)(void*)); 1191e397f8fSdrh void (*result_text16le)(sqlite3_context*,const void*,int,void(*)(void*)); 1201e397f8fSdrh void (*result_value)(sqlite3_context*,sqlite3_value*); 1211e397f8fSdrh void * (*rollback_hook)(sqlite3*,void(*)(void*),void*); 1221e397f8fSdrh int (*set_authorizer)(sqlite3*,int(*)(void*,int,const char*,const char*,const char*,const char*),void*); 1231e397f8fSdrh void (*set_auxdata)(sqlite3_context*,int,void*,void (*)(void*)); 1241e397f8fSdrh char * (*snprintf)(int,char*,const char*,...); 1251e397f8fSdrh int (*step)(sqlite3_stmt*); 1261e397f8fSdrh int (*table_column_metadata)(sqlite3*,const char*,const char*,const char*,char const**,char const**,int*,int*,int*); 1271e397f8fSdrh void (*thread_cleanup)(void); 1281e397f8fSdrh int (*total_changes)(sqlite3*); 1291e397f8fSdrh void * (*trace)(sqlite3*,void(*xTrace)(void*,const char*),void*); 1301e397f8fSdrh int (*transfer_bindings)(sqlite3_stmt*,sqlite3_stmt*); 1311e397f8fSdrh void * (*update_hook)(sqlite3*,void(*)(void*,int ,char const*,char const*,sqlite_int64),void*); 1321e397f8fSdrh void * (*user_data)(sqlite3_context*); 1331e397f8fSdrh const void * (*value_blob)(sqlite3_value*); 1341e397f8fSdrh int (*value_bytes)(sqlite3_value*); 1351e397f8fSdrh int (*value_bytes16)(sqlite3_value*); 1361e397f8fSdrh double (*value_double)(sqlite3_value*); 1371e397f8fSdrh int (*value_int)(sqlite3_value*); 1381e397f8fSdrh sqlite_int64 (*value_int64)(sqlite3_value*); 1391e397f8fSdrh int (*value_numeric_type)(sqlite3_value*); 1401e397f8fSdrh const unsigned char * (*value_text)(sqlite3_value*); 1411e397f8fSdrh const void * (*value_text16)(sqlite3_value*); 1421e397f8fSdrh const void * (*value_text16be)(sqlite3_value*); 1431e397f8fSdrh const void * (*value_text16le)(sqlite3_value*); 1441e397f8fSdrh int (*value_type)(sqlite3_value*); 1451e397f8fSdrh char * (*vmprintf)(const char*,va_list); 1461e397f8fSdrh }; 1471e397f8fSdrh 1481e397f8fSdrh /* 1491e397f8fSdrh ** The following macros redefine the API routines so that they are 1501e397f8fSdrh ** redirected throught the global sqlite3_api structure. 1511e397f8fSdrh ** 1521e397f8fSdrh ** This header file is also used by the loadext.c source file 1531e397f8fSdrh ** (part of the main SQLite library - not an extension) so that 1541e397f8fSdrh ** it can get access to the sqlite3_api_routines structure 1551e397f8fSdrh ** definition. But the main library does not want to redefine 1561e397f8fSdrh ** the API. So the redefinition macros are only valid if the 1571e397f8fSdrh ** SQLITE_CORE macros is undefined. 1581e397f8fSdrh */ 1591e397f8fSdrh #ifndef SQLITE_CORE 1601e397f8fSdrh #define sqlite3_aggregate_context sqlite3_api->aggregate_context 1611e397f8fSdrh #define sqlite3_aggregate_count sqlite3_api->aggregate_count 1621e397f8fSdrh #define sqlite3_bind_blob sqlite3_api->bind_blob 1631e397f8fSdrh #define sqlite3_bind_double sqlite3_api->bind_double 1641e397f8fSdrh #define sqlite3_bind_int sqlite3_api->bind_int 1651e397f8fSdrh #define sqlite3_bind_int64 sqlite3_api->bind_int64 1661e397f8fSdrh #define sqlite3_bind_null sqlite3_api->bind_null 1671e397f8fSdrh #define sqlite3_bind_parameter_count sqlite3_api->bind_parameter_count 1681e397f8fSdrh #define sqlite3_bind_parameter_index sqlite3_api->bind_parameter_index 1691e397f8fSdrh #define sqlite3_bind_parameter_name sqlite3_api->bind_parameter_name 1701e397f8fSdrh #define sqlite3_bind_text sqlite3_api->bind_text 1711e397f8fSdrh #define sqlite3_bind_text16 sqlite3_api->bind_text16 172c1be6324Sdrh #define sqlite3_bind_value sqlite3_api->bind_value 1731e397f8fSdrh #define sqlite3_busy_handler sqlite3_api->busy_handler 1741e397f8fSdrh #define sqlite3_busy_timeout sqlite3_api->busy_timeout 1751e397f8fSdrh #define sqlite3_changes sqlite3_api->changes 1761e397f8fSdrh #define sqlite3_close sqlite3_api->close 1771e397f8fSdrh #define sqlite3_collation_needed sqlite3_api->collation_needed 1781e397f8fSdrh #define sqlite3_collation_needed16 sqlite3_api->collation_needed16 1791e397f8fSdrh #define sqlite3_column_blob sqlite3_api->column_blob 1801e397f8fSdrh #define sqlite3_column_bytes sqlite3_api->column_bytes 1811e397f8fSdrh #define sqlite3_column_bytes16 sqlite3_api->column_bytes16 1821e397f8fSdrh #define sqlite3_column_count sqlite3_api->column_count 1831e397f8fSdrh #define sqlite3_column_database_name sqlite3_api->column_database_name 1841e397f8fSdrh #define sqlite3_column_database_name16 sqlite3_api->column_database_name16 1851e397f8fSdrh #define sqlite3_column_decltype sqlite3_api->column_decltype 1861e397f8fSdrh #define sqlite3_column_decltype16 sqlite3_api->column_decltype16 1871e397f8fSdrh #define sqlite3_column_double sqlite3_api->column_double 1881e397f8fSdrh #define sqlite3_column_int sqlite3_api->column_int 1891e397f8fSdrh #define sqlite3_column_int64 sqlite3_api->column_int64 1901e397f8fSdrh #define sqlite3_column_name sqlite3_api->column_name 1911e397f8fSdrh #define sqlite3_column_name16 sqlite3_api->column_name16 1921e397f8fSdrh #define sqlite3_column_origin_name sqlite3_api->column_origin_name 1931e397f8fSdrh #define sqlite3_column_origin_name16 sqlite3_api->column_origin_name16 1941e397f8fSdrh #define sqlite3_column_table_name sqlite3_api->column_table_name 1951e397f8fSdrh #define sqlite3_column_table_name16 sqlite3_api->column_table_name16 1961e397f8fSdrh #define sqlite3_column_text sqlite3_api->column_text 1971e397f8fSdrh #define sqlite3_column_text16 sqlite3_api->column_text16 1981e397f8fSdrh #define sqlite3_column_type sqlite3_api->column_type 199d6e8dd00Sdanielk1977 #define sqlite3_column_value sqlite3_api->column_value 2001e397f8fSdrh #define sqlite3_commit_hook sqlite3_api->commit_hook 2011e397f8fSdrh #define sqlite3_complete sqlite3_api->complete 2021e397f8fSdrh #define sqlite3_complete16 sqlite3_api->complete16 2031e397f8fSdrh #define sqlite3_create_collation sqlite3_api->create_collation 2041e397f8fSdrh #define sqlite3_create_collation16 sqlite3_api->create_collation16 2051e397f8fSdrh #define sqlite3_create_function sqlite3_api->create_function 2061e397f8fSdrh #define sqlite3_create_function16 sqlite3_api->create_function16 207d6e8dd00Sdanielk1977 #define sqlite3_create_module sqlite3_api->create_module 2081e397f8fSdrh #define sqlite3_data_count sqlite3_api->data_count 2091e397f8fSdrh #define sqlite3_db_handle sqlite3_api->db_handle 210d6e8dd00Sdanielk1977 #define sqlite3_declare_vtab sqlite3_api->declare_vtab 2111e397f8fSdrh #define sqlite3_enable_shared_cache sqlite3_api->enable_shared_cache 2121e397f8fSdrh #define sqlite3_errcode sqlite3_api->errcode 2131e397f8fSdrh #define sqlite3_errmsg sqlite3_api->errmsg 2141e397f8fSdrh #define sqlite3_errmsg16 sqlite3_api->errmsg16 2151e397f8fSdrh #define sqlite3_exec sqlite3_api->exec 2161e397f8fSdrh #define sqlite3_expired sqlite3_api->expired 2171e397f8fSdrh #define sqlite3_finalize sqlite3_api->finalize 2181e397f8fSdrh #define sqlite3_free sqlite3_api->free 2191e397f8fSdrh #define sqlite3_free_table sqlite3_api->free_table 2201e397f8fSdrh #define sqlite3_get_autocommit sqlite3_api->get_autocommit 2211e397f8fSdrh #define sqlite3_get_auxdata sqlite3_api->get_auxdata 2221e397f8fSdrh #define sqlite3_get_table sqlite3_api->get_table 2231e397f8fSdrh #define sqlite3_global_recover sqlite3_api->global_recover 2241e397f8fSdrh #define sqlite3_interrupt sqlite3_api->interrupt 2251e397f8fSdrh #define sqlite3_last_insert_rowid sqlite3_api->last_insert_rowid 2261e397f8fSdrh #define sqlite3_libversion sqlite3_api->libversion 2271e397f8fSdrh #define sqlite3_libversion_number sqlite3_api->libversion_number 22828dd479cSdrh #define sqlite3_malloc sqlite3_api->malloc 2291e397f8fSdrh #define sqlite3_mprintf sqlite3_api->mprintf 2301e397f8fSdrh #define sqlite3_open sqlite3_api->open 2311e397f8fSdrh #define sqlite3_open16 sqlite3_api->open16 2321e397f8fSdrh #define sqlite3_prepare sqlite3_api->prepare 2331e397f8fSdrh #define sqlite3_prepare16 sqlite3_api->prepare16 2341e397f8fSdrh #define sqlite3_profile sqlite3_api->profile 2351e397f8fSdrh #define sqlite3_progress_handler sqlite3_api->progress_handler 23628dd479cSdrh #define sqlite3_realloc sqlite3_api->realloc 2371e397f8fSdrh #define sqlite3_reset sqlite3_api->reset 2381e397f8fSdrh #define sqlite3_result_blob sqlite3_api->result_blob 2391e397f8fSdrh #define sqlite3_result_double sqlite3_api->result_double 2401e397f8fSdrh #define sqlite3_result_error sqlite3_api->result_error 2411e397f8fSdrh #define sqlite3_result_error16 sqlite3_api->result_error16 2421e397f8fSdrh #define sqlite3_result_int sqlite3_api->result_int 2431e397f8fSdrh #define sqlite3_result_int64 sqlite3_api->result_int64 2441e397f8fSdrh #define sqlite3_result_null sqlite3_api->result_null 2451e397f8fSdrh #define sqlite3_result_text sqlite3_api->result_text 2461e397f8fSdrh #define sqlite3_result_text16 sqlite3_api->result_text16 2471e397f8fSdrh #define sqlite3_result_text16be sqlite3_api->result_text16be 2481e397f8fSdrh #define sqlite3_result_text16le sqlite3_api->result_text16le 2491e397f8fSdrh #define sqlite3_result_value sqlite3_api->result_value 2501e397f8fSdrh #define sqlite3_rollback_hook sqlite3_api->rollback_hook 2511e397f8fSdrh #define sqlite3_set_authorizer sqlite3_api->set_authorizer 2521e397f8fSdrh #define sqlite3_set_auxdata sqlite3_api->set_auxdata 2531e397f8fSdrh #define sqlite3_snprintf sqlite3_api->snprintf 2541e397f8fSdrh #define sqlite3_step sqlite3_api->step 2551e397f8fSdrh #define sqlite3_table_column_metadata sqlite3_api->table_column_metadata 2561e397f8fSdrh #define sqlite3_thread_cleanup sqlite3_api->thread_cleanup 2571e397f8fSdrh #define sqlite3_total_changes sqlite3_api->total_changes 2581e397f8fSdrh #define sqlite3_trace sqlite3_api->trace 2591e397f8fSdrh #define sqlite3_transfer_bindings sqlite3_api->transfer_bindings 2601e397f8fSdrh #define sqlite3_update_hook sqlite3_api->update_hook 2611e397f8fSdrh #define sqlite3_user_data sqlite3_api->user_data 2621e397f8fSdrh #define sqlite3_value_blob sqlite3_api->value_blob 2631e397f8fSdrh #define sqlite3_value_bytes sqlite3_api->value_bytes 2641e397f8fSdrh #define sqlite3_value_bytes16 sqlite3_api->value_bytes16 2651e397f8fSdrh #define sqlite3_value_double sqlite3_api->value_double 2661e397f8fSdrh #define sqlite3_value_int sqlite3_api->value_int 2671e397f8fSdrh #define sqlite3_value_int64 sqlite3_api->value_int64 2681e397f8fSdrh #define sqlite3_value_numeric_type sqlite3_api->value_numeric_type 2691e397f8fSdrh #define sqlite3_value_text sqlite3_api->value_text 2701e397f8fSdrh #define sqlite3_value_text16 sqlite3_api->value_text16 2711e397f8fSdrh #define sqlite3_value_text16be sqlite3_api->value_text16be 2721e397f8fSdrh #define sqlite3_value_text16le sqlite3_api->value_text16le 2731e397f8fSdrh #define sqlite3_value_type sqlite3_api->value_type 2741e397f8fSdrh #define sqlite3_vmprintf sqlite3_api->vmprintf 2751e397f8fSdrh #endif /* SQLITE_CORE */ 2761e397f8fSdrh 2771e397f8fSdrh #define SQLITE_EXTENSION_INIT1 const sqlite3_api_routines *sqlite3_api; 2781e397f8fSdrh #define SQLITE_EXTENSION_INIT2(v) sqlite3_api = v; 2791e397f8fSdrh 2801e397f8fSdrh #endif /* _SQLITE3EXT_H_ */ 281