from datetime import datetime from sqlalchemy import func from sqlalchemy.ext.asyncio import AsyncSession from sqlmodel import select from ..models.todo import Todo, TodoCreate, TodoUpdate from . import event_service, stats_service def _todo_payload(todo: Todo) -> dict: return { "id": todo.id, "title": todo.title, "completed": todo.completed, "priority": todo.priority, "tags": todo.tags, "recurrence": todo.recurrence, "due_date": todo.due_date.isoformat() if todo.due_date else None, } async def create(session: AsyncSession, data: TodoCreate, user_id: str) -> Todo: todo = Todo( title=data.title, description=data.description, user_id=user_id, priority=data.priority, tags=data.tags, due_date=data.due_date, reminder_at=data.reminder_at, recurrence=data.recurrence, ) session.add(todo) await session.commit() await session.refresh(todo) await event_service.publish_task_event("created", todo.id, user_id, _todo_payload(todo)) await event_service.publish_sync_event(user_id, "created", todo.id) if todo.reminder_at: await event_service.schedule_reminder(todo.id, user_id, todo.title, todo.reminder_at) return todo async def get(session: AsyncSession, todo_id: int, user_id: str) -> Todo | None: result = await session.execute( select(Todo).where(Todo.id == todo_id, Todo.user_id == user_id) ) return result.scalar_one_or_none() async def list_todos( session: AsyncSession, user_id: str, status: str = "all", priority: str | None = None, tag: str | None = None, search: str | None = None, sort_by: str = "created_at", sort_order: str = "desc", due_before: datetime | None = None, due_after: datetime | None = None, limit: int = 50, offset: int = 0, ) -> tuple[list[Todo], int]: from sqlalchemy import or_ from sqlalchemy.dialects.postgresql import array base = select(Todo).where(Todo.user_id == user_id) count_base = select(func.count(Todo.id)).where(Todo.user_id == user_id) if status == "completed": base = base.where(Todo.completed.is_(True)) count_base = count_base.where(Todo.completed.is_(True)) elif status == "pending": base = base.where(Todo.completed.is_(False)) count_base = count_base.where(Todo.completed.is_(False)) if priority: base = base.where(Todo.priority == priority) count_base = count_base.where(Todo.priority == priority) if tag: base = base.where(Todo.tags.contains(array([tag]))) count_base = count_base.where(Todo.tags.contains(array([tag]))) if search: pattern = f"%{search}%" cond = or_(Todo.title.ilike(pattern), Todo.description.ilike(pattern)) base = base.where(cond) count_base = count_base.where(cond) if due_before: base = base.where(Todo.due_date <= due_before) count_base = count_base.where(Todo.due_date <= due_before) if due_after: base = base.where(Todo.due_date >= due_after) count_base = count_base.where(Todo.due_date >= due_after) total_result = await session.execute(count_base) total: int = total_result.scalar() # type: ignore[assignment] # Sort sort_col = getattr(Todo, sort_by, Todo.created_at) order = sort_col.desc() if sort_order == "desc" else sort_col.asc() query = base.order_by(order).limit(limit).offset(offset) result = await session.execute(query) todos = list(result.scalars().all()) return todos, total async def update( session: AsyncSession, todo_id: int, data: TodoUpdate, user_id: str ) -> Todo | None: todo = await get(session, todo_id, user_id) if not todo: return None if data.title is not None: todo.title = data.title if data.description is not None: todo.description = data.description if data.completed is not None: todo.completed = data.completed if data.priority is not None: todo.priority = data.priority if data.tags is not None: todo.tags = data.tags if data.due_date is not None: todo.due_date = data.due_date if data.reminder_at is not None: todo.reminder_at = data.reminder_at await event_service.schedule_reminder(todo.id, user_id, todo.title, todo.reminder_at) if data.recurrence is not None: todo.recurrence = data.recurrence todo.updated_at = datetime.utcnow() # Timezone-naive for PostgreSQL session.add(todo) await session.commit() await session.refresh(todo) await event_service.publish_task_event("updated", todo.id, user_id, _todo_payload(todo)) await event_service.publish_sync_event(user_id, "updated", todo.id) return todo async def toggle(session: AsyncSession, todo_id: int, user_id: str) -> Todo | None: todo = await get(session, todo_id, user_id) if not todo: return None todo.completed = not todo.completed todo.updated_at = datetime.utcnow() # Timezone-naive for PostgreSQL session.add(todo) await session.commit() await session.refresh(todo) event_type = "completed" if todo.completed else "uncompleted" if todo.completed: await stats_service.record_completion(session, user_id, todo.id, _todo_payload(todo)) await event_service.publish_task_event(event_type, todo.id, user_id, _todo_payload(todo)) await event_service.publish_sync_event(user_id, event_type, todo.id) return todo async def delete(session: AsyncSession, todo_id: int, user_id: str) -> bool: todo = await get(session, todo_id, user_id) if not todo: return False payload = _todo_payload(todo) await session.delete(todo) await session.commit() await event_service.publish_task_event("deleted", todo_id, user_id, payload) await event_service.publish_sync_event(user_id, "deleted", todo_id) return True