Skip to content
Source
Sign inSign up
pingdotgg/t3code
Open History to see the last commit

038_ProjectionThreadsPinOrderKey.ts

16 lines453 Bytes

1import * as Effect from "effect/Effect";
2import * as SqlClient from "effect/sql/SqlClient";
3​
4export default Effect.gen(function* () {
5 const sql = yield* SqlClient.SqlClient;
6 const columns = yield* sql<{ readonly name: string }>`
7 PRAGMA table_info(projection_threads)
8 `;
9​
10 if (!columns.some((column) => column.name === "pin_order_key")) {
11 yield* sql`
12 ALTER TABLE projection_threads
13 ADD COLUMN pin_order_key TEXT
14 `;
15 }
16});