Package gluon :: Module dal :: Class MSSQL2Adapter

[frames] | no frames]

Class MSSQL2Adapter

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

Instance Methods

represent(self, obj, fieldtype)

source code

execute(self, a)

source code

Inherited from MSSQLAdapter: AGGREGATE, ALLOW_NULL, CAST, CONCAT, EPOCH, EXTRACT, LEFT_JOIN, PRIMARY_KEY, RANDOM, ST_ASTEXT, ST_CONTAINS, ST_DISTANCE, ST_EQUALS, ST_INTERSECTS, ST_OVERLAPS, ST_TOUCHES, ST_WITHIN, SUBSTRING, __init__, concat_add, lastrowid, rowslice, select_limitby, varquote

Inherited from BaseAdapter: ADD, AND, AS, BELONGS, CASE, COALESCE, COALESCE_ZERO, COMMA, CONTAINS, COUNT, DIV, ENDSWITH, EQ, GE, GT, ILIKE, INVERT, JOIN, LE, LENGTH, LIKE, LOWER, LT, MOD, MUL, NE, NOT, NOT_NULL, ON, OR, RAW, REGEXP, REPLACE, STARTSWITH, SUB, UPPER, adapt, alias, build_parsemap, bulk_insert, close_connection, commit, commit_prepared, common_filter, 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, find_driver, get_table, id_query, insert, isOperationalError, isProgrammingError, is_numerical_type, log, log_execute, migrate_table, parse, parse_blob, parse_boolean, parse_date, parse_datetime, parse_decimal, parse_double, parse_id, parse_integer, parse_json, parse_list_integers, parse_list_references, parse_list_strings, parse_reference, parse_time, parse_value, prepare, represent_exceptions, rollback, rollback_prepared, save_dbt, select, sequence_name, smart_adapt, table_alias, tables, trigger_name, truncate, update

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

Inherited from ConnectionPool: after_connection, after_connection_hook, close, find_or_make_work_folder, reconnect

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

Static Methods

Inherited from ConnectionPool: close_all_instances, set_folder

Class Variables

drivers = 'pyodbc',

types = {'big-id': 'BIGINT IDENTITY PRIMARY KEY', 'big-referen...

Inherited from MSSQLAdapter: FALSE, QUOTE_TEMPLATE, REGEX_ARGPATTERN, REGEX_DSN, REGEX_URI, TRUE, T_SEP

Inherited from BaseAdapter: can_select_for_update, commit_on_alter_table, connection, dbpath, driver, driver_name, folder, native_json, support_distributed_transaction, uploads_in_blob

Inherited from ConnectionPool: POOLS, check_active_connection

Properties

Inherited from object: __class__

Method Details

represent(self, obj, fieldtype)

Overrides: BaseAdapter.represent

execute(self, a)

Overrides: BaseAdapter.execute

Class Variable Details

types

Value:

{'big-id': 'BIGINT IDENTITY PRIMARY KEY',
 'big-reference': 'BIGINT, CONSTRAINT %(constraint_name)s FOREIGN KEY 
(%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_acti
on)s',
 'bigint': 'BIGINT',
 'blob': 'IMAGE',
 'boolean': 'CHAR(1)',
 'date': 'DATETIME',
...