Guest User

Untitled

a guest
Oct 22nd, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. issues.belongsToMany(models.labels, {
  2. through: 'issues_labels',
  3. foreignKey: 'issueId',
  4. as: 'labels'
  5. });
  6.  
  7. issues.hasMany(models.issues_labels , {
  8. as: 'query'
  9. });
  10.  
  11. labels.belongsToMany(models.issues, {
  12. through: 'issues_labels',
  13. foreignKey: 'labelId',
  14. constraints: false
  15. });
  16.  
  17. issuesLabels.belongsTo(models.issues, {constraints: false});
  18. issuesLabels.belongsTo(models.labels, {constraints: false});
  19.  
  20. issues.findAll(
  21. {
  22. include: [
  23. {
  24. model: labels,
  25. as: 'labels',
  26. },
  27. {
  28. model: issues_labels,
  29. as: 'query',
  30. where: {
  31. labelId: {
  32. [op.in]: [2, 3]
  33. }
  34. }
  35. },
  36. ]
  37. }
  38. )
Add Comment
Please, Sign In to add comment