Index

_

__call__() (DataClassRowFactory method) (TypesConverterCursorFactory method) __enter__() (Backup method) (Blob method) (Connection method)

__exit__() (Backup method) (Blob method) (Connection method) __iter__() (Cursor method) __next__() (Cursor method)

A

AbortError Accessing results by column name (example code) action (QueryAction attribute) action_name (QueryAction attribute) actions (QueryDetails attribute) adapt_value() (TypesConverterCursorFactory method) addr (VDBEInstruction attribute) AggregateFactory (class in apsw) AggregateFinal (class in apsw) AggregateStep (class in apsw) AggregateT (class in apsw)

apsw module apsw.ext module apsw.shell module apswversion() (in module apsw) AuthError Authorizer (class in apsw) authorizer (Connection attribute) Authorizer (control what SQL can do) (example code) autovacuum_pages() (Connection method)

B

Backup (class in apsw) Backup an open database (example code) backup() (Connection method) Begin() (VTTable method) BestIndex() (VTTable method) Bindings (class in apsw) Bindings (dict) (example code)

bindings (QueryDetails attribute) Bindings (sequence) (example code) BindingsError Blob (class in apsw) Blob I/O (example code) blobopen() (Connection method) BusyError

C

cache_stats() (Connection method) CantOpenError changes() (Connection method) Checking APSW and SQLite versions (example code) Cleanup (example code) close() (Backup method) (Blob method) (Connection method) (Cursor method) Close() (VTCursor method) cmdloop() (Shell method) collationneeded() (Connection method) Column() (VTCursor method) column_name (QueryAction attribute) comment (VDBEInstruction attribute) Commit hook (example code) Commit() (VTTable method) CommitHook (class in apsw) compile_options (in module apsw) complete() (in module apsw) (Shell method)

complete_command() (Shell method) complete_sql() (Shell method) config() (Connection method) (in module apsw) Connect() (VTModule method) Connection (class in apsw) connection (Cursor attribute) connection_hooks (in module apsw) ConnectionClosedError ConnectionNotClosedError ConstraintError convert_value() (TypesConverterCursorFactory method) CorruptError Create() (VTModule method) createaggregatefunction() (Connection method) createcollation() (Connection method) createmodule() (Connection method) createscalarfunction() (Connection method) Cursor (class in apsw) cursor() (Connection method) cursor_factory (Connection attribute) CursorClosedError

D

database_name (QueryAction attribute) DataClassRowFactory (class in apsw.ext) db (Shell property) db_filename() (Connection method) db_names() (Connection method) Defining aggregate functions (example code) Defining collations (sorting) (example code) Defining your own functions (example code) description (Cursor attribute) (QueryDetails attribute)

description_full (Cursor attribute) (QueryDetails attribute) deserialize() (Connection method) Destroy() (VTTable method) detail (QueryPlan attribute) Disconnect() (VTTable method) display_timing() (Shell method) done (Backup attribute)

E

EmptyError enableloadextension() (Connection method) enablesharedcache() (in module apsw) Eof() (VTCursor method) Error excepthook() (VFS method) (VFSFile method) exceptionfor() (in module apsw) exectrace (Connection attribute) (Cursor attribute) ExecTraceAbort ExecTracer (class in apsw) execute() (Connection method) (Cursor method) (TypesConverterCursorFactory.TypeConverterCursor method)

executemany (example code) executemany() (Connection method) (Cursor method) (TypesConverterCursorFactory.TypeConverterCursor method) Executing SQL (example code) ExecutionCompleteError expanded_sql (Cursor attribute) (QueryDetails attribute) explain (QueryDetails attribute) extendedresult (Error attribute) ExtensionLoadingError

F

fetchall() (Cursor method) fetchone() (Cursor method) file_name (QueryAction attribute) filecontrol() (Connection method) filename (Connection attribute) filename() (URIFilename method) Filter() (VTCursor method) FindFunction() (VTTable method)

finish() (Backup method) first_query (QueryDetails attribute) fixup_backslashes() (Shell method) fork_checker() (in module apsw) ForkingViolationError format_sql_value() (in module apsw) FormatError FullError function_name (QueryAction attribute)

G

get_dataclass() (DataClassRowFactory method) get_resource_usage() (Shell method) get_type() (DataClassRowFactory method) getautocommit() (Connection method) getcompleteline() (Shell method) getconnection() (Cursor method)

getdescription() (Cursor method) getexectrace() (Connection method) (Cursor method) getline() (Shell method) getrowtrace() (Connection method) (Cursor method)

H

handle_exception() (Shell method)

handle_interrupt() (Shell method)

I

in_transaction (Connection attribute) IncompleteExecutionError initialize() (in module apsw) InternalError interrupt() (Connection method)

InterruptError IOError is_explain (Cursor attribute) (QueryDetails attribute) is_readonly (Cursor attribute) (QueryDetails attribute)

K

keywords (in module apsw)

L

last_insert_rowid() (Connection method) length() (Blob method) (zeroblob method) limit() (Connection method)

Limits (example code) loadextension() (Connection method) LockedError log() (in module apsw)

M

main() (in module apsw.shell) mapping_access (in module apsw) mapping_authorizer_function (in module apsw) mapping_authorizer_return (in module apsw) mapping_bestindex_constraints (in module apsw) mapping_config (in module apsw) mapping_conflict_resolution_modes (in module apsw) mapping_db_config (in module apsw) mapping_db_status (in module apsw) mapping_device_characteristics (in module apsw) mapping_extended_result_codes (in module apsw) mapping_file_control (in module apsw) mapping_limits (in module apsw) mapping_locking_level (in module apsw) mapping_open_flags (in module apsw) mapping_prepare_flags (in module apsw)

mapping_result_codes (in module apsw) mapping_status (in module apsw) mapping_sync (in module apsw) mapping_txn_state (in module apsw) mapping_virtual_table_configuration_options (in module apsw) mapping_virtual_table_scan_flags (in module apsw) mapping_wal_checkpoint (in module apsw) mapping_xshmlock_flags (in module apsw) memoryhighwater() (in module apsw) memoryused() (in module apsw) MismatchError MisuseError module apsw apsw.ext apsw.shell module_name (QueryAction attribute)

N

Next() (VTCursor method) NoLFSError

NoMemError NotADBError NotFoundError

O

opcode (VDBEInstruction attribute) Open() (VTTable method) open_flags (Connection attribute)

open_vfs (Connection attribute) Opening the database (example code) operation (QueryAction attribute) overloadfunction() (Connection method)

P

p1 (VDBEInstruction attribute) p2 (VDBEInstruction attribute) p3 (VDBEInstruction attribute) p4 (VDBEInstruction attribute) p5 (VDBEInstruction attribute) pagecount (Backup attribute) PermissionsError pop_input() (Shell method) pop_output() (Shell method) pragma_name (QueryAction attribute) pragma_value (QueryAction attribute) process_args() (Shell method)

process_command() (Shell method) process_complete_line() (Shell method) process_sql() (Shell method) process_unknown_args() (Shell method) Progress handler (example code) ProtocolError push_input() (Shell method) push_output() (Shell method) Python Enhancement Proposals PEP 0343, [1], [2], [3] PEP 249, [1] PEP 370, [1]

Q

query (QueryDetails attribute) Query details (example code) query_info() (in module apsw.ext) query_plan (QueryDetails attribute)

query_remaining (QueryDetails attribute) QueryAction (class in apsw.ext) QueryDetails (class in apsw.ext) QueryPlan (class in apsw.ext)

R

randomness() (in module apsw) RangeError read() (Blob method) readinto() (Blob method) readonly() (Connection method) ReadOnlyError register_adapter() (TypesConverterCursorFactory method) register_converter() (TypesConverterCursorFactory method) releasememory() (in module apsw)

remaining (Backup attribute) Rename() (VTTable method) reopen() (Blob method) result (Error attribute) Rollback() (VTTable method) Rowid() (VTCursor method) rowtrace (Connection attribute) (Cursor attribute) RowTracer (class in apsw)

S

ScalarProtocol (class in apsw) SchemaChangeError seek() (Blob method) serialize() (Connection method) set_encoding() (Shell method) set_last_insert_rowid() (Connection method) setauthorizer() (Connection method) setbusyhandler() (Connection method) setbusytimeout() (Connection method) setcommithook() (Connection method) setexectrace() (Connection method) (Cursor method) setprofile() (Connection method) setprogresshandler() (Connection method) setrollbackhook() (Connection method) setrowtrace() (Connection method) (Cursor method) setupdatehook() (Connection method) setwalhook() (Connection method) Shell (class in apsw.shell) (example code) Shell.Error shutdown() (in module apsw) softheaplimit() (in module apsw) SQLError sqlite3_autovacuum_pages sqlite3_backup_finish sqlite3_backup_init sqlite3_backup_pagecount sqlite3_backup_remaining sqlite3_backup_step sqlite3_bind_blob sqlite3_bind_double sqlite3_bind_int64 sqlite3_bind_null sqlite3_bind_text sqlite3_bind_zeroblob sqlite3_blob_bytes sqlite3_blob_close sqlite3_blob_open sqlite3_blob_read, [1] sqlite3_blob_reopen sqlite3_blob_write sqlite3_busy_handler sqlite3_busy_timeout sqlite3_changes64 sqlite3_close sqlite3_collation_needed sqlite3_column_database_name sqlite3_column_decltype, [1] sqlite3_column_name, [1] sqlite3_column_origin_name sqlite3_column_table_name sqlite3_commit_hook sqlite3_compileoption_get sqlite3_complete sqlite3_config sqlite3_create_collation_v2 sqlite3_create_function_v2, [1] sqlite3_create_module_v2 sqlite3_db_config sqlite3_db_filename, [1]

sqlite3_db_name sqlite3_db_readonly sqlite3_db_status sqlite3_deserialize sqlite3_enable_load_extension sqlite3_enable_shared_cache sqlite3_expanded_sql sqlite3_file_control sqlite3_get_autocommit, [1] sqlite3_initialize sqlite3_interrupt sqlite3_keyword_count sqlite3_keyword_name sqlite3_last_insert_rowid sqlite3_libversion sqlite3_limit sqlite3_load_extension sqlite3_log sqlite3_memory_highwater sqlite3_memory_used sqlite3_open_v2 sqlite3_overload_function sqlite3_prepare_v3 sqlite3_profile sqlite3_progress_handler sqlite3_randomness sqlite3_release_memory sqlite3_rollback_hook sqlite3_serialize sqlite3_set_authorizer sqlite3_set_last_insert_rowid sqlite3_shutdown sqlite3_soft_heap_limit64 sqlite3_sourceid sqlite3_sourceid() (in module apsw) sqlite3_status64 sqlite3_step sqlite3_stmt_isexplain sqlite3_stmt_readonly sqlite3_total_changes64 sqlite3_txn_state sqlite3_update_hook sqlite3_uri_boolean sqlite3_uri_int64 sqlite3_uri_parameter sqlite3_vfs_find sqlite3_vfs_register sqlite3_vfs_unregister sqlite3_wal_autocheckpoint sqlite3_wal_checkpoint_v2 sqlite3_wal_hook sqlite3pointer() (Connection method) SQLITE_VERSION_NUMBER (in module apsw) sqlitelibversion() (in module apsw) SQLiteTypeAdapter (class in apsw.ext) SQLiteValue (class in apsw) SQLiteValues (class in apsw) Statistics (example code) status() (Connection method) (in module apsw) step() (Backup method) sub (QueryPlan attribute) Sync() (VTTable method)

T

table_name (QueryAction attribute) tell() (Blob method) ThreadingViolationError to_sqlite_value() (SQLiteTypeAdapter method) TooBigError totalchanges() (Connection method) Tracing execution (example code) Tracing returned rows (example code)

Transactions (example code) trigger_name (QueryAction attribute) trigger_or_view (QueryAction attribute) txn_state() (Connection method) Type conversion into/out of database (example code) TypesConverterCursorFactory (class in apsw.ext) TypesConverterCursorFactory.DictAdapter (class in apsw.ext) TypesConverterCursorFactory.TypeConverterCursor (class in apsw.ext)

U

unregister() (VFS method) Update hook (example code) UpdateChangeRow() (VTTable method) UpdateDeleteRow() (VTTable method) UpdateInsertRow() (VTTable method) uri_boolean() (URIFilename method)

uri_int() (URIFilename method) uri_parameter() (URIFilename method) URIFilename (class in apsw) usage() (Shell method) Using different types (example code) using_amalgamation (in module apsw)

V

VDBEInstruction (class in apsw.ext) VFS (class in apsw) VFS - Virtual File System (example code) VFSFile (class in apsw) VFSFileClosedError vfsnames() (in module apsw)

VFSNotImplementedError view_name (QueryAction attribute) Virtual tables (example code) VTCursor (class in apsw) VTModule (class in apsw) VTTable (class in apsw)

W

wal_autocheckpoint() (Connection method) wal_checkpoint() (Connection method) Why you use bindings to provide values (example code)

wrap_bindings() (TypesConverterCursorFactory method) wrap_sequence_bindings() (TypesConverterCursorFactory method) write() (Blob method) (Shell method)

X

xAccess() (VFS method) xCheckReservedLock() (VFSFile method) xClose() (VFSFile method) xCurrentTime() (VFS method) xDelete() (VFS method) xDeviceCharacteristics() (VFSFile method) xDlClose() (VFS method) xDlError() (VFS method) xDlOpen() (VFS method) xDlSym() (VFS method) xFileControl() (VFSFile method) xFileSize() (VFSFile method) xFullPathname() (VFS method)

xGetLastError() (VFS method) xGetSystemCall() (VFS method) xLock() (VFSFile method) xNextSystemCall() (VFS method) xOpen() (VFS method) xRandomness() (VFS method) xRead() (VFSFile method) xSectorSize() (VFSFile method) xSetSystemCall() (VFS method) xSleep() (VFS method) xSync() (VFSFile method) xTruncate() (VFSFile method) xUnlock() (VFSFile method) xWrite() (VFSFile method)

Z

zeroblob (class in apsw)