unlight/prisma-query-log

Log prisma query event

prisma-query-log

Log prisma query event. Currently works only for SQLite, MySQL.

Features:

• Substitute parameters
• Remove backticks and database prefix

Install

npm install --save-dev prisma-query-log

Usage

import { createPrismaQueryEventHandler } from 'prisma-query-log';
import { PrismaClient } from '@prisma/client';

const prisma = new PrismaClient({
    log: [
        {
            level: 'query',
            emit: 'event',
        },
    ],
});

const log = createPrismaQueryEventHandler();

prisma.$on('query', log);

API

function createPrismaQueryEventHandler(
    options?: CreatePrismaQueryEventHandlerArgs,
): (event: PrismaQueryEvent) => void;

const defaultOptions = {
    /**
     * Boolean of custom log function,
     * if true `console.log` will be used,
     * if false noop - logs nothing.
     */
    logger: true as boolean | ((query: string) => unknown),
    /**
     * Remove backticks.
     */
    unescape: true,
    /**
     * Color of query (ANSI escape code)
     */
    colorQuery: undefined as undefined | string,
    /**
     * Color of parameters (ANSI escape code)
     */
    colorParameter: undefined as undefined | string,
    /**
     * Format SQL query,
     * colorQuery/colorParameter will be ignored.
     */
    format: false,

    /**
     * Formatter options
     * https://github.com/mtxr/vscode-sqltools/tree/master/packages/formatter#options
     */

    /**
     * Show Query Duration, default is false
     */
    queryDuration: false as boolean,

    /**
     * Query language, default is Standard SQL
     */
    language: undefined as 'sql' | 'n1ql' | 'db2' | 'pl/sql' | undefined,
    /**
     * Characters used for indentation
     */
    indent: '    ',
    /**
     * How to change the case of reserved words
     */
    // eslint-disable-next-line unicorn/no-null
    reservedWordCase: null as 'upper' | 'lower' | null,
    /**
     * How many line breaks between queries
     */
    linesBetweenQueries: 1 as number | 'preserve',
};

Other projects

https://github.com/unlight/nestolog - Logger for NestJS, implements LoggerService

Screenshots

Before

After

Development

docker run -it -p 5432:5432 -e POSTGRES_PASSWORD=postgres -e POSTGRES_USER=user postgres
docker run -it -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password -e MYSQL_DATABASE=query_log_example_db mysql

prisma-query-log's Issues

Todo

• where x in (x,x,x) -> (x, x, x)
• support postgres
• create bug about parse params #4

Error JSON.parse(eventParams)

 index.ts: const params: any[] = JSON.parse(eventParams);

eventParams not always is json.
For example:

prisma.Movie.create({
    data: {
        description: `she will give him ten days of "love," at blabla....`,
    } 
})

Params in this case:

["she will give him ten days of "love," at blabla...."]

This is not valid json string.

Versions:

    "prisma": "^3.7.0",
    "prisma-query-log": "^3.1.0",

Error:

SyntaxError: Unexpected token l in JSON at position ...