jquery - 如何使用 Sequelize 修复 RAW 查询

Question

我有一个这样的查询:

SELECT merchant_id as name,count(id) as y FROM table_name WHERE DATE(created_at) = current_date() GROUP BY merchant_id

我将使用 Squelize 在 hapijs 中运行此查询。

我像这样尝试但不起作用，返回空数组

return new Promise(async function (resolve, reject) {
        return await sequelize.query(query, { type: sequelize.QueryTypes.SELECT})
        .then(users => {
            resolve(users)
        })
        .catch(error => {
            reject(error)
        })
    });

Answer 1

试试这个怎么样？

return new Promise(async (resolve, reject) => {
      try {
        const users = await sequelize.query(query, { type: sequelize.QueryTypes.SELECT})
        resolve(users)
      } catch (error) {
        reject(error)
      }
    });