Something went wrong. Try again.
This repository has no description
Something went wrong. Try again.
988 B · 51 lines
TypeScript
at main
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152import Database from "better-sqlite3";import { Kysely, SqliteDialect } from "kysely";
const DATABASE_PATH = process.env.DATABASE_PATH || "app.db";
let _db: Kysely<DatabaseSchema> | null = null;
export const getDb = (): Kysely<DatabaseSchema> => { if (!_db) { const sqlite = new Database(DATABASE_PATH); sqlite.pragma("journal_mode = WAL");
_db = new Kysely<DatabaseSchema>({ dialect: new SqliteDialect({ database: sqlite }), }); } return _db;};
export interface DatabaseSchema { auth_state: AuthStateTable; auth_session: AuthSessionTable; account: AccountTable; status: StatusTable;}
interface AuthStateTable { key: string; value: string;}
interface AuthSessionTable { key: string; value: string;}
export interface AccountTable { did: string; handle: string; active: 0 | 1;}
export interface StatusTable { uri: string; authorDid: string; status: string; createdAt: string; indexedAt: string; current: 0 | 1;}