sequelize.js - Multiple One to many relations modelling -
i have 2 models both of have relation users table i.e. project users has foreign key users, , comments belong users
for project users model (projectusers.js file):
var user = require('./users').table; var pusers_table = db.define('project_users', { ... }); pusers_table.belongsto(user); user.hasmany(pusers_table); for comments model (comments.js file):
var user = require('./users').table; var comments_table = db.define('comments', { ... }); comments_table.belongsto(user); user.hasmany(comments_table); please note 3 (users, project users , comments) defined in different js files , included using requirejs.
typeerror: cannot read property 'associationtype' of null @ null.<anonymous> (./node_modules/sequelize/lib/dialects/abstract/query.js:328:54) @ array.foreach (native) @ module.exports.buildassociateddaoinstances (./node_modules/sequelize/lib/dialects/abstract/query.js:324:21) @ module.exports.transformrowwitheagerloadingintodao (./node_modules/sequelize/lib/dialects/abstract/query.js:295:37) @ null.<anonymous> (./node_modules/sequelize/lib/dialects/abstract/query.js:282:50) @ array.map (native) @ module.exports.transformrowswitheagerloadingintodaos (./node_modules/sequelize/lib/dialects/abstract/query.js:281:58) @ module.exports.handleselectquery (./node_modules/sequelize/lib/dialects/abstract/query.js:262:54) @ module.exports.abstractquery.formatresults (./node_modules/sequelize/lib/dialects/abstract/query.js:68:34) @ null.<anonymous> (./node_modules/sequelize/lib/dialects/mysql/query.js:32:35) @ query.sequence.end (./node_modules/mysql/lib/protocol/sequences/sequence.js:66:24) @ query._handlefinalresultpacket (./node_modules/mysql/lib/protocol/sequences/query.js:143:8) @ query.eofpacket (./node_modules/mysql/lib/protocol/sequences/query.js:127:8) @ protocol._parsepacket (./node_modules/mysql/lib/protocol/protocol.js:172:24) @ parser.write (./node_modules/mysql/lib/protocol/parser.js:62:12) @ protocol.write (./node_modules/mysql/lib/protocol/protocol.js:37:16) @ socket.ondata (stream.js:51:26) @ socket.eventemitter.emit (events.js:117:20) @ socket.<anonymous> (_stream_readable.js:710:14) @ socket.eventemitter.emit (events.js:92:17) @ emitreadable_ (_stream_readable.js:382:10) @ emitreadable (_stream_readable.js:378:5) @ readableaddchunk (_stream_readable.js:143:7) @ socket.readable.push (_stream_readable.js:113:10) @ tcp.onread (net.js:511:21) i tried upgrading sequelize , on sequelize@1.7.0-alpha1 still have issue.
please note not error if have 1 of these defined (i.e. if remove relations in comments, project users works totally fine, , vice versa).
what doing wrong?
Comments
Post a Comment