124 lines
4.4 KiB
Go
124 lines
4.4 KiB
Go
// AI run 列表使用创建时间/UUID 的复合游标,支持状态和活跃子图范围筛选。
|
|
package platform
|
|
|
|
import (
|
|
"database/sql"
|
|
"encoding/base64"
|
|
"encoding/json"
|
|
"net/http"
|
|
"strconv"
|
|
"time"
|
|
)
|
|
|
|
// canvasRunCursor 用时间加 ID 处理同一时间创建的 run,不依赖不稳定的 OFFSET。
|
|
type canvasRunCursor struct {
|
|
Time time.Time `json:"created_at"`
|
|
ID string `json:"id"`
|
|
}
|
|
|
|
// listCanvasAIRuns 先查范围候选,再核对各 run 来源画布的可见性;返回列表不含冻结提示或原始输出文本。
|
|
func (s *service) listCanvasAIRuns(w http.ResponseWriter, r *http.Request, project, account string) error {
|
|
if r.Method != http.MethodGet {
|
|
reject(w, 405, "method_not_allowed")
|
|
return nil
|
|
}
|
|
status := r.URL.Query().Get("status")
|
|
if status != "" && !canvasChoice(status, "active", "queued", "running", "succeeded", "partially_succeeded", "failed", "cancelled", "conflict") {
|
|
reject(w, 400, "invalid_filter")
|
|
return nil
|
|
}
|
|
include := false
|
|
if value := r.URL.Query().Get("include_descendants"); value != "" {
|
|
if value != "true" && value != "false" {
|
|
reject(w, 400, "invalid_filter")
|
|
return nil
|
|
}
|
|
include = value == "true"
|
|
}
|
|
limit := 50
|
|
var err error
|
|
if raw := r.URL.Query().Get("limit"); raw != "" {
|
|
limit, err = strconv.Atoi(raw)
|
|
}
|
|
if err != nil || limit < 1 || limit > 50 {
|
|
reject(w, 400, "invalid_pagination")
|
|
return nil
|
|
}
|
|
cursor := canvasRunCursor{Time: time.Now().Add(time.Hour), ID: "ffffffff-ffff-ffff-ffff-ffffffffffff"}
|
|
if value := r.URL.Query().Get("cursor"); value != "" {
|
|
raw, e := base64.RawURLEncoding.DecodeString(value)
|
|
if e != nil || len(raw) > 512 || json.Unmarshal(raw, &cursor) != nil || cursor.Time.IsZero() || !uuidSlugPattern.MatchString(cursor.ID) {
|
|
reject(w, 400, "invalid_pagination")
|
|
return nil
|
|
}
|
|
}
|
|
workspace, board := r.PathValue("workspace"), r.PathValue("material")
|
|
tx, err := s.db.BeginTx(r.Context(), nil)
|
|
if err != nil {
|
|
return err
|
|
}
|
|
defer tx.Rollback()
|
|
if _, _, err = lockMaterial(r.Context(), tx, project, workspace, board, account); err != nil {
|
|
return err
|
|
}
|
|
rows, err := tx.QueryContext(r.Context(), `WITH RECURSIVE boards(id,depth) AS (
|
|
SELECT $3::uuid,0 UNION ALL SELECT s.child_board_id,b.depth+1 FROM boards b JOIN canvas_subgraphs s ON s.project=$1 AND s.workspace_id=$2 AND s.parent_board_id=b.id AND s.archived_at IS NULL WHERE $4 AND b.depth<8
|
|
) SELECT r.id::text,r.board_id::text,r.status,r.created_at,r.completed_at,r.error_code FROM canvas_ai_runs r
|
|
WHERE r.project=$1 AND r.workspace_id=$2 AND (r.board_id IN(SELECT id FROM boards) OR EXISTS(SELECT 1 FROM canvas_ai_steps step WHERE step.project=r.project AND step.workspace_id=r.workspace_id AND step.run_id=r.id AND step.board_id IN(SELECT id FROM boards)))
|
|
AND ($5='' OR ($5='active' AND r.status IN('queued','running')) OR r.status=$5)
|
|
AND (r.created_at,r.id)<($6,$7::uuid) ORDER BY r.created_at DESC,r.id DESC LIMIT $8`, project, workspace, board, include, status, cursor.Time, cursor.ID, limit+1)
|
|
if err != nil {
|
|
return err
|
|
}
|
|
type item struct {
|
|
ID, Board, Status string
|
|
Created time.Time
|
|
Completed sql.NullTime
|
|
Code sql.NullString
|
|
}
|
|
candidates := []item{}
|
|
for rows.Next() {
|
|
var it item
|
|
if err = rows.Scan(&it.ID, &it.Board, &it.Status, &it.Created, &it.Completed, &it.Code); err != nil {
|
|
break
|
|
}
|
|
candidates = append(candidates, it)
|
|
}
|
|
if err == nil {
|
|
err = rows.Err()
|
|
}
|
|
rows.Close()
|
|
if err != nil {
|
|
return err
|
|
}
|
|
// SQL 多取一条判断后页;权限过滤可能使公开本页少于 limit,游标仍按扫描到的候选末尾前进。
|
|
hasMore := len(candidates) > limit
|
|
if hasMore {
|
|
candidates = candidates[:limit]
|
|
}
|
|
items := []any{}
|
|
for _, it := range candidates {
|
|
if _, _, err = lockMaterial(r.Context(), tx, project, workspace, it.Board, account); err == sql.ErrNoRows {
|
|
continue
|
|
} else if err != nil {
|
|
return err
|
|
}
|
|
value := response{"run_id": it.ID, "board_id": it.Board, "status": it.Status, "created_at": it.Created}
|
|
if it.Completed.Valid {
|
|
value["completed_at"] = it.Completed.Time
|
|
}
|
|
if it.Code.Valid {
|
|
value["error"] = it.Code.String
|
|
}
|
|
items = append(items, value)
|
|
}
|
|
var next any
|
|
if hasMore && len(candidates) > 0 {
|
|
last := candidates[len(candidates)-1]
|
|
raw, _ := json.Marshal(canvasRunCursor{Time: last.Created, ID: last.ID})
|
|
next = base64.RawURLEncoding.EncodeToString(raw)
|
|
}
|
|
reply(w, 200, response{"runs": items, "next_cursor": next, "retention_days": 30})
|
|
return nil
|
|
}
|