firebirdsql-run 1.0.5

Firebirdsql wrapper inspired by subprocess.run

firebirdsql-run

Firebirdsql wrapper inspired by subprocess.run

Installation

pip install firebirdsql-run

Examples

Table

maker	model	type
B	1121	PC
A	1232	PC

Execute

result = execute(
    query="SELECT * FROM TABLE",
    host="localhost",
    db="fdb",
    user="sysdba",
)

if result.returncode != 0:
    log.error(result)
else:
    log.info(result)

Info result example

CompletedTransaction(
    host="localhost",
    db="fdb",
    user="sysdba",
    returncode=0,
    error="",
    query="SELECT * FROM TABLE",
    params=(),
    data=[
        {"maker": "B", "model": 1121, "type": "PC"},
        {"maker": "A", "model": 1232, "type": "PC"},
    ],
)

Error result example

CompletedTransaction(
    host="localhost",
    db="fdb",
    user="sysdba",
    returncode=1,
    error="Dynamic SQL Error\nSQL error code = -204\nTable unknown\nTABLE\nAt line 1, column 15\n",
    query="SELECT * FROM TABLE",
    params=(),
    data=[],
)

Reuse connection

conn = connection(host="localhost", db="fdb", user="sysdba")

execute(use_conn=conn, query="SELECT * FROM TABLE")
...
callproc(use_conn=conn, procname="PROCNAME", params=(...))
...

conn.close()

Env variables

FIREBIRD_KEY=

The FIREBIRD_KEY environment variable can be overridden with the function argument passwd.