Python ORM for the Oracle Database

Synopsis • Installation • Examples • Documentation

Synopsis

Sibilla is a Python ORM solution for the Oracle Database. It has been designed with the goal of making database access as Pythonic as possible. SQL queries and PL/SQL code blocks are aliens in Python sources. With Sibilla you can access table content and call PL/SQL code in a Pythonic way.

Internally, Sibilla relies on the cx_Oracle package to perform queries against the Oracle Data Dictionaries to retrieve stored objects and the data they contain.

Installation

Sibilla can be installed directly from PyPI

python3 -m pip install sibilla --upgrade

Alternatively, it can be installed with pip from GitHub with

python3 -m pip install git+https://github.com/P403n1x87/sibilla

Example

A minimal example to connect to a database and access a table called CUSTOMER is

from sibilla import OracleDB


db = OracleDB("username", "password", dsn="dsn")
customer_table = db.customer

If the customer table has a primary key on a column named ID, and a column NAME, we can get the value of the latter on a row with ID 42 (assuming it exists in the database) with

>>> customer = customer_table[42]
>>> customer.name
'John Smith'

Documentation

For more examples and customisation details, please refer to the official Sibilla Documentation.

License

GPLv3.