lqs
d20566fe07
Some checks failed
Test / lint (push) Has been cancelled
Test / test (pydantic-v1, 3.10) (push) Has been cancelled
Test / test (pydantic-v1, 3.11) (push) Has been cancelled
Test / test (pydantic-v1, 3.12) (push) Has been cancelled
Test / test (pydantic-v1, 3.8) (push) Has been cancelled
Test / test (pydantic-v1, 3.9) (push) Has been cancelled
Test / test (pydantic-v2, 3.10) (push) Has been cancelled
Test / test (pydantic-v2, 3.11) (push) Has been cancelled
Test / test (pydantic-v2, 3.12) (push) Has been cancelled
Test / test (pydantic-v2, 3.8) (push) Has been cancelled
Test / test (pydantic-v2, 3.9) (push) Has been cancelled
Test / coverage-combine (push) Has been cancelled
Test / check (push) Has been cancelled
Issue Manager / issue-manager (push) Has been cancelled
Label Approved / label-approved (push) Has been cancelled
66 lines
1.4 KiB
Python
66 lines
1.4 KiB
Python
from typing import List
|
|
|
|
import databases
|
|
import sqlalchemy
|
|
from fastapi import FastAPI
|
|
from pydantic import BaseModel
|
|
|
|
# SQLAlchemy specific code, as with any other app
|
|
DATABASE_URL = "sqlite:///./test.db"
|
|
# DATABASE_URL = "postgresql://user:password@postgresserver/db"
|
|
|
|
database = databases.Database(DATABASE_URL)
|
|
|
|
metadata = sqlalchemy.MetaData()
|
|
|
|
notes = sqlalchemy.Table(
|
|
"notes",
|
|
metadata,
|
|
sqlalchemy.Column("id", sqlalchemy.Integer, primary_key=True),
|
|
sqlalchemy.Column("text", sqlalchemy.String),
|
|
sqlalchemy.Column("completed", sqlalchemy.Boolean),
|
|
)
|
|
|
|
|
|
engine = sqlalchemy.create_engine(
|
|
DATABASE_URL, connect_args={"check_same_thread": False}
|
|
)
|
|
metadata.create_all(engine)
|
|
|
|
|
|
class NoteIn(BaseModel):
|
|
text: str
|
|
completed: bool
|
|
|
|
|
|
class Note(BaseModel):
|
|
id: int
|
|
text: str
|
|
completed: bool
|
|
|
|
|
|
app = FastAPI()
|
|
|
|
|
|
@app.on_event("startup")
|
|
async def startup():
|
|
await database.connect()
|
|
|
|
|
|
@app.on_event("shutdown")
|
|
async def shutdown():
|
|
await database.disconnect()
|
|
|
|
|
|
@app.get("/notes/", response_model=List[Note])
|
|
async def read_notes():
|
|
query = notes.select()
|
|
return await database.fetch_all(query)
|
|
|
|
|
|
@app.post("/notes/", response_model=Note)
|
|
async def create_note(note: NoteIn):
|
|
query = notes.insert().values(text=note.text, completed=note.completed)
|
|
last_record_id = await database.execute(query)
|
|
return {**note.dict(), "id": last_record_id}
|