@devries-cameron20 / t3code Mirror · read-only
Fork 0

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

Mirrored from https://github.com/Camo67/t3code.git

Synced Nov 21, 04:45 UTC

main
ts 78 lines 2.03 KB
Raw
1 import * as Effect from "effect/Effect";
2 import * as SqlClient from "effect/sql/SqlClient";
3
4 export default Effect.gen(function* () {
5 const sql = yield* SqlClient.SqlClient;
6
7 yield* sql`
8 CREATE TABLE orchestration_v2_effect_outbox_next (
9 effect_id TEXT PRIMARY KEY,
10 command_id TEXT NOT NULL,
11 thread_id TEXT NOT NULL,
12 effect_type TEXT NOT NULL,
13 payload_json TEXT NOT NULL,
14 status TEXT NOT NULL CHECK (
15 status IN ('pending', 'running', 'succeeded', 'failed', 'cancelled')
16 ),
17 attempt_count INTEGER NOT NULL DEFAULT 0,
18 available_at TEXT NOT NULL,
19 lease_owner TEXT,
20 lease_expires_at TEXT,
21 created_at TEXT NOT NULL,
22 updated_at TEXT NOT NULL,
23 completed_at TEXT,
24 last_error TEXT
25 )
26 `;
27 yield* sql`
28 INSERT INTO orchestration_v2_effect_outbox_next (
29 effect_id,
30 command_id,
31 thread_id,
32 effect_type,
33 payload_json,
34 status,
35 attempt_count,
36 available_at,
37 lease_owner,
38 lease_expires_at,
39 created_at,
40 updated_at,
41 completed_at,
42 last_error
43 )
44 SELECT
45 effect_id,
46 command_id,
47 thread_id,
48 effect_type,
49 payload_json,
50 status,
51 attempt_count,
52 available_at,
53 lease_owner,
54 lease_expires_at,
55 created_at,
56 updated_at,
57 completed_at,
58 last_error
59 FROM orchestration_v2_effect_outbox
60 `;
61 yield* sql`DROP TABLE orchestration_v2_effect_outbox`;
62 yield* sql`
63 ALTER TABLE orchestration_v2_effect_outbox_next
64 RENAME TO orchestration_v2_effect_outbox
65 `;
66 yield* sql`
67 CREATE INDEX orchestration_v2_effect_outbox_claim_idx
68 ON orchestration_v2_effect_outbox(status, available_at, lease_expires_at, created_at)
69 `;
70 yield* sql`
71 CREATE INDEX orchestration_v2_effect_outbox_command_idx
72 ON orchestration_v2_effect_outbox(command_id, effect_id)
73 `;
74 yield* sql`
75 CREATE INDEX orchestration_v2_effect_outbox_thread_status_idx
76 ON orchestration_v2_effect_outbox(thread_id, status, effect_type)
77 `;
78 });