sequelize find one code example
Example 1: sequelize find one
const project = await Project.findOne({ where: { title: 'My Title' } });
if (project === null) {
console.log('Not found!');
} else {
console.log(project instanceof Project); // true
console.log(project.title); // 'My Title'
}
Example 2: 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 3: sequelize max
exports.getMinPrice = () => Item.findAll({ attributes: [[sequelize.fn('min', sequelize.col('price')), 'minPrice']], });
Example 4: sequelize get data
Tokens.findAll({
where: { guid: req.query['guid'] }
}).then(tokens => {
console.log(tokens[0]['date'])
}).catch(err => console.log('erro: ' + err));;