Package gluon :: Module dal :: Class MSSQL4Adapter

[frames] | no frames]

Class MSSQL4Adapter

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

support for true pagination in MSSQL >= 2012

Nested Classes

Inherited from BaseAdapter: __metaclass__

Instance Methods

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

source code

rowslice(self, rows, minimum=0, maximum=None)
By default this function does nothing; overload when db does not do slicing.

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, represent, 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, connector, constraint_name, count, create_sequence_and_triggers, create_table, delete, distributed_transaction_begin, drop, execute, 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, sqlsafe_field, sqlsafe_table, 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

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

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

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

Overrides: BaseAdapter.select_limitby

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

By default this function does nothing; overload when db does not do slicing.

Overrides: BaseAdapter.rowslice: (inherited documentation)