ll.orasql contains utilities for working with cx_Oracle:

It allows calling procedures with keyword arguments (via the Procedure class).
Query results will be put into Record objects, where database fields are accessible as object attributes.
The Connection class provides methods for iterating through the database metadata.

Importing this module adds support for URLs with the scheme oracle to ll.url. Examples of these URLs are:

oracle://user:pwd@db/
oracle://user:pwd@db/view/
oracle://user:pwd@db/view/USER_TABLES.sql
oracle://sys:pwd:sysdba@db/

class `SQLObjectNotFoundError`(`IOError`):

def `init`(`self`, `obj`):

class `SQLNoSuchObjectError`(`Exception`):

def `init`(`self`, `name`, `owner`):

def `repr`(`self`):

def `str`(`self`):

class `UnknownModeError`(`ValueError`):

def `init`(`self`, `mode`):

def `repr`(`self`):

def `str`(`self`):

class `ConflictError`(`ValueError`):

def `init`(`self`, `object`, `message`):

def `repr`(`self`):

def `str`(`self`):

class `Args`(`dict`):

An Args object is a subclass of dict that is used for passing arguments to procedures and functions. Both item and attribute access (i.e. __getitem__ and __getattr__) are available. Names are case insensitive.

def `init`(`self`, `arg`=`None`, **`kwargs`):

def `update`(`self`, `arg`=`None`, **`kwargs`):

def `getitem`(`self`, `name`):

def `setitem`(`self`, `name`, `value`):

def `delitem`(`self`, `name`):

def `getattr`(`self`, `name`):

def `setattr`(`self`, `name`, `value`):

def `delattr`(`self`, `name`):

def `repr`(`self`):

class `CLOBStream`(`object`):

A CLOBStream object provides streamlike access to a CLOB.

def `init`(`self`, `value`, `encoding`):

def `readall`(`self`):

Read all remaining data from the stream and return the decoded unicode object for the data.

def `readchunk`(`self`):

Read a chunk of data from the stream and return the decoded unicode object for the data. Reading is done in optimally sized chunks.

def `read`(`self`, `size`=`None`):

Read size bytes from to stream and return the decoded unicode object for the data. If size is None, all remaining data will be read.

def `reset`(`self`):

Reset the stream, so that the next read call starts at the beginning of the CLOB.

class `BLOBStream`(`object`):

A BLOBStream object provides streamlike access to a BLOB.

def `init`(`self`, `value`):

def `readall`(`self`):

Read all remaining data from the stream and return it.

def `readchunk`(`self`):

Read a chunk of data from the stream and return it. Reading is done in optimally sized chunks.

def `read`(`self`, `size`=`None`):

Read size bytes from to stream and return them. If size is None, all remaining data will be read.

def `reset`(`self`):

Reset the stream, so that the next read call starts at the beginning of the BLOB.

def `_decodeclob`(`value`, `encoding`, `readlobs`):

def `_decodeblob`(`value`, `readlobs`):

class `RecordMaker`(`object`):

def `init`(`self`, `cursor`):

def `call`(`self`, *`row`):

def `STRING`(`self`, `value`):

def `LONG_STRING`(`self`, `value`):

def `FIXED_CHAR`(`self`, `value`):

def `CLOB`(`self`, `value`):

def `NCLOB`(`self`, `value`):

def `BLOB`(`self`, `value`):

def `DEFAULT`(`self`, `value`):

class `Record`(`tuple`):

A Record is a subclass of tuple that is used for storing results of database fetches and procedure and function calls. Both item and attribute access (i.e. __getitem__ and __getattr__) are available. Field names are case insensitive.

def `getitem`(`self`, `arg`):

def `getattr`(`self`, `name`):

def `get`(`self`, `name`, `default`=`None`):

Return the value for the field named name. If this field doesn't exist in self, return default instead.

def `contains`(`self`, `name`):

def `iterkeys`(`self`):

Return an iterator over field names

def `keys`(`self`):

Return a list of field names

def `items`(`self`):

Return a list of (field name, field value) tuples.

def `iteritems`(`self`):

Return an iterator over (field name, field value) tuples.

def `repr`(`self`):

class `SessionPool`(`OracleSessionPool`):

SessionPool is a subclass of cx_Oracle.SessionPool.

def `init`(`self`, `user`, `password`, `database`, `min`, `max`, `increment`, `connectiontype`=`None`, `threaded`=`False`, `getmode`=`1`, `homogeneous`=`True`):

def `connectstring`(`self`):

def `repr`(`self`):

class `Connection`(`cx_Oracle.Connection`):

Connection is a subclass of cx_Oracle.Connection.

def `init`(`self`, *`args`, **`kwargs`):

Create a new connection. In addition to the parameters supported by cx_Oracle.connect the following keyword argument is supported.

readlobs (bool or integer): If readlobs is False all cursor fetches return CLOBStream or BLOBStream objects. If readlobs is an int LOB`s with a maximum size of :var:`readlobs will be returned as str/unicode objects. If readlobs is True all LOB values will be returned as strings.

def `connectstring`(`self`):

def `cursor`(`self`, `readlobs`=`None`):

Return a new cursor for this connection. For the meaning of readlobs see __init__.

def `repr`(`self`):

def `itertables`(`self`, `owner`=`<object object at 0xf67a2c80>`, `mode`=`'flat'`):

Generator that yields all table definitions in the current users schema (or all users schemas). mode specifies the order in which tables will be yielded:

"create": Create order, deleting records from the table in this order will not violate foreign key constraints.
"drop": Drop order, deleting records from the table in this order will not violate foreign key constraints.
"flat": Unordered.

schema specifies from which user tables should be yielded:

"user": Only tables belonging to the current user (and those objects these depend on) will be yielded (i.e. tables from the USER_TABLES view).
"all": All tables accessible to the current user will be yielded (i.e. tables from the ALL_TABLES views).
"dba": All tables from all users will be yielded (i.e. tables from the DBA_TABLES view, this requires the appropriate privileges).

Tables that are materialized views will be skipped in all cases.

def `itersequences`(`self`, `owner`=`<object object at 0xf67a2c80>`):

Generator that yields sequences. owner can be None, ALL (the default) or a user name.

def `iterfks`(`self`, `owner`=`<object object at 0xf67a2c80>`):

Generator that yields all foreign key constraints. owner can be None, ALL (the default) or a user name.

def `iterprivileges`(`self`, `owner`=`<object object at 0xf67a2c80>`):

Generator that yields object privileges. owner can be None, ALL (the default) or a user name.

def `iterusers`(`self`):

Generator that yields all users.

def `iterobjects`(`self`, `owner`=`<object object at 0xf67a2c80>`, `mode`=`'create'`):

Generator that yields the sequences, tables, primary keys, foreign keys, comments, unique constraints, indexes, views, functions, procedures, packages and types in the current users schema (or all users schemas) in a specified order.

mode specifies the order in which objects will be yielded:

"create": Create order, i.e. recreating the objects in this order will not lead to errors.
"drop": Drop order, i.e. dropping the objects in this order will not lead to errors.
"flat": Unordered.

schema specifies from which schema objects should be yielded:

"user": Only objects belonging to the current user (and those objects these depend on) will be yielded.
"all": All objects accessible to the current user will be yielded.
"dba": All objects from all users will be yielded (this requires the appropriate privileges).

def `_getobject`(`self`, `name`, `owner`=`None`):

def `getobject`(`self`, `name`, `owner`=`None`):

Return the object named name from the schema. If owner is None the current schema is queried, else the specified one is used. name and owner are treated case insensitively.

def `connect`(*`args`, **`kwargs`):

Create a connection to the database and return a Connection object.

class `Cursor`(`OracleCursor`):

A subclass of the cursor class in cx_Oracle. The "execute" methods support a unicode statement and unicode parameters (they will be encoded in the client encoding before being passed to the database). The "fetch" methods will return records as Record objects and string values and CLOB values, if the cursors readlobs attribute has the appropriate value) will be returned as unicode objects (except for BLOB values). (Note that strings in the national character set (and NCLOB values) are not supported).

def `init`(`self`, `connection`, `readlobs`=`None`):

Return a new cursor for the connection connection. For the meaning of readlobs see Connection.__init__.

def `ddprefix`(`self`):

Return whether the user has access to the DBA_* views ("dba") or not ("all").

def `ddprefixargs`(`self`):

Return whether the user has access to the DBA_ARGUMENTS view ("dba") or not ("all").

def `_encode`(`self`, `value`):

def `execute`(`self`, `statement`, `parameters`=`None`, **`kwargs`):

def `executemany`(`self`, `statement`, `parameters`):

def `repr`(`self`):

def `formatstring`(`value`, `latin1`=`False`):

def `makeurl`(`name`):

class `MixinNormalDates`(`object`):

Mixin class that provides methods for determining creation and modification dates for objects.

def `cdate`(`self`, `connection`=`None`):

def `udate`(`self`, `connection`=`None`):

class `MixinCodeDDL`(`object`):

Mixin class that provides methods returning the create and drop statements for various objects.

def `createddl`(`self`, `connection`=`None`, `term`=`True`):

def `dropddl`(`self`, `connection`=`None`, `term`=`True`):

def `fixname`(`cls`, `code`):

def `getfullname`(`name`, `owner`):

class `Object`(`object`):

The base class for all Python classes modelling schema objects in the database.

Subclasses are: Sequence, Table, PrimaryKey, Comment, ForeignKey, Index, Unique, Synonym, View, MaterializedView, Library, Function, Package, Type, Trigger, JavaSource and Column.

class `metaclass`(`type`):

def `init`(`self`, `name`, `owner`=`None`, `connection`=`None`):

def `repr`(`self`):

def `str`(`self`):

def `eq`(`self`, `other`):

def `ne`(`self`, `other`):

def `hash`(`self`):

def `getfullname`(`self`):

def `createddl`(`self`, *`args`, **`kwargs`):

Return SQL code to create this object.

def `dropddl`(`self`, *`args`, **`kwargs`):

Return SQL code to drop this object

def `fixname`(`self`, *`args`, **`kwargs`):

Replace the name of the object in the SQL code code with the name of self.

def `cdate`(`self`, *`args`, **`kwargs`):

Return a datetime.datetime object with the creation date of self in the database specified by connection (or None if such information is not available).

def `udate`(`self`, *`args`, **`kwargs`):

Return a datetime.datetime object with the last modification date of self in the database specified by connection (or None if such information is not available).

def `iterreferences`(`self`, `connection`=`None`):

Objects directly used by self.

If connection is not None it will be used as the database connection from which to fetch data. If connection is None the connection from which self has been extracted will be used. If there is not such connection, you'll get an exception.

def `iterreferencesall`(`self`, `connection`=`None`, `done`=`None`):

All objects used by self (recursively).

For the meaning of connection see iterreferences.

done is used internally and shouldn't be passed.

def `iterreferencedby`(`self`, `connection`=`None`):

Objects using self.

For the meaning of connection see iterreferences.

def `iterreferencedbyall`(`self`, `connection`=`None`, `done`=`None`):

All objects depending on self (recursively).

For the meaning of connection see iterreferences.

done is used internally and shouldn't be passed.

def `getconnection`(`self`, `connection`):

def `getcursor`(`self`, `connection`):

property connectstring:

def `get`(`self`):

def `iternames`(`cls`, `connection`, `owner`=`<object object at 0xf67a2c80>`):

Generator that yields the names of all objects of this type. The argument owner specifies whos objects are yielded:

None: All objects belonging to the current user (i.e. via the view USER_OBJECTS).
ALL: All objects for all users (via the views ALL_OBJECTS or DBA_OBJECTS)
username (string): All objects belonging the the specified user

def `iterobjects`(`cls`, `connection`, `owner`=`<object object at 0xf67a2c80>`):

Generator that yields all objects of this type in the current users schema. The argument owner specifies whos objects are yielded:

None: All objects belonging to the current user (i.e. via the view USER_OBJECTS).
ALL: All objects for all users (via the views ALL_OBJECTS or DBA_OBJECTS)
username (string): All objects belonging the the specified user

class `Sequence`(`MixinNormalDates`, `Object`):

Models a sequence in the database.

def `_createddl`(`self`, `connection`, `term`, `copyvalue`):

def `createddl`(`self`, `connection`=`None`, `term`=`True`):

def `createddlcopy`(`self`, `connection`=`None`, `term`=`True`):

Return SQL code to create an identical copy of this sequence.

def `dropddl`(`self`, `connection`=`None`, `term`=`True`):

def `fixname`(`cls`, `code`):

def `iterreferences`(`self`, `connection`=`None`, `done`=`None`):

def `_columntype`(`rec`, `data_precision`=`None`, `data_scale`=`None`, `char_length`=`None`):

def `_columndefault`(`rec`):

class `Table`(`MixinNormalDates`, `Object`):

Models a table in the database.

def `createddl`(`self`, `connection`=`None`, `term`=`True`):

def `dropddl`(`self`, `connection`=`None`, `term`=`True`):

def `fixname`(`cls`, `code`):

def `mview`(`self`, `connection`=`None`):

The materialized view this table belongs to (or None if it's a real table).

def `ismview`(`self`, `connection`=`None`):

Is this table a materialized view?

def `organization`(`self`, `connection`=`None`):

Return the organization of this table: either "heap" (for "normal" tables) or "index" (for index organized tables).

def `iternames`(`cls`, `connection`, `owner`=`<object object at 0xf67a2c80>`):

def `itercolumns`(`self`, `connection`=`None`):

Generator that yields all column objects of the Table self.

def `iterrecords`(`self`, `connection`=`None`):

Generator that yields all records of the table self.

def `itercomments`(`self`, `connection`=`None`):

Generator that yields all column comments of the table self.

def `_iterconstraints`(`self`, `connection`, `cond`):

def `iterconstraints`(`self`, `connection`=`None`):

Generator that yields all constraints for this table.

def `pk`(`self`, `connection`=`None`):

Return the primary key constraint for this table (or None if the table has no primary key constraint).

def `iterreferences`(`self`, `connection`=`None`):

def `iterreferencedby`(`self`, `connection`=`None`):

class `Constraint`(`Object`):

Base class of all constraints (primary key constraints, foreign key constraints and unique constraints).

def `cdate`(`self`, `connection`=`None`):

def `udate`(`self`, `connection`=`None`):

def `iternames`(`cls`, `connection`, `owner`=`<object object at 0xf67a2c80>`):

def `fixname`(`cls`, `code`):

class `PrimaryKey`(`Constraint`):

Models a primary key constraint in the database.

def `itercolumns`(`self`, `connection`=`None`):

Return an iterator over the columns this primary key consists of.

def `createddl`(`self`, `connection`=`None`, `term`=`True`):

def `dropddl`(`self`, `connection`=`None`, `term`=`True`):

def `iterreferencedby`(`self`, `connection`=`None`):

def `iterreferences`(`self`, `connection`=`None`):

def `table`(`self`, `connection`=`None`):

Return the Table self belongs to.

class `Comment`(`Object`):

Models a column comment in the database.

def `createddl`(`self`, `connection`=`None`, `term`=`True`):

def `dropddl`(`self`, `connection`=`None`, `term`=`True`):

def `fixname`(`cls`, `code`):

def `cdate`(`self`, `connection`=`None`):

def `udate`(`self`, `connection`=`None`):

def `iterreferences`(`self`, `connection`=`None`):

def `iterreferencedby`(`self`, `connection`=`None`):

class `ForeignKey`(`Constraint`):

Models a foreign key constraint in the database.

def `createddl`(`self`, `connection`=`None`, `term`=`True`):

def `_ddl`(`self`, `connection`, `cmd`, `term`):

def `dropddl`(`self`, `connection`=`None`, `term`=`True`):

def `enableddl`(`self`, `connection`=`None`, `term`=`True`):

def `disableddl`(`self`, `connection`=`None`, `term`=`True`):

def `iterreferencedby`(`self`, `connection`=`None`):

def `iterreferences`(`self`, `connection`=`None`):

def `table`(`self`, `connection`=`None`):

Return the Table self belongs to.

def `pk`(`self`, `connection`=`None`):

Return the primary key referenced by self.

def `itercolumns`(`self`, `connection`=`None`):

Return an iterator over the columns this foreign key consists of.

def `isenabled`(`self`, `connection`=`None`):

Return whether this constraint is enabled.

class `Index`(`MixinNormalDates`, `Object`):

Models an index in the database.

def `createddl`(`self`, `connection`=`None`, `term`=`True`):

def `dropddl`(`self`, `connection`=`None`, `term`=`True`):

def `iternames`(`cls`, `connection`, `owner`=`<object object at 0xf67a2c80>`):

def `fixname`(`cls`, `code`):

def `constraint`(`self`, `connection`=`None`):

If this index is generated by a constraint, return the constraint otherwise return None.

def `isconstraint`(`self`, `connection`=`None`):

Is this index generated by a constraint?

def `iterreferences`(`self`, `connection`=`None`):

def `table`(`self`, `connection`=`None`):

Return the Table self belongs to.

class `UniqueConstraint`(`Constraint`):

Models a unique constraint in the database.

def `createddl`(`self`, `connection`=`None`, `term`=`True`):

def `dropddl`(`self`, `connection`=`None`, `term`=`True`):

def `iterreferencedby`(`self`, `connection`=`None`):

def `iterreferences`(`self`, `connection`=`None`):

def `table`(`self`, `connection`=`None`):

Return the Table self belongs to.

class `Synonym`(`Object`):

Models a synonym in the database.

def `createddl`(`self`, `connection`=`None`, `term`=`True`):

def `dropddl`(`self`, `connection`=`None`, `term`=`True`):

def `fixname`(`cls`, `code`):

def `cdate`(`self`, `connection`=`None`):

def `udate`(`self`, `connection`=`None`):

def `iterreferences`(`self`, `connection`=`None`, `done`=`None`):

def `getobject`(`self`, `connection`=`None`):

Get the object for which self is a synonym.

class `View`(`MixinNormalDates`, `Object`):

Models a view in the database.

def `createddl`(`self`, `connection`=`None`, `term`=`True`):

def `dropddl`(`self`, `connection`=`None`, `term`=`True`):

def `fixname`(`cls`, `code`):

def `iterrecords`(`self`, `connection`=`None`):

class `MaterializedView`(`View`):

Models a meterialized view in the database.

def `createddl`(`self`, `connection`=`None`, `term`=`True`):

def `dropddl`(`self`, `connection`=`None`, `term`=`True`):

def `fixname`(`cls`, `code`):

def `iterreferences`(`self`, `connection`=`None`):

def `iterreferencedby`(`self`, `connection`=`None`):

class `Library`(`Object`):

Models a library in the database.

def `createddl`(`self`, `connection`=`None`, `term`=`True`):

def `dropddl`(`self`, `connection`=`None`, `term`=`True`):

def `fixname`(`cls`, `code`):

class `Argument`(`object`):

Argument objects hold information about the arguments of a stored procedure.

def `init`(`self`, `name`, `position`, `datatype`, `isin`, `isout`):

def `repr`(`self`):

class `Callable`(`MixinNormalDates`, `MixinCodeDDL`, `Object`):

Models a callable object in the database, i.e. functions and procedures.

def `init`(`self`, `name`, `owner`=`None`, `connection`=`None`):

def `_calcargs`(`self`, `cursor`):

def `_getargs`(`self`, `cursor`, *`args`, **`kwargs`):

def `_wraparg`(`self`, `cursor`, `arginfo`, `arg`):

def `_unwraparg`(`self`, `arginfo`, `cursor`, `value`):

def `_makerecord`(`self`, `cursor`, `args`):

def `iterarguments`(`self`, `connection`=`None`):

Generator that yields all arguments of the function/procedure self.

class `Procedure`(`Callable`):

Models a procedure in the database. A Procedure object can be used as a wrapper for calling the procedure with keyword arguments.

def `call`(`self`, `cursor`, *`args`, **`kwargs`):

Call the procedure with arguments args and keyword arguments kwargs. cursor must be a ll.orasql cursor. This will return a Record object containing the result of the call (i.e. this record will contain all specified and all out parameters).

class `Function`(`Callable`):

Models a function in the database. A Function object can be used as a wrapper for calling the function with keyword arguments.

def `call`(`self`, `cursor`, *`args`, **`kwargs`):

Call the function with arguments args and keyword arguments kwargs. cursor must be an ll.orasql cursor. This will return a tuple containing the result and a Record object containing the modified parameters (i.e. this record will contain all specified and out parameters).

class `Package`(`MixinNormalDates`, `MixinCodeDDL`, `Object`):

Models a package in the database.

class `PackageBody`(`MixinNormalDates`, `MixinCodeDDL`, `Object`):

Models a package body in the database.

class `Type`(`MixinNormalDates`, `MixinCodeDDL`, `Object`):

Models a type definition in the database.

class `Trigger`(`MixinNormalDates`, `MixinCodeDDL`, `Object`):

Models a trigger in the database.

class `JavaSource`(`MixinNormalDates`, `Object`):

Models Java source code in the database.

def `createddl`(`self`, `connection`=`None`, `term`=`True`):

def `dropddl`(`self`, `connection`=`None`, `term`=`True`):

def `fixname`(`cls`, `code`):

class `Privilege`(`object`):

Models a database object privilege (i.e. a grant).

A Privilege object has the following attributes:

privilege (string): The type of the privilege (EXECUTE etc.)
name (string): The name of the object for which this privilege grants access
owner (string or None): the owner of the object
grantor (string or None): Who granted this privilege?
grantee (string or None): To whom has this privilege been granted?
connection (Connection or None): The database connection

def `init`(`self`, `privilege`, `name`, `grantor`, `grantee`, `owner`=`None`, `connection`=`None`):

def `repr`(`self`):

def `str`(`self`):

def `getconnection`(`self`, `connection`):

def `getcursor`(`self`, `connection`):

property connectstring:

def `get`(`self`):

def `iterobjects`(`cls`, `connection`, `owner`=`<object object at 0xf67a2c80>`):

Generator that yields object privileges. For the meaning of owner see Object.iternames.

def `grantddl`(`self`, `connection`=`None`, `term`=`True`, `mapgrantee`=`True`):

Return SQL code to grant this privilege. If mapgrantee is a list or a dictionary and self.grantee is not in this list (or dictionary) no command will be returned. If it's a dictionary and self.grantee is in it, the privilege will be granted to the user specified as the value instead of the original one. If mapgrantee is true (the default) the privilege will be granted to the original grantee.

class `Column`(`Object`):

Models a single column of a table in the database. This is used to output ALTER TABLE ... statements for adding, dropping and modifying columns.

def `_getcolumnrecord`(`self`, `cursor`):

def `addddl`(`self`, `connection`=`None`, `term`=`True`):

def `modifyddl`(`self`, `connection`, `cursorold`, `cursornew`, `term`=`True`):

def `dropddl`(`self`, `connection`=`None`, `term`=`True`):

def `table`(`self`):

def `cdate`(`self`, `connection`=`None`):

def `udate`(`self`, `connection`=`None`):

def `iterreferences`(`self`, `connection`=`None`):

def `iterreferencedby`(`self`, `connection`=`None`):

def `datatype`(`self`, `connection`=`None`):

The SQL type of this column.

def `default`(`self`, `connection`=`None`):

The SQL default value for this column.

def `nullable`(`self`, `connection`=`None`):

Is this column nullable?

def `comment`(`self`, `connection`=`None`):

The comment for this column.

class `User`(`object`):

Models a user in the database

def `init`(`self`, `name`, `connection`=`None`):

def `repr`(`self`):

def `str`(`self`):

def `eq`(`self`, `other`):

def `ne`(`self`, `other`):

def `hash`(`self`):

def `iternames`(`cls`, `connection`):

Generator that yields the names of all users

def `iterobjects`(`cls`, `connection`):

Generator that yields all user objects.

class `OracleConnection`(`ll.url.Connection`):

def `init`(`self`, `context`, `connection`, `mode`):

def `open`(`self`, `url`, `mode`=`'rb'`):

def `close`(`self`):

def `_type`(`self`, `url`):

def `_infofromurl`(`self`, `url`):

def `_objectfromurl`(`self`, `url`):

def `isdir`(`self`, `url`):

def `isfile`(`self`, `url`):

def `mimetype`(`self`, `url`):

def `owner`(`self`, `url`):

def `cdate`(`self`, `url`):

def `mdate`(`self`, `url`):

def `_listdir`(`self`, `url`, `pattern`=`None`, `files`=`True`, `dirs`=`True`):

def `listdir`(`self`, `url`, `pattern`=`None`):

def `files`(`self`, `url`, `pattern`=`None`):

def `dirs`(`self`, `url`, `pattern`=`None`):

def `repr`(`self`):

class `OracleFileResource`(`ll.url.Resource`):

An OracleFileResource wraps an Oracle database object (like a table, view, function, procedure etc.) in a file-like API.

def `init`(`self`, `connection`, `url`, `mode`=`'rb'`):

def `read`(`self`, `size`=`-1`):

def `write`(`self`, `data`):

def `mimetype`(`self`):

def `cdate`(`self`):

def `mdate`(`self`):

def `close`(`self`):

class `OracleSchemeDefinition`(`ll.url.SchemeDefinition`):

ll.orasql

Utilities for working with cx_Oracle

class SQLObjectNotFoundError​(IOError):

def __init__​(self, obj):

class SQLNoSuchObjectError​(Exception):

def __init__​(self, name, owner):

def __repr__​(self):

def __str__​(self):

class UnknownModeError​(ValueError):

def __init__​(self, mode):

def __repr__​(self):

def __str__​(self):

class ConflictError​(ValueError):

def __init__​(self, object, message):

def __repr__​(self):

def __str__​(self):

class Args​(dict):

def __init__​(self, arg=None, **kwargs):

def update​(self, arg=None, **kwargs):

def __getitem__​(self, name):

def __setitem__​(self, name, value):

def __delitem__​(self, name):

def __getattr__​(self, name):

def __setattr__​(self, name, value):

def __delattr__​(self, name):

def __repr__​(self):

class CLOBStream​(object):

def __init__​(self, value, encoding):

def readall​(self):

def readchunk​(self):

def read​(self, size=None):

def reset​(self):

class BLOBStream​(object):

def __init__​(self, value):

def readall​(self):

def readchunk​(self):

def read​(self, size=None):

def reset​(self):

def _decodeclob​(value, encoding, readlobs):

def _decodeblob​(value, readlobs):

class RecordMaker​(object):

def __init__​(self, cursor):

def __call__​(self, *row):

def STRING​(self, value):

def LONG_STRING​(self, value):

def FIXED_CHAR​(self, value):

def CLOB​(self, value):

def NCLOB​(self, value):

def BLOB​(self, value):

def DEFAULT​(self, value):

class Record​(tuple):

def __getitem__​(self, arg):

def __getattr__​(self, name):

def get​(self, name, default=None):

def __contains__​(self, name):

def iterkeys​(self):

def keys​(self):

def items​(self):

def iteritems​(self):

def __repr__​(self):

class SessionPool​(OracleSessionPool):

def __init__​(self, user, password, database, min, max, increment, connectiontype=None, threaded=False, getmode=1, homogeneous=True):

def connectstring​(self):

def __repr__​(self):

class Connection​(cx_Oracle.Connection):

def __init__​(self, *args, **kwargs):

def connectstring​(self):

def cursor​(self, readlobs=None):

def __repr__​(self):

def itertables​(self, owner=<object object at 0xf67a2c80>, mode='flat'):

def itersequences​(self, owner=<object object at 0xf67a2c80>):

def iterfks​(self, owner=<object object at 0xf67a2c80>):

def iterprivileges​(self, owner=<object object at 0xf67a2c80>):

def iterusers​(self):

def iterobjects​(self, owner=<object object at 0xf67a2c80>, mode='create'):

def _getobject​(self, name, owner=None):

def getobject​(self, name, owner=None):

def connect​(*args, **kwargs):

class Cursor​(OracleCursor):

def __init__​(self, connection, readlobs=None):

Utilities for working with `cx_Oracle`

class `SQLObjectNotFoundError`(`IOError`):

def `init`(`self`, `obj`):

class `SQLNoSuchObjectError`(`Exception`):

def `init`(`self`, `name`, `owner`):

def `repr`(`self`):

def `str`(`self`):

class `UnknownModeError`(`ValueError`):

def `init`(`self`, `mode`):

def `repr`(`self`):

def `str`(`self`):

class `ConflictError`(`ValueError`):

def `init`(`self`, `object`, `message`):

def `repr`(`self`):

def `str`(`self`):

class `Args`(`dict`):

def `init`(`self`, `arg`=`None`, **`kwargs`):

def `update`(`self`, `arg`=`None`, **`kwargs`):

def `getitem`(`self`, `name`):

def `setitem`(`self`, `name`, `value`):

def `delitem`(`self`, `name`):

def `getattr`(`self`, `name`):

def `setattr`(`self`, `name`, `value`):

def `delattr`(`self`, `name`):

def `repr`(`self`):

class `CLOBStream`(`object`):

def `init`(`self`, `value`, `encoding`):

def `readall`(`self`):

def `readchunk`(`self`):

def `read`(`self`, `size`=`None`):

def `reset`(`self`):

class `BLOBStream`(`object`):

def `init`(`self`, `value`):

def `readall`(`self`):

def `readchunk`(`self`):

def `read`(`self`, `size`=`None`):

def `reset`(`self`):

def `_decodeclob`(`value`, `encoding`, `readlobs`):

def `_decodeblob`(`value`, `readlobs`):

class `RecordMaker`(`object`):

def `init`(`self`, `cursor`):

def `call`(`self`, *`row`):

def `STRING`(`self`, `value`):

def `LONG_STRING`(`self`, `value`):

def `FIXED_CHAR`(`self`, `value`):

def `CLOB`(`self`, `value`):

def `NCLOB`(`self`, `value`):

def `BLOB`(`self`, `value`):

def `DEFAULT`(`self`, `value`):

class `Record`(`tuple`):

def `getitem`(`self`, `arg`):

def `getattr`(`self`, `name`):

def `get`(`self`, `name`, `default`=`None`):

def `contains`(`self`, `name`):

def `iterkeys`(`self`):

def `keys`(`self`):

def `items`(`self`):

def `iteritems`(`self`):

def `repr`(`self`):

class `SessionPool`(`OracleSessionPool`):

def `init`(`self`, `user`, `password`, `database`, `min`, `max`, `increment`, `connectiontype`=`None`, `threaded`=`False`, `getmode`=`1`, `homogeneous`=`True`):

def `connectstring`(`self`):

def `repr`(`self`):

class `Connection`(`cx_Oracle.Connection`):

def `init`(`self`, *`args`, **`kwargs`):

def `connectstring`(`self`):

def `cursor`(`self`, `readlobs`=`None`):

def `repr`(`self`):

def `itertables`(`self`, `owner`=`<object object at 0xf67a2c80>`, `mode`=`'flat'`):

def `itersequences`(`self`, `owner`=`<object object at 0xf67a2c80>`):

def `iterfks`(`self`, `owner`=`<object object at 0xf67a2c80>`):

def `iterprivileges`(`self`, `owner`=`<object object at 0xf67a2c80>`):

def `iterusers`(`self`):

def `iterobjects`(`self`, `owner`=`<object object at 0xf67a2c80>`, `mode`=`'create'`):

def `_getobject`(`self`, `name`, `owner`=`None`):

def `getobject`(`self`, `name`, `owner`=`None`):

def `connect`(*`args`, **`kwargs`):

class `Cursor`(`OracleCursor`):

def `init`(`self`, `connection`, `readlobs`=`None`):

def `ddprefix`(`self`):