f89e074dd1
Governed substrate for autonomous agents: scoped identity (passports), audited actions, MCP workspace. Infra IPs and secrets redacted for public release.
62 lines
1.8 KiB
Bash
Executable file
62 lines
1.8 KiB
Bash
Executable file
#!/bin/bash
|
|
# Orchestrator Save System
|
|
# Usage:
|
|
# ./orchestrator-save.sh load 270 # Load save by conversation ID
|
|
# ./orchestrator-save.sh list # List all saves
|
|
# ./orchestrator-save.sh list holetron # List saves by project
|
|
|
|
DB_USER="godcrm"
|
|
DB_NAME="godcrm_prod"
|
|
DB_HOST="localhost"
|
|
export PGPASSWORD="godcrm_dev_2026"
|
|
|
|
CMD=${1:-list}
|
|
ARG=${2:-}
|
|
|
|
case "$CMD" in
|
|
load)
|
|
if [ -z "$ARG" ]; then
|
|
echo "Usage: $0 load <conversation_id>"
|
|
exit 1
|
|
fi
|
|
echo "=== ORCHESTRATOR SAVE #$ARG ==="
|
|
psql -h $DB_HOST -U $DB_USER -d $DB_NAME -t -c "
|
|
SELECT jsonb_pretty(
|
|
jsonb_build_object(
|
|
'conversation_id', conversation_id,
|
|
'project', project,
|
|
'summary', context_summary,
|
|
'knowledge', knowledge_base,
|
|
'tags', to_jsonb(tags),
|
|
'saved_at', created_at,
|
|
'updated_at', updated_at
|
|
)
|
|
)
|
|
FROM orchestrator_saves
|
|
WHERE conversation_id = $ARG;" 2>/dev/null
|
|
;;
|
|
list)
|
|
if [ -n "$ARG" ]; then
|
|
echo "=== SAVES FOR PROJECT: $ARG ==="
|
|
psql -h $DB_HOST -U $DB_USER -d $DB_NAME -c "
|
|
SELECT conversation_id as \"#\", project,
|
|
left(context_summary, 80) || '...' as summary,
|
|
tags, updated_at
|
|
FROM orchestrator_saves
|
|
WHERE LOWER(project) = LOWER('$ARG')
|
|
ORDER BY conversation_id DESC;" 2>/dev/null
|
|
else
|
|
echo "=== ALL ORCHESTRATOR SAVES ==="
|
|
psql -h $DB_HOST -U $DB_USER -d $DB_NAME -c "
|
|
SELECT conversation_id as \"#\", project,
|
|
left(context_summary, 80) || '...' as summary,
|
|
tags, updated_at
|
|
FROM orchestrator_saves
|
|
ORDER BY conversation_id DESC;" 2>/dev/null
|
|
fi
|
|
;;
|
|
*)
|
|
echo "Orchestrator Save System"
|
|
echo "Commands: load <id>, list [project]"
|
|
;;
|
|
esac
|