How to show queries in console log using sails?

Question

I am starting a project with sails and mysql, and I do'nt know how configurate it to show the queries executed in the console.

score 24 · Answer 1 · answered Dec 20 '14 at 18:01

24

The mysql adapter has a debug variable LOG_QUERIES to send all queries to the console.

LOG_QUERIES=true node myFile.js

answered Dec 20 '14 at 18:01

user1278519

816
6
9

3

This works fine, that variable is in file: sails-mysql/lib/adapter.js Thank you!!! :D – mzalazar Jan 06 '15 at 16:39
This work great thanks, @user1278519 and at mzalazar. – Vishnu Mishra Apr 27 '16 at 06:04
Note that this is an environment variable. – Tyler Collier Jul 15 '16 at 00:28

score 14 · Accepted Answer · edited May 23 '17 at 12:34

14

Unfortunately this isn't possible with Sails at this time, although the feature has been requested. Your best bet is to inspect the log file provided by your database:

Postgres: How to log PostgreSQL queries?

MySQL: Log all queries in mysql

MongoDB: MongoDB logging all queries

edited May 23 '17 at 12:34

Community

1
1

answered Mar 14 '14 at 18:40

sgress454

24,765
4
72
91

4

Use the `LOG_QUERIES=true node myFile.js` mentioned below – Tony Gutierrez Sep 17 '15 at 17:05
LOG_QUERIES=true is not working any more with sails 1.1 – Vishnu Mishra Oct 18 '19 at 13:56

score 2 · Answer 3 · answered Oct 30 '14 at 17:59

If you're doing Sails.js development on Mac OS with Postgresql.app, you can enable all query logging as follows:

In a new Terminal, edit ~/Library/Application Support/Postgres/var/postgresql.conf and set:

logging_collector = on
log_directory = 'pg_log'
log_statement = 'all'

Then restart Postgresql.app (click on menubar icon, Quit, then use Spotlight to relaunch).

Then tail the log with:

tail -F ~/Library/Application\ Support/Postgres/var/pg_log/postgresql-2014-10-30_104957.log

You'll have to find the newest postgresql-*log to tail and substitute that above.

latest postgresql.app has the var folder named var-9.* – chrismarx Apr 17 '16 at 15:17 — chrismarx, Apr 17 '16 at 15:17

score 2 · Answer 4 · answered Aug 01 '18 at 20:43

My answer might me very late but just found a solution which might help people sails version = 0.12.14

to log quires do following

navigate to node_modules\sails-mysql\lib\adapter.js

locate variable declaration of "log"

then change "process.env.LOG_QUERIES" to "sails.config.LOG_QUERIES"

navigate to

[sails root]/config/env/[development or production].js

add

LOG_QUERIES = 'true',

NOTE :- remember to put ""or '' for true

score 2 · Answer 5 · answered Aug 08 '20 at 20:45

2

This solution works for sails >= 1.1.

The sails-mysql (as of v1.0.0) adapter uses the machinepack-mysql driver which logs queries to debug. So all that's needed to log all native queries is to enable the debug flag:

DEBUG=query node app.js

answered Aug 08 '20 at 20:45

timcour

364
3
9

It also works for sails-mssql/sails-sqlserver adapter. – Cristian Torres Sep 01 '20 at 09:17

score 1 · Answer 6 · edited Jan 05 '15 at 19:53

1

Or add log to sql module.

In mysql this is:

working_dir/node_modules/sails-mysql/node_modules/mysql/lib/Connection.js

function **createQuery** (33)

edited Jan 05 '15 at 19:53

matthias_h

11,260
9
20
39

answered Jan 05 '15 at 18:53

Camel Rafal

11
1

score 0 · Answer 7 · answered Sep 19 '18 at 09:17

0

Put

LOG_QUERIES = 'true'

in sails lift command

answered Sep 19 '18 at 09:17

susheel

83
10

score 0 · Answer 8 · answered Aug 11 '20 at 06:32

Just add this to your datastore

debug: ["ComQueryPacket"]

config/datastores.js should be look like this

module.exports.datastores = {
  default: {
    adapter: 'sails-mysql',
    user: '*****',
    password: "****",
    host: '*****',
    database: '****',
    debug: ["ComQueryPacket"]
  }
}

How to show queries in console log using sails?

8 Answers8

Linked