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

main
ts 22 lines 728 Bytes
Raw
1 // Historical sessions cannot be mapped unambiguously to configured instances; leave the column nullable.
2 import * as SqlClient from "effect/sql/SqlClient";
3 import * as Effect from "effect/Effect";
4
5 export default Effect.gen(function* () {
6 const sql = yield* SqlClient.SqlClient;
7
8 const columns = yield* sql<{ readonly name: string }>`
9 PRAGMA table_info(provider_session_runtime)
10 `;
11 if (!columns.some((column) => column.name === "provider_instance_id")) {
12 yield* sql`
13 ALTER TABLE provider_session_runtime
14 ADD COLUMN provider_instance_id TEXT
15 `;
16 }
17
18 yield* sql`
19 CREATE INDEX IF NOT EXISTS idx_provider_session_runtime_instance
20 ON provider_session_runtime(provider_instance_id)
21 `;
22 });