from typing import List from fastapi import APIRouter, Depends, HTTPException, status from sqlalchemy.orm import Session from app.db import get_db from app.models import Post from app.schemas import PostCreate, PostResponse router = APIRouter( prefix="/posts", tags=["Posts"], @router.post("/", response_model=PostResponse, status_code=status.HTTP_201_CREATED) def create_post(post: PostCreate, db: Session = Depends(get_db)): new_post = Post(**post.dict()) db.add(new_post) db.commit() db.refresh(new_post) return new_post @router.get("/", response_model=List[PostResponse]) def get_all_posts(db: Session = Depends(get_db)): posts = db.query(Post).all() return posts @router.get("/{post_id}", response_model=PostResponse) def get_post(post_id: int, db: Session = Depends(get_db)): post = db.query(Post).filter(Post.id == post_id).first() if not post: raise HTTPException(status_code=status.HTTP_404_NOT_FOUND, detail="Post not found") return post @router.put("/{post_id}", response_model=PostResponse) def update_post(post_id: int, post: PostCreate, db: Session = Depends(get_db)): db_post = db.query(Post).filter(Post.id == post_id).first() if not db_post: raise HTTPException(status_code=status.HTTP_404_NOT_FOUND, detail="Post not found") update_data = post.dict(exclude_unset=True) for key, value in update_data.items(): setattr(db_post, key, value) db.commit() db.refresh(db_post) return db_post @router.delete("/{post_id}", status_code=status.HTTP_204_NO_CONTENT) def delete_post(post_id: int, db: Session = Depends(get_db)): post = db.query(Post).filter(Post.id == post_id).first() if not post: raise HTTPException(status_code=status.HTTP_404_NOT_FOUND, detail="Post not found") db.delete(post) db.commit() return This file defines the following endpoints: Note that you'll need to define the `Post` model and `PostCreate` and `PostResponse` schemas in separate files (`models.py` and `schemas.py`, respectively) for this code to work.