Synopsis • Installation • Examples • Documentation
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.
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
A minimal example to connect to a database and access a table called CUSTOMER
is
from sibilla import Database
db = Database("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'
For more examples and customisation details, please refer to the official Sibilla Documentation.
GPLv3.