From 7096fb3941579e5c045796361745d597e03ff7fc Mon Sep 17 00:00:00 2001 From: MohamedBassem Date: Wed, 28 Feb 2024 15:50:08 +0000 Subject: fix: Fix drizzle logging params in prod --- packages/db/drizzle.ts | 13 ++++++++++++- 1 file changed, 12 insertions(+), 1 deletion(-) (limited to 'packages') diff --git a/packages/db/drizzle.ts b/packages/db/drizzle.ts index adfe4884..2f8dc1b0 100644 --- a/packages/db/drizzle.ts +++ b/packages/db/drizzle.ts @@ -4,9 +4,20 @@ import Database from "better-sqlite3"; import * as schema from "./schema"; import { migrate } from "drizzle-orm/better-sqlite3/migrator"; import path from "path"; +import { Logger } from "drizzle-orm"; + +class MyLogger implements Logger { + logQuery(query: string, params: unknown[]): void { + let line = `Query: ${query}`; + if (process.env.NODE_ENV !== "production") { + line += ` , params: ${JSON.stringify(params)}`; + } + console.log(line); + } +} const sqlite = new Database(process.env.DATABASE_URL); -export const db = drizzle(sqlite, { schema, logger: true }); +export const db = drizzle(sqlite, { schema, logger: new MyLogger() }); export function getInMemoryDB(runMigrations: boolean) { const mem = new Database(":memory:"); -- cgit v1.2.3-70-g09d2