Readonly
Optional
A list of log levels to log or a custom logger function.
Currently there's only two levels: query and error. This will be expanded based on user feedback later.
query
error
Setting up built-in logging for preferred log levels:
import * as Sqlite from 'better-sqlite3'import { Kysely, SqliteDialect } from 'kysely'import type { Database } from 'type-editor' // imaginary moduleconst db = new Kysely<Database>({ dialect: new SqliteDialect({ database: new Sqlite(':memory:'), }), log: ['query', 'error']}) Copy
import * as Sqlite from 'better-sqlite3'import { Kysely, SqliteDialect } from 'kysely'import type { Database } from 'type-editor' // imaginary moduleconst db = new Kysely<Database>({ dialect: new SqliteDialect({ database: new Sqlite(':memory:'), }), log: ['query', 'error']})
Setting up custom logging:
import * as Sqlite from 'better-sqlite3'import { Kysely, SqliteDialect } from 'kysely'import type { Database } from 'type-editor' // imaginary moduleconst db = new Kysely<Database>({ dialect: new SqliteDialect({ database: new Sqlite(':memory:'), }), log(event): void { if (event.level === 'query') { console.log(event.query.sql) console.log(event.query.parameters) } }}) Copy
import * as Sqlite from 'better-sqlite3'import { Kysely, SqliteDialect } from 'kysely'import type { Database } from 'type-editor' // imaginary moduleconst db = new Kysely<Database>({ dialect: new SqliteDialect({ database: new Sqlite(':memory:'), }), log(event): void { if (event.level === 'query') { console.log(event.query.sql) console.log(event.query.parameters) } }})
A list of log levels to log or a custom logger function.
Currently there's only two levels:
query
anderror
. This will be expanded based on user feedback later.Examples
Setting up built-in logging for preferred log levels:
Setting up custom logging: