dblite.engines.sqlite Namespace Reference

Classes
class	Database
	Convenience wrapper around sqlite3.Connection. More...
class	Queryable
class	Transaction
	Transaction context manager, breakable by raising Rollback. More...

Functions
def	autodetect (opts)
	Returns true if input is recognizable as SQLite connection options. More...
def	quote (value, force=False)
	Returns identifier in quotes and proper-escaped for queries, if value needs quoting (has non-alphanumerics, starts with number, or is reserved). More...
def	register_adapter (transformer, typeclasses)
	Registers function to auto-adapt given Python types to SQLite types in query parameters. More...
def	register_converter (transformer, typenames)
	Registers function to auto-convert given SQLite types to Python types in query results. More...
def	register_row_factory (row_factory)
	Registers custom row factory, as or `None` to reset to default. More...

Variables
list	RESERVED_KEYWORDS
	SQLite reserved keywords, needing quotes in SQL queries. More...

Function Documentation

autodetect()

def dblite.engines.sqlite.autodetect

(

opts

)

Returns true if input is recognizable as SQLite connection options.

Parameters

opts	expected as a path string or path-like object

Definition at line 574 of file sqlite.py.

quote()

def dblite.engines.sqlite.quote	(		value,
			force = False
	)

Returns identifier in quotes and proper-escaped for queries, if value needs quoting (has non-alphanumerics, starts with number, or is reserved).

Parameters

value	the value to quote, returned as-is if not string
force	whether to quote value even if not required

Definition at line 590 of file sqlite.py.

register_adapter()

def dblite.engines.sqlite.register_adapter	(		transformer,
			typeclasses
	)

Registers function to auto-adapt given Python types to SQLite types in query parameters.

Definition at line 600 of file sqlite.py.

register_converter()

def dblite.engines.sqlite.register_converter	(		transformer,
			typenames
	)

Registers function to auto-convert given SQLite types to Python types in query results.

Definition at line 605 of file sqlite.py.

register_row_factory()

def dblite.engines.sqlite.register_row_factory

(

row_factory

)

Registers custom row factory, as or `None` to reset to default.

Definition at line 610 of file sqlite.py.

Variable Documentation

RESERVED_KEYWORDS

list dblite.engines.sqlite.RESERVED_KEYWORDS

Initial value:

=  [
    "ACTION", "ADD", "AFTER", "ALL", "ALTER", "ALWAYS", "ANALYZE", "AND", "AS", "ASC", "ATTACH",
    "AUTOINCREMENT", "BEFORE", "BEGIN", "BETWEEN", "BY", "CASE", "CAST", "CHECK", "COLLATE",
    "COMMIT", "CONSTRAINT", "CREATE", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP",
    "DEFAULT", "DEFERRABLE", "DEFERRED", "DELETE", "DESC", "DETACH", "DISTINCT", "DO", "DROP",
    "EACH", "ELSE", "END", "ESCAPE", "EXCEPT", "EXISTS", "EXPLAIN", "FOR", "FOREIGN", "FROM",
    "GENERATED", "GROUP", "HAVING", "IF", "IMMEDIATE", "IN", "INDEX", "INITIALLY", "INSERT",
    "INSTEAD", "INTERSECT", "INTO", "IS", "ISNULL", "JOIN", "KEY", "LIKE", "LIMIT", "MATCH",
    "NO", "NOT", "NOTHING", "NOTNULL", "NULL", "OF", "ON", "OR", "ORDER", "OVER", "PRAGMA",
    "PRECEDING", "PRIMARY", "RAISE", "RECURSIVE", "REFERENCES", "REGEXP", "REINDEX", "RELEASE",
    "RENAME", "REPLACE", "RESTRICT", "ROLLBACK", "SAVEPOINT", "SELECT", "SET", "TABLE",
    "TEMPORARY", "THEN", "TIES", "TO", "TRANSACTION", "TRIGGER", "UNBOUNDED", "UNION",
    "UNIQUE", "UPDATE", "USING", "VACUUM", "VALUES", "VIEW", "WHEN", "WHERE", "WITHOUT"
]

SQLite reserved keywords, needing quotes in SQL queries.

Definition at line 31 of file sqlite.py.