Fastapi-crudrouter

🎉 Highlights
With the release of v0.8.5 fastapi-crudrouter now officially supports both **Python 3.10** and **typed python**. This release also includes significant improvements to the documentation, test suite, and developer experience.

Keep an eye of for the next release which will contain support for **async SQLAlchemy** (122).

Big thanks to all contributors that made this possible!

✨ Features
- Typed python support 132 111
- Python 3.10 support 114
- Test suite now runs against multiple databases 86
- Documentation improvements 79 91 117 123 124 125 andrewthetechie
- More informative exceptions 94 137
- General test suite improvements 96 97

🐛 Bug Fixes
- OrderBy not working correctly with Microsoft SQL Server 88
- 404 response not documented in OpenAPI spec 104 sondrelg
- DatabasesCRUDRouter not functioning for inserts and deletes with AsyncPG 98

**Full Changelog**: https://github.com/awtkns/fastapi-crudrouter/compare/v0.8.0...v0.8.5

🎉 Highlights
With the release of v0.6.0 fastapi-crudrouter **now supports [Gino](https://github.com/python-gino/gino)** as an async backend! When generating routes, GinoCRUDRouter will automatically tie into your database using your Gino models. To use it, simply pass your Gino database model, a database reference, and your pydantic.

python
GinoCRUDRouter(
schema=MyPydanticModel,
db_model=MyModel,
db=db
)


Check out the [docs](https://fastapi-crudrouter.awtkns.com/backends/gino.html) for more details on how to use the GinoCRUDRouter.

✨ Features
- Full Gino Support Turall 78
- Documentation improvements 69 75

🐛 Bug Fixes
- All Path Prefixes are now correctly lowercase 64 65

🎉 Highlights
With the release of v0.7.0 fastapi-crudrouter now provides the ability to set custom dependencies on a per route basis; a much requested feature. Prior to this release, it was only possible to set dependencies for all the routes at once.

python
MemoryCRUDRouter(
schema=MySchema,
create_route=[Depends(user)],
delete_all_route=[Depends(admin)]
)


Shown above is a brief example on how limiting each route to specific access rights would work using this new feature. Check out the [docs](https://fastapi-crudrouter.awtkns.com/dependencies/) for more details.

✨ Features
- Custom Dependencies Per Route 37 59 60 DorskFR jm-moreau
- Ability to Provide a List of Custom Tags for OpenAPI 57 jm-moreau
- Improved Documentation 52
- Dark Mode for Documentation

🎉 Highlights
With the release of v0.6.0 fastapi-crudrouter **now supports [ormar](https://github.com/collerek/ormar)** as an async backend! When generating routes, the OrmarCRUDRouter will automatically tie into your database using your ormar models. To use it, simply pass your ormar database model as the schema.

python
OrmarCRUDRouter(
schema=MyPydanticModel,
paginate=25
)


Check out the [docs](https://fastapi-crudrouter.awtkns.com/backends/ormar/) for more details on how to use the `OrmarCRUDRouter`.

✨ Features
- Full Ormar Support collerek 46
- Better handling of database errors in the update route sorXCode 48
- Improved typing 46 43
- Black, Flake8 and Mypy linting 46
- Additional Tests for nested models 40

🐛 Bug Fixes
- Pagination issues when max limit was set to null ethanhaid 42

🎉 Highlights
With the release of v0.5.0 all CRUDRouters **now supports pagination**. All "get all" routes now accept `skip` and `limit` query parameters allowing you to easily paginate your routes. By default, no limit is set on the number of items returned by your routes. Should you wish to limit the number of items that a client can request, it can be done as shown below.

python
CRUDRouter(
schema=MyPydanticModel,
paginate=25
)


Check out the [docs](https://fastapi-crudrouter.awtkns.com/pagination/) on pagination for more information!

✨ Features
- Pagination Support 34
- Ability to set custom update schemas andreipopovici 31 27
- Better documentation of past releases 36

🐛 Bug Fixes
- Prefixing not available for versions of fastapi below v0.62.0 29 30
- Fixed an Import Issue SQLAlchemy and Integrity Errors andreipopovici 33

✨Features
- Full support for tortoise-orm 24
- Dynamic pk/id types for get_one, delete_one, and update_one routes 26

🐛 Bug Fixes
- Fixed the summary for the delete one route 16
- Fixed import errors when certain packages are not installed 21
- Improved SQLA type hinting