Oracle Async Connection

Use SQLSpec’s async Oracle adapter to fetch the current timestamp. Override credentials with SQLSPEC_ORACLE_USER, SQLSPEC_ORACLE_PASSWORD, and SQLSPEC_ORACLE_DSN.

SQLSPEC_ORACLE_USER=system SQLSPEC_ORACLE_PASSWORD=oracle SQLSPEC_ORACLE_DSN=localhost/FREE \
  uv run python docs/examples/adapters/oracledb/connect_async.py

Source

"""Async Oracle connection powered by SQLSpec."""

import asyncio
import os

from sqlspec.adapters.oracledb import OracleAsyncConfig

__all__ = ("main",)


USER = os.getenv("SQLSPEC_ORACLE_USER", "system")
PASSWORD = os.getenv("SQLSPEC_ORACLE_PASSWORD", "oracle")
DSN = os.getenv("SQLSPEC_ORACLE_DSN", "localhost/FREE")
config = OracleAsyncConfig(
    bind_key="docs_oracle_async", pool_config={"user": USER, "password": PASSWORD, "dsn": DSN, "min": 1, "max": 4}
)


async def main() -> None:
    """Connect to Oracle and print the current timestamp."""
    async with config.provide_session() as session:
        result = await session.select_one_or_none("SELECT systimestamp AS ts FROM dual")
        if result:
            print({"adapter": "oracledb", "timestamp": str(result["ts"])})
        else:
            print({"adapter": "oracledb", "timestamp": "unknown"})


if __name__ == "__main__":
    asyncio.run(main())