62 lines
1.8 KiB
Python
62 lines
1.8 KiB
Python
"""FastAPI CRUD — yksi endpoint-setti per entiteetti."""
|
|
|
|
from fastapi import FastAPI, Depends, HTTPException
|
|
from sqlalchemy.orm import Session
|
|
|
|
from models import SessionLocal, Todo
|
|
from schemas import TodoCreate, TodoResponse
|
|
|
|
app = FastAPI()
|
|
|
|
|
|
def get_db():
|
|
"""Tietokantasessio per pyyntö."""
|
|
db = SessionLocal()
|
|
try:
|
|
yield db
|
|
finally:
|
|
db.close()
|
|
|
|
|
|
@app.post("/todos/", response_model=TodoResponse, status_code=201)
|
|
def create_todo(item: TodoCreate, db: Session = Depends(get_db)):
|
|
db_item = Todo(**item.model_dump())
|
|
db.add(db_item)
|
|
db.commit()
|
|
db.refresh(db_item)
|
|
return db_item
|
|
|
|
|
|
@app.get("/todos/", response_model=list[TodoResponse])
|
|
def list_todos(db: Session = Depends(get_db)):
|
|
return db.query(Todo).all()
|
|
|
|
|
|
@app.get("/todos/{item_id}", response_model=TodoResponse)
|
|
def get_todo(item_id: int, db: Session = Depends(get_db)):
|
|
item = db.query(Todo).filter(Todo.id == item_id).first()
|
|
if not item:
|
|
raise HTTPException(status_code=404, detail="Todo not found")
|
|
return item
|
|
|
|
|
|
@app.put("/todos/{item_id}", response_model=TodoResponse)
|
|
def update_todo(item_id: int, item: TodoCreate, db: Session = Depends(get_db)):
|
|
db_item = db.query(Todo).filter(Todo.id == item_id).first()
|
|
if not db_item:
|
|
raise HTTPException(status_code=404, detail="Todo not found")
|
|
for key, value in item.model_dump().items():
|
|
setattr(db_item, key, value)
|
|
db.commit()
|
|
db.refresh(db_item)
|
|
return db_item
|
|
|
|
|
|
@app.delete("/todos/{item_id}", status_code=204)
|
|
def delete_todo(item_id: int, db: Session = Depends(get_db)):
|
|
db_item = db.query(Todo).filter(Todo.id == item_id).first()
|
|
if not db_item:
|
|
raise HTTPException(status_code=404, detail="Todo not found")
|
|
db.delete(db_item)
|
|
db.commit()
|