吉鑫升andClaude Opus 4.7
e3cde9be25
定时任务:
- 运行详情页新增「执行过程」标签页,按 agent_run_id 拉取该次运行的
agent 消息(GET /scheduled-tasks/runs/{id}/messages),运行中每 4s
自动刷新,可观察卡住的任务停在哪一步
- 详情页「返回」按钮回到来源列表(普通/管理员)并重新选中原任务
- 管理员可下载、删除任意用户的执行记录(DELETE /runs/{id} 加管理员兜底)
MySQL 兼容修复:
- 合并迁移 20260518_06 汇合 ai-writing 与 thread-shares 两个 head
- 20260517_02 改用 SQLAlchemy Core 构造,规避保留字 key 的 1064 报错
- list_messages_by_run 各事件存储补 user_id 形参以保持接口一致
测试: 新增 test_scheduled_task_admin_run_delete.py
Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
143 lines
5.3 KiB
Python
143 lines
5.3 KiB
Python
"""Abstract scheduled-task persistence API."""
|
|
|
|
from __future__ import annotations
|
|
|
|
from abc import ABC, abstractmethod
|
|
from datetime import datetime
|
|
from typing import Any
|
|
|
|
|
|
class ScheduledTaskStore(ABC):
|
|
@abstractmethod
|
|
async def get_or_create_scheduler_thread(self, user_id: str, thread_id_factory) -> dict:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def list_tasks(self, user_id: str) -> list[dict[str, Any]]:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def get_task(self, task_id: str, user_id: str) -> dict[str, Any] | None:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def create_task(self, data: dict[str, Any]) -> dict[str, Any]:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def update_task(self, task_id: str, user_id: str, data: dict[str, Any]) -> dict[str, Any] | None:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def delete_task(self, task_id: str, user_id: str) -> bool:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def due_tasks(self, now: datetime, *, limit: int = 20) -> list[dict[str, Any]]:
|
|
raise NotImplementedError
|
|
|
|
# --- Admin (cross-user) ---
|
|
|
|
@abstractmethod
|
|
async def list_all_tasks(self) -> list[dict[str, Any]]:
|
|
"""Return every task across all users. Admin-only callers."""
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def update_task_any(self, task_id: str, data: dict[str, Any]) -> dict[str, Any] | None:
|
|
"""Update a task by id without restricting by owner. Admin-only callers."""
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def delete_task_any(self, task_id: str) -> bool:
|
|
"""Delete a task by id without restricting by owner. Admin-only callers."""
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def list_runs_any(self, task_id: str, *, limit: int = 50) -> list[dict[str, Any]]:
|
|
"""Return runs for a task without restricting by owner. Admin-only callers."""
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def list_stuck_runs(self, cutoff: datetime, *, limit: int = 50) -> list[dict[str, Any]]:
|
|
"""Return runs still in a non-terminal state whose ``started_at`` is older
|
|
than ``cutoff``. Used by the scheduler watchdog to recover runs that hung
|
|
or were orphaned by a service restart."""
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def create_run_once(self, data: dict[str, Any]) -> dict[str, Any] | None:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def update_run(self, run_id: str, data: dict[str, Any]) -> None:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def list_runs(self, task_id: str, user_id: str, *, limit: int = 50) -> list[dict[str, Any]]:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def get_run(self, run_id: str, user_id: str) -> dict[str, Any] | None:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def delete_run(self, run_id: str, user_id: str) -> bool:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def delete_run_any(self, run_id: str) -> bool:
|
|
"""Delete a run by id without restricting by owner. Admin-only callers."""
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def get_delivery_profile(self, user_id: str) -> dict[str, Any]:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def update_delivery_profile(self, user_id: str, data: dict[str, Any]) -> dict[str, Any]:
|
|
raise NotImplementedError
|
|
|
|
# --- Publish / subscribe ---
|
|
|
|
@abstractmethod
|
|
async def get_task_any(self, task_id: str) -> dict[str, Any] | None:
|
|
"""Return a task by id without restricting by owner. Used for publish/subscribe lookups."""
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def get_run_any(self, run_id: str) -> dict[str, Any] | None:
|
|
"""Return a run by id without restricting by owner. Used for subscriber visibility."""
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def set_task_published(self, task_id: str, owner_user_id: str, *, published: bool) -> dict[str, Any] | None:
|
|
"""Toggle published flag. Returns updated task or ``None`` if missing / not owned."""
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def list_published_tasks(self, *, limit: int = 50, offset: int = 0) -> list[dict[str, Any]]:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def list_subscribed_tasks(self, user_id: str) -> list[dict[str, Any]]:
|
|
"""Return tasks the user has subscribed to. Each item carries ``_subscription`` dict."""
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def get_subscription(self, task_id: str, user_id: str) -> dict[str, Any] | None:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def upsert_subscription(self, task_id: str, user_id: str, *, notify_element: bool) -> dict[str, Any]:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def delete_subscription(self, task_id: str, user_id: str) -> bool:
|
|
raise NotImplementedError
|
|
|
|
@abstractmethod
|
|
async def list_notify_subscribers(self, task_id: str) -> list[dict[str, Any]]:
|
|
"""Subscribers with ``notify_element=True`` for the given task."""
|
|
raise NotImplementedError
|