0

I am new to Sequelize and trying to write equivalent Sequelize query in Node js for the following MySQL select statement.

SELECT date(Game.TournamentDate) Date,
       COUNT(DISTINCT CASE WHEN Game in('Ludo','Cricket') && (Player.Status in ('Active','Rest')) THEN Point END) Field1 ,
       COUNT(DISTINCT CASE WHEN Player.Code in('PLY1','PLY2') && (Player.Status = 'Sleeping') THEN Point END) Field2  
FROM Game 
       LEFT JOIN Player ON Game.ID = Player.ID 
WHERE Game.TournamentDate BETWEEN '" + dateFrom + "' AND DATE_ADD('" + dateTo + "',INTERVAL 1 day) 
GROUP BY date(Game.TournamentDate) 
ORDER BY date(Game.TournamentDate)

** Query is altered for demo purpose.

I have seen this question How to use CASE WHEN expression in Sequelize? but I want to know the feature close to Sequelize, but in case if there is no easy or possible way to do it in native syntax then please let me know the meaning of following syntax in where condition of the question mentioned in the link.

Type: ['Employee', 'School', 'Public', 'Other']
Ajendra Prasad
  • 299
  • 1
  • 8
  • 22

1 Answers1

0

You Can go for Raw Query as well in sequilize. Something like this

sequelize.query("SELECT * FROM `users`", { type: sequelize.QueryTypes.SELECT}).then(users => {})

Check Out this

Er Mitul Parmar
  • 33
  • 1
  • 11