@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 29 lines 1.35 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 yield* sql`ALTER TABLE scheduled_tasks ADD COLUMN last_run_webhook_delivery_id TEXT`;
7 yield* sql`CREATE TABLE scheduled_task_webhook_replay_keys (
8 task_id TEXT NOT NULL REFERENCES scheduled_tasks(task_id) ON DELETE CASCADE,
9 replay_key TEXT NOT NULL,
10 delivery_id TEXT NOT NULL,
11 expires_at INTEGER NOT NULL,
12 PRIMARY KEY (task_id, replay_key)
13 )`;
14 yield* sql`CREATE INDEX idx_webhook_replay_expiry ON scheduled_task_webhook_replay_keys(expires_at)`;
15 yield* sql`CREATE INDEX idx_webhook_replay_delivery ON scheduled_task_webhook_replay_keys(delivery_id)`;
16 yield* sql`CREATE TABLE scheduled_task_webhook_pending (
17 delivery_id TEXT PRIMARY KEY,
18 task_id TEXT NOT NULL REFERENCES scheduled_tasks(task_id) ON DELETE CASCADE,
19 coalesce_key TEXT NOT NULL,
20 due_at INTEGER NOT NULL,
21 state TEXT NOT NULL DEFAULT 'pending',
22 task_json TEXT NOT NULL,
23 request_json TEXT NOT NULL,
24 delivery_ids_json TEXT NOT NULL
25 )`;
26 yield* sql`CREATE INDEX idx_webhook_pending_due ON scheduled_task_webhook_pending(state, due_at)`;
27 yield* sql`CREATE UNIQUE INDEX idx_webhook_pending_key
28 ON scheduled_task_webhook_pending(task_id, coalesce_key) WHERE state = 'pending'`;
29 });