Package gluon :: Module dal :: Class OracleAdapter
[hide private]
[frames] | no frames]

Class OracleAdapter

source code

    object --+        
             |        
ConnectionPool --+    
                 |    
       BaseAdapter --+
                     |
                    OracleAdapter

Nested Classes [hide private]

Inherited from BaseAdapter: __metaclass__

Instance Methods [hide private]
 
trigger_name(self, tablename) source code
 
LEFT_JOIN(self) source code
 
RANDOM(self) source code
 
NOT_NULL(self, default, field_type) source code
 
_drop(self, table, mode) source code
 
select_limitby(self, sql_s, sql_f, sql_t, sql_w, sql_o, limitby) source code
 
constraint_name(self, tablename, fieldname) source code
 
represent_exceptions(self, obj, fieldtype) source code
 
__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
 
after_connection(self)
this it is supposed to be overloaded by adapters
source code
 
execute(self, command, args=None) source code
 
create_sequence_and_triggers(self, query, table, **args) source code
 
lastrowid(self, table) source code
 
_fetchall(self) source code
 
sqlsafe_table(self, tablename, ot=None) 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, ON, OR, PRIMARY_KEY, RAW, REGEXP, REPLACE, STARTSWITH, SUB, SUBSTRING, UPPER, adapt, alias, build_parsemap, bulk_insert, close_connection, commit, commit_prepared, common_filter, concat_add, connector, count, 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, rollback, rollback_prepared, rowslice, save_dbt, select, sequence_name, smart_adapt, sqlsafe_field, table_alias, tables, truncate, update, varquote

Inherited from ConnectionPool: 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 [hide private]

Inherited from ConnectionPool: close_all_instances, set_folder

Class Variables [hide private]
  drivers = ('cx_Oracle')
  commit_on_alter_table = False
  types = {'big-id': 'NUMBER PRIMARY KEY', 'big-reference': 'NUM...
  oracle_fix = re.compile(r'[^\']*(\'[^\']*\'[^\']*)*:(?P<clob>C...

Inherited from BaseAdapter: FALSE, QUOTE_TEMPLATE, TRUE, T_SEP, can_select_for_update, connection, dbpath, driver, driver_name, folder, native_json, support_distributed_transaction, uploads_in_blob

Inherited from ConnectionPool: POOLS, check_active_connection

Properties [hide private]

Inherited from object: __class__

Method Details [hide private]

trigger_name(self, tablename)

source code 
Overrides: BaseAdapter.trigger_name

LEFT_JOIN(self)

source code 
Overrides: BaseAdapter.LEFT_JOIN

RANDOM(self)

source code 
Overrides: BaseAdapter.RANDOM

NOT_NULL(self, default, field_type)

source code 
Overrides: BaseAdapter.NOT_NULL

_drop(self, table, mode)

source code 
Overrides: BaseAdapter._drop

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

source code 
Overrides: BaseAdapter.select_limitby

constraint_name(self, tablename, fieldname)

source code 
Overrides: BaseAdapter.constraint_name

represent_exceptions(self, obj, fieldtype)

source code 
Overrides: BaseAdapter.represent_exceptions

__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)

source code 

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

Overrides: object.__init__
(inherited documentation)

after_connection(self)

source code 

this it is supposed to be overloaded by adapters

Overrides: ConnectionPool.after_connection
(inherited documentation)

execute(self, command, args=None)

source code 
Overrides: BaseAdapter.execute

create_sequence_and_triggers(self, query, table, **args)

source code 
Overrides: BaseAdapter.create_sequence_and_triggers

lastrowid(self, table)

source code 
Overrides: BaseAdapter.lastrowid

_fetchall(self)

source code 
Overrides: BaseAdapter._fetchall

sqlsafe_table(self, tablename, ot=None)

source code 
Overrides: BaseAdapter.sqlsafe_table

Class Variable Details [hide private]

types

Value:
{'big-id': 'NUMBER PRIMARY KEY',
 'big-reference': 'NUMBER, CONSTRAINT %(constraint_name)s FOREIGN KEY \
(%(field_name)s) REFERENCES %(foreign_key)s ON DELETE %(on_delete_acti\
on)s',
 'bigint': 'NUMBER',
 'blob': 'CLOB',
 'boolean': 'CHAR(1)',
 'date': 'DATE',
...

oracle_fix

Value:
re.compile(r'[^\']*(\'[^\']*\'[^\']*)*:(?P<clob>CLOB\(\'([^\']+|\'\')*\
\'\))')