SQLITE_DBCONFIG_ENABLE_TRIGGER ¶ sqlite3. SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ¶ sqlite3. SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER ¶ sqlite3.

Today, it carries no meaning or practical value. Package, a third-party library which used to upstream changes to The mappings from SQLite threading modes to DB-API 2.0 threadsafety levelsĭeprecated since version 3.12, will be removed in version 3.14: This constant used to reflect the version number of the pysqlite Serialized: In serialized mode, SQLite can be safely used by Threads provided that no single database connection is used Multi-thread: In this mode, SQLite can be safely used by multiple Unsafe to use in more than a single thread at once. Single-thread: In this mode, all mutexes are disabled and SQLite is Underlying SQLite library is compiled with. Integer constant required by the DB-API 2.0, stating the level of thread Version number of the runtime SQLite library as a tuple of Version number of the runtime SQLite library as a string. The named DB-API parameter style is also supported.

The type name must be wrapped in square brackets ( ). Using the type name, parsed from the query column name, Pass this flag value to the detect_types parameter ofĬonnect() to look up a converter function by See Transaction control via the isolation_level attribute for more information. Old style (pre-Python 3.12) transaction control behaviour. Set autocommit to this constant to select Note: typename and the name of the type in your query are matchedĬase-insensitively. It is passed a bytes object and should return an object of theĬonnect() for information regarding how type detection works. The converter is invoked for all SQLite values of type typename Typename into a Python object of a specific type. Register the converter callable to convert SQLite objects of type register_converter ( typename, converter, / ) ¶ The adapter is called with a Python object of type type as its sole Register an adapter callable to adapt the Python type type Raises an auditing event nnect/handle with argument connection_handle.Įrrors in user-defined function callbacks are logged as unraisable exceptions. Raises an auditing event nnect with argument database. The default will change to False in a future Python release. Transaction control via the autocommit attribute for more information. The query string allows passing parameters to SQLite,Įnabling various How to work with SQLite URIs.Īutocommit ( bool) – Control PEP 249 transaction handling behaviour. Uri ( bool) – If set to True, database is interpreted as aĪnd the path can be relative or absolute. Should internally cache for this connection, to avoid parsing overhead. Write operations may need to be serialized by the userįactory ( Connection) – A custom subclass of Connection to create the connection with,Ĭached_statements ( int) – The number of statements that sqlite3 If False, the connection may be accessed in multiple threads If the database connection is used by a thread LEGACY_TRANSACTION_CONTROL (the default).Ĭheck_same_thread ( bool) – If True (default), ProgrammingError will be raised Or None to disable opening transactions implicitly.

Transaction control via the isolation_level attribute for more information.Ĭan be 'DEFERRED' (default), 'EXCLUSIVE' or 'IMMEDIATE' Isolation_level ( str | None) – Control legacy transaction handling behaviour. Types cannot be detected for generated fields (for example max(data)),Įven when the detect_types parameter is set str will beīy default ( 0), type detection is disabled. Set it to any combination (using |, bitwise or) ofĬolumn names takes precedence over declared types if both flags are set. Using the converters registered with register_converter(). That table will be locked until the transaction is committed.ĭetect_types ( int) – Control whether and how data types notĪre looked up to be converted to Python types, If another connection opens a transaction to modify a table, Timeout ( float) – How many seconds the connection should wait before raisingĪn OperationalError when a table is locked. You can pass ':memory:' to create an SQLite database existing only Parameters :ĭatabase ( path-like object) – The path to the database file to be opened. connect ( database, timeout = 5.0, detect_types = 0, isolation_level = 'DEFERRED', check_same_thread = True, factory = sqlite3.Connection, cached_statements = 128, uri = False, *, autocommit = sqlite3.LEGACY_TRANSACTION_CONTROL ) ¶ How to use the connection context managerĮxplanation for in-depth background on transaction control. How to convert SQLite values to custom Python types How to adapt custom Python types to SQLite values How to use placeholders to bind values in SQL queries

Get sqlite mac