Package web2py :: Package gluon :: Module dal :: Class MSSQLAdapter

Class MSSQLAdapter

    object --+        
             |        
ConnectionPool --+    
                 |    
       BaseAdapter --+
                     |
                    MSSQLAdapter

Known Subclasses:: MSSQL2Adapter

Instance Methods

[hide private]

EXTRACT(self, field, what)

source code

LEFT_JOIN(self)

source code

RANDOM(self)

source code

ALLOW_NULL(self)

source code

SUBSTRING(self, field, parameters)

source code

PRIMARY_KEY(self, key)

source code

select_limitby(self, sql_s, sql_f, sql_t, sql_w, sql_o, limitby)

source code

represent_exceptions(self, obj, fieldtype)

source code

__init__(self, db, uri, pool_size=0, folder=1, db_codec='UTF-8', credential_decoder=<function <lambda> at 0xd6b8c0>, driver_args={}, adapter_args={}, fake_connect=True)
x.__init__(...) initializes x; see x.__class__.__doc__ for signature source code

lastrowid(self, table)

source code

integrity_error_class(self)

source code

rowslice(self, rows, minimum=0, maximum=1)
by default this function does nothing, overload when db does not do slicing

source code

Inherited from BaseAdapter: ADD, AGGREGATE, AND, AS, BELONGS, COALESCE_ZERO, COMMA, CONTAINS, DIV, ENDSWITH, EQ, GE, GT, INVERT, JOIN, LE, LIKE, LOWER, LT, MOD, MUL, NE, NOT, NOT_NULL, ON, OR, STARTSWITH, SUB, UPPER, alias, bulk_insert, close, commit, commit_prepared, concat_add, constraint_name, count, create_sequence_and_triggers, create_table, delete, distributed_transaction_begin, drop, execute, expand, file_close, file_delete, file_exists, file_open, filter_tenant, get_table, insert, integrity_error, log_execute, migrate_table, parse, prepare, represent, rollback, rollback_prepared, select, sequence_name, tables, trigger_name, truncate, update

Inherited from BaseAdapter (private): _count, _delete, _drop, _insert, _select, _truncate, _update

Inherited from ConnectionPool: find_or_make_work_folder, pool_connection

Inherited from object: __delattr__, __getattribute__, __hash__, __new__, __reduce__, __reduce_ex__, __repr__, __setattr__, __str__

Static Methods

[hide private]

Inherited from ConnectionPool: close_all_instances, set_folder

Class Variables

[hide private]

driver = globals().get('pyodbc', None)
PyMySQL: A pure-Python drop-in replacement for MySQLdb.

types = {'blob': 'IMAGE', 'boolean': 'BIT', 'date': 'DATETIME'...

Inherited from BaseAdapter: commit_on_alter_table, maxcharlength, support_distributed_transaction, uploads_in_blob

Inherited from ConnectionPool: pools

Properties

[hide private]

Inherited from object: __class__

Method Details

[hide private]

init(self, db, uri, pool_size=0, folder=1, db_codec=`'UTF-8'`, credential_decoder=<function <lambda> at 0xd6b8c0>, driver_args=`{}`, adapter_args=`{}`, fake_connect=True)
(Constructor)

source code

x.__init__(...) initializes x; see x.__class__.__doc__ for signature

Overrides: BaseAdapter.__init__

lastrowid(self, table)

source code

Overrides: BaseAdapter.lastrowid

integrity_error_class(self)

source code

Overrides: BaseAdapter.integrity_error_class

rowslice(self, rows, minimum=0, maximum=1)

source code

by default this function does nothing, overload when db does not do slicing

Overrides: BaseAdapter.rowslice: (inherited documentation)

Class Variable Details

[hide private]

types

Value:

{'blob': 'IMAGE',
 'boolean': 'BIT',
 'date': 'DATETIME',
 'datetime': 'DATETIME',
 'decimal': 'NUMERIC(%(precision)s,%(scale)s)',
 'double': 'FLOAT',
 'id': 'INT IDENTITY PRIMARY KEY',
 'integer': 'INT',
...

Class MSSQLAdapter

EXTRACT(self, field, what)

LEFT_JOIN(self)

RANDOM(self)

ALLOW_NULL(self)

SUBSTRING(self, field, parameters)

PRIMARY_KEY(self, key)

select_limitby(self, sql_s, sql_f, sql_t, sql_w, sql_o, limitby)

represent_exceptions(self, obj, fieldtype)

__init__(self, db, uri, pool_size=0, folder=1, db_codec='UTF-8', credential_decoder=<function <lambda> at 0xd6b8c0>, driver_args={}, adapter_args={}, fake_connect=True) (Constructor)

lastrowid(self, table)

integrity_error_class(self)

rowslice(self, rows, minimum=0, maximum=1)

types

init(self, db, uri, pool_size=0, folder=1, db_codec=`'UTF-8'`, credential_decoder=<function <lambda> at 0xd6b8c0>, driver_args=`{}`, adapter_args=`{}`, fake_connect=True)
(Constructor)