Package gluon :: Module dal :: Class TeradataAdapter

[frames] | no frames]

Class TeradataAdapter

    object --+        
             |        
ConnectionPool --+    
                 |    
       BaseAdapter --+
                     |
                    TeradataAdapter

Nested Classes

Inherited from BaseAdapter: __metaclass__

Instance Methods

__init__(self, db, uri, pool_size=0, folder=None, db_codec='UTF-8', credential_decoder=<function IDENTITY at 0x334cd70>, driver_args={}, adapter_args={}, do_connect=True, after_connection=None)
x.__init__(...) initializes x; see help(type(x)) for signature source code

close(self, action='commit', really=True) source code

LEFT_JOIN(self)

source code

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

source code

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

Inherited from BaseAdapter: ADD, AGGREGATE, ALLOW_NULL, AND, AS, BELONGS, CASE, CAST, COALESCE, COALESCE_ZERO, COMMA, CONCAT, CONTAINS, COUNT, DIV, ENDSWITH, EPOCH, EQ, EXTRACT, GE, GT, ILIKE, INVERT, JOIN, LE, LENGTH, LIKE, LOWER, LT, MOD, MUL, NE, NOT, NOT_NULL, ON, OR, PRIMARY_KEY, RANDOM, RAW, REGEXP, REPLACE, STARTSWITH, SUB, SUBSTRING, UPPER, adapt, alias, build_parsemap, bulk_insert, close_connection, commit, commit_prepared, common_filter, concat_add, 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, lastrowid, 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, represent_exceptions, rollback, rollback_prepared, rowslice, save_dbt, select, sequence_name, smart_adapt, sqlsafe_field, sqlsafe_table, table_alias, tables, trigger_name, truncate, update, varquote

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

Inherited from ConnectionPool: after_connection, after_connection_hook, 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 GENERATED ALWAYS AS IDENTITY', 'big...

Inherited from BaseAdapter: FALSE, QUOTE_TEMPLATE, TRUE, T_SEP, 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

init(self, db, uri, pool_size=0, folder=None, db_codec=`'UTF-8'`, credential_decoder=<function IDENTITY at 0x334cd70>, driver_args=`{}`, adapter_args=`{}`, do_connect=True, after_connection=None)
(Constructor)

x.__init__(...) initializes x; see help(type(x)) for signature

Overrides: object.__init__: (inherited documentation)

close(self, action=`'commit'`, really=True)

Overrides: ConnectionPool.close

LEFT_JOIN(self)

Overrides: BaseAdapter.LEFT_JOIN

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

Overrides: BaseAdapter.select_limitby

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

Overrides: BaseAdapter._truncate

Class Variable Details

types

Value:

{'big-id': 'BIGINT GENERATED ALWAYS AS IDENTITY',
 'big-reference': 'BIGINT',
 'bigint': 'BIGINT',
 'blob': 'BLOB',
 'boolean': 'CHAR(1)',
 'date': 'DATE',
 'datetime': 'TIMESTAMP',
 'decimal': 'NUMERIC(%(precision)s,%(scale)s)',
...