Ready-to-go SQLAlchemy concoctions.
Project description
Advanced Alchemy
About
A carefully crafted, thoroughly tested, optimized companion library for SQLAlchemy, offering features such as:
-
Sync and async repositories, featuring common CRUD and highly optimized bulk operations
-
Integration with major web frameworks including Litestar, Starlette, FastAPI, Sanic.
-
Custom-built alembic configuration and CLI with optional framework integration
-
Utility base classes with audit columns, primary keys and utility functions
-
Optimized JSON types including a custom JSON type for Oracle.
-
Pre-configured base classes with audit columns UUID or Big Integer primary keys and a sentinel column.
-
Synchronous and asynchronous repositories featuring:
- Common CRUD operations for SQLAlchemy models
- Bulk inserts, updates, upserts, and deletes with dialect-specific enhancements
- lambda_stmt when possible for improved query building performance
- Integrated counts, pagination, sorting, filtering with
LIKE
,IN
, and dates before and/or after.
-
Tested support for multiple database backends including:
- SQLite via aiosqlite or sqlite
- Postgres via asyncpg or psycopg3 (async or sync)
- MySQL via asyncmy
- Oracle via oracledb
- Google Spanner via spanner-sqlalchemy
- DuckDB via duckdb_engine
Usage
Litestar
[!NOTE]
This section has not been completed (yet!)
Starlette/FastAPI
[!NOTE]
This section has not been completed (yet!)
Sanic
[!NOTE]
This section has not been completed (yet!)
Contributing
[!NOTE]
This section has not been completed (yet!)
A Jolt Organization Project
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for advanced_alchemy-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7fee516ecc7acd45e8f3739aa193b26526012557c1ad0a75542fad77501a5ceb |
|
MD5 | 17e37004e9e7b459961d756ed90fb6a3 |
|
BLAKE2b-256 | ab280f2069f324dff1db01031ed3168362d0a286a740c47c250e7a97e8850a4d |