序列化，使关联返回问题
|
我目前正在尝试Sequelize，并且有两个对象，分别是
Person
Position
var User = sequelize.define(\'user\', {
first_name: Sequelize.STRING,
last_name: Sequelize.STRING
});
var Position = sequelize.define(\'position\', {
name: Sequelize.STRING,
affiliation: Sequelize.STRING
});
Position.hasMany(User, { foreignKey : \'position_id\' });
User.belongsTo(Position, { foreignKey : \'position_id\'});
User.findAll({ fetchAssociations: true }, function(results) {
//I\'ve tried doing some work in here, but haven\'t found the correct procedure.
}).on(\'success\', function(results) {
res.render(\'users\', {
title: \'user page\',
users: results
});
});
没有找到相关结果
已邀请:
4 个回复
好按紊叉
User.findAll().on(\'success\', function(users) { var chainer = new Sequelize.Utils.QueryChainer , _users = [] users.forEach(function(u) { var emitter = new Sequelize.Utils.CustomEventEmitter(function() { u.getPosition().on(\'success\', function(pos) { _users.push({user: u, position: pos}) emitter.emit(\'success\') }) }) chainer.add(emitter.run()) }) chainer.run().on(\'success\', function() { res.render(\'users\', { title: \'user page\', users: _users }) }) })锯康
Position.hasMany(User, {foreignKey : \'position_id\', as: \'User\'}); User.belongsTo(Position, {foreignKey : \'position_id\', as: \'Posit\'});User.findAll({ include: [{ model: Position, as: \'Posit\' }] }).success(function(match) { // your logic });博沮富教全
User.findAll().on(\'success\', function(users) { // asd })谦响局豢报
// define models var Person = sequelize.define(\'Person\', { name: Sequelize.STRING }); var Task = sequelize.define(\'Task\', { name: Sequelize.STRING, nameWithPerson: { type: Sequelize.VIRTUAL, get: function() { return this.name + \' (\' + this.Person.name + \')\' } attributes: [ \'name\' ], include: [ { model: Person, attributes: [ \'name\' ] } ], order: [ [\'name\'], [ Person, \'name\' ] ] } }); // define associations Task.belongsTo(Person); Person.hasMany(Task); // activate virtual fields functionality sequelize.initVirtualFields();