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

main
ts 18 lines 771 Bytes
Raw
1 import * as Effect from "effect/Effect";
2 import * as SqlClient from "effect/sql/SqlClient";
3
4 import { createMessageSearchTriggers } from "../../orchestration-v2/messageSearchIndex.ts";
5
6 export default Effect.gen(function* () {
7 const sql = yield* SqlClient.SqlClient;
8 const index = yield* sql`
9 SELECT 1 FROM sqlite_master WHERE name = 'orchestration_v2_message_search'
10 `;
11 if (index.length === 0) return;
12
13 // Legacy placeholders stay indexed until rebuild; FTS deletes can overflow last_insert_rowid at commit.
14 yield* sql`DROP TRIGGER orchestration_v2_message_search_insert`;
15 yield* sql`DROP TRIGGER orchestration_v2_message_search_update`;
16 yield* sql`DROP TRIGGER orchestration_v2_message_search_delete`;
17 yield* createMessageSearchTriggers(sql);
18 });