FastLegs include/join for multi-relationship tables/ circular dependency about fastlegs HOT 3 CLOSED

Hey. We've been quiet on this project for a while, but we're starting to try to pick up again. Hopefully we can get to this in the next week or two. Can you explain the second point about circular dependencies a little more? We typically define a model in its own file and require them, you should be able to create those dependencies that way. However, we haven't run performance tests on something like that, so I can't guarantee good results.

from fastlegs.

It is a great project, I am sure all users appreciate the effort.

circular depency (in terms of the variables) e.g.

USERS receive many reviews... REVIEWS are made by many USERS

var Reviews = FastLegS.Base.extend({
tableName: 'reviews',
primaryKey: 'id'
_fields: [
{ 'column_name': 'user_id' },
{ 'column_name': 'author_id' },
{ 'column_name': 'id' },
{ 'column_name': 'comment' }
]
});

var Users = FastLegS.Base.extend({
tableName: 'users',
primaryKey: 'id',
_fields: [
{ 'column_name': 'id' },
{ 'column_name': 'first' },
{ 'column_name': 'last' }
]
many: [
{ 'reviews': Reviews, joinOn: 'user_id' },
//**{'users': Users, joinOn: 'user_id'} Reviews may have many authors, however Users would be UNdefined (yes i know i presently wouldn't be able to connect using user_id).
]
});

If i wanted to perform a join on users and reviews; and at the sametime get the author of those reviews it would NOT be possible since (see **)

User.find({ 'id.in': ['1', '2', '3'] }, {
only: ['id', 'first', 'last'],
order: ['-first'],
include: { 'reviews': {
//* There is no way i can include users here again since i cant say
//* include on reviews.author_id = users.id
//** FastLegs always assFK to a PK OR two columns that are not Keys
}
}
}, function(err, results) {
//
});

from fastlegs.

Relationships will have to be defined outside of the models for e.g. http://nodetoolbox.com/packages/jugglingdb OR https://github.com/1602/jugglingdb they are too tightly coupled to the model.

from fastlegs.