Files
Bedrock/internal/platform/canvas_ai_list.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
}