FastAPI SQLAlchemy Toolkit

FastAPI SQLAlchemy Toolkit — a library for the FastAPI + Async SQLAlchemy stack that helps solve the following tasks:

• reducing the amount of templated, copy-pasted code that arises when developing REST APIs and interacting with databases through SQLAlchemy;

• automatic validation of values at the database level when creating and modifying objects through the API.

To achieve this, FastAPI SQLAlachemy Toolkit provides the fastapi_sqlalchemy_toolkit.ModelManager manager class for interacting with the SQLAlchemy.

Features

• Methods for CRUD operations with objects in the database

• Filtering with optional query parameters handling (see the Filtering section)

Declarative sorting using ordering_dep (see the Sorting section)

• Validation of foreign key existence

• Validation of unique constraints

• Simplification of CRUD actions with M2M relationships

Installation

pip install fastapi-sqlalchemy-toolkit

Demonstration

Example of fastapi-sqlalchemy-toolkit usage in FastAPI app:

https://github.com/e-kondr01/fastapi-sqlalchemy-toolkit/tree/master/examples/app

Read More

• Usage
• Filtering
• Sorting
• Transactions
• Database-Level Validation
• Extension
• Other utilities