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

main
ts 27 lines 854 Bytes
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_projection_provider_session_bindings (
9 provider_session_id TEXT NOT NULL,
10 thread_id TEXT NOT NULL,
11 PRIMARY KEY (provider_session_id, thread_id)
12 )
13 `;
14 yield* sql`
15 INSERT OR IGNORE INTO orchestration_v2_projection_provider_session_bindings (
16 provider_session_id,
17 thread_id
18 )
19 SELECT provider_session_id, thread_id
20 FROM orchestration_v2_projection_provider_sessions
21 WHERE thread_id IS NOT NULL
22 `;
23 yield* sql`
24 CREATE INDEX orchestration_v2_projection_provider_session_bindings_thread_idx
25 ON orchestration_v2_projection_provider_session_bindings(thread_id)
26 `;
27 });