sqlalchemy-pytibero 0.3.0

Tibero dialect for SQLAlchemy

sqlalchemy-pytibero

SQLAlchemy 2.0 dialect for the Tibero database, backed by pytibero.

Installation

pip install sqlalchemy-pytibero

With DB-API dependency:

pip install "sqlalchemy-pytibero[pytibero]"

Quick Start

from sqlalchemy import create_engine, text

engine = create_engine("tibero://tibero:password@localhost:8629/TESTDB")

with engine.connect() as conn:
    value = conn.execute(text("SELECT 1 FROM DUAL")).scalar()
    print(value)

Alembic Support

This dialect includes an Alembic implementation. After installing, Alembic migrations work out of the box:

# alembic.ini
sqlalchemy.url = tibero://tibero:password@localhost:8629/TESTDB

alembic upgrade head

Note: Tibero DDL is auto-committed, so transactional_ddl = False.

Architecture

flowchart TD
    app["Application"] --> sa["SQLAlchemy Core/ORM"]
    sa --> dialect["TiberoDialect"]
    dialect --> dbapi["pytibero"]
    dbapi --> server["Tibero Server"]

Development

make lint
make test

License

MIT