sequelize.js - 在创建后的续集中添加响应“val”：“CURRENT_TIMESTAMP”时间实例（2019-03-22 09:56:38）

Question

在创建后的 Sequelize 中添加时间的响应"val": "CURRENT_TIMESTAMP"实例（2019-03-22 09:56:38） ，代码中定义的内容如下所述

模型：

        created_at: {
              type: DataTypes.DATE,
              allowNull: false,
              defaultValue: sequelize.literal('CURRENT_TIMESTAMP'),
            },

控制器：

    Message.create(
          {
            col: body.col
          },
        ).then((
          const MessageResponse = response.get({
            plain: true,
          });
       res.send(apiSuccessHandler({}, { MessageResponse, message: 'Your request submitted successfully.' }, 200));
    }).catch((err) => {
      console.log(err);
      res.status(403).send(apiFailureHandler({ message: "We couldn't save your request, please try again." }, {}, 403));
    });

回复：

{
    "resultState": {
        "status": 200,
        "message": "Success"
    },
    "MessageResponse": {
        //what i get
         "created_at": {
            "val": "CURRENT_TIMESTAMP"
        },
        //my requirement 
        "created_at": 2019-03-22 09:56:38,
        "id": 60,

    },
    "message": "Your request submitted successfully."
}

标签： sequelize.js

Answer 1

你可以试试这个

 Message.create(
      {
        col: body.col,
        created_at: moment(), // add this line
      },
    ).then((
      const MessageResponse = response.get({
        plain: true,
      });
   res.send(apiSuccessHandler({}, { MessageResponse, message: 'Your request submitted successfully.' }, 200));
}).catch((err) => {
  console.log(err);
  res.status(403).send(apiFailureHandler({ message: "We couldn't save your request, please try again." }, {}, 403));
});