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

041_AuthSessionClientConnection.ts

23 lines619 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(auth_sessions)
8 `;
9​
10 if (!columns.some((column) => column.name === "client_surface")) {
11 yield* sql`
12 ALTER TABLE auth_sessions
13 ADD COLUMN client_surface TEXT
14 `;
15 }
16​
17 if (!columns.some((column) => column.name === "client_app_version")) {
18 yield* sql`
19 ALTER TABLE auth_sessions
20 ADD COLUMN client_app_version TEXT
21 `;
22 }
23});