@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 21 lines 630 Bytes
Raw
1 import * as SqlClient from "effect/sql/SqlClient";
2 import * as Effect from "effect/Effect";
3
4 export default Effect.gen(function* () {
5 const sql = yield* SqlClient.SqlClient;
6
7 const columns = yield* sql<{ readonly name: string }>`
8 PRAGMA table_info(projection_thread_sessions)
9 `;
10 if (!columns.some((column) => column.name === "provider_instance_id")) {
11 yield* sql`
12 ALTER TABLE projection_thread_sessions
13 ADD COLUMN provider_instance_id TEXT
14 `;
15 }
16
17 yield* sql`
18 CREATE INDEX IF NOT EXISTS idx_projection_thread_sessions_instance
19 ON projection_thread_sessions(provider_instance_id)
20 `;
21 });