MSSQLConnection


Attributes

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.autoval is not null\n\n    "

a SHOW_COLUMNS

"\n        select\n                name,\n                length,\n                (       select name\n                        from systypes\n                        where cast(xusertype as int)= cast(sc.xtype as int)\n                ) datatype,\n                prec,\n                scale,\n                isnullable,\n                cdefault,\n                m.text default_text,\n                isnull(len(autoval),0) is_identity\n        from syscolumns sc\n        LEFT OUTER JOIN syscomments m on sc.cdefault = m.id\n                AND m.colid = 1\n        where\n                sc.id in (select id\n                        from sysobjects\n                where name = '%s')\n        order by\n                colorder"

a SHOW_TABLES

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

a dbName

'mssql'

a limit_re

<_sre.SRE_Pattern object at 0xa71d590>

a schemes

['mssql']

a supportTransactions

True

Methods

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

f insert_id(self, conn) ...

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, size, precision, scale) ...

Here we take raw values coming out of syscolumns and map to SQLObject class types.

f server_version(self) ...

f can_use_max_types(self) ...

f __del__(self) ...

See the source for more information.