async def delete(book_id: int, db: DatabaseSession = Depends(get_db)): model = db.query(Book).filter(Book.id == book_id).first() db.delete(model) db.commit() return { 'id': model.id, }
async def update(book_id: int, db: DatabaseSession = Depends(get_db)): model = db.query(Book).filter(Book.id == book_id).first() model.read = True db.add(model) db.commit() return { 'id': model.id, }
async def get(book_id: int, db: DatabaseSession = Depends(get_db)): return db.query(Book).filter(Book.id == book_id).first()
async def index(db: DatabaseSession = Depends(get_db)): return db.query(Book).order_by(desc(Book.id)).all()