Updating a model with a composite primary key

[nathasm]

I have a model that is set up to have a composite primary key:

knex.schema.createTable('table', function(t) {
  ....
  t.primary(['user_id', 'another_id'])
});

When using bookshelf, I have a User model with a function 'add' that will add the user or update the user if they already exist. I'm doing something like:

  add: function(data, attrs) {
    return User.forge(data).fetch().then(function(user) {
      if(user) {
        // If I remove the update, it assumes insert and save fails since the primary key already exists
        return user.save({ attrs: attrs }, { method: 'update' });
      }
      return User.forge(connection).save();
    });
  },

The code above, as written, yields an error of

Error: A model cannot be updated without a "where" clause or an idAttribute.

Is there a way to save/update the user with a composite key by just doing 'save' or do I need to include the 'where' clause as well?

[gdw2]

I'm having the same problem.

[rhys-vdw]

Unfortunately bookshelf does currently not support composite keys.

Is there a way to save/update the user with a composite key by just doing 'save' or do I need to include the 'where' clause as well?

You'll have to use a where clause for now.

I'm going to close this as a duplicate as this issue is being tracked in #93.

[kc5ez]

@rhys-vdw

I am also trying to save/update a table that has composite keys. since bookshelf doesn't support composite keys, should we just get rid of composite key completely and use another ORM?

What is a workaround?

Can you provide an example of using the where clause in the save function? I've tried it but still trying to return 'id' (which does not exist)

[dnascimento]

@kichingxx just use where clause like:

new model().where({key: keyVal}).save(obj)

However, compose keys should be a bookshelf feature...

[ItsShadowCone]

Unfortunately bookshelf does currently not support composite keys.

Has this changed in the past ~2 years?