Oracle¶

Installation¶

You have to make sure that the Oracle Instant Client (sqlplus64) is installed.

On Mac, follow these instructions. Then sudo ln -s /usr/local/bin/sqlplus /usr/local/bin/sqlplus64 to make the binary accessible as sqlplus64.

Configuration examples¶

import mara_db.dbs
mara_db.config.databases = lambda: {
    'dwh': mara_db.dbs.OracleDB(
        host='localhost',
        user='root',
        password='<my_strong_password>',
        endpoint='oracle-endpoint'),
}

API reference¶

This section contains database specific API in the module.

Configuration¶

class mara_db.dbs.OracleDB(host: Optional[str] = None, port: int = 0, endpoint: Optional[str] = None, user: Optional[str] = None, password: Optional[str] = None)¶

__init__(host: Optional[str] = None, port: int = 0, endpoint: Optional[str] = None, user: Optional[str] = None, password: Optional[str] = None)¶

property sqlalchemy_url¶: Returns the SQLAlchemy url for a database