`attach` with additional attributes

[bookshelf]

`attach` with additional attributes

[ErisDS]

I ended up here with the same question after searching 😉, I then found the following hints, which I thought it would be helpful to post here:

• Example on stackoverflow showing this is working now: http://stackoverflow.com/a/22153459/1808480
• Docs on with/update Pivot http://bookshelfjs.org/#Model-withPivot
• Related discussion #134

[vjpr]

At the moment I'm just creating a join table model like so:

class Collection
  addLink: (link) =>
      cl = db.Models.CollectionLink.forge
        collectionId: @id
        linkId: link.id
        order: 0
      cl.save()

[tgriesser]

So I think I intended to be able to pass a model as a joinTableName but hadn't quite gotten there yet... If you want to try to work out an implementation/tests for it as a PR, that'd be great...I think the issue may have been with the need for a composite key based on the foreignKey & otherKey but also potentially allowing an idAttribute id... I'm not sure, I'll take out that comment for now so it's not confusing.

Right now you can do this:

collection.belongsToMany(db.Models.Link).attach(link.attributes)

And the object that is set as the attributes will be saved with additional columns, but I realize that doesn't help with wanting a model/methods/timestamps on the join table... I'll think a bit more about this one.

[tgriesser]

Oh... I know what I was going to do here - the equivalent of ActiveRecord's hasMany :through - where you could do

links: function() {
   return this.hasMany(Links, CollectionsLinks);
}

And then you'd have a CollectionsLinks model to work with for the joining table... Didn't quite work through the specifics, including how you'd access the join model or how the the fetch/eager loading on that would work... Does that make sense though?

[vjpr]

Yep that makes sense.

[tgriesser]

So @vjpr - this is sort of in the works. With 0.3.0 I added .belongsToMany(Model).through(OtherModel) which works well for retrieval, but I'm still working out how attaching & working with the OtherModel happens. I'll keep you posted when I make progress on this one.

[mistakia]

Hey, just wondering if there's an update on how to attach relations with a join model/table with additional attributes (timestamps, etc)?

[rhys-vdw]

Hi @ErisDS. Thanks for pointing this out. I'll try to update the docs soon.