Fastapi CRUD Template Generator

Introducing FastAPI CRUD Template Generator

FastAPI CRUD Template Generator is a tool that helps developers quickly scaffold FastAPI projects with CRUD operations for their SQLAlchemy databases. It can provide a starting point for your project and can save time and effort by providing pre-written code of the CRUD operations and validation model, and a pre-defined project structureIt. The generated code can be customized to add business logic and extend the functionality of the FastAPI project. The tool supports the following APIs:

• Get one
• Get many
• Insert one
• Insert many
• Update one
• Update many
• Patch one
• Patch many
• Delete one
• Delete many

FastAPI CRUD Generator is the tool for building efficient and scalable APIs with FastAPI and SQLAlchemy. Try it now and start building your next great project.

DEMO

Features

• CRUD router code generation from SQLAlchemy declarative class definitions
• API validation model code generation
• Support for SQLAlchemy 1.4
• Pagination support for APIs
• Flexible API request handling

Quick Start with in-memory DB (or see the other (example)

Install

To get started with FastAPI CRUD Template Generator, you will need to install the package using pip:

pip install fastapi-crud-code-generator

Prepare your Sqlalchemy schema

Next, you will need to prepare your SQLAlchemy schema by defining your database tables as declarative classes. You can use the sqlacodegen tool to automatically generate these classes from your database.

from sqlalchemy import *
from sqlalchemy.orm import declarative_base

Base = declarative_base()
metadata = Base.metadata

class SampleTable(Base):
    __tablename__ = 'test_build_myself_memory'
    __table_args__ = (
        UniqueConstraint('primary_key', 'int4_value', 'float4_value'),
    )
    primary_key = Column(Integer, primary_key=True, autoincrement=True)
    bool_value = Column(Boolean, nullable=False, default=False)
    bytea_value = Column(LargeBinary)
    char_value = Column(CHAR(10, collation='NOCASE'))
    date_value = Column(Date)
    float4_value = Column(Float, nullable=False)
    float8_value = Column(Float(53), nullable=False, default=10.10)
    int2_value = Column(SmallInteger, nullable=False)
    int4_value = Column(Integer, nullable=False)
    int8_value = Column(BigInteger, default=99)
    text_value = Column(Text)
    varchar_value = Column(String)

class SampleTableTwo(Base):
    __tablename__ = 'test_build_myself_memory_two'
    primary_key = Column(Integer, primary_key=True, autoincrement=True)
    bool_value = Column(Boolean, nullable=False, default=False)
    bytea_value = Column(LargeBinary)

Generate template

Once you have your SQLAlchemy schema defined, you can use the crud_router_builder method to generate CRUD router code for your API. This method takes the declarative class definitions as input and generates code that defines the endpoints and validation models for each CRUD operation.

Here is an example of how to use the crud_router_builder method to generate CRUD router code:

from fastapi_quickcrud_codegen.db_model import DbModel
from fastapi_quickcrud_codegen.misc.type import CrudMethods

from fastapi_quickcrud_codegen import crud_router_builder

model_list = [DbModel(db_model=SampleTable, prefix="/my_first_api", tags=["sample api"],
                      exclude_columns=['bytea_value']),
              DbModel(db_model=SampleTableTwo, prefix="/my_second_api", tags=["sample api"],
                      exclude_columns=['bytea_value'],crud_methods=[CrudMethods.FIND_ONE])]
crud_router_builder(
    db_model_list=model_list,
    # is_async=True,
    # database_url="sqlite+aiosqlite://",
    is_async=False,
    database_url="sqlite://"
)

crud_router_builder args

• db_model_list [Required[List[DbModel]]]

  Model list of dict for code generate

  • List[]
    • DbModel
      • db_model [Required[DeclarativeMeta]]
      • prefix [Required[str]]

        prefix for Fastapi's end point

      • tags [Required[List[str]]]

        list of tag for Fastapi's end point

      • exclude_columns [Optional[List[str]]]

        set the columns that not to be operated but the columns should nullable or set the default value)

      • crud_methods [Opional[List[CrudMethods]]]

        • Create the following apis for that model, but default: [CrudMethods.FIND_MANY, CrudMethods.FIND_ONE, CrudMethods.CREATE_MANY, CrudMethods.PATCH_ONE, CrudMethods.PATCH_MANY, CrudMethods.PATCH_ONE, CrudMethods.UPDATE_MANY, CrudMethods.UPDATE_ONE, CrudMethods.DELETE_MANY, CrudMethods.DELETE_ONE]

        - CrudMethods.FIND_ONE
        - CrudMethods.FIND_MANY
        - CrudMethods.UPDATE_ONE
        - CrudMethods.UPDATE_MANY
        - CrudMethods.PATCH_ONE
        - CrudMethods.PATCH_MANY
        - CrudMethods.CREATE_ONE
        - CrudMethods.CREATE_MANY
        - CrudMethods.DELETE_ONE
        - CrudMethods.DELETE_MANY
        

• is_async [Required]

  True for async; False for sync

• database_url [Optional (str)]

  A database URL. The URL is passed directly to SQLAlchemy's create_engine() method so please refer to SQLAlchemy's documentation for instructions on how to construct a proper URL.

Known limitations

• ❌ Please use composite unique constraints instead of multiple unique constraints
• ❌ Composite primary key is not supported
• ❌ Sqlalchemy table type model schema is not supported

Design:

The model generation part and api router part refer to my another project; The code generation part is using Jinja

How to contribute more apis?

It will be super excited if you have any idea with api router/ model template. then you can follow the step as below to try to contribute.

1. Model generation
   1. Prepare Jinja template to fastapi-crud-project-generator/src/fastapi_quickcrud_codegen/model/template
   2. Prepare model code generation method from fastapi_quickcrud_codegen.utils.schema_builder.ApiParameterSchemaBuilder
   3. Generate the code from fastapi_quickcrud_codegen/model/model_builder.py
2. CRUD Method Generation
   1. After the model generation, you can try to build your own api by your own model
   2. Modify fastapi_quickcrud_codegen.utils.sqlalchemy_to_pydantic.sqlalchemy_to_pydantic, fastapi_quickcrud_codegen.misc.type.CrudMethods and fastapi_quickcrud_codegen.misc.crud_model.CRUDModel to let project supports your api
   3. Prepare your api router Jinja template from src/fastapi_quickcrud_codegen/model/template/route
   4. Generate the code from fastapi_quickcrud_codegen/model/crud_builder.py
   5. Update the api_register from src/fastapi_quickcrud_codegen/crud_generator.py

• use Sqlalchemy's sql.expression instead custom statement when building sql statement for your api

Road map

Current State: Stable

Will do:

• Support foreign tree in find api
• Support foreign tree in insert api
• Support foreign tree in update api
• Support foreign tree in delete api

Good to have:

• Support Sqlalchemy Table type model