Package web2py :: Package gluon :: Module dal :: Class MSSQL2Adapter

[hide private]
[frames] | no frames]

# Class MSSQL2Adapter

source code

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

Instance Methods | [hide private]

represent(self, obj, fieldtype) | source code

execute(self, a) | source code

Inherited from `MSSQLAdapter`: `ALLOW_NULL`, `EXTRACT`, `LEFT_JOIN`, `PRIMARY_KEY`, `RANDOM`, `SUBSTRING`, `__init__`, `integrity_error_class`, `lastrowid`, `represent_exceptions`, `rowslice`, `select_limitby`

Inherited from `BaseAdapter`: `ADD`, `AGGREGATE`, `AND`, `AS`, `BELONGS`, `COALESCE`, `COALESCE_ZERO`, `COMMA`, `CONTAINS`, `DIV`, `ENDSWITH`, `EQ`, `GE`, `GT`, `ILIKE`, `INVERT`, `JOIN`, `LE`, `LIKE`, `LOWER`, `LT`, `MOD`, `MUL`, `NE`, `NOT`, `NOT_NULL`, `ON`, `OR`, `RAW`, `REGEXP`, `STARTSWITH`, `SUB`, `UPPER`, `adapt`, `alias`, `build_parsemap`, `bulk_insert`, `close`, `commit`, `commit_prepared`, `common_filter`, `concat_add`, `constraint_name`, `count`, `create_sequence_and_triggers`, `create_table`, `delete`, `distributed_transaction_begin`, `drop`, `expand`, `expand_all`, `file_close`, `file_delete`, `file_exists`, `file_open`, `get_table`, `insert`, `integrity_error`, `log_execute`, `migrate_table`, `operational_error`, `parse`, `parse_blob`, `parse_boolean`, `parse_date`, `parse_datetime`, `parse_decimal`, `parse_double`, `parse_id`, `parse_integer`, `parse_list_integers`, `parse_list_references`, `parse_list_strings`, `parse_reference`, `parse_time`, `parse_value`, `prepare`, `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]

| types = ``{``'``blob``'``:` `'``IMAGE``'``,` `'``boolean``'``:` `'``CHAR(1)``'``,` `'``date``'``:` `'``DATET``...``
Inherited from `MSSQLAdapter`: `driver` Inherited from `BaseAdapter`: `can_select_for_update`, `commit_on_alter_table`, `maxcharlength`, `support_distributed_transaction`, `uploads_in_blob` Inherited from `ConnectionPool`: `check_active_connection`, `pools`

Properties | [hide private]

Inherited from `object`: `__class__`

Method Details | [hide private]

### represent(self, obj, fieldtype)

source code

Overrides: BaseAdapter.represent

### execute(self, a)

source code

Overrides: BaseAdapter.execute

Class Variable Details | [hide private]

### types

Value:

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