Self-hosted workflows for coding-agent delivery. Orchestrate CodeBuddy, Codex and Claude Code with scripts and human approval gates. Includes Local workflows for coding assistants.
JavaScript agent-orchestrationagentic-workflowai-agentsai-codingclaude-codecode-reviewcodebuddycodexcoding-agentscursordeveloper-toolshuman-on-the-loopllmmcpmulti-agentsdlcself-hostedsopworkflow-automationworkflow-engine
package repo
import (
"encoding/json"
"fmt"
"log"
"time"
"agentflow/internal/domain"
)
// SidebarRunMeta is the cheap run header the conversation history needs to
// name and label a shared SOP run session. Decorating the whole list from
// batched reads keeps the history endpoint's query count flat: per-session
// RunState lookups once made long histories slow and transferred node graphs
// the sidebar never shows.
type SidebarRunMeta struct {
Status string
WorkflowID string
Kind string
WorkflowName string
IssueID string
IssueNumber int
ResponsibleUserID int64
// Input is the head of the task text the run was started with; it names a
// run that serves no requirement.
Input string
CreatedAt time.Time
}
// sidebarRunInputChars bounds how much task text the list reads per run.
const sidebarRunInputChars = 300
// SidebarRunMetas loads those headers for the listed runs.
func (r *RunsRepo) SidebarRunMetas(ids []string) map[string]SidebarRunMeta {
out := make(map[string]SidebarRunMeta, len(ids))
if len(ids) == 0 {
return out
}
nameExpr := "json_extract(snapshot, '$.name')"
if r.isMySQL() {
nameExpr = "JSON_UNQUOTE(JSON_EXTRACT(snapshot, '$.name'))"
}
for start := 0; start < len(ids); start += 500 {
var rows []struct {
ID string
Status string
WorkflowID *string
Kind *string
Workflow *string
Context []byte
Input *string
Created *time.Time
}
err := r.DB.Table("runs").
Select(fmt.Sprintf("id, status, workflow_id, kind, %s AS workflow, execution_context AS context, SUBSTR(input, 1, %d) AS input, created_at AS created", nameExpr, sidebarRunInputChars)).
Where("id IN ?", ids[start:min(start+500, len(ids))]).
Scan(&rows).Error
if err != nil {
log.Printf("sidebar run meta read failed: %v", err)
return out
}
for _, row := range rows {
meta := SidebarRunMeta{Status: row.Status}
if row.Workflow != nil {
meta.WorkflowName = *row.Workflow
}
var ctx domain.TelemetryContext
if len(row.Context) > 0 {
_ = json.Unmarshal(row.Context, &ctx)
}
meta.IssueID = ctx.IssueID
meta.IssueNumber = ctx.IssueNumber
meta.ResponsibleUserID = ctx.ResponsibleUserID
if row.WorkflowID != nil {
meta.WorkflowID = *row.WorkflowID
}
if row.Kind != nil {
meta.Kind = *row.Kind
}
if row.Input != nil {
meta.Input = *row.Input
}
if row.Created != nil {
meta.CreatedAt = *row.Created
}
out[row.ID] = meta
}
}
return out
}
// SidebarIssue is the requirement identity shown next to a SOP run.
type SidebarIssue struct {
Number int
Title string
}
// IssueSidebarIdentities loads only the requirement number and title, never
// the description or the comments.
func (r *IssuesRepo) IssueSidebarIdentities(ids []string) map[string]SidebarIssue {
out := make(map[string]SidebarIssue, len(ids))
if len(ids) == 0 {
return out
}
for start := 0; start < len(ids); start += 500 {
var rows []struct {
ID string
Number int
Title string
}
err := r.DB.Table("issues").Select("id, number, title").
Where("id IN ?", ids[start:min(start+500, len(ids))]).Scan(&rows).Error
if err != nil {
log.Printf("sidebar issue identity read failed: %v", err)
return out
}
for _, row := range rows {
out[row.ID] = SidebarIssue{Number: row.Number, Title: row.Title}
}
}
return out
}
// AssistantSessionMessageCounts reports persisted message counts so the history
// list can tell an unused SOP run conversation from one that already holds a
// discussion, without transferring transcripts. The list projection strips
// messages, so the count has to come from the stored payload.
func (r *AssistantRepo) AssistantSessionMessageCounts(ids []string) map[string]int {
out := make(map[string]int, len(ids))
if len(ids) == 0 {
return out
}
expr := "COALESCE(json_array_length(payload, '$.messages'), 0)"
if r.isMySQL() {
expr = "COALESCE(JSON_LENGTH(JSON_EXTRACT(payload, '$.messages')), 0)"
}
for start := 0; start < len(ids); start += 500 {
var rows []struct {
ID string
Total int
}
err := r.DB.Table("assistant_sessions").Select("id, "+expr+" AS total").
Where("id IN ?", ids[start:min(start+500, len(ids))]).Scan(&rows).Error
if err != nil {
log.Printf("assistant message count read failed: %v", err)
return out
}
for _, row := range rows {
out[row.ID] = row.Total
}
}
return out
}