javascript - 使用 Sequelize 每天每小时的负载数据

Question

如何加载每小时的交易记录。

if (ExpenseGraphTimeSeries === 'today') {
        let date = new Date(Date.now());
        let createdAt = {
          [Op.lt]: new Date(date),
          [Op.gte]: new Date().setHours(0, 0, 0, 0)
        };

        ExpenseGraphCondition.createdAt = createdAt
        ExpenseGraph = await model.Expense.findAll({
          where: createdAt,
          attributes: [
            [model.sequelize.fn('sum', model.sequelize.col('Amount')), 'expense'], 'createdAt'
          ],
        });
      }

当前输出是
|金额 |创建于 |
| -------- | -------------- |
|第2349章01-01-2020 00:00:00 |
|第2349章02-01-2020 00:00:00 |

i need record of every hour with amount of that hour. how to do this? 

Answer 1

group:[] 在 sequelize 中用于按组返回数据。
你的代码会是这样的

    if (ExpenseGraphTimeSeries === 'today') {
        let date = new Date(Date.now());
        let createdAt = {
          [Op.lt]: new Date(date),
          [Op.gte]: new Date().setHours(0, 0, 0, 0)
        };

        ExpenseGraphCondition.createdAt = createdAt
        ExpenseGraph = await model.Expense.findAll({
          where: createdAt,
          attributes: [
            [model.sequelize.fn('sum', model.sequelize.col('Amount')), 'expense'], 'createdAt'
          ],
          group: [model.sequelize.fn('hour', model.sequelize.col('createdAt'))],
          order: [['id', 'asc']], //optional
        });
      }