how to return query data sequelize code example
Example 1: sequelize query result
sequelize.query("UPDATE users SET y = 42 WHERE x = 12").spread(function(results,
metadata) {
// Results will be an empty array and metadata will contain the number of
// affected rows.
})
/* In cases where you don't need to access the metadata you can pass in a query
type to tell sequelize how to format the results. For example, for a simple
select query you could do: */
sequelize.query("SELECT * FROM `users`", { type: sequelize.QueryTypes.SELECT})
.then(function(users) {
// We don't need spread here, since only the results will be returned for
// select queries
})
Example 2: sequelize get data
Tokens.findAll({
where: { guid: req.query['guid'] }
}).then(tokens => {
console.log(tokens[0]['date'])
}).catch(err => console.log('erro: ' + err));;