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 .dependencies.simpleCRUD 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.4.tar.gz
(113.9 kB
view hashes)
Built Distribution
Close
Hashes for fastapi-simple-crud-0.0.4.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | def9ba6d14dfd5a01ab0802b834377b2fb8428f5edfaea55b066675b8c97f012 |
|
MD5 | 821023e6d36a578bf5cecbad0e42faa9 |
|
BLAKE2b-256 | 3b5b0560f4f5d60f557414d708e12a04bd557da6a7bc7f92ccdee2d89a671915 |
Close
Hashes for fastapi_simple_crud-0.0.4-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 87f72a8af3be092597109360b0c7ae9183d494627c8127997dd30401cad3c7db |
|
MD5 | b6adc67e59f73b9e20566109c9526cb2 |
|
BLAKE2b-256 | 2fe9f33711c48be7c1152afded325fcf71feb9f43e000fcd7530a33d6ce79dc6 |