Swap sqlite for postgres

3 files changed, 8 insertions, 11 deletions

diff --git a/app/src/hooks.server.ts b/app/src/hooks.server.ts
deleted file mode 100644
index 739ef2b..0000000
--- a/app/src/hooks.server.ts
+++ /dev/null
@@ -1,3 +0,0 @@
-export async function handleFetch({ event, request, fetch }) {
-    return await fetch(request);
-}
\ No newline at end of file
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"),