postgresql - 如何在 Sequelize.js 的 where 子句中使用 if 条件

Question

仅当 manufacturer_id 不等于 null 时，我才想查询 ManufacturerId: manufacturer_id。

我试过这段代码，但它给我语法错误:

/* Get Brands List */
router.get('/', function(req, res) {
  var archived_status = req.query["archived-status"];
  var manufacturer_id = req.params.manufacturer_id;
  models.Brand.findAll({
    where: {
        brand_archived_status: archived_status,
        if(manufacturer_id != null){
          ManufacturerId: manufacturer_id
        }
    },
    include: [{
      model: models.Job,
      required: false
    }]
  }).  
  then(function(brands) {  
      res.status(200).json(brands);  
  }, function(error) {  
      res.status(500).send(error);  
  });  
});

Answer 1

你为什么不在 Sequelize 查询之外创建整个 where 条件，给你:

let where = {
    brand_archived_status: archived_status
};
if (manufacturer_id != null) {
    where['ManufacturerId'] = manufacturer_id
}

models.Brand.findAll({
    where,
    include: [{
        model: models.Job,
        required: false
    }]
})

这看起来干净简单:)