SQLAlchemy 0.3 Documentation

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

module sqlalchemy.databases.firebird

Module Functions

def descriptor()
back to section top

class FBBinary(Binary)

def get_col_spec(self)
back to section top

class FBBoolean(Boolean)

def get_col_spec(self)
back to section top

class FBChar(CHAR)

def get_col_spec(self)
back to section top

class FBCompiler(ANSICompiler)

Firebird specific idiosincrasies

def limit_clause(self, select)

Already taken care of in the visit_select_precolumns method.

def visit_alias(self, alias)
def visit_function(self, func)
def visit_insert(self, insert)

Inserts are required to have the primary keys be explicitly present.

mapper will by default not put them in the insert statement to comply with autoincrement fields that require they not be present. So, put them all in for all primary key columns.

def visit_select_precolumns(self, select)

Called when building a SELECT statement, position is just before column list Firebird puts the limit and offset right after the SELECT...

back to section top

class FBDate(DateTime)

def get_col_spec(self)
back to section top

class FBDateTime(DateTime)

def get_col_spec(self)
back to section top

class FBDefaultRunner(ANSIDefaultRunner)

def exec_default_sql(self, default)
def visit_sequence(self, seq)
back to section top

class FBDialect(ANSIDialect)

def __init__(self, module=None, **params)
def compiler(self, statement, bindparams, **kwargs)
def connection(self)

Returns a managed DBAPI connection from this SQLEngine's connection pool.

def create_connect_args(self, url)
def create_execution_context(self)
def dbapi(self)
def defaultrunner(self, engine, proxy)
def do_commit(self, connection)
def do_execute(self, cursor, statement, parameters, **kwargs)
def do_rollback(self, connection)
def has_table(self, connection, table_name, schema=None)
def last_inserted_ids(self)
def preparer(self)
def reflecttable(self, connection, table)
def schemadropper(self, *args, **kwargs)
def schemagenerator(self, *args, **kwargs)
def supports_sane_rowcount(self)
def type_descriptor(self, typeobj)
back to section top

class FBDialect(ANSIDialect)

def __init__(self, module=None, **params)
def compiler(self, statement, bindparams, **kwargs)
def connection(self)

Returns a managed DBAPI connection from this SQLEngine's connection pool.

def create_connect_args(self, url)
def create_execution_context(self)
def dbapi(self)
def defaultrunner(self, engine, proxy)
def do_commit(self, connection)
def do_execute(self, cursor, statement, parameters, **kwargs)
def do_rollback(self, connection)
def has_table(self, connection, table_name, schema=None)
def last_inserted_ids(self)
def preparer(self)
def reflecttable(self, connection, table)
def schemadropper(self, *args, **kwargs)
def schemagenerator(self, *args, **kwargs)
def supports_sane_rowcount(self)
def type_descriptor(self, typeobj)
back to section top

class FBExecutionContext(DefaultExecutionContext)

def supports_sane_rowcount(self)
back to section top

class FBIdentifierPreparer(ANSIIdentifierPreparer)

def __init__(self, dialect)
back to section top

class FBInteger(Integer)

def get_col_spec(self)
back to section top

class FBNumeric(Numeric)

def get_col_spec(self)
back to section top

class FBSchemaDropper(ANSISchemaDropper)

def visit_sequence(self, sequence)
back to section top

class FBSchemaGenerator(ANSISchemaGenerator)

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

class FBSmallInteger(SmallInteger)

def get_col_spec(self)
back to section top

class FBString(String)

def get_col_spec(self)
back to section top

class FBText(TEXT)

def get_col_spec(self)