🚀 Manage database models with FastAPI CLI

[antonintouron]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched in the documentation/README.
• I already searched in Google "How to do X" and didn't find any information.
• I already read and followed all the tutorial in the docs/README and didn't find an answer.

Commit to Help

• I commit to help with one of those options 👆

Example Code

# Create SQLAlchemy database from configuration
fastapi sqlalchemy:database:create

# Delete SQLAlchemy database from configuration
fastapi sqlalchemy:database:drop

# Make Sqlalchemy model class
# This request prompt from user and create sqlalchemy model
# It also can be auto create pydantic schema, controller, router, etc...
fastapi make:sqlalchemy:model

> Class name of the model to create :
...
> New property name :
...
> Field type (enter ? to see all types) [string]:
...
> Field length [255]:
...
> Can this field be null in the database (nullable) (yes/no) [no]:
...
> New property name (press <return> to stop adding fields):
... etc ...

# Make migration with alembic (internal)
fastapi make:sqlalchemy:migration

# Run migrations with alembic (internal)
fastapi sqlalchemy:migrations:migrate

Description

Create a FastAPI CLI commands to manage database with SQLAlchemy and more ORM (and ODM ?).
Add commands to improve productivity with FastAPI applications.
Create database, drop database, create models, update models, manage relationships, auto create migrations, run migrations and more (like generate controllers, routers, etc...).

Operating System

Linux, Windows, macOS

Operating System Details

All operating systems

Python Version

3.10

Additional Context

No response