Generate CRUD routers for you schema in a simple way
Project description
FastAPI Simple CRUD Generator
Repository
Installation
pip install fastapi-simple-crud
Description
A package to generate a CRUD routers and endpoints in a very simple way. Based on SQLAlchemy asynchronous operation and schema.
How to use ?
from fastapi import FastAPI
from typing import Optional
from sqlalchemy import Column, ForeignKey, Integer, String
from sqlalchemy.orm import relationship
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.ext.asyncio import AsyncSession, create_async_engine
from sqlalchemy.orm import sessionmaker
from fastapi_simple_crud import SimpleCRUDGenerator, RouterMap
engine = create_async_engine("sqlite+aiosqlite:///./test.db", echo=True, future=True)
async_session = sessionmaker(engine, class_=AsyncSession, expire_on_commit=False)
Base = declarative_base()
async def get_session() -> AsyncSession:
async with async_session() as session:
yield session
class Country(Base):
__tablename__ = "country"
id = Column(Integer, primary_key=True, index=True, autoincrement=True)
name = Column(String(100), nullable=False)
class President(Base):
__tablename__ = "president"
id = Column(Integer, primary_key=True, index=True)
name = Column(String, nullable=False)
country_id = Column(Integer, ForeignKey("country.id"))
country = relationship("Country")
class People(Base):
__tablename__ = "people"
id = Column(Integer, primary_key=True, index=True)
name = Column(String, nullable=False)
age = Column(Integer)
country_id = Column(Integer, ForeignKey("country.id"))
country = relationship("Country")
app = FastAPI()
@app.on_event("startup")
async def startup():
async with engine.begin() as conn:
await conn.run_sync(Base.metadata.create_all)
## ULTRA SIMPLE OH MY GOD!
RouterMap.create_router_map_from_base(base=Base)
crudGenerator = SimpleCRUDGenerator(application=app, session_getter=get_session)
Results
- your endpoints
- your pydantic schema
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
fastapi-simple-crud-0.0.6.tar.gz
(113.9 kB
view hashes)
Built Distribution
Close
Hashes for fastapi-simple-crud-0.0.6.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 37f031621a7ee3cf759bd66628f01f80a2d809247766197e0f4274cec8741ffe |
|
MD5 | aefa4beed668b51f73df57fa41dacfdc |
|
BLAKE2b-256 | 27daa9b4004c76a0a21d27096171b00b0f98a1d37cfa644b73fb303ecacd256a |
Close
Hashes for fastapi_simple_crud-0.0.6-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d72b0d77f6f3c4cee6cd0f293affe28c748a4b70967486fcc20ed817a045e244 |
|
MD5 | a13ad54e08cbf9e105b75929adcaa23b |
|
BLAKE2b-256 | 931eedec028adefd180b8f709ce3d82cece5ad324d3316d82f2edbf06a0481a0 |