NodeJs报SequelizeDatabaseError Unknown column ‘created_at‘ in ‘field list‘解决方法

秋9

于 2022-09-25 15:40:01 发布

阅读量3k

点赞数 3

分类专栏： NodeJS 文章标签： sql 数据库

本文链接：https://blog.csdn.net/jlq_diligence/article/details/127038666

版权

NodeJS 专栏收录该内容

28 篇文章

订阅专栏

现象

{
    "ret": 0,
    "msg": "获取失败",
    "e": {
        "name": "SequelizeDatabaseError",
        "parent": {
            "code": "ER_BAD_FIELD_ERROR",
            "errno": 1054,
            "sqlState": "42S22",
            "sqlMessage": "Unknown column 'created_at' in 'field list'",
            "sql": "SELECT `id`, `room_id` AS `roomId`, `stu_name` AS `stuName`, `stu_code` AS `stuCode`, `vision_left` AS `visionLeft`, `vision_right` AS `visionRight`, `vision_avg` AS `visionAvg`, `correct_left` AS `correctLeft`, `correct_right` AS `correctRight`, `correct_avg` AS `correctAvg`, `change_yn` AS `changeYn`, `vision_source` AS `visionSource`, `vision_type` AS `visionType`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `vision` AS `vision` WHERE `vision`.`room_id` = 1681;"
        },
        "original": {
            "code": "ER_BAD_FIELD_ERROR",
            "errno": 1054,
            "sqlState": "42S22",
            "sqlMessage": "Unknown column 'created_at' in 'field list'",
            "sql": "SELECT `id`, `room_id` AS `roomId`, `stu_name` AS `stuName`, `stu_code` AS `stuCode`, `vision_left` AS `visionLeft`, `vision_right` AS `visionRight`, `vision_avg` AS `visionAvg`, `correct_left` AS `correctLeft`, `correct_right` AS `correctRight`, `correct_avg` AS `correctAvg`, `change_yn` AS `changeYn`, `vision_source` AS `visionSource`, `vision_type` AS `visionType`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `vision` AS `vision` WHERE `vision`.`room_id` = 1681;"
        },
        "sql": "SELECT `id`, `room_id` AS `roomId`, `stu_name` AS `stuName`, `stu_code` AS `stuCode`, `vision_left` AS `visionLeft`, `vision_right` AS `visionRight`, `vision_avg` AS `visionAvg`, `correct_left` AS `correctLeft`, `correct_right` AS `correctRight`, `correct_avg` AS `correctAvg`, `change_yn` AS `changeYn`, `vision_source` AS `visionSource`, `vision_type` AS `visionType`, `created_at` AS `createdAt`, `updated_at` AS `updatedAt` FROM `vision` AS `vision` WHERE `vision`.`room_id` = 1681;",
        "parameters": {}
    }
}

原因：

Nodejs中，在Sequelize创建实例时未设置timestamps参数，timestamps参数含义为是否给每条记录添加createdAt和updatedAt字段，默认为true。通过使此参数为false使其不添加这两个参数即可。

解决方法：

module.exports = app => {
  const { STRING, INTEGER, DATE, BOOLEAN, DOUBLE ,TEXT} = app.Sequelize;

  const Vision = app.model.define('vision', {
    id: { type: INTEGER, primaryKey: true, autoIncrement: true },
    stuName: STRING(32),
    stuCode: STRING(32),
    visionLeft:{type: DOUBLE,defaultValue: 0},
    visionRight:{type: DOUBLE,defaultValue: 0},
    visionAvg:{type: DOUBLE,defaultValue: 0}
  },{tableName: 'vision',timestamps: false});
  return Vision;
};