File size: 2,278 Bytes
cf699d4 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 | from sqlmodel import Session, select
from ..models.task import Task, TaskCreate, TaskUpdate
from typing import List, Optional
class TaskService:
"""Service class for task-related operations"""
@classmethod
def create_task(cls, db: Session, task: TaskCreate, user_id: str) -> Task:
"""Create a new task for a specific user"""
db_task = Task(**task.model_dump(), user_id=user_id)
db.add(db_task)
db.commit()
db.refresh(db_task)
return db_task
@classmethod
def get_task_by_id(cls, db: Session, task_id: int, user_id: str) -> Task:
"""Retrieve a specific task by ID for a specific user"""
statement = select(Task).where(Task.id == task_id, Task.user_id == user_id)
return db.exec(statement).first()
@classmethod
def get_tasks_for_user(cls, db: Session, user_id: str, skip: int = 0, limit: int = 100) -> List[Task]:
"""Retrieve all tasks for a specific user with pagination"""
statement = select(Task).where(Task.user_id == user_id).offset(skip).limit(limit)
return db.exec(statement).all()
@classmethod
def update_task(cls, db: Session, task_id: int, task_update: TaskUpdate, user_id: str) -> Optional[Task]:
"""Update a specific task for a specific user"""
db_task = cls.get_task_by_id(db, task_id, user_id)
if not db_task:
return None
update_data = task_update.model_dump(exclude_unset=True)
for field, value in update_data.items():
setattr(db_task, field, value)
db.add(db_task)
db.commit()
db.refresh(db_task)
return db_task
@classmethod
def delete_task(cls, db: Session, task_id: int, user_id: str) -> bool:
"""Delete a specific task for a specific user"""
db_task = cls.get_task_by_id(db, task_id, user_id)
if not db_task:
return False
db.delete(db_task)
db.commit()
return True
@classmethod
def get_tasks_by_status(cls, db: Session, user_id: str, status: str) -> List[Task]:
"""Retrieve tasks for a user filtered by status"""
statement = select(Task).where(Task.user_id == user_id, Task.status == status)
return db.exec(statement).all()
|