@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 35 lines 1.88 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 // ProjectionStore.listActiveShellIndex reads these fields from the index instead of parsing
8 // every active thread's payload. Keep the expressions identical to that query's.
9 yield* sql`
10 CREATE INDEX IF NOT EXISTS orchestration_v2_projection_threads_active_shell_idx
11 ON orchestration_v2_projection_threads(
12 updated_at,
13 thread_id,
14 project_id,
15 CASE WHEN json_valid(payload_json) THEN json_extract(payload_json, '$.lineage.relationshipToParent') END,
16 CASE WHEN json_valid(payload_json) THEN json_extract(payload_json, '$.lineage.parentThreadId') END,
17 CASE WHEN json_valid(payload_json) THEN json_extract(payload_json, '$.lineage.rootThreadId') END,
18 CASE WHEN json_valid(payload_json) THEN json_extract(payload_json, '$.lineage.sideChat') END,
19 CASE WHEN json_valid(payload_json) THEN json_extract(payload_json, '$.settledOverride') END,
20 CASE WHEN json_valid(payload_json) THEN json_extract(payload_json, '$.settledAt') END,
21 CASE WHEN json_valid(payload_json) THEN json_extract(payload_json, '$.pinnedAt') END,
22 CASE WHEN json_valid(payload_json) THEN json_extract(payload_json, '$.pinOrderKey') END,
23 CASE WHEN json_valid(payload_json) THEN json_extract(payload_json, '$.snoozedUntil') END,
24 CASE WHEN json_valid(payload_json) THEN json_type(payload_json, '$.pullRequests[0]') END
25 )
26 WHERE deleted_at IS NULL AND archived_at IS NULL
27 `;
28 yield* sql`
29 CREATE INDEX IF NOT EXISTS orchestration_v2_projection_provider_threads_pending_tasks_idx
30 ON orchestration_v2_projection_provider_threads(thread_id)
31 WHERE CASE WHEN json_valid(payload_json)
32 THEN json_array_length(payload_json, '$.pendingBackgroundTasks') > 0
33 ELSE 0 END
34 `;
35 });