The best way to control Claude Code, Codex and more from any computer or phone

main
ts 172 lines 6.19 KB
Raw
1 import * as Effect from "effect/Effect";
2 import * as SqlClient from "effect/sql/SqlClient";
3
4 // Legacy NOT NULL provider columns remain write-through shadows; V2 reads explicit driver/instance columns.
5 export default Effect.gen(function* () {
6 const sql = yield* SqlClient.SqlClient;
7
8 yield* sql`ALTER TABLE orchestration_v2_events ADD COLUMN driver TEXT`;
9 yield* sql`ALTER TABLE orchestration_v2_events ADD COLUMN provider_instance_id TEXT`;
10 yield* sql`
11 UPDATE orchestration_v2_events
12 SET
13 driver = COALESCE(json_extract(payload_json, '$.driver'), provider),
14 provider_instance_id = COALESCE(
15 json_extract(payload_json, '$.providerInstanceId'),
16 provider
17 )
18 `;
19 yield* sql`CREATE INDEX orchestration_v2_events_instance_sequence_idx ON orchestration_v2_events(provider_instance_id, sequence)`;
20
21 yield* sql`ALTER TABLE orchestration_v2_projection_threads ADD COLUMN provider_instance_id TEXT`;
22 yield* sql`
23 UPDATE orchestration_v2_projection_threads
24 SET provider_instance_id = COALESCE(
25 json_extract(payload_json, '$.providerInstanceId'),
26 default_provider
27 )
28 `;
29
30 yield* sql`ALTER TABLE orchestration_v2_projection_runs ADD COLUMN provider_instance_id TEXT`;
31 yield* sql`
32 UPDATE orchestration_v2_projection_runs
33 SET provider_instance_id = COALESCE(
34 json_extract(payload_json, '$.providerInstanceId'),
35 provider
36 )
37 `;
38
39 yield* sql`ALTER TABLE orchestration_v2_projection_run_attempts ADD COLUMN provider_instance_id TEXT`;
40 yield* sql`
41 UPDATE orchestration_v2_projection_run_attempts
42 SET provider_instance_id = COALESCE(
43 json_extract(payload_json, '$.providerInstanceId'),
44 provider
45 )
46 `;
47
48 yield* sql`ALTER TABLE orchestration_v2_projection_provider_sessions ADD COLUMN driver TEXT`;
49 yield* sql`ALTER TABLE orchestration_v2_projection_provider_sessions ADD COLUMN provider_instance_id TEXT`;
50 yield* sql`
51 UPDATE orchestration_v2_projection_provider_sessions
52 SET
53 driver = COALESCE(json_extract(payload_json, '$.driver'), provider),
54 provider_instance_id = COALESCE(
55 json_extract(payload_json, '$.providerInstanceId'),
56 provider
57 )
58 `;
59 yield* sql`CREATE INDEX orchestration_v2_projection_provider_sessions_instance_status_idx ON orchestration_v2_projection_provider_sessions(provider_instance_id, status)`;
60
61 yield* sql`ALTER TABLE orchestration_v2_projection_provider_threads ADD COLUMN driver TEXT`;
62 yield* sql`ALTER TABLE orchestration_v2_projection_provider_threads ADD COLUMN provider_instance_id TEXT`;
63 yield* sql`
64 UPDATE orchestration_v2_projection_provider_threads
65 SET
66 driver = COALESCE(json_extract(payload_json, '$.driver'), provider),
67 provider_instance_id = COALESCE(
68 json_extract(payload_json, '$.providerInstanceId'),
69 provider
70 )
71 `;
72 yield* sql`CREATE INDEX orchestration_v2_projection_provider_threads_instance_status_idx ON orchestration_v2_projection_provider_threads(provider_instance_id, status)`;
73
74 yield* sql`ALTER TABLE orchestration_v2_projection_subagents ADD COLUMN driver TEXT`;
75 yield* sql`ALTER TABLE orchestration_v2_projection_subagents ADD COLUMN provider_instance_id TEXT`;
76 yield* sql`
77 UPDATE orchestration_v2_projection_subagents
78 SET
79 driver = json_extract(payload_json, '$.driver'),
80 provider_instance_id = COALESCE(
81 json_extract(payload_json, '$.providerInstanceId'),
82 provider
83 )
84 `;
85
86 yield* sql`ALTER TABLE orchestration_v2_projection_context_transfers ADD COLUMN source_provider_instance_id TEXT`;
87 yield* sql`ALTER TABLE orchestration_v2_projection_context_transfers ADD COLUMN target_provider_instance_id TEXT`;
88 yield* sql`
89 UPDATE orchestration_v2_projection_context_transfers
90 SET
91 source_provider_instance_id = COALESCE(
92 json_extract(payload_json, '$.sourceProviderInstanceId'),
93 source_provider
94 ),
95 target_provider_instance_id = COALESCE(
96 json_extract(payload_json, '$.targetProviderInstanceId'),
97 target_provider
98 )
99 `;
100
101 yield* sql`
102 CREATE TABLE orchestration_v2_effect_outbox (
103 effect_id TEXT PRIMARY KEY,
104 command_id TEXT NOT NULL,
105 thread_id TEXT NOT NULL,
106 effect_type TEXT NOT NULL,
107 payload_json TEXT NOT NULL,
108 status TEXT NOT NULL CHECK (status IN ('pending', 'running', 'succeeded', 'failed')),
109 attempt_count INTEGER NOT NULL DEFAULT 0,
110 available_at TEXT NOT NULL,
111 lease_owner TEXT,
112 lease_expires_at TEXT,
113 created_at TEXT NOT NULL,
114 updated_at TEXT NOT NULL,
115 completed_at TEXT,
116 last_error TEXT
117 )
118 `;
119 yield* sql`CREATE INDEX orchestration_v2_effect_outbox_claim_idx ON orchestration_v2_effect_outbox(status, available_at, lease_expires_at, created_at)`;
120 yield* sql`CREATE INDEX orchestration_v2_effect_outbox_command_idx ON orchestration_v2_effect_outbox(command_id, effect_id)`;
121
122 yield* sql`
123 CREATE TABLE orchestration_v2_turn_item_positions (
124 thread_id TEXT NOT NULL,
125 turn_item_id TEXT NOT NULL,
126 ordinal INTEGER NOT NULL,
127 PRIMARY KEY (thread_id, turn_item_id),
128 UNIQUE (thread_id, ordinal)
129 )
130 `;
131 yield* sql`
132 INSERT INTO orchestration_v2_turn_item_positions (
133 thread_id,
134 turn_item_id,
135 ordinal
136 )
137 SELECT
138 item.thread_id,
139 item.turn_item_id,
140 COALESCE(run.ordinal, 0) * 1000000 + ROW_NUMBER() OVER (
141 PARTITION BY item.thread_id, COALESCE(run.ordinal, 0)
142 ORDER BY item.ordinal, item.turn_item_id
143 )
144 FROM orchestration_v2_projection_turn_items AS item
145 LEFT JOIN orchestration_v2_projection_runs AS run
146 ON run.thread_id = item.thread_id
147 AND run.run_id = item.run_id
148 `;
149
150 yield* sql`
151 CREATE TABLE orchestration_v2_projection_metadata (
152 projection_name TEXT PRIMARY KEY,
153 schema_version INTEGER NOT NULL,
154 last_sequence INTEGER NOT NULL,
155 updated_at TEXT NOT NULL
156 )
157 `;
158 yield* sql`
159 INSERT INTO orchestration_v2_projection_metadata (
160 projection_name,
161 schema_version,
162 last_sequence,
163 updated_at
164 )
165 VALUES (
166 'thread-projections',
167 1,
168 COALESCE((SELECT MAX(sequence) FROM orchestration_v2_events), 0),
169 strftime('%Y-%m-%dT%H:%M:%fZ', 'now')
170 )
171 `;
172 });