flo-bit.dev
[READ-ONLY] Mirror of https://github.com/flo-bit/skywatched. review movies and tv shows, based on at proto
skywatched.app
640 B
18 lines
1import { drizzle } from 'drizzle-orm/libsql';
2import { createClient } from '@libsql/client';
3import { env } from '$env/dynamic/private';
4import * as schema from './schema';
5
6if (!env.DATABASE_URL) throw new Error('DATABASE_URL is not set');
7const client = createClient({ url: env.DATABASE_URL, authToken: env.DATABASE_AUTH_TOKEN });
8export const db = drizzle(client, { schema: schema });
9
10client.execute(`CREATE TABLE IF NOT EXISTS auth_state (
11 key TEXT PRIMARY KEY UNIQUE,
12 state TEXT NOT NULL
13 );`);
14
15client.execute(`CREATE TABLE IF NOT EXISTS auth_session (
16 key TEXT PRIMARY KEY UNIQUE,
17 session TEXT NOT NULL
18 );`);