MaxdbConnection


Attributes

a supportTransactions

True

a schemes

['maxdb']

a GET_PK_AND_FK

"\n    SELECT constraint_cols.column_name, constraints.constraint_type,\n           refname,reftablename\n    FROM user_cons_columns constraint_cols\n    INNER JOIN user_constraints constraints\n    ON constraint_cols.constraint_name = constraints.constraint_name\n    LEFT OUTER JOIN show_foreign_key fk\n    ON constraint_cols.column_name = fk.columnname\n    WHERE constraints.table_name =UPPER('%s')"

a GET_COLUMNS

"\n    SELECT COLUMN_NAME, NULLABLE, DATA_DEFAULT, DATA_TYPE,\n           DATA_LENGTH, DATA_SCALE\n    FROM USER_TAB_COLUMNS WHERE TABLE_NAME=UPPER('%s')"

a dbName

'maxdb'

Methods

f __init__(self, host='', port=None, user=None, password=None, database=None, autoCommit=1, sqlmode='internal', isolation=None, timeout=None, **kw) ...

f createSequenceName(self, table) ...

sequence name are builded with the concatenation of the table name with '_SEQ' word we truncate the name of the sequence_name because sapdb identifier cannot exceed 32 characters so that the name of the sequence does not exceed 32 characters

f makeConnection(self) ...

f sqlAddLimit(cls, query, limit) ...

f createTable(self, soClass) ...

f createReferenceConstraint(self, soClass, col) ...

f createColumn(self, soClass, col) ...

f createIDColumn(self, soClass) ...

f createIndexSQL(self, soClass, index) ...

f dropTable(self, tableName, cascade=False) ...

f joinSQLType(self, join) ...

f tableExists(self, tableName) ...

f addColumn(self, tableName, column) ...

f delColumn(self, sqlmeta, column) ...

f columnsFromSchema(self, tableName, soClass) ...

f guessClass(self, t, flength, fscale=None) ...

An internal method that tries to figure out what Col subclass is appropriate given whatever introspective information is available -- both very database-specific.

f __del__(self) ...

See the source for more information.