Oracle 🔗

Supported drivers:

dbapi	default	driver	connection class
oracledb		`oracle+oracledb`	`oracledb.Connection`

oracledb🔗

oracledb is the default dbapi driver for Oracle in pydapper.

Installation🔗

pippoetry

pip install pydapper[oracledb]

poetry add pydapper -E oracledb

DSN format🔗

TemplateExampleExample (Default Driver)

dsn = f"oracle+oracledb://{user}:{password}@{host}:{port}/{servicename}"

dsn = "oracle+oracledb://myuser:mypassword:1521@localhost/myservicename"

dsn = "oracle://myuser:mypassword:1521@localhost/myservicename"

Note

You connect to oracledb in pydapper using service names

Example - `connect`🔗

Please see the oracledb docs for a full description of context manager behavior.

import pydapper

with pydapper.connect("oracle+oracledb://pydapper:pydapper@localhost:1522/pydapper") as commands:
    print(type(commands))
    # <class 'pydapper.oracle.oracledb.OracledbCommands'>

    print(type(commands.connection))
    # <class 'oracledb.Connection'>

    with commands.cursor() as raw_cursor:
        print(type(raw_cursor))
        # <class 'oracledb.Cursor'>

Example - `using`🔗

Use pydapper with a oracledb connection pool.

from oracledb import create_pool

import pydapper

my_pool = create_pool(user="pydapper", password="pydapper", dsn="localhost:1522/pydapper")


commands = pydapper.using(my_pool.acquire())
print(type(commands))
# <class 'pydapper.oracle.oracledb.OracledbCommands'>

print(type(commands.connection))
# <class 'oracledb.Connection'>

my_pool.release(commands.connection)

Oracle🔗