SQLAlchemy 0.3 Documentation

Version: 0.3.5 Last Updated: 03/18/07 18:39:07
Table of Contents
Up: Generated Documentation | Previous: module sqlalchemy.databases.sqlite | Next: module sqlalchemy.databases.mysql

module sqlalchemy.databases.postgres

module sqlalchemy.databases.postgres

Module Functions

def descriptor()
back to section top

class PG1Date(Date)

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

class PG1DateTime(DateTime)

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

class PG1Time(Time)

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

class PG2Date(Date)

def get_col_spec(self)
back to section top

class PG2DateTime(DateTime)

def get_col_spec(self)
back to section top

class PG2Time(Time)

def get_col_spec(self)
back to section top

class PGBigInteger(PGInteger)

def get_col_spec(self)
back to section top

class PGBinary(Binary)

def get_col_spec(self)
back to section top

class PGBoolean(Boolean)

def get_col_spec(self)
back to section top

class PGChar(CHAR)

def get_col_spec(self)
back to section top

class PGCompiler(ANSICompiler)

def binary_operator_string(self, binary)
def limit_clause(self, select)
def visit_insert_column(self, column, parameters)
def visit_insert_sequence(self, column, sequence, parameters)

this is the 'sequence' equivalent to ANSICompiler's 'visit_insert_column_default' which ensures that the column is present in the generated column list

def visit_select_precolumns(self, select)
back to section top

class PGDefaultRunner(ANSIDefaultRunner)

def get_column_default(self, column, isinsert=True)
def visit_sequence(self, seq)
back to section top

class PGDialect(ANSIDialect)

def __init__(self, module=None, use_oids=False, use_information_schema=False, server_side_cursors=False, **params)
def compiler(self, statement, bindparams, **kwargs)
def create_connect_args(self, url)
def create_cursor(self, connection)
def create_execution_context(self)
def dbapi(self)
def defaultrunner(self, engine, proxy)
def do_executemany(self, c, statement, parameters, context=None)

We need accurate rowcounts for updates, inserts and deletes.

psycopg2 is not nice enough to produce this correctly for an executemany, so we do our own executemany here.

def get_default_schema_name(self, connection)
def has_sequence(self, connection, sequence_name)
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 PGDialect(ANSIDialect)

def __init__(self, module=None, use_oids=False, use_information_schema=False, server_side_cursors=False, **params)
def compiler(self, statement, bindparams, **kwargs)
def create_connect_args(self, url)
def create_cursor(self, connection)
def create_execution_context(self)
def dbapi(self)
def defaultrunner(self, engine, proxy)
def do_executemany(self, c, statement, parameters, context=None)

We need accurate rowcounts for updates, inserts and deletes.

psycopg2 is not nice enough to produce this correctly for an executemany, so we do our own executemany here.

def get_default_schema_name(self, connection)
def has_sequence(self, connection, sequence_name)
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 PGExecutionContext(DefaultExecutionContext)

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

class PGFloat(Float)

def get_col_spec(self)
back to section top

class PGIdentifierPreparer(ANSIIdentifierPreparer)

back to section top

class PGInet(TypeEngine)

def get_col_spec(self)
back to section top

class PGInteger(Integer)

def get_col_spec(self)
back to section top

class PGInterval(TypeEngine)

def get_col_spec(self)
back to section top

class PGNumeric(Numeric)

def get_col_spec(self)
back to section top

class PGSchemaDropper(ANSISchemaDropper)

def visit_sequence(self, sequence)
back to section top

class PGSchemaGenerator(ANSISchemaGenerator)

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

class PGSmallInteger(SmallInteger)

def get_col_spec(self)
back to section top

class PGString(String)

def get_col_spec(self)
back to section top

class PGText(TEXT)

def get_col_spec(self)
back to section top
Up: Generated Documentation | Previous: module sqlalchemy.databases.sqlite | Next: module sqlalchemy.databases.mysql