diff options
| -rw-r--r-- | .gitignore | 3 | ||||
| -rw-r--r-- | app/drizzle.config.ts | 2 | ||||
| -rw-r--r-- | app/package.json | 2 | ||||
| -rw-r--r-- | app/src/hooks.server.ts | 3 | ||||
| -rw-r--r-- | app/src/lib/server/db/index.ts | 5 | ||||
| -rw-r--r-- | app/src/lib/server/db/schema.ts | 11 |
6 files changed, 11 insertions, 15 deletions
@@ -63,4 +63,5 @@ report.[0-9]_.[0-9]_.[0-9]_.[0-9]_.json actualDataDir .sb1state .sb1at.json -**/.svelte-kit
\ No newline at end of file +**/.svelte-kit +**/build/**
\ No newline at end of file diff --git a/app/drizzle.config.ts b/app/drizzle.config.ts index 317f310..d57e081 100644 --- a/app/drizzle.config.ts +++ b/app/drizzle.config.ts @@ -4,7 +4,7 @@ if (!process.env.DATABASE_URL) throw new Error('DATABASE_URL is not set'); export default defineConfig({ schema: './src/lib/server/db/schema.ts', - dialect: 'sqlite', + dialect: 'postgresql', dbCredentials: { url: process.env.DATABASE_URL }, verbose: true, strict: true diff --git a/app/package.json b/app/package.json index 0419e92..f4985d5 100644 --- a/app/package.json +++ b/app/package.json @@ -20,7 +20,6 @@ "@sveltejs/adapter-node": "^5.4.0", "@sveltejs/kit": "^2.49.2", "@sveltejs/vite-plugin-svelte": "^6.2.1", - "@types/better-sqlite3": "^7.6.13", "@types/node": "^25.0.3", "@types/pg": "^8.16.0", "drizzle-kit": "^0.31.8", @@ -36,7 +35,6 @@ }, "dependencies": { "@ivars/ueb": "^0.1.0", - "better-sqlite3": "^12.5.0", "pg": "^8.16.3" } }
\ No newline at end of file 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"), |