tasklert-api / src /services /todo_service.py
hashir-qt's picture
initial deploy
507973e
Raw History Blame Contribute Delete
6 kB
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