xref: /sqlite-3.40.0/src/sqlite3ext.h (revision 73bdf077)
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