import * as Effect from "effect/Effect";
import * as SqlClient from "effect/sql/SqlClient";
import ApplicationEventSequenceIndexes from "./OrchestrationV2/ApplicationEventSequenceIndexes.ts";
import ApplicationEventSource from "./OrchestrationV2/ApplicationEventSource.ts";
import OrchestrationV2EffectCancellation from "./OrchestrationV2/EffectCancellation.ts";
import OrchestrationV2Foundation from "./OrchestrationV2/Foundation.ts";
import LegacyV1ImportState from "./OrchestrationV2/LegacyV1ImportState.ts";
import OrchestrationV2ProviderSessionBindings from "./OrchestrationV2/ProviderSessionBindings.ts";
import OrchestrationV2RecoveryIndexes from "./OrchestrationV2/RecoveryIndexes.ts";
import ScheduledTasks from "./OrchestrationV2/ScheduledTasks.ts";
import OrchestrationV2ShellIndexes from "./OrchestrationV2/ShellIndexes.ts";
import OrchestrationV2Subagents from "./OrchestrationV2/Subagents.ts";
import OrchestrationV2ThreadLaunchWorkflows from "./OrchestrationV2/ThreadLaunchWorkflows.ts";
const OrchestrationV2Base = Effect.gen(function* () {
const sql = yield* SqlClient.SqlClient;
yield* sql`
CREATE TABLE orchestration_v2_events (
sequence INTEGER PRIMARY KEY AUTOINCREMENT,
event_id TEXT NOT NULL UNIQUE,
command_id TEXT,
thread_id TEXT NOT NULL,
run_id TEXT,
node_id TEXT,
provider TEXT,
raw_event_id TEXT,
event_type TEXT NOT NULL,
occurred_at TEXT NOT NULL,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE INDEX orchestration_v2_events_command_idx ON orchestration_v2_events(command_id, sequence)`;
yield* sql`CREATE INDEX orchestration_v2_events_thread_sequence_idx ON orchestration_v2_events(thread_id, sequence)`;
yield* sql`CREATE INDEX orchestration_v2_events_thread_type_sequence_idx ON orchestration_v2_events(thread_id, event_type, sequence)`;
yield* sql`CREATE INDEX orchestration_v2_events_run_sequence_idx ON orchestration_v2_events(run_id, sequence)`;
yield* sql`CREATE INDEX orchestration_v2_events_node_sequence_idx ON orchestration_v2_events(node_id, sequence)`;
yield* sql`CREATE INDEX orchestration_v2_events_raw_event_idx ON orchestration_v2_events(raw_event_id)`;
yield* sql`
CREATE TABLE orchestration_v2_command_receipts (
command_id TEXT PRIMARY KEY,
thread_id TEXT NOT NULL,
command_type TEXT NOT NULL,
accepted_at TEXT NOT NULL,
result_sequence INTEGER NOT NULL,
status TEXT NOT NULL,
error TEXT
)
`;
yield* sql`CREATE INDEX orchestration_v2_command_receipts_thread_sequence_idx ON orchestration_v2_command_receipts(thread_id, result_sequence)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_threads (
thread_id TEXT PRIMARY KEY,
project_id TEXT NOT NULL,
title TEXT NOT NULL,
default_provider TEXT NOT NULL,
runtime_mode TEXT NOT NULL,
interaction_mode TEXT NOT NULL,
active_provider_thread_id TEXT,
created_at TEXT NOT NULL,
updated_at TEXT NOT NULL,
archived_at TEXT,
deleted_at TEXT,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE INDEX orchestration_v2_projection_threads_project_updated_idx ON orchestration_v2_projection_threads(project_id, updated_at)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_runs (
run_id TEXT PRIMARY KEY,
thread_id TEXT NOT NULL,
ordinal INTEGER NOT NULL,
provider TEXT NOT NULL,
provider_thread_id TEXT,
status TEXT NOT NULL,
requested_at TEXT NOT NULL,
completed_at TEXT,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE UNIQUE INDEX orchestration_v2_projection_runs_thread_ordinal_idx ON orchestration_v2_projection_runs(thread_id, ordinal)`;
yield* sql`CREATE INDEX orchestration_v2_projection_runs_provider_thread_idx ON orchestration_v2_projection_runs(provider_thread_id)`;
yield* sql`CREATE INDEX orchestration_v2_projection_runs_thread_status_idx ON orchestration_v2_projection_runs(thread_id, status)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_run_attempts (
attempt_id TEXT PRIMARY KEY,
thread_id TEXT NOT NULL,
run_id TEXT NOT NULL,
attempt_ordinal INTEGER NOT NULL,
root_node_id TEXT NOT NULL,
provider TEXT NOT NULL,
provider_thread_id TEXT NOT NULL,
provider_turn_id TEXT,
status TEXT NOT NULL,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE UNIQUE INDEX orchestration_v2_projection_run_attempts_run_ordinal_idx ON orchestration_v2_projection_run_attempts(run_id, attempt_ordinal)`;
yield* sql`CREATE INDEX orchestration_v2_projection_run_attempts_thread_idx ON orchestration_v2_projection_run_attempts(thread_id, run_id)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_nodes (
node_id TEXT PRIMARY KEY,
thread_id TEXT NOT NULL,
run_id TEXT,
parent_node_id TEXT,
root_node_id TEXT NOT NULL,
kind TEXT NOT NULL,
status TEXT NOT NULL,
provider_thread_id TEXT,
provider_turn_id TEXT,
runtime_request_id TEXT,
checkpoint_scope_id TEXT,
started_at TEXT,
completed_at TEXT,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE INDEX orchestration_v2_projection_nodes_thread_run_idx ON orchestration_v2_projection_nodes(thread_id, run_id)`;
yield* sql`CREATE INDEX orchestration_v2_projection_nodes_parent_idx ON orchestration_v2_projection_nodes(parent_node_id)`;
yield* sql`CREATE INDEX orchestration_v2_projection_nodes_provider_turn_idx ON orchestration_v2_projection_nodes(provider_turn_id)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_provider_sessions (
provider_session_id TEXT PRIMARY KEY,
thread_id TEXT,
provider TEXT NOT NULL,
status TEXT NOT NULL,
model TEXT,
updated_at TEXT NOT NULL,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE INDEX orchestration_v2_projection_provider_sessions_thread_idx ON orchestration_v2_projection_provider_sessions(thread_id)`;
yield* sql`CREATE INDEX orchestration_v2_projection_provider_sessions_provider_status_idx ON orchestration_v2_projection_provider_sessions(provider, status)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_provider_threads (
provider_thread_id TEXT PRIMARY KEY,
thread_id TEXT,
owner_node_id TEXT,
provider TEXT NOT NULL,
provider_session_id TEXT,
status TEXT NOT NULL,
first_run_ordinal INTEGER,
last_run_ordinal INTEGER,
updated_at TEXT NOT NULL,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE INDEX orchestration_v2_projection_provider_threads_thread_idx ON orchestration_v2_projection_provider_threads(thread_id)`;
yield* sql`CREATE INDEX orchestration_v2_projection_provider_threads_session_idx ON orchestration_v2_projection_provider_threads(provider_session_id)`;
yield* sql`CREATE INDEX orchestration_v2_projection_provider_threads_owner_idx ON orchestration_v2_projection_provider_threads(owner_node_id)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_provider_turns (
provider_turn_id TEXT PRIMARY KEY,
thread_id TEXT NOT NULL,
provider_thread_id TEXT NOT NULL,
node_id TEXT NOT NULL,
run_attempt_id TEXT,
ordinal INTEGER NOT NULL,
status TEXT NOT NULL,
started_at TEXT,
completed_at TEXT,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE INDEX orchestration_v2_projection_provider_turns_thread_idx ON orchestration_v2_projection_provider_turns(thread_id)`;
yield* sql`CREATE UNIQUE INDEX orchestration_v2_projection_provider_turns_thread_ordinal_idx ON orchestration_v2_projection_provider_turns(provider_thread_id, ordinal)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_runtime_requests (
runtime_request_id TEXT PRIMARY KEY,
thread_id TEXT NOT NULL,
node_id TEXT NOT NULL,
provider_turn_id TEXT,
kind TEXT NOT NULL,
status TEXT NOT NULL,
created_at TEXT NOT NULL,
resolved_at TEXT,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE INDEX orchestration_v2_projection_runtime_requests_thread_status_idx ON orchestration_v2_projection_runtime_requests(thread_id, status)`;
yield* sql`CREATE INDEX orchestration_v2_projection_runtime_requests_provider_turn_idx ON orchestration_v2_projection_runtime_requests(provider_turn_id)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_messages (
message_id TEXT PRIMARY KEY,
thread_id TEXT NOT NULL,
run_id TEXT,
node_id TEXT,
role TEXT NOT NULL,
streaming INTEGER NOT NULL,
created_at TEXT NOT NULL,
updated_at TEXT NOT NULL,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE INDEX orchestration_v2_projection_messages_thread_created_idx ON orchestration_v2_projection_messages(thread_id, created_at, message_id)`;
yield* sql`CREATE INDEX orchestration_v2_projection_messages_run_idx ON orchestration_v2_projection_messages(run_id)`;
yield* sql`CREATE INDEX orchestration_v2_projection_messages_node_idx ON orchestration_v2_projection_messages(node_id)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_plans (
plan_id TEXT PRIMARY KEY,
thread_id TEXT NOT NULL,
run_id TEXT,
node_id TEXT NOT NULL,
kind TEXT NOT NULL,
status TEXT NOT NULL,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE INDEX orchestration_v2_projection_plans_thread_idx ON orchestration_v2_projection_plans(thread_id)`;
yield* sql`CREATE INDEX orchestration_v2_projection_plans_run_idx ON orchestration_v2_projection_plans(run_id)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_turn_items (
turn_item_id TEXT PRIMARY KEY,
thread_id TEXT NOT NULL,
run_id TEXT,
node_id TEXT,
provider_thread_id TEXT,
provider_turn_id TEXT,
parent_item_id TEXT,
ordinal INTEGER NOT NULL,
type TEXT NOT NULL,
status TEXT NOT NULL,
updated_at TEXT NOT NULL,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE INDEX orchestration_v2_projection_turn_items_thread_ordinal_idx ON orchestration_v2_projection_turn_items(thread_id, ordinal, turn_item_id)`;
yield* sql`CREATE INDEX orchestration_v2_projection_turn_items_run_ordinal_idx ON orchestration_v2_projection_turn_items(run_id, ordinal)`;
yield* sql`CREATE INDEX orchestration_v2_projection_turn_items_node_ordinal_idx ON orchestration_v2_projection_turn_items(node_id, ordinal)`;
yield* sql`CREATE INDEX orchestration_v2_projection_turn_items_provider_turn_idx ON orchestration_v2_projection_turn_items(provider_turn_id)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_checkpoint_scopes (
scope_id TEXT PRIMARY KEY,
thread_id TEXT NOT NULL,
run_id TEXT,
node_id TEXT NOT NULL,
parent_scope_id TEXT,
provider_thread_id TEXT,
kind TEXT NOT NULL,
ordinal_within_parent INTEGER NOT NULL,
advances_app_run_count INTEGER NOT NULL,
created_at TEXT NOT NULL,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE INDEX orchestration_v2_projection_checkpoint_scopes_thread_idx ON orchestration_v2_projection_checkpoint_scopes(thread_id)`;
yield* sql`CREATE INDEX orchestration_v2_projection_checkpoint_scopes_parent_idx ON orchestration_v2_projection_checkpoint_scopes(parent_scope_id)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_checkpoints (
checkpoint_id TEXT PRIMARY KEY,
thread_id TEXT NOT NULL,
scope_id TEXT NOT NULL,
run_id TEXT,
node_id TEXT NOT NULL,
parent_checkpoint_id TEXT,
ordinal_within_scope INTEGER NOT NULL,
app_run_ordinal INTEGER,
status TEXT NOT NULL,
captured_at TEXT NOT NULL,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE UNIQUE INDEX orchestration_v2_projection_checkpoints_scope_ordinal_idx ON orchestration_v2_projection_checkpoints(scope_id, ordinal_within_scope)`;
yield* sql`CREATE INDEX orchestration_v2_projection_checkpoints_thread_idx ON orchestration_v2_projection_checkpoints(thread_id)`;
yield* sql`CREATE INDEX orchestration_v2_projection_checkpoints_parent_idx ON orchestration_v2_projection_checkpoints(parent_checkpoint_id)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_context_handoffs (
context_handoff_id TEXT PRIMARY KEY,
thread_id TEXT NOT NULL,
target_run_id TEXT NOT NULL,
to_provider_thread_id TEXT NOT NULL,
strategy TEXT NOT NULL,
status TEXT NOT NULL,
updated_at TEXT NOT NULL,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE INDEX orchestration_v2_projection_context_handoffs_thread_idx ON orchestration_v2_projection_context_handoffs(thread_id)`;
yield* sql`CREATE INDEX orchestration_v2_projection_context_handoffs_target_run_idx ON orchestration_v2_projection_context_handoffs(target_run_id)`;
yield* sql`
CREATE TABLE orchestration_v2_projection_context_transfers (
context_transfer_id TEXT PRIMARY KEY,
source_thread_id TEXT NOT NULL,
target_thread_id TEXT NOT NULL,
target_run_id TEXT,
type TEXT NOT NULL,
status TEXT NOT NULL,
source_provider TEXT,
target_provider TEXT,
updated_at TEXT NOT NULL,
payload_json TEXT NOT NULL
)
`;
yield* sql`CREATE INDEX orchestration_v2_projection_context_transfers_source_thread_idx ON orchestration_v2_projection_context_transfers(source_thread_id)`;
yield* sql`CREATE INDEX orchestration_v2_projection_context_transfers_target_thread_idx ON orchestration_v2_projection_context_transfers(target_thread_id, status)`;
yield* sql`CREATE INDEX orchestration_v2_projection_context_transfers_target_run_idx ON orchestration_v2_projection_context_transfers(target_run_id)`;
});
export default Effect.gen(function* () {
yield* OrchestrationV2Base;
yield* OrchestrationV2Subagents;
yield* OrchestrationV2Foundation;
yield* OrchestrationV2ProviderSessionBindings;
yield* OrchestrationV2ThreadLaunchWorkflows;
yield* ApplicationEventSource;
yield* OrchestrationV2EffectCancellation;
yield* ScheduledTasks;
yield* LegacyV1ImportState;
yield* ApplicationEventSequenceIndexes;
yield* OrchestrationV2RecoveryIndexes;
yield* OrchestrationV2ShellIndexes;
});