codeverseinnovation
update files
a7a252e
Raw History Blame Contribute Delete
3.01 kB
from sqlmodel import Session, select
from typing import List, Optional
from uuid import UUID
from datetime import datetime
from ..models.task import Task, TaskCreate
from ..models.user import User
def list_user_tasks(db: Session, user_id: UUID, skip: int = 0, limit: int = 50) -> List[Task]:
"""
List all tasks for a specific user with pagination.
"""
statement = (
select(Task)
.where(Task.user_id == user_id)
.order_by(Task.created_at.desc())
.offset(skip)
.limit(limit)
)
return db.exec(statement).all()
def get_user_task(db: Session, task_id: UUID, user_id: UUID) -> Optional[Task]:
"""
Get a specific task for a user.
Returns the task only if it belongs to the user, None otherwise.
"""
statement = select(Task).where(Task.id == task_id).where(Task.user_id == user_id)
return db.exec(statement).first()
def create_task(db: Session, task_create: TaskCreate, user_id: UUID) -> Task:
"""
Create a new task for a user.
"""
db_task = Task(
title=task_create.title,
description=task_create.description,
user_id=user_id,
is_completed=getattr(task_create, 'is_completed', False)
)
db.add(db_task)
db.commit()
db.refresh(db_task)
return db_task
def update_task(db: Session, task_id: UUID, user_id: UUID, title: str = None, description: str = None) -> Optional[Task]:
"""
Update a task for a user.
Returns the updated task if successful, None if task doesn't exist or doesn't belong to user.
"""
db_task = get_user_task(db, task_id, user_id)
if not db_task:
return None
if title is not None:
db_task.title = title
if description is not None:
db_task.description = description
db_task.updated_at = datetime.utcnow()
db.add(db_task)
db.commit()
db.refresh(db_task)
return db_task
def delete_task(db: Session, task_id: UUID, user_id: UUID) -> bool:
"""
Delete a task for a user.
Returns True if successful, False if task doesn't exist or doesn't belong to user.
"""
db_task = get_user_task(db, task_id, user_id)
if not db_task:
return False
db.delete(db_task)
db.commit()
return True
def toggle_task_completion(db: Session, task_id: UUID, user_id: UUID) -> Optional[Task]:
"""
Toggle the completion status of a task for a user.
Returns the updated task if successful, None if task doesn't exist or doesn't belong to user.
"""
db_task = get_user_task(db, task_id, user_id)
if not db_task:
return None
db_task.is_completed = not db_task.is_completed
db_task.updated_at = datetime.utcnow()
db.add(db_task)
db.commit()
db.refresh(db_task)
return db_task
def get_user_task_count(db: Session, user_id: UUID) -> int:
"""
Get the total count of tasks for a user.
"""
statement = select(Task).where(Task.user_id == user_id)
return len(db.exec(statement).all())