Package backend :: Package server :: Package rhnSQL :: Module driver_cx_Oracle :: Class Database

[frames] | no frames]

Class Database

source code

Nested Classes

[hide private]

_cursor_class
Wrapper that should just transform Oracle specific exceptions into something generic from sql_base.

_procedure_class
Class for calling out to stored procedures.

OracleError

Instance Methods

[hide private]

TimestampFromTicks(...)
hash(x)

__init__(self, host=None, port=None, username=None, password=None, database=None, sslmode=None, sslrootcert=None)

source code

connect(self, reconnect=1)
Opens a connection to the database.

source code

_connect(self)

source code

is_connected_to(self, backend, host, port, username, password, database, sslmode, sslrootcert)
Check if this database matches the given connection parameters.

source code

close(self)
Close the connection

source code

cursor(self)
return an empty Cursor object

source code

prepare(self, sql, force=0, blob_map=None)
Prepare an SQL statement.

source code

procedure(self, name)
Return a pointer to a callable instance for a given stored procedure.

source code

_function(self, name, ret_type)

source code

execute(self, sql, *args, **kwargs)

source code

transaction(self, name)
set a transaction point to which we can rollback to

source code

commit(self)
Commit changes

source code

rollback(self, name=None)
rollback changes, optionally to a previously set transaction point

source code

check_connection(self)
Check that this connection is still valid.

source code

_fix_environment_vars(self)
Fix environment variables (to be redefined in subclasses)

source code

_get_oracle_error_info(self, error)

source code

_read_lob(self, lob)
Reads a lob's contents

source code

Date(self, year, month, day)
Returns a Date object

source code

DatetimeFromTicks(self, ticks)

source code

Inherited from sql_base.Database: DateFromTicks, function

Method Details

[hide private]

TimestampFromTicks(...)

hash(x)

Overrides: TimestampFromTicks

init(self, host=None, port=None, username=None, password=None, database=None, sslmode=None, sslrootcert=None)
(Constructor)

source code

Overrides: sql_base.Database.__init__

connect(self, reconnect=1)

source code

Opens a connection to the database.

Overrides: sql_base.Database.connect: (inherited documentation)

is_connected_to(self, backend, host, port, username, password, database, sslmode, sslrootcert)

source code

Check if this database matches the given connection parameters.

Overrides: sql_base.Database.is_connected_to: (inherited documentation)

close(self)

source code

Close the connection

Overrides: sql_base.Database.close: (inherited documentation)

cursor(self)

source code

return an empty Cursor object

Overrides: sql_base.Database.cursor: (inherited documentation)

prepare(self, sql, force=0, blob_map=None)

source code

Prepare an SQL statement.

Overrides: sql_base.Database.prepare: (inherited documentation)

procedure(self, name)

source code

Return a pointer to a callable instance for a given stored procedure. The return value is a (possibly modified) copy of the arguments passed in. see cx_Oracle's Cursor.callproc for more details