Package web2py :: Package gluon :: Module dal :: Class OracleAdapter

Class OracleAdapter

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

Instance Methods

[hide private]

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

contraint_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')
x.__init__(...) initializes x; see x.__class__.__doc__ for signature source code

execute(self, command)

source code

create_sequence_and_triggers(self, query, table)

source code

commit_on_alter_table(self)

source code

lastrowid(self, tablename)

source code

Inherited from BaseAdapter: ADD, AGGREGATE, AND, BELONGS, COMMA, COUNT, DELETE, DESC, DIV, EQ, EXTRACT, GE, GT, INSERT, LE, LIKE, LOWER, LT, MUL, NE, NOT, ON, OR, PRIMARY_KEY, SELECT, SUB, SUBSTRING, TRUNCATE, UPDATE, UPPER, VERBATIM, alias, commit, commit_prepared, concat_add, count, distributed_transaction_begin, expand, integrity_error_class, log_execute, parse, prepare, represent, rollback, rollback_prepared, rowslice, select, support_distributed_transaction, tables

Inherited from ConnectionPool: find_or_make_work_folder, pool_connection

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

Static Methods

[hide private]

Inherited from ConnectionPool: close_all_instances, set_thread_folder

Class Variables

[hide private]

types = {'blob': 'CLOB', 'boolean': 'CHAR(1)', 'date': 'DATE',...

oracle_fix = re.compile(r'[^\']*(\'[^\']*\'[^\']*)*:(?P<clob>C...

Inherited from BaseAdapter: KEYWORDS_ALL, KEYWORDS_COMMON

Inherited from ConnectionPool (private): _connection_pools, _folders, _instances

Properties

[hide private]

Inherited from object: __class__

Method Details

[hide private]

x.__init__(...) initializes x; see x.__class__.__doc__ for signature

Overrides: object.__init__: (inherited documentation)

execute(self, command)

source code

Overrides: BaseAdapter.execute

create_sequence_and_triggers(self, query, table)

source code

Overrides: BaseAdapter.create_sequence_and_triggers

commit_on_alter_table(self)

source code

Overrides: BaseAdapter.commit_on_alter_table

lastrowid(self, tablename)

source code

Overrides: BaseAdapter.lastrowid

Class Variable Details

[hide private]

types

Value:

{'blob': 'CLOB',
 'boolean': 'CHAR(1)',
 'date': 'DATE',
 'datetime': 'DATE',
 'decimal': 'NUMERIC(%(precision)s,%(scale)s)',
 'double': 'FLOAT',
 'id': 'NUMBER PRIMARY KEY',
 'integer': 'INT',
...

oracle_fix

Value:

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

Class OracleAdapter

LEFT_JOIN(self)

RANDOM(self)

NOT_NULL(self, default, field_type)

DROP(self, table, mode)

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

contraint_name(self, tablename, fieldname)

represent_exceptions(self, obj, fieldtype)

__init__(self, db, uri, pool_size=0, folder=None, db_codec='UTF-8') (Constructor)

execute(self, command)

create_sequence_and_triggers(self, query, table)

commit_on_alter_table(self)

lastrowid(self, tablename)

types

oracle_fix

init(self, db, uri, pool_size=0, folder=None, db_codec=`'UTF-8'`)
(Constructor)