序列化紧急加载错误: social_logins未关联到用户

Question

用户模型定义如下。

const db = require ('../../config/db_config');

const users = db.sequelize.define('users', {
  id: {
    type: db.DataTypes.INTEGER,
    primaryKey: true,
    autoIncrement: true,
  },
  first_name: {
    type: db.DataTypes.STRING(150),
  },
  last_name: {
    type: db.DataTypes.STRING(150),
  },
  email: {
    type: db.DataTypes.STRING(256),
    required: true,
    unique: true
  },
  password: {
    type: db.DataTypes.STRING,
  },
  student_id: {
    type: db.DataTypes.STRING
  },
  status: {
    type: db.DataTypes.BOOLEAN,
    required: true,
    defaultValue: 0
  },
  is_deleted: {
    type: db.DataTypes.BOOLEAN,
    required: true,
    defaultValue: 0
  },
  createdAt: db.DataTypes.DATE,
  updatedAt: db.DataTypes.DATE,
});

module.exports = users;

定义如下的social_logins模型

const db = require ('../../config/db_config');

const socialLogins = db.sequelize.define('social_logins', {
  id: {
     type: db.DataTypes.INTEGER,
     primaryKey: true,
     autoIncrement: true,
  },
  token: {
    type: db.DataTypes.STRING
  },
  tokenType: {
    type: db.DataTypes.STRING
  },
  fb_id: {
    type: db.DataTypes.STRING
  },
  user_id: {
    type: db.DataTypes.INTEGER
  },
  is_deleted: {
    type: db.DataTypes.BOOLEAN,
    required: true,
    defaultValue: false
  }
}, { underscored: true, timestamp: true, tableName: 'social_logins' });

module.exports = socialLogins;

使用belongsTo函数与social_logins模型关联的用户模型

socialLoginsModel.belongsTo(users)

Sequelize抛出eagerLoadingError错误EagerLoadingError SequelizeEagerLoadingError: social_logins未关联到用户！

在运行下面给出的查询时。

const userModel = require ('./users_model');
const socialLoginModel = require('../social_logins/social_logins_model');

let id = "123456";
let email = "ex@example.com";

userModel.findOne({
  where: { email },
  include: [{
     model: socialLogins,
     where: {
       fb_id: id
     }
  }]
});

Answer 1

根据您的模型名称，您应该具有如下所示的关联

基于数据库中定义的关系的socialLogins.belongsTo(用户)& users.hasOne(socialLogins)/ users.hasMany(socialLogins)