fusetools.db_conn_tools.Oracle

class fusetools.db_conn_tools.Oracle

Bases: object

Oracle database connections.

Methods

con_oracle	Create an Oracle connection object.
eng_oracle	Create an Oracle database engine object using SqlAlchemy.
eng_oracle_addr	Create an Oracle database engine object using JDBC.

classmethod con_oracle(usr, pwd, dbname)

Create an Oracle connection object.

Parameters

• usr – Oracle username.

• pwd – Oracle password.

Returns

Oracle database connection object.

classmethod eng_oracle(usr, pwd, dbname)

Create an Oracle database engine object using SqlAlchemy.

Parameters

• usr – Oracle username.

• pwd – Oracle password.

Returns

Oracle database engine object.

classmethod eng_oracle_addr(usr, pwd, host, port, dbname)

Create an Oracle database engine object using JDBC. Requires cx_oracle package.

Parameters

• usr – Oracle username.

• pwd – Oracle password.

Returns

Oracle database engine object.