Package gluon :: Module dal :: Class VerticaAdapter

[frames] | no frames]

Class VerticaAdapter

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

Nested Classes

Inherited from BaseAdapter: __metaclass__

Instance Methods

EXTRACT(self, first, what)

source code

_truncate(self, table, mode='') source code

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

source code

lastrowid(self, table)

source code

execute(self, a)

source code

Inherited from MSSQLAdapter: AGGREGATE, ALLOW_NULL, CAST, CONCAT, EPOCH, 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, represent, rowslice, 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, 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, _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',

T_SEP = ' '

types = {'big-reference': 'BIGINT REFERENCES %(foreign_key)s O...

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

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

EXTRACT(self, first, what)

Overrides: BaseAdapter.EXTRACT

_truncate(self, table, mode=`''`)

Overrides: BaseAdapter._truncate

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

Overrides: BaseAdapter.select_limitby

lastrowid(self, table)

Overrides: BaseAdapter.lastrowid

execute(self, a)

Overrides: BaseAdapter.execute

Class Variable Details

types

Value:

{'big-reference': 'BIGINT REFERENCES %(foreign_key)s ON DELETE %(on_de
lete_action)s',
 'bigint': 'BIGINT',
 'blob': 'BYTEA',
 'boolean': 'BOOLEAN',
 'date': 'DATE',
 'datetime': 'DATETIME',
 'decimal': 'DECIMAL(%(precision)s,%(scale)s)',
...