node.js - 无法解析 Node js 中的 sequelize 对象

Question

以下是使用 sequelize ORM 的连接查询的输出

[ dashboard_grid_elements {
dataValues: 
 { id: 1,
   grid_id: '816',
   type: 1,
   subtype: 1,
   created_at: 2018-04-09T13:33:05.776Z,
   updated_at: 2018-04-09T13:33:05.776Z },
_previousDataValues: 
 { id: 1,
   grid_id: '816',
   type: 1,
   subtype: 1,
   created_at: 2018-04-09T13:33:05.776Z,
   updated_at: 2018-04-09T13:33:05.776Z },
_changed: {},
_modelOptions: 
 { timestamps: true,
   validate: {},
   freezeTableName: true,
   underscored: true,
   underscoredAll: false,
   paranoid: false,
   rejectOnEmpty: false,
   whereCollection: null,
   schema: null,
   schemaDelimiter: '',
   defaultScope: {},
   scopes: [],
   indexes: [],
   name: [Object],
   omitNull: false,
   tableName: 'dashboard_grid_elements',
   sequelize: [Object],
   hooks: {},
   uniqueKeys: {} },
_options: 
 { isNewRecord: false,
   _schema: null,
   _schemaDelimiter: '',
   include: undefined,
   includeNames: undefined,
   includeMap: undefined,
   includeValidated: true,
   raw: true,
   attributes: undefined },
__eagerlyLoadedAssociations: [],
isNewRecord: false } ]

尝试使用dashboard_grid_elements.type获取type的值时，显示undefined。有没有办法解析这个json对象。

Answer 1

添加 raw : true 您的查询，它将返回普通对象。

model.findOne({
    raw : true ,
    ...
}).then((user) => {
    console.log(user.type);
})

或(仅当您使用 findOne 或获取单个对象而不是对象数组时)

model.findOne({
    ...
}).then((user) => {
    user = user.toJSON();
    console.log(user.type);
})