def databases_implementation():
engine, database = _setup_database()
metadata = MetaData()
potatoes = Table(
"potatoes",
metadata,
Column("id", Integer, primary_key=True),
Column("thickness", Float),
Column("mass", Float),
Column("color", String),
Column("type", String),
)
carrots = Table(
"carrots",
metadata,
Column("id", Integer, primary_key=True),
Column("length", Float),
Column("color", String),
)
metadata.create_all(bind=engine)
app = FastAPI()
@app.on_event("startup")
async def startup():
await database.connect()
@app.on_event("shutdown")
async def shutdown():
await database.disconnect()
potato_router = DatabasesCRUDRouter(
database=database,
table=potatoes,
schema=Potato,
prefix="potato",
paginate=PAGINATION_SIZE,
)
carrot_router = DatabasesCRUDRouter(
database=database,
table=carrots,
schema=Carrot,
create_schema=CarrotCreate,
update_schema=CarrotUpdate,
prefix="carrot",
tags=CUSTOM_TAGS,
)
app.include_router(potato_router)
app.include_router(carrot_router)
return app
def databases_implementation_custom_ids():
engine, database = _setup_database()
metadata = MetaData()
potatoes = Table(
"potatoes",
metadata,
Column("potato_id", Integer, primary_key=True),
Column("thickness", Float),
Column("mass", Float),
Column("color", String),
Column("type", String),
)
metadata.create_all(bind=engine)
app = FastAPI()
@app.on_event("startup")
async def startup():
await database.connect()
@app.on_event("shutdown")
async def shutdown():
await database.disconnect()
potato_router = DatabasesCRUDRouter(database=database,
table=potatoes,
schema=CustomPotato)
app.include_router(potato_router)
return app
def databases_implementation_string_pk():
engine, database = _setup_database()
metadata = MetaData()
potato_types = Table(
"potato_type",
metadata,
Column("name", String, primary_key=True),
Column("origin", String),
)
metadata.create_all(bind=engine)
app = FastAPI()
@app.on_event("startup")
async def startup():
await database.connect()
@app.on_event("shutdown")
async def shutdown():
await database.disconnect()
potato_router = DatabasesCRUDRouter(
database=database,
table=potato_types,
schema=PotatoType,
create_schema=PotatoType,
)
app.include_router(potato_router)
return app