node.js - Squeelize 无法访问外键

Question

我正在尝试这个例子:

const Sequelize = require('sequelize');

const sequelize = new Sequelize({
    dialect: 'sqlite',
    storage: 'foo/database.sqlite'
});

class User extends Sequelize.Model {
}

User.init({
    name: Sequelize.STRING,
}, {
    sequelize,
    modelName: 'user'
});

class Project extends Sequelize.Model {
}

Project.init({
    name: Sequelize.STRING
}, {
    sequelize,
    modelName: 'project'
});

User.hasMany(Project);
User.create({
    name: "foo",
    tags: [
        {name: "project_1"}
    ]
}, {
    include: [Project]
});

Project.sync().then(() => console.log("project table created"));
User.sync().then(() => console.log("user table created"));

User.findAll().then((users) => {
    for (user of users) {
        console.log(user.Projects);

    }
});

对于给定的用户，我希望获得所有项目。但是，这会打印出 undefined。

如何访问给定用户的项目？

Answer 1

我相信您必须在选择中指定您也想要这些项目:

User.findAll({
    include: [{
        model: Project
    }]
})