From f67ae821230da9bc92a3c9ff6c550a36d48c0ee9 Mon Sep 17 00:00:00 2001 From: MohamedBassem Date: Wed, 28 Feb 2024 15:43:32 +0000 Subject: tests: Add tests for the bookmarks routes --- packages/db/drizzle.ts | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'packages/db') diff --git a/packages/db/drizzle.ts b/packages/db/drizzle.ts index def1fc0a..adfe4884 100644 --- a/packages/db/drizzle.ts +++ b/packages/db/drizzle.ts @@ -2,6 +2,17 @@ import "dotenv/config"; import { drizzle } from "drizzle-orm/better-sqlite3"; import Database from "better-sqlite3"; import * as schema from "./schema"; +import { migrate } from "drizzle-orm/better-sqlite3/migrator"; +import path from "path"; const sqlite = new Database(process.env.DATABASE_URL); export const db = drizzle(sqlite, { schema, logger: true }); + +export function getInMemoryDB(runMigrations: boolean) { + const mem = new Database(":memory:"); + const db = drizzle(mem, { schema, logger: true }); + if (runMigrations) { + migrate(db, { migrationsFolder: path.resolve(__dirname, "./drizzle") }); + } + return db; +} -- cgit v1.2.3-70-g09d2