SybaseConnection

The SybaseConnection class is accessible via the sqlobject.sybase.sybaseconnection module.

Attributes

a supportTransactions

False

a NumericType

None

a SHOW_COLUMNS

"SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '%s'"

a SHOW_TABLES

"SELECT name FROM sysobjects WHERE type='U'"

a HAS_IDENTITY

"\n       SELECT col.name, col.status, obj.name\n       FROM syscolumns col\n       JOIN sysobjects obj\n       ON obj.id = col.id\n       WHERE obj.name = '%s'\n             AND (col.status & 0x80) = 0x80\n    "

a schemes

['sybase']

a dbName

'sybase'

Methods

f __init__(self, db, user, password='', host='localhost', port=None, locking=1, **kw) ...

f insert_id(self, conn) ...

Sybase adapter/cursor does not support the insert_id method.

f makeConnection(self) ...

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

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

f createIDColumn(self, soClass) ...

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

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) ...

f __del__(self) ...

See the source for more information.