如何查看Sequelize.js生成的SQL？

初始化sequelize时可以传递日志记录选项,可以是函数或console.log

var sequelize = new Sequelize('database', 'username', 'password', {
    logging: console.log
    logging: function (str) {
        // do your own logging
    }
});

如果只想查看表创建查询,还可以将日志记录选项传递给.sync

sequelize.sync({ logging: console.log })

如日志中所述Error: Please note that find* was refactored and uses only one options object from now on..对于最新的sequelize版本(4),如果您只想获得一个命令的结果:

User.findAll({where: {...}, logging: console.log})

如果你想查看一个命令的sequelize,你可以听它并附加一个函数来打印sql.

看看这个例子:

User.find(1).on('sql', console.log).then(function(user) {
  // do whatever you want with the user here