sqlalchemy-pyaltibase 0.3.0

Altibase dialect for SQLAlchemy

sqlalchemy-pyaltibase

SQLAlchemy 2.0 dialect for the Altibase database, backed by pyaltibase.

Installation

pip install sqlalchemy-pyaltibase

With DB-API dependency:

pip install "sqlalchemy-pyaltibase[pyaltibase]"

Quick Start

from sqlalchemy import create_engine, text

engine = create_engine("altibase://user:password@localhost:20300/mydb")

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 = altibase://user:password@localhost:20300/mydb

alembic upgrade head

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

Architecture

flowchart TD
    app["Application"] --> sa["SQLAlchemy Core/ORM"]
    sa --> dialect["AltibaseDialect"]
    dialect --> dbapi["pyaltibase"]
    dbapi --> server["Altibase Server"]

Development

make lint
make test

License

MIT