Nav

Top
Examples 0
See Also 0
Notes0

Data Persistence

All modules

Connection

sqlite3

class

SQLite database connection object.

Changed in 3.13

3.13: A ResourceWarning is emitted if close() is not called before a Connection object is deleted.

Members of Connection

a

autocommit: This attribute controls PEP 249-compliant transaction behaviour.

b

backup: Makes a backup of the database.
blobopen: Open and return a BLOB object.

c

close: Close the database connection.
commit: Commit any pending transaction to the database.
create_aggregate: Creates a new aggregate.
create_collation: Creates a collation function.
create_function: Creates a new function.
create_window_function: Creates or redefines an aggregate window function.
cursor: Return a cursor for the connection.

d

deserialize: Load a serialized database.

e

enable_load_extension: Enable dynamic loading of SQLite extension modules.
execute: Executes an SQL statement.
executemany: Repeatedly executes an SQL statement.
executescript: Executes multiple SQL statements at once.

g

getconfig: Query a boolean connection configuration option.
getlimit: Get connection run-time limits.

i

in_transaction: This read-only attribute corresponds to the low-level SQLite autocommit mode.
interrupt: Abort any pending database operation.
isolation_level: Controls the legacy transaction handling mode of sqlite3.
iterdump: Returns iterator to the dump of the database in an SQL text format.

l

load_extension: Load SQLite extension module.

r

rollback: Roll back to the start of any pending transaction.
row_factory: The initial row_factory for Cursor objects created from this connection.

s

serialize: Serialize a database into a byte string.
set_authorizer: Set authorizer callback.
set_progress_handler: Set progress handler callback.
set_trace_callback: Set a trace callback called for each SQL statement (passed as unicode).
setconfig: Set a boolean connection configuration option.
setlimit: Set connection run-time limits.

t

text_factory: A callable that accepts a bytes parameter and returns a text representation of it.
total_changes: Return the total number of database rows that have been modified, inserted, or deleted since the database connection was opened.

PyDocs

Nav

Data Persistence

Nav

Data Persistence

All modules

Connection

sqlite3

Members of Connection

a

b

c

d

e

g

i

l

r

s

t

0 Examples

See Also

0 Notes