Get raw query generated by sequelize.js

Question

Good afternoon everyone. I am developing a node.js/express system using sequelize.js (postgresql).

My problem is: I need to store the raw queries generated by sequelize in a log history, but I can't find a function that returns the generated query. Does anyone know if sequelize provides a function that returns the generated SQL query, or if there's any other way to achieve this?

score 9 · Accepted Answer · answered Jan 14 '15 at 20:27

9

Your best bet is to use Sequelize's built-in logging functionality.

var sequelize = new Sequelize('db', 'username', 'pwd', {

  // you can either write to console
  logging: console.log

  // or write your own custom logging function
  logging: function (str) {
    // do stuff with the sql str
  }
});

answered Jan 14 '15 at 20:27

Yuri Zarubin

11,439
4
30
33

4

what if I want to print specific query only and not all queries? – Piyush Arora Sep 26 '16 at 07:33
1

You can use {logging: true} with the particular query. Check the params of the [FindAll](http://docs.sequelizejs.com/class/lib/model.js~Model.html#static-method-findAll) – Nimish Gupta Dec 14 '18 at 14:31
7

What if we only want to get a query not to execute? – Pradip Bhuvani Nov 17 '21 at 09:09

Get raw query generated by sequelize.js

1 Answers1

Linked