Scratch space for learning atproto app development
cduck.me
1import SqliteDb from "better-sqlite3";
2import { Kysely, Migrator, SqliteDialect } from "kysely";
3import { migrationProvider } from "./migrations";
4import type { DatabaseSchema } from "./schema";
5
6export const createDb = (location: string): Database => {
7 return new Kysely<DatabaseSchema>({
8 dialect: new SqliteDialect({
9 database: new SqliteDb(location),
10 }),
11 });
12};
13
14export const migrateToLatest = async (db: Database) => {
15 const migrator = new Migrator({ db, provider: migrationProvider });
16 const { error } = await migrator.migrateToLatest();
17 if (error) throw error;
18};
19
20export type Database = Kysely<DatabaseSchema>;