web.web.db.MSSQLDB

Package web :: Package web :: Module db :: Class MSSQLDB |
[hide private]
[frames] | no frames]

# Class MSSQLDB

source code

    DB --+
         |
        MSSQLDB

Instance Methods | [hide private]
__init__(self, **keywords) Creates a database. | source code
sql_clauses(self, what, tables, where, group, order, limit, offset) | source code
_test(self) Test LIMIT. | source code
Inherited from `DB`: `delete`, `gen_clause`, `insert`, `multiple_insert`, `query`, `select`, `transaction`, `update`, `where` Inherited from `DB` (private): `_connect`, `_connect_with_pooling`, `_db_cursor`, `_db_execute`, `_getctx`, `_load_context`, `_param_marker`, `_process_insert_query`, `_unload_context`, `_where`

Properties | [hide private]
Inherited from `DB`: `ctx`

Method Details | [hide private]

### __init__(self, **keywords) (Constructor) | source code
Creates a database. Overrides: DB.__init__ (inherited documentation)

### sql_clauses(self, what, tables, where, group, order, limit, offset) | source code
Overrides: DB.sql_clauses

### _test(self) | source code
Test LIMIT. Fake presence of pymssql module for running tests. >>> import sys >>> sys.modules['pymssql'] = sys.modules['sys'] MSSQL has TOP clause instead of LIMIT clause. >>> db = MSSQLDB(db='test', user='joe', pw='secret') >>> db.select('foo', limit=4, _test=True) <sql: 'SELECT * TOP 4 FROM foo'>