SQLAlchemy 0.3 Documentation

Version: 0.3.5 Last Updated: 03/18/07 18:39:07

module sqlalchemy.databases.sqlite

Module Functions

def descriptor()
back to section top

class DateTimeMixin(object)

def convert_bind_param(self, value, dialect)
back to section top

class PassiveDefault(DefaultGenerator)

A default that takes effect on the database side.

def __init__(self, arg, **kwargs)
def accept_visitor(self, visitor)
back to section top

class SLBinary(Binary)

def get_col_spec(self)
back to section top

class SLBoolean(Boolean)

def convert_bind_param(self, value, dialect)
def convert_result_value(self, value, dialect)
def get_col_spec(self)
back to section top

class SLChar(CHAR)

def get_col_spec(self)
back to section top

class SLDate(DateTimeMixin,Date)

def convert_result_value(self, value, dialect)
def get_col_spec(self)
back to section top

class SLDateTime(DateTimeMixin,DateTime)

def convert_result_value(self, value, dialect)
def get_col_spec(self)
back to section top

class SLInteger(Integer)

def get_col_spec(self)
back to section top

class SLNumeric(Numeric)

def get_col_spec(self)
back to section top

class SLSmallInteger(SmallInteger)

def get_col_spec(self)
back to section top

class SLString(String)

def get_col_spec(self)
back to section top

class SLText(TEXT)

def get_col_spec(self)
back to section top

class SLTime(DateTimeMixin,Time)

def convert_result_value(self, value, dialect)
def get_col_spec(self)
back to section top

class SQLiteCompiler(ANSICompiler)

def binary_operator_string(self, binary)
def for_update_clause(self, select)
def limit_clause(self, select)
def visit_cast(self, cast)
back to section top

class SQLiteDialect(ANSIDialect)

def __init__(self, **kwargs)
def compiler(self, statement, bindparams, **kwargs)
def create_connect_args(self, url)
def create_execution_context(self)
def dbapi(self)
def has_table(self, connection, table_name, schema=None)
def last_inserted_ids(self)
def oid_column_name(self, column)
def preparer(self)
def reflecttable(self, connection, table)
def schemadropper(self, *args, **kwargs)
def schemagenerator(self, *args, **kwargs)
def type_descriptor(self, typeobj)
back to section top

class SQLiteDialect(ANSIDialect)

def __init__(self, **kwargs)
def compiler(self, statement, bindparams, **kwargs)
def create_connect_args(self, url)
def create_execution_context(self)
def dbapi(self)
def has_table(self, connection, table_name, schema=None)
def last_inserted_ids(self)
def oid_column_name(self, column)
def preparer(self)
def reflecttable(self, connection, table)
def schemadropper(self, *args, **kwargs)
def schemagenerator(self, *args, **kwargs)
def type_descriptor(self, typeobj)
back to section top

class SQLiteExecutionContext(DefaultExecutionContext)

def post_exec(self, engine, proxy, compiled, parameters, **kwargs)
back to section top

class SQLiteIdentifierPreparer(ANSIIdentifierPreparer)

def __init__(self, dialect)
back to section top

class SQLiteSchemaDropper(ANSISchemaDropper)

def supports_alter(self)
back to section top

class SQLiteSchemaGenerator(ANSISchemaGenerator)

def get_column_specification(self, column, **kwargs)
def supports_alter(self)
back to section top

class SingletonThreadPool(Pool)

Maintain one connection per each thread, never moving a connection to a thread other than the one which it was created in.

This is used for SQLite, which both does not handle multithreading by default, and also requires a singleton connection if a :memory: database is being used.

Options are the same as those of Pool, as well as:

pool_size : 5
The number of threads in which to maintain connections at once.
def __init__(self, creator, pool_size=5, **params)
def cleanup(self)
def dispose(self)
def dispose_local(self)
def do_get(self)
def do_return_conn(self, conn)
def status(self)
back to section top