module documentation

SQLite backend for the sqlite3 module in the standard library.
Constant FORMAT​_QMARK​_REGEX Undocumented
Class ​Database​Wrapper No class docstring; 0/8 class variable, 2/13 methods documented
Class ​SQLite​Cursor​Wrapper Django uses "format" style placeholders, but pysqlite2 uses "qmark" style. This fixes it -- but note that if you want to use a literal "%s" in a query, you'll need to use "%%s".
Function ​_sqlite​_date​_trunc Undocumented
Function ​_sqlite​_datetime​_cast​_date Undocumented
Function ​_sqlite​_datetime​_cast​_time Undocumented
Function ​_sqlite​_datetime​_extract Undocumented
Function ​_sqlite​_datetime​_parse Undocumented
Function ​_sqlite​_datetime​_trunc Undocumented
Function ​_sqlite​_format​_dtdelta No summary
Function ​_sqlite​_lpad Undocumented
Function ​_sqlite​_prepare​_dtdelta​_param Undocumented
Function ​_sqlite​_regexp Undocumented
Function ​_sqlite​_rpad Undocumented
Function ​_sqlite​_time​_diff Undocumented
Function ​_sqlite​_time​_extract Undocumented
Function ​_sqlite​_time​_trunc Undocumented
Function ​_sqlite​_timestamp​_diff Undocumented
Function check​_sqlite​_version Undocumented
Function decoder Convert bytestrings from Python's sqlite3 interface to a regular string.
Function list​_aggregate Return an aggregate class that accumulates values in a list and applies the provided function to the data.
Function none​_guard No summary
FORMAT_QMARK_REGEX =

Undocumented

Value
_lazy_re_compile('(?<!%)%s')
def _sqlite_date_trunc(lookup_type, dt, tzname, conn_tzname):

Undocumented

def _sqlite_datetime_cast_date(dt, tzname, conn_tzname):

Undocumented

def _sqlite_datetime_cast_time(dt, tzname, conn_tzname):

Undocumented

def _sqlite_datetime_extract(lookup_type, dt, tzname=None, conn_tzname=None):

Undocumented

def _sqlite_datetime_parse(dt, tzname=None, conn_tzname=None):

Undocumented

def _sqlite_datetime_trunc(lookup_type, dt, tzname, conn_tzname):

Undocumented

@none_guard
def _sqlite_format_dtdelta(conn, lhs, rhs):
LHS and RHS can be either: - An integer number of microseconds - A string representing a datetime - A scalar value, e.g. float
@none_guard
def _sqlite_lpad(text, length, fill_text):

Undocumented

def _sqlite_prepare_dtdelta_param(conn, param):

Undocumented

@none_guard
def _sqlite_regexp(re_pattern, re_string):

Undocumented

@none_guard
def _sqlite_rpad(text, length, fill_text):

Undocumented

@none_guard
def _sqlite_time_diff(lhs, rhs):

Undocumented

def _sqlite_time_extract(lookup_type, dt):

Undocumented

def _sqlite_time_trunc(lookup_type, dt, tzname, conn_tzname):

Undocumented

@none_guard
def _sqlite_timestamp_diff(lhs, rhs):

Undocumented

def check_sqlite_version():

Undocumented

def decoder(conv_func):
Convert bytestrings from Python's sqlite3 interface to a regular string.
def list_aggregate(function):
Return an aggregate class that accumulates values in a list and applies the provided function to the data.
def none_guard(func):
Decorator that returns None if any of the arguments to the decorated function are None. Many SQL functions return NULL if any of their arguments are NULL. This decorator simplifies the implementation of this for the custom functions registered below.