How do I convert a SQL query for Sequelize?

Question

I have a SQL query (using mysql as DB) that I now need to rewrite as a sequelize.js query in node.js.

SQL Query

SELECT p.UserID, SUM(p.score), u.username
FROM Picks p
LEFT JOIN Users u
ON p.UserId = u.id
GROUP BY p.UserId;

not quite sure how this query needs to be structured to get the same results with sequelize.

Answer 1

This should do what you're needing:

db.Pick.findAll({
  attributes: [
    'UserID',
    [db.sequelize.fn('SUM', db.sequelize.col('score')), 'score']
  ],
  include: [{
    model: db.User,
    required: true,
    attributes: ['username']
  }],
  group: ['UserID']
}).then((results) => {
  ...
})