Report a bug
If you spot a problem with this page, click here to create a Bugzilla issue.
Improve this page
Quickly fork, edit online, and submit a pull request for this page.
Requires a signed-in GitHub account. This works well for small changes.
If you'd like to make larger changes you may want to consider using
a local clone.
etc.c.sqlite3
- * CAPI3REF: Compile-Time Library Version Numbers
- * CAPI3REF: Run-Time Library Version Numbers
- * CAPI3REF: Run-Time Library Compilation Options Diagnostics
- * CAPI3REF: Test To See If The Library Is Threadsafe
- * CAPI3REF: Database Connection Handle
- * CAPI3REF: Closing A Database Connection *
- * The type for a callback function. * This is legacy and deprecated. It is included for historical * compatibility and is not documented.
- * CAPI3REF: One-Step Query Execution Interface
- Successful result
- DittoSQL error or missing database
- Internal logic error in SQLite
- Access permission denied
- Callback routine requested an abort
- The database file is locked
- A table in the database is locked
- A malloc() failed
- Attempt to write a readonly database
- Operation terminated by sqlite3_interrupt()
- Some kind of disk I/O error occurred
- The database disk image is malformed
- Unknown opcode in sqlite3_file_control()
- Insertion failed because database is full
- Unable to open the database file
- Database lock protocol error
- Database is empty
- The database schema changed
- String or BLOB exceeds size limit
- Abort due to constraint violation
- Data type mismatch
- Library used incorrectly
- Uses OS features not supported on host
- Authorization denied
- Auxiliary database format error
- 2nd parameter to sqlite3_bind out of range
- File opened that is not a database file
- sqlite3_step() has another row ready
- sqlite3_step() has finished executing
- Ok for sqlite3_open_v2()
- Ok for sqlite3_open_v2()
- Ok for sqlite3_open_v2()
- VFS only
- VFS only
- VFS only
- Ok for sqlite3_open_v2()
- Ok for sqlite3_open_v2()
- VFS only
- VFS only
- VFS only
- VFS only
- VFS only
- VFS only
- VFS only
- Ok for sqlite3_open_v2()
- Ok for sqlite3_open_v2()
- Ok for sqlite3_open_v2()
- Ok for sqlite3_open_v2()
- VFS only
- * CAPI3REF: OS Interface Open File Handle
- * CAPI3REF: OS Interface File Virtual Methods Object
- * CAPI3REF: Mutex Handle
- * CAPI3REF: OS Interface Object
- Used by PRAGMA temp_store_directory
- Unused
- * CAPI3REF: Maximum xShmLock index
- * CAPI3REF: Initialize The SQLite Library
- * CAPI3REF: Configuring The SQLite Library
- * CAPI3REF: Configure database connections
- * CAPI3REF: Memory Allocation Routines
- Memory allocation function
- Free a prior allocation
- Resize an allocation
- Return the size of an allocation
- Round up request size to allocation size
- Initialize the memory allocator
- Deinitialize the memory allocator
- Argument to xInit() and xShutdown()
- nil
- nil
- nil
- sqlite3_mem_methods*
- sqlite3_mem_methods*
- void*, int sz, int N
- void*, int sz, int N
- void*, int nByte, int min
- boolean
- sqlite3_mutex_methods*
- sqlite3_mutex_methods*
- int int
- sqlite3_pcache_methods*
- sqlite3_pcache_methods*
- xFunc, void*
- void* int int
- int int*
- int int*
- * CAPI3REF: Enable Or Disable Extended Result Codes
- * CAPI3REF: Last Insert Rowid
- * CAPI3REF: Count The Number Of Rows Modified
- * CAPI3REF: Total Number Of Rows Modified
- * CAPI3REF: Interrupt A Long-Running Query
- * CAPI3REF: Determine If An SQL Statement Is Complete
- * CAPI3REF: Register A Callback To Handle SQLITE_BUSY Errors
- * CAPI3REF: Set A Busy Timeout
- * CAPI3REF: Convenience Routines For Running Queries
- * CAPI3REF: Formatted String Printing Functions
- * CAPI3REF: Memory Allocation Subsystem
- * CAPI3REF: Memory Allocator Statistics
- * CAPI3REF: Pseudo-Random Number Generator
- * CAPI3REF: Compile-Time Authorization Callbacks
- Abort the SQL statement with an error
- Don't allow access, but don't generate an error
- Index Name Table Name
- Table Name NULL
- Index Name Table Name
- Table Name NULL
- Trigger Name Table Name
- View Name NULL
- Trigger Name Table Name
- View Name NULL
- Table Name NULL
- Index Name Table Name
- Table Name NULL
- Index Name Table Name
- Table Name NULL
- Trigger Name Table Name
- View Name NULL
- Trigger Name Table Name
- View Name NULL
- Table Name NULL
- Pragma Name 1st arg or NULL
- Table Name Column Name
- NULL NULL
- Operation NULL
- Table Name Column Name
- Filename NULL
- Database Name NULL
- Database Name Table Name
- Index Name NULL
- Table Name NULL
- Table Name Module Name
- Table Name Module Name
- NULL Function Name
- Operation Savepoint Name
- No longer used
- * CAPI3REF: Tracing And Profiling Functions
- * CAPI3REF: Query Progress Callbacks
- nothrow int sqlite3_open(const(char)* filename, sqlite3** ppDb);
nothrow int sqlite3_open16(const(void)* filename, sqlite3** ppDb);
nothrow int sqlite3_open_v2(const(char)* filename, sqlite3** ppDb, int flags, const(char)* zVfs);
nothrow int sqlite3_uri_boolean(const(char)* zFile, const(char)* zParam, int bDefault);
nothrow sqlite3_int64 sqlite3_uri_int64(const char*, const char*, sqlite3_int64); - * CAPI3REF: Opening A New Database Connection
- * CAPI3REF: Error Codes And Messages
- * CAPI3REF: SQL Statement Object
- * CAPI3REF: Run-time Limits
- nothrow int sqlite3_prepare(sqlite3* db, const(char)* zSql, int nByte, sqlite3_stmt** ppStmt, const(char*)* pzTail);
nothrow int sqlite3_prepare_v2(sqlite3* db, const(char)* zSql, int nByte, sqlite3_stmt** ppStmt, const(char*)* pzTail);
nothrow int sqlite3_prepare16(sqlite3* db, const(void)* zSql, int nByte, sqlite3_stmt** ppStmt, const(void*)* pzTail);
nothrow int sqlite3_prepare16_v2(sqlite3* db, const(void)* zSql, int nByte, sqlite3_stmt** ppStmt, const(void*)* pzTail); - * CAPI3REF: Compiling An SQL Statement
- * CAPI3REF: Retrieving Statement SQL
- * CAPI3REF: Determine If A Prepared Statement Has Been Reset
- * CAPI3REF: Dynamically Typed Value Object
- * CAPI3REF: SQL Function Context Object
- nothrow int sqlite3_bind_blob(sqlite3_stmt*, int, const void*, int n, void function(void*));
nothrow int sqlite3_bind_blob64(sqlite3_stmt*, int, const void*, sqlite3_uint64, void function(void*));
nothrow int sqlite3_bind_double(sqlite3_stmt*, int, double);
nothrow int sqlite3_bind_int(sqlite3_stmt*, int, int);
nothrow int sqlite3_bind_int64(sqlite3_stmt*, int, sqlite3_int64);
nothrow int sqlite3_bind_null(sqlite3_stmt*, int);
nothrow int sqlite3_bind_text(sqlite3_stmt*, int, const char*, int n, void function(void*));
nothrow int sqlite3_bind_text16(sqlite3_stmt*, int, const void*, int, void function(void*));
nothrow int sqlite3_bind_text64(sqlite3_stmt*, int, const char*, sqlite3_uint64, void function(void*), ubyte encoding);
nothrow int sqlite3_bind_value(sqlite3_stmt*, int, const sqlite3_value*);
nothrow int sqlite3_bind_zeroblob(sqlite3_stmt*, int, int n);
nothrow int sqlite3_bind_zeroblob64(sqlite3_stmt*, int, sqlite3_uint64 n); - * CAPI3REF: Binding Values To Prepared Statements
- * CAPI3REF: Number Of SQL Parameters
- * CAPI3REF: Name Of A Host Parameter
- * CAPI3REF: Index Of A Parameter With A Given Name
- * CAPI3REF: Reset All Bindings On A Prepared Statement
- * CAPI3REF: Number Of Columns In A Result Set
- * CAPI3REF: Column Names In A Result Set
- nothrow const(char)* sqlite3_column_database_name(sqlite3_stmt*, int);
nothrow const(void)* sqlite3_column_database_name16(sqlite3_stmt*, int);
nothrow const(char)* sqlite3_column_table_name(sqlite3_stmt*, int);
nothrow const(void)* sqlite3_column_table_name16(sqlite3_stmt*, int);
nothrow const(char)* sqlite3_column_origin_name(sqlite3_stmt*, int);
nothrow const(void)* sqlite3_column_origin_name16(sqlite3_stmt*, int); - * CAPI3REF: Source Of Data In A Query Result
- * CAPI3REF: Declared Datatype Of A Query Result
- * CAPI3REF: Evaluate An SQL Statement
- * CAPI3REF: Number of columns in a result set
- nothrow const(void)* sqlite3_column_blob(sqlite3_stmt*, int iCol);
nothrow int sqlite3_column_bytes(sqlite3_stmt*, int iCol);
nothrow int sqlite3_column_bytes16(sqlite3_stmt*, int iCol);
nothrow double sqlite3_column_double(sqlite3_stmt*, int iCol);
nothrow int sqlite3_column_int(sqlite3_stmt*, int iCol);
nothrow sqlite3_int64 sqlite3_column_int64(sqlite3_stmt*, int iCol);
nothrow const(char)* sqlite3_column_text(sqlite3_stmt*, int iCol);
nothrow const(void)* sqlite3_column_text16(sqlite3_stmt*, int iCol);
nothrow int sqlite3_column_type(sqlite3_stmt*, int iCol);
nothrow sqlite3_value* sqlite3_column_value(sqlite3_stmt*, int iCol); - * CAPI3REF: Result Values From A Query
- * CAPI3REF: Destroy A Prepared Statement Object
- * CAPI3REF: Reset A Prepared Statement Object
- nothrow int sqlite3_create_function(sqlite3* db, const(char)* zFunctionName, int nArg, int eTextRep, void* pApp, void function(sqlite3_context*, int, sqlite3_value**) xFunc, void function(sqlite3_context*, int, sqlite3_value**) xStep, void function(sqlite3_context*) xFinal);
nothrow int sqlite3_create_function16(sqlite3* db, const(void)* zFunctionName, int nArg, int eTextRep, void* pApp, void function(sqlite3_context*, int, sqlite3_value**) xFunc, void function(sqlite3_context*, int, sqlite3_value**) xStep, void function(sqlite3_context*) xFinal);
nothrow int sqlite3_create_function_v2(sqlite3* db, const(char)* zFunctionName, int nArg, int eTextRep, void* pApp, void function(sqlite3_context*, int, sqlite3_value**) xFunc, void function(sqlite3_context*, int, sqlite3_value**) xStep, void function(sqlite3_context*) xFinal, void function(void*) xDestroy); - * CAPI3REF: Create Or Redefine SQL Functions
- Use native byte order
- sqlite3_create_function only
- sqlite3_create_collation only
- * CAPI3REF: Function Flags
- * CAPI3REF: Deprecated Functions
- nothrow const(void)* sqlite3_value_blob(sqlite3_value*);
nothrow int sqlite3_value_bytes(sqlite3_value*);
nothrow int sqlite3_value_bytes16(sqlite3_value*);
nothrow double sqlite3_value_double(sqlite3_value*);
nothrow int sqlite3_value_int(sqlite3_value*);
nothrow sqlite3_int64 sqlite3_value_int64(sqlite3_value*);
nothrow const(char)* sqlite3_value_text(sqlite3_value*);
nothrow const(void)* sqlite3_value_text16(sqlite3_value*);
nothrow const(void)* sqlite3_value_text16le(sqlite3_value*);
nothrow const(void)* sqlite3_value_text16be(sqlite3_value*);
nothrow int sqlite3_value_type(sqlite3_value*);
nothrow int sqlite3_value_numeric_type(sqlite3_value*); - * CAPI3REF: Obtaining SQL Function Parameter Values
- * CAPI3REF: Obtain Aggregate Function Context
- * CAPI3REF: User Data For Functions
- * CAPI3REF: Database Connection For Functions
- * CAPI3REF: Function Auxiliary Data
- * CAPI3REF: Constants Defining Special Destructor Behavior
- nothrow void sqlite3_result_blob(sqlite3_context*, const void*, int, void function(void*));
nothrow void sqlite3_result_blob64(sqlite3_context*, const void*, sqlite3_uint64, void function(void*));
nothrow void sqlite3_result_double(sqlite3_context*, double);
nothrow void sqlite3_result_error(sqlite3_context*, const char*, int);
nothrow void sqlite3_result_error16(sqlite3_context*, const void*, int);
nothrow void sqlite3_result_error_toobig(sqlite3_context*);
nothrow void sqlite3_result_error_nomem(sqlite3_context*);
nothrow void sqlite3_result_error_code(sqlite3_context*, int);
nothrow void sqlite3_result_int(sqlite3_context*, int);
nothrow void sqlite3_result_int64(sqlite3_context*, sqlite3_int64);
nothrow void sqlite3_result_null(sqlite3_context*);
nothrow void sqlite3_result_text(sqlite3_context*, const char*, int, void function(void*));
nothrow void sqlite3_result_text64(sqlite3_context*, const char*, sqlite3_uint64, void function(void*), ubyte encoding);
nothrow void sqlite3_result_text16(sqlite3_context*, const void*, int, void function(void*));
nothrow void sqlite3_result_text16le(sqlite3_context*, const void*, int, void function(void*));
nothrow void sqlite3_result_text16be(sqlite3_context*, const void*, int, void function(void*));
nothrow void sqlite3_result_value(sqlite3_context*, sqlite3_value*);
nothrow void sqlite3_result_zeroblob(sqlite3_context*, int n);
nothrow int sqlite3_result_zeroblob64(sqlite3_context*, sqlite3_uint64 n); - * CAPI3REF: Setting The Result Of An SQL Function
- nothrow int sqlite3_create_collation(sqlite3*, const(char)* zName, int eTextRep, void* pArg, int function(void*, int, const void*, int, const void*) xCompare);
nothrow int sqlite3_create_collation_v2(sqlite3*, const(char)* zName, int eTextRep, void* pArg, int function(void*, int, const void*, int, const void*) xCompare, void function(void*) xDestroy);
nothrow int sqlite3_create_collation16(sqlite3*, const(void)* zName, int eTextRep, void* pArg, int function(void*, int, const void*, int, const void*) xCompare); - * CAPI3REF: Define New Collating Sequences
- * CAPI3REF: Collation Needed Callbacks
- * Change the key on an open database. If the current database is not * encrypted, this routine will encrypt it. If pNew==0 or nNew==0, the * database is decrypted. * * The code to implement this API is not available in the public release * of SQLite.
- * Specify the activation key for a SEE database. Unless * activated, none of the SEE routines will work.
- * Specify the activation key for a CEROD database. Unless * activated, none of the CEROD routines will work.
- * CAPI3REF: Suspend Execution For A Short Time
- * CAPI3REF: Name Of The Folder Holding Temporary Files
- * CAPI3REF: Name Of The Folder Holding Database Files
- * CAPI3REF: Test For Auto-Commit Mode
- * CAPI3REF: Find The Database Handle Of A Prepared Statement
- * CAPI3REF: Return The Filename For A Database Connection
- * CAPI3REF: Determine if a database is read-only
- * CAPI3REF: Commit And Rollback Notification Callbacks
- * CAPI3REF: Data Change Notification Callbacks
- * CAPI3REF: Enable Or Disable Shared Pager Cache
- * CAPI3REF: Attempt To Free Heap Memory
- * CAPI3REF: Free Memory Used By A Database Connection
- * CAPI3REF: Deprecated Soft Heap Limit Interface
- * CAPI3REF: Extract Metadata About A Column Of A Table
- * CAPI3REF: Load An Extension
- * CAPI3REF: Enable Or Disable Extension Loading
- * CAPI3REF: Automatically Load Statically Linked Extensions
- * CAPI3REF: Cancel Automatic Extension Loading
- * CAPI3REF: Reset Automatic Extension Loading
- * The interface to the virtual-table mechanism is currently considered * to be experimental. The interface might change in incompatible ways. * If this is a problem for you, do not use the interface at this time. * * When the virtual-table mechanism stabilizes, we will declare the * interface fixed, support it indefinitely, and remove this comment.* CAPI3REF: Virtual Table Object
- * CAPI3REF: Virtual Table Indexing Information
- Number of entries in aConstraint
- Table of WHERE clause constraints
- Number of terms in the ORDER BY clause
- The ORDER BY clause
- Number used to identify the index
- String, possibly obtained from sqlite3_malloc
- Free idxStr using sqlite3_free() if true
- True if output is already ordered
- Estimated cost of using this index
- * CAPI3REF: Register A Virtual Table Implementation
- * CAPI3REF: Virtual Table Instance Object
- The module for this virtual table
- NO LONGER USED
- Error message from sqlite3_mprintf()
- * CAPI3REF: Virtual Table Cursor Object
- Virtual table of this cursor
- * CAPI3REF: Declare The Schema Of A Virtual Table
- * CAPI3REF: Overload A Function For A Virtual Table
- * The interface to the virtual-table mechanism defined above (back up * to a comment remarkably similar to this one) is currently considered * to be experimental. The interface might change in incompatible ways. * If this is a problem for you, do not use the interface at this time. * * When the virtual-table mechanism stabilizes, we will declare the * interface fixed, support it indefinitely, and remove this comment.
- * CAPI3REF: Open A BLOB For Incremental I/O
- * CAPI3REF: Move a BLOB Handle to a New Row
- * CAPI3REF: Close A BLOB Handle
- * CAPI3REF: Return The Size Of An Open BLOB
- * CAPI3REF: Read Data From A BLOB Incrementally
- * CAPI3REF: Write Data Into A BLOB Incrementally
- * CAPI3REF: Virtual File System Objects
- * CAPI3REF: Mutexes
- * CAPI3REF: Mutex Methods Object
- * CAPI3REF: Mutex Verification Routines
- sqlite3_malloc()
- NOT USED
- sqlite3BtreeOpen()
- sqlite3_random()
- lru page list
- NOT USED
- sqlite3PageMalloc()
- For use by application
- For use by application
- For use by application
- For use by built-in VFS
- For use by extension VFS
- For use by application VFS
- * CAPI3REF: Retrieve the mutex for a database connection
- * CAPI3REF: Low-Level Control Of Database Files
- * CAPI3REF: Testing Interface
- * CAPI3REF: SQLite Runtime Status
- * CAPI3REF: Database Connection Status
- Largest defined DBSTATUS
- * CAPI3REF: Prepared Statement Status
- * CAPI3REF: Custom Page Cache Object
- * CAPI3REF: Custom Page Cache Object
- * CAPI3REF: Application Defined Page Cache.
- * CAPI3REF: Online Backup Object
- nothrow sqlite3_backup* sqlite3_backup_init(sqlite3* pDest, const(char)* zDestName, sqlite3* pSource, const(char)* zSourceName);
nothrow int sqlite3_backup_step(sqlite3_backup* p, int nPage);
nothrow int sqlite3_backup_finish(sqlite3_backup* p);
nothrow int sqlite3_backup_remaining(sqlite3_backup* p);
nothrow int sqlite3_backup_pagecount(sqlite3_backup* p); - * CAPI3REF: Online Backup API.
- * CAPI3REF: Unlock Notification
- * CAPI3REF: String Comparison
- * CAPI3REF: Error Logging Interface
- * CAPI3REF: Write-Ahead Log Commit Hook
- * CAPI3REF: Configure an auto-checkpoint
- * CAPI3REF: Checkpoint a database
- * CAPI3REF: Checkpoint a database
- * CAPI3REF: Virtual Table Configuration Options
- * Register a geometry callback named zGeom that can be used as part of an * R-Tree geometry query as follows: * * SELECT ... FROM <rtree> WHERE <rtree col> MATCH zGeom(... params ...)
- * A pointer to a structure of the following type is passed as the first * argument to callbacks registered using rtree_geometry_callback().
- Size of array aParam[]
- Parameters passed to SQL geom function
- Callback implementation user data
- Called by SQLite to clean up pUser
- struct Fts5Context;
alias fts5_extension_function = extern (C) void function(const(Fts5ExtensionApi*) pApi, Fts5Context* pFts, sqlite3_context* pCtx, int nVal, sqlite3_value** apVal) nothrow;
struct Fts5PhraseIter;
struct Fts5ExtensionApi;
struct Fts5Tokenizer;
enum int FTS5_TOKENIZE_QUERY;
enum int FTS5_TOKENIZE_PREFIX;
enum int FTS5_TOKENIZE_DOCUMENT;
enum int FTS5_TOKENIZE_AUX;
enum int FTS5_TOKEN_COLOCATED;
struct fts5_api; - * Interfaces to extend FTS5.
Copyright © 1999-2017 by Digital Mars ®, All Rights Reserved | Page generated by
Ddoc on (no date time)