Skip to content
Extraits de code Groupes Projets
tasks.py 836 octets
Newer Older
  • Learn to ignore specific revisions
  • from sqlalchemy.orm import Session
    
    import models
    import schemas
    
    
    def get_tasks(db: Session, skip: int = 0):
        return db.query(models.Task).offset(skip).all()
    
    
    def get_task(db: Session, task_id: int):
        return db.query(models.Task).filter(models.Task.id == task_id).first()
    
    
    def create_task(db: Session, task: schemas.TaskCreate) -> models.Task:
        db_task = models.Task(**task.model_dump())
        db.add(db_task)
        db.commit()
        db.refresh(db_task)
        return db_task
    
    
    def update_task(db: Session, task: schemas.TaskCreate, task_id: int) -> None:
        db.query(models.Task).filter(models.Task.id == task_id).update(
            {**task.model_dump(exclude_unset=True)}
        )
        db.commit()
    
    
    def delete_task(db: Session, task_id: int) -> None:
        db.query(models.Task).filter(models.Task.id == task_id).delete()
        db.commit()