Knex.js - SQL Debugging Only

Question

Is there a way to display only SQL queries on the console when debug mode is on? I want to reduce the amount of information that is displayed.

Thanks for the help;)

Answer 1

Actually, if you use MySQL, you can install

debug: ['ComQueryPacket']

as part of the configuration settings for mysql (not Knex).

I will consider this as an option in Knex.

Answer 2

Set the environment variables to configure the module debug:

• DEBUG=knex:query for just inquiries
• DEBUG=knex:tx for transactions
• and DEBUG=knex*for everyone.

Answer 3

, , , "", Knex .

:

var knex = require( 'knex' );
knex.on( 'query', function( queryData ) {
    console.log( queryData );
});

, queryData json .