Sequelize 模型与模型无关 [英] Sequelize Model is not associated with model

问题描述

我一直在无所事事地花费几个小时.我有很多资源，它们都差不多，但我就是无法让我的项目发挥作用.

这个问题

<小时>

评论部分的 Anatoly 指出，当 findOne 启动时，db.users 似乎没有关联.以下是我在 server.js 中设置模型的方法:

<代码>....const db = require("./app/models")如果(process.env.NODE_ENV ===生产"){db.sequelize.sync().then(() => {使用路由()种子数据库()})} 别的 {db.sequelize.sync({ force: true }).then(() => {console.log("删除并重新同步数据库.")使用路由()种子数据库()})}函数 useRoutes() {console.log("使用路由...")require("./app/routes/user/user.routes")(app)require("./app/routes/emojis/emojis.routes")(app)require("./app/routes/auth/auth.routes")(app)const db = require("./app/models")//风俗.db.op = db.Sequelize.Op//楷模db.appsettings = require("./app/models/appsettings/appsettings.model")(db.sequelize, db.Sequelize)db.countries = require("./app/models/appsettings/country.model")(db.sequelize, db.Sequelize)db.users = require("./app/models/user/user.model")(db.sequelize, db.Sequelize)db.roles = require("./app/models/user/role.model")(db.sequelize, db.Sequelize)db.userscores = require("./app/models/user/userscore.model")(db.sequelize, db.Sequelize)db.answers = require("./app/models/game/answer.model")(db.sequelize, db.Sequelize)db.categories = require("./app/models/game/category.model")(db.sequelize, db.Sequelize)db.questions = require("./app/models/game/question.model")(db.sequelize, db.Sequelize)db.useracoomlishedquestions = require("./app/models/game/useracoomlishedquestion.model")(db.sequelize, db.Sequelize)}

<小时>

models/index.js(由 Sequelize 生成，我对其进行了一些修改，并使用 glob 轻松扫描子文件夹)

'use strict';const fs = require('fs');const path = require('path');const Sequelize = require('sequelize');const basename = path.basename(__filename);const env = process.env.NODE_ENV ||'发展';const config = require(__dirname + '/../config/config')[env];const db = {};const glob = require("glob")让续集；如果(config.use_env_variable){sequelize = new Sequelize(process.env[config.use_env_variable], config);} 别的 {sequelize = new Sequelize(config.database, config.username, config.password, config);}//使用 glob 访问子文件夹中的模型文件.const 文件 = glob.sync(__dirname + "/*/*.js")files.forEach(file => {const model = sequelize['import'](file);db[model.name] = 模型；})Object.keys(db).forEach(modelName => {如果 (db[modelName].associate) {db[modelName].associate(db);}});db.sequelize = 续集；db.Sequelize = 续集；module.exports = db;

解决方案

通过这段代码

//模型db.appsettings = require("./app/models/appsettings/appsettings.model")(db.sequelize, db.Sequelize)db.countries = require("./app/models/appsettings/country.model")(db.sequelize, db.Sequelize)db.users = require("./app/models/user/user.model")(db.sequelize, db.Sequelize)db.roles = require("./app/models/user/role.model")(db.sequelize, db.Sequelize)db.userscores = require("./app/models/user/userscore.model")(db.sequelize, db.Sequelize)db.answers = require("./app/models/game/answer.model")(db.sequelize, db.Sequelize)db.categories = require("./app/models/game/category.model")(db.sequelize, db.Sequelize)db.questions = require("./app/models/game/question.model")(db.sequelize, db.Sequelize)db.useracoomlishedquestions = require("./app/models/game/useracoomlishedquestion.model")(db.sequelize, db.Sequelize)

您覆盖了在 models/index.js 中注册的模型定义，这就是这些模型没有关联的原因.只需删除这些行.

I've been spending hours for nothing. I've had so many sources, they are all kinda the same, but I just couldn't make my project work.

This question Sequelize.js - "is not associated to" is so much the same to mine, BUT, this question of mine shouldn't be a duplicate. Because it has certainly a new issue!

To list down my sources, the ones that I've read thoroughly and tried out:

1. Sequelize.js - "is not associated to"
2. Sequelize 4.3.2 n:m (many-to-many) association: Unhandled rejection SequelizeEagerLoadingError
3. Link to a book on Google
4. https://medium.com/@eth3rnit3/sequelize-relationships-ultimate-guide-f26801a75554

To add context, I'm trying to provide a route that lets the users get their profile. Every USER has ONLY one ROLE.

Like so:

{
  id: 4,
  email: '[e-mail]',
  role: {
     id: 2,
     name: 'admin'
  }
}

Using findOne with WHERE and INCLUDE

exports.getme = (req, res) => {
  db.users.findOne({
    where: { id: req.user.id },
    include: [{
      model: db.roles,
    }]
  })  
  .then(data => {
    res.send(data)
  })
  .catch(err => {
    console.log(err)
    res.status(500).send({
      message: "An error has occured while retrieving data."
    })
  })
}

The error that I get is:

Role is not associated to User!

---

And here are the models, and how I put their respective associations:

Role.js

'use strict';
module.exports = (sequelize, DataTypes) => {
  const Role = sequelize.define('Role', {
    id: {
      type: DataTypes.INTEGER,
      allowNull: false,
      primaryKey: true,
      autoIncrement: true,
      field: "id"
    },
    role: DataTypes.STRING
  }, {
    timestamps: false
  });
  Role.associate = function (models) {
    Role.hasMany(models.User, {
      foreignKey: "roleId",
      sourceKey: "id"
    })
  }
  return Role;
};

User.js

'use strict';
module.exports = (sequelize, DataTypes) => {
  const User = sequelize.define('User', {
    id: { type: DataTypes.BIGINT, allowNull: false, autoIncrement: true, unique: true, primaryKey: true },
    email: DataTypes.STRING,
  }, {});
  User.associate = function (models) {
    User.belongsTo(models.Role, { 
      foreignKey: "roleId", 
      targetKey: "id"
    });
  }
  return User
}

---

Also, when I check the relations of my tables, I can only see details in my USER table, but none in my ROLES table.

---

EDIT: Anatoly from the comment section pointed out that it seems db.users has no association when the findOne fires up. Here's how I setup my models in my server.js:

....
const db = require("./app/models")

if (process.env.NODE_ENV === "production") {
  db.sequelize.sync().then(() => {
    useRoutes()
    seedDB()
  })
} else {
  db.sequelize.sync({ force: true }).then(() => {
    console.log("Drop and re-sync db.")
    useRoutes()
    seedDB()
  })
}

function useRoutes() {
  console.log("Use routes...")
  require("./app/routes/user/user.routes")(app)
  require("./app/routes/emojis/emojis.routes")(app)
  require("./app/routes/auth/auth.routes")(app)

  const db = require("./app/models")
  // Custom.
  db.op = db.Sequelize.Op
  // Models
  db.appsettings = require("./app/models/appsettings/appsettings.model")(db.sequelize, db.Sequelize)
  db.countries = require("./app/models/appsettings/country.model")(db.sequelize, db.Sequelize)

  db.users = require("./app/models/user/user.model")(db.sequelize, db.Sequelize)
  db.roles = require("./app/models/user/role.model")(db.sequelize, db.Sequelize)
  db.userscores = require("./app/models/user/userscore.model")(db.sequelize, db.Sequelize)

  db.answers = require("./app/models/game/answer.model")(db.sequelize, db.Sequelize)
  db.categories = require("./app/models/game/category.model")(db.sequelize, db.Sequelize)
  db.questions = require("./app/models/game/question.model")(db.sequelize, db.Sequelize)
  db.useracoomplishedquestions = require("./app/models/game/useracoomplishedquestion.model")(db.sequelize, db.Sequelize)
}

---

models/index.js (generated by Sequelize and I modified it a bit and use glob to scan through subfolders easily)

'use strict';

const fs = require('fs');
const path = require('path');
const Sequelize = require('sequelize');
const basename = path.basename(__filename);
const env = process.env.NODE_ENV || 'development';
const config = require(__dirname + '/../config/config')[env];
const db = {};
const glob = require("glob")

let sequelize;
if (config.use_env_variable) {
  sequelize = new Sequelize(process.env[config.use_env_variable], config);
} else {
  sequelize = new Sequelize(config.database, config.username, config.password, config);
}

// Use glob to access model files inside subfolders.
const files = glob.sync(__dirname + "/*/*.js")

files.forEach(file => {
  const model = sequelize['import'](file);
  db[model.name] = model;
})

Object.keys(db).forEach(modelName => {
  if (db[modelName].associate) {
    db[modelName].associate(db);
  }
});

db.sequelize = sequelize;
db.Sequelize = Sequelize;

module.exports = db;

解决方案

By this code

// Models
  db.appsettings = require("./app/models/appsettings/appsettings.model")(db.sequelize, db.Sequelize)
  db.countries = require("./app/models/appsettings/country.model")(db.sequelize, db.Sequelize)

  db.users = require("./app/models/user/user.model")(db.sequelize, db.Sequelize)
  db.roles = require("./app/models/user/role.model")(db.sequelize, db.Sequelize)
  db.userscores = require("./app/models/user/userscore.model")(db.sequelize, db.Sequelize)

  db.answers = require("./app/models/game/answer.model")(db.sequelize, db.Sequelize)
  db.categories = require("./app/models/game/category.model")(db.sequelize, db.Sequelize)
  db.questions = require("./app/models/game/question.model")(db.sequelize, db.Sequelize)
  db.useracoomplishedquestions = require("./app/models/game/useracoomplishedquestion.model")(db.sequelize, db.Sequelize)

you overridden model definitions registered in models/index.js that's why these models don't have associations. Just remove these lines.

这篇关于Sequelize 模型与模型无关的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！