MSSQLConnection


Attributes

a supportTransactions

True

a limit_re

<_sre.SRE_Pattern object>

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 HAS_IDENTITY

"\n       select 1\n       from INFORMATION_SCHEMA.COLUMNS\n       where TABLE_NAME = '%s'\n       and COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1\n    "

a schemes

['mssql']

a dbName

'mssql'

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.