sqlalchemy-firebirdsql 0.1.0

Examples

Local server, default port:

firebirdsql+syn://sysdba:masterkey@localhost//home/me/databases/my_project.fdb

Remote server on port 3050:

firebirdsql+syn://sysdba:masterkey@example.com:3050//srv/databases/my_project.fdb

Synchronous

from sqlalchemy import create_engine, text

engine = create_engine(
    "firebirdsql+syn://sysdba:masterkey@localhost//home/me/databases/my_project.fdb",
    echo=True,
)

with engine.connect() as conn:
    result = conn.execute(text("select 1 from rdb$database"))
    print(result.scalar())

Asynchronous

import asyncio
from sqlalchemy import text
from sqlalchemy.ext.asyncio import create_async_engine

engine = create_async_engine(
    "firebirdsql+asyn://sysdba:masterkey@localhost//home/me/databases/my_project.fdb",
    echo=True,
)

async def main():
    async with engine.connect() as conn:
        result = await conn.execute(text("select 1 from rdb$database"))
        print(result.scalar())

asyncio.run(main())

Clone and install

git clone git@github.com:nakagami/sqlalchemy_firebirdsql.git
cd sqlalchemy_firebirdsql
python3 -m venv .venv
. .venv/bin/activate
pip install -e .
pip install pytest

Create test database and execute pytest

prepare-test-environment
pytest --db syn
pytest --db asyn