sequelize get records from model code example
Example 1: sequelize get where
// Example
const Tokens = db.define('tokens', {
guid: {
type: sequelize.STRING
}
});
// The basics of Sequelize Get Where
Tokens.findAll({
where: { guid: 'guid12345' }
}).then(tokens => {
console.log(tokens);
}).catch(err => console.log('error: ' + err));;
// is equal to >> SELECT * FROM Tokens WHERE guid = 'guid12345'
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));;