forked from hesabix/arc
62 lines
2.3 KiB
Python
62 lines
2.3 KiB
Python
from __future__ import annotations
|
|
|
|
from datetime import datetime
|
|
from typing import Optional
|
|
|
|
from sqlalchemy import DateTime, ForeignKey, Integer, String, Text
|
|
from sqlalchemy.orm import Mapped, mapped_column, relationship
|
|
|
|
from adapters.db.session import Base
|
|
|
|
|
|
class AISessionTodoStatus:
|
|
PENDING = "pending"
|
|
IN_PROGRESS = "in_progress"
|
|
DONE = "done"
|
|
SKIPPED = "skipped"
|
|
ERROR = "error"
|
|
|
|
ALL = frozenset({PENDING, IN_PROGRESS, DONE, SKIPPED, ERROR})
|
|
|
|
|
|
class AISessionTodo(Base):
|
|
"""برنامهٔ کاری موقت agent در یک جلسهٔ چت — فقط برای پیگیری سناریوهای چندمرحلهای."""
|
|
|
|
__tablename__ = "ai_session_todos"
|
|
|
|
id: Mapped[int] = mapped_column(primary_key=True, autoincrement=True)
|
|
public_id: Mapped[str] = mapped_column(String(16), nullable=False, index=True)
|
|
session_id: Mapped[int] = mapped_column(
|
|
Integer,
|
|
ForeignKey("ai_chat_sessions.id", ondelete="CASCADE"),
|
|
nullable=False,
|
|
index=True,
|
|
)
|
|
origin_message_id: Mapped[Optional[int]] = mapped_column(
|
|
Integer,
|
|
ForeignKey("ai_chat_messages.id", ondelete="SET NULL"),
|
|
nullable=True,
|
|
)
|
|
title: Mapped[str] = mapped_column(String(512), nullable=False)
|
|
description: Mapped[Optional[str]] = mapped_column(Text, nullable=True)
|
|
status: Mapped[str] = mapped_column(
|
|
String(32),
|
|
nullable=False,
|
|
default=AISessionTodoStatus.PENDING,
|
|
server_default=AISessionTodoStatus.PENDING,
|
|
)
|
|
sort_order: Mapped[int] = mapped_column(Integer, nullable=False, default=0, server_default="0")
|
|
linked_tool: Mapped[Optional[str]] = mapped_column(String(128), nullable=True)
|
|
error_message: Mapped[Optional[str]] = mapped_column(Text, nullable=True)
|
|
extra_json: Mapped[Optional[str]] = mapped_column(Text, nullable=True)
|
|
created_at: Mapped[datetime] = mapped_column(DateTime, default=datetime.utcnow, nullable=False)
|
|
updated_at: Mapped[datetime] = mapped_column(
|
|
DateTime,
|
|
default=datetime.utcnow,
|
|
onupdate=datetime.utcnow,
|
|
nullable=False,
|
|
)
|
|
started_at: Mapped[Optional[datetime]] = mapped_column(DateTime, nullable=True)
|
|
completed_at: Mapped[Optional[datetime]] = mapped_column(DateTime, nullable=True)
|
|
|
|
session = relationship("AIChatSession", back_populates="session_todos")
|