sequelize 根据传递的参数动态组合多个where 条件怎么实现

Question

想用 sequelize 实现下面这样的功能，不知道该咋写，
根据查询参数动态组合 where 里的条件

let { name, age, gender } = this.request.query
let sql = `SELECT * FROM myTable WHERE status = 'active'`

if(name) {
    sql += ` AND name=${name}`
}
if(age) {
    sql += ` AND age=${age}`
}
if(gender) {
    sql += ` AND gender=${name}`
}

let data = await db.query(sql)

Answer 1

where 就是一个对象，merge 或 Object.assign 等方法都可以啊。

Answer 2

Project.findAll({
  where: {
    id: {
      $and: {a: 5}           // AND (a = 5)
      $or: [{a: 5}, {a: 6}]  // (a = 5 OR a = 6)
      $gt: 6,                // id > 6
      $gte: 6,               // id >= 6
      $lt: 10,               // id < 10
      $lte: 10,              // id <= 10
      $ne: 20,               // id != 20
      $between: [6, 10],     // BETWEEN 6 AND 10
      $notBetween: [11, 15], // NOT BETWEEN 11 AND 15
      $in: [1, 2],           // IN [1, 2]
      $notIn: [1, 2],        // NOT IN [1, 2]
      $like: '%hat',         // LIKE '%hat'
      $notLike: '%hat'       // NOT LIKE '%hat'
      $iLike: '%hat'         // ILIKE '%hat' (case insensitive)  (PG only)
      $notILike: '%hat'      // NOT ILIKE '%hat'  (PG only)
      $overlap: [1, 2]       // && [1, 2] (PG array overlap operator)
      $contains: [1, 2]      // @> [1, 2] (PG array contains operator)
      $contained: [1, 2]     // <@ [1, 2] (PG array contained by operator)
      $any: [2,3]            // ANY ARRAY[2, 3]::INTEGER (PG only)
    },
    status: {
      $not: false,           // status NOT FALSE
    }
  }
})