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

main
ts 42 lines 1.17 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 IF NOT EXISTS scheduled_tasks (
9 task_id TEXT PRIMARY KEY,
10 title TEXT NOT NULL,
11 prompt TEXT NOT NULL,
12 enabled INTEGER NOT NULL,
13 schedule_json TEXT NOT NULL,
14 project_id TEXT NOT NULL,
15 thread_id TEXT,
16 workspace_strategy_json TEXT NOT NULL,
17 model_selection_json TEXT NOT NULL,
18 runtime_mode TEXT NOT NULL,
19 interaction_mode TEXT NOT NULL,
20 created_by TEXT NOT NULL,
21 creation_source TEXT NOT NULL,
22 created_at TEXT NOT NULL,
23 updated_at TEXT NOT NULL,
24 next_run_at TEXT,
25 last_run_at TEXT,
26 last_run_status TEXT NOT NULL,
27 last_run_error TEXT,
28 run_count INTEGER NOT NULL
29 )
30 `;
31
32 yield* sql`
33 CREATE INDEX IF NOT EXISTS idx_scheduled_tasks_due
34 ON scheduled_tasks(enabled, next_run_at)
35 WHERE enabled = 1 AND next_run_at IS NOT NULL
36 `;
37
38 yield* sql`
39 CREATE INDEX IF NOT EXISTS idx_scheduled_tasks_project
40 ON scheduled_tasks(project_id, updated_at)
41 `;
42 });