trac.db.sqlite_backend

class trac.db.sqlite_backend.SQLiteConnection(path, log=None, params={})

Bases: trac.db.api.ConnectionBase, trac.db.util.ConnectionWrapper

Connection wrapper for SQLite.

class trac.db.sqlite_backend.SQLiteConnector

Bases: trac.core.Component

Database connector for SQLite.

Database URLs should be of the form: {{{ sqlite:path/to/trac.db }}}

alter_column_types(table, columns)

Yield SQL statements altering the type of one or more columns of a table.

Type changes are specified as a columns dict mapping column names to (from, to) SQL type tuples.

backup(dest_file)

Simple SQLite-specific backup of the database.

Parameters:dest_file – Destination file basename

extensions

Paths to [https://sqlite.org/loadext.html sqlite extensions]. The paths may be absolute or relative to the Trac environment.