sequelize.js - 在创建后的 Sequelize 中添加响应 "val": "CURRENT_TIMESTAMP" instance of time(2019-03-22 09:56:38)

Question

在创建后的 Sequelize 中添加响应 "val": "CURRENT_TIMESTAMP" time(2019-03-22 09:56:38) 的实例下面介绍代码中定义的内容

型号:

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

Controller :

    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."
}

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));
});