Python DatabaseSession.query Examples

Example #1

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,
    }

Example #2

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,
    }

Example #3

async def get(book_id: int, db: DatabaseSession = Depends(get_db)):
    return db.query(Book).filter(Book.id == book_id).first()

Example #4

async def index(db: DatabaseSession = Depends(get_db)):
    return db.query(Book).order_by(desc(Book.id)).all()