Spaces:
Sleeping
Sleeping
Download src/services/todo_service.py from hashir-qt/tasklert-api: direct link, hf CLI and curl.
- Browser
- Download file 6 kB
-
https://huggingface.co/spaces/hashir-qt/tasklert-api/resolve/main/src/services/todo_service.py
- Command line
-
hf download hf://spaces/hashir-qt/tasklert-api/src/services/todo_service.py
-
curl -L -o todo_service.py https://huggingface.co/spaces/hashir-qt/tasklert-api/resolve/main/src/services/todo_service.py
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 | |