Complex Associations

[sequelize]

Complex Associations

[sdepold]

Due to being on the train at the moment I can't test it, but what exactly is the problem? Right now you should be able to do

Project.belongsTo(User, { as: "Founder" });
someproject.getFounder();

What is not working is:

Project.hasMany(User, { as: "Owner" }); // singular
someproject.getOwners();

but

Project.hasMany(User, { as: "Owners" }); // singular
someproject.getOwners();

should work. Isn't it?

[mjadobson]

Sorry, I'm probably not being very clear. I'll write a gist to try and clarify what I mean.

[mjadobson]

Ok, so I'm not reporting a bug here (or at least I don't think I am). What I would like to add is functionality for having multiple associations between 2 models.

The // singular comment I made was just to indicate a possible change in API, to make things more consistent, and have proper pluralisation when finding associated data in reverse.

Hopefully this gist makes it a bit clearer: https://gist.github.com/1045705

If I'm still not making any sense, let me know.

[sdepold]

ah ok i got it. if i remember correctly, someone requested in issue about automatical pluralization and that it should be possible to disable it. so i added the "as" flag to overwrite the default behavior. but i guess i will automatically pluralize it if a specific config flag in sequelize isn't set or so. thanks for your request

[matjaz]

is this still actual?

I have a similar problem.
I have a Game with two properties.

Game.hasMany(User,    { as: 'X' })
Game.hasMany(User,    { as: 'O' })

As @Sugarstack already pointed it out. second association overwrites the first one.

[sdepold]

you have to defined the foreignKey http://sequelizejs.com/?active=associations#associations

[matjaz]

It is many-many relation.

I expect GamesUsers table would have following fields:
-GameId
-UserId
-type (X or O)

or have two "GamesUsers" relation tables.

[sdepold]

well you can just define the reference table on your own. here is a not tested version:

var Sequelize = require("sequelize")
  , sequelize = new Sequelize('database', 'root')

var User = sequelize.define('User', { username: Sequelize.STRING })
  , Game = sequelize.define('Game', { title: Sequelize.STRING })
  , GameUser = sequelize.define('GameUser', {
      userId: Sequelize.INTEGER
    , gameId: Sequelize.INTEGER
    , gameType: Sequelize.STRING
    })

User.hasMany(GameUser)
Game.hasMany(GameUser)
GameUser.belongsTo(Game).belongsTo(User)

sequelize.sync({ force: true }).success(function() {
  // create your stuff
})

But yeah, you can't do things like game.getUsers().

[mjadobson]

Yeah, I ended up writing my own SQL lib because I wanted a nice way for users to have many different relationships with tables. I still think it would be a nice addition to sequelize though.

[janmeier]

Implemented in the joinTableModel PR