Metadata-Version: 2.5
Name: nyssa-ai-dbgateway
Version: 0.1.1
Summary: Zero-ceremony, typed database gateway across SQLite and PostgreSQL matching NyssaAI.DbGateway
Project-URL: Homepage, https://github.com/NyssaAI/NyssaAI.Shared
Project-URL: Repository, https://github.com/NyssaAI/NyssaAI.Shared.git
Project-URL: Issues, https://github.com/NyssaAI/NyssaAI.Shared/issues
Author-email: NyssaAI <oss@nyssa.ai>
License: Apache-2.0
Keywords: database,gateway,migrations,postgres,postgresql,sqlite
Classifier: Development Status :: 4 - Beta
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: Apache Software License
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.12
Classifier: Programming Language :: Python :: 3.13
Classifier: Topic :: Database
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Classifier: Typing :: Typed
Requires-Python: >=3.12
Requires-Dist: psycopg[binary]>=3.2.0
Provides-Extra: dev
Requires-Dist: mypy>=1.9.0; extra == 'dev'
Requires-Dist: pytest-cov>=4.0.0; extra == 'dev'
Requires-Dist: pytest>=8.0.0; extra == 'dev'
Requires-Dist: ruff>=0.3.0; extra == 'dev'
Description-Content-Type: text/markdown

# nyssa-ai-dbgateway (Python)

Zero-ceremony, typed database gateway across SQLite and PostgreSQL matching `NyssaAI.DbGateway` (.NET) and `@nyssa-ai/db-gateway` (TypeScript).

## Features

- **Zero-Ceremony Gateway**: Single `DbGateway` interface (`execute`, `scalar`, `query`, `query_single`).
- **Engine-Agnostic Coercion**: Write `@param` placeholders in SQL across SQLite and PostgreSQL.
- **Typed Commands & Queries**: First-class `DbCommand[TResult]`, `DbNonQuery`, and `DbQuery[TRow]`.
- **Automatic Transactions**: `client.begin_transaction()` and `client.execute_transaction(lambda tx: ...)`.
- **Paired & Universal Migrations**: Dual-engine schema migrations with SHA-256 fingerprint verification and PostgreSQL session advisory locks.
