如何查看 Sequelize.js 生成的 SQL? [英] How can I see the SQL generated by Sequelize.js?

问题描述

我想查看发送到 PostgreSQL 服务器的 SQL 命令，因为我需要检查它们是否正确.特别是，我对表创建命令感兴趣.

I want to see the SQL commands that are sent to the PostgreSQL server because I need to check if they are correct. In particular, I am interested in the table creation commands.

例如，ActiveRecord (Ruby) 将其 SQL 语句打印到标准输出.Node.js/ActionHero.js 和 Sequelize.js 是否也能做到这一点?

For instance, ActiveRecord (Ruby) prints its SQL statements to standard output. Is this possible with Node.js/ActionHero.js and Sequelize.js as well?

推荐答案

初始化sequelize的时候可以传入一个日志选项，可以是函数也可以是console.log

You can pass a logging option when initializing sequelize, which can either be a function or console.log

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

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

You can also pass a logging option to .sync if you only want to view the table creation queries

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

这篇关于如何查看 Sequelize.js 生成的 SQL?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！