From 6c65d3947e56530e7ec3976e2955b027b7abe679 Mon Sep 17 00:00:00 2001
From: ivar <i@oiee.no>
Date: Fri, 19 Dec 2025 12:05:27 +0100
Subject: Swap sqlite for postgres

---
 app/src/lib/server/db/index.ts  |  5 ++---
 app/src/lib/server/db/schema.ts | 11 ++++++-----
 2 files changed, 8 insertions(+), 8 deletions(-)

(limited to 'app/src/lib/server/db')

diff --git a/app/src/lib/server/db/index.ts b/app/src/lib/server/db/index.ts
index b3c877b..3168d01 100644
--- a/app/src/lib/server/db/index.ts
+++ b/app/src/lib/server/db/index.ts
@@ -1,10 +1,9 @@
-import { drizzle } from 'drizzle-orm/better-sqlite3';
+import { drizzle } from 'drizzle-orm/node-postgres';
 import Database from 'better-sqlite3';
-import * as schema from './schema';
 import { env } from '$env/dynamic/private';
 
 if (!env.DATABASE_URL) throw new Error('DATABASE_URL is not set');
 
 const client = new Database(env.DATABASE_URL);
 
-export const db = drizzle(client, { schema });
+export const db = drizzle(env.DATABASE_URL);
\ No newline at end of file
diff --git a/app/src/lib/server/db/schema.ts b/app/src/lib/server/db/schema.ts
index c1bea43..150d970 100644
--- a/app/src/lib/server/db/schema.ts
+++ b/app/src/lib/server/db/schema.ts
@@ -1,15 +1,16 @@
 import { relations } from 'drizzle-orm';
-import { int, sqliteTable, text } from 'drizzle-orm/sqlite-core';
+import { numeric, text, pgTable } from "drizzle-orm/pg-core";
 
-export const syncSession = sqliteTable("session", {
+
+export const syncSession = pgTable("session", {
 	id: text('id').primaryKey().$defaultFn(() => crypto.randomUUID()),
 	authzState: text("authzState"),
-	accessTokenCreated: int("accessTokenCreated"),
-	refreshTokenCreated: int("refreshTokenCreated"),
+	accessTokenCreated: numeric("accessTokenCreated"),
+	refreshTokenCreated: numeric("refreshTokenCreated"),
 	tokens: text("tokens")
 })
 
-export const syncLog = sqliteTable("session_log", {
+export const syncLog = pgTable("session_log", {
 	id: text("id").primaryKey(),
 	sessionId: text("session_id"),
 	dateTime: text("date_time"),
-- 
cgit v1.3