Package web :: Package web :: Module db :: Class MSSQLDB

[frames] | no frames]

Class MSSQLDB

DB --+
     |
    MSSQLDB

Instance Methods

__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

Inherited from DB: ctx

Method Details

init(self, **keywords)
(Constructor)

Creates a database.

Overrides: DB.__init__: (inherited documentation)

sql_clauses(self, what, tables, where, group, order, limit, offset)

Overrides: DB.sql_clauses

_test(self)

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'>