you can use the query options {raw: true} to return the raw result. Your query should like follows: db.Sensors.findAll({ where: { nodeid: node.nodeid }, raw: true, }) also if you have associations with include that gets flattened. So, we can use another parameter nest:true db.Sensors.findAll({ where: { nodeid: node.nodeid }, raw: true, nest: true, })
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 } }); You can also pass a logging option to .sync if you only want to view the table … Read more
While the accepted answer isn’t technically wrong, it doesn’t answer the original question nor the follow up question in the comments, which was what I came here looking for. But I figured it out, so here goes. If you want to find all Posts that have Users (and only the ones that have users) where … Read more
Generating the “first migration” In your case, the most reliable way is to do it almost manually. I would suggest to use sequelize-cli tool. The syntax is rather plain: sequelize init … sequelize model:create –name User –attributes first_name:string,last_name:string,bio:text This will create both model AND migration. Then, manually merge your existing models with generated with sequelize-cli, … Read more
Since version 2.0.0 you need to wrap your where clause in a where property: Project.update( { title: ‘a very different title now’ }, { where: { _id: 1 } } ) .success(result => handleResult(result) ) .error(err => handleError(err) ) Update 2016-03-09 The latest version actually doesn’t use success and error anymore but instead uses then-able … Read more
When you create your Sequelize object, pass false to the logging parameter: var sequelize = new Sequelize(‘database’, ‘username’, ‘password’, { // disable logging; default: console.log logging: false }); For more options, check the docs.