Tuesday 23 May 2017

Bookshelf query and update value in a single step

I am using Bookshelf JS as my ORM. I want to query for a special entity and update it one query (as if I execute INSERT INTO... WHERE...)

How can I do this without a raw query?

Here is how I do it right now:

async function updateSetting() { 
  let userSetting = await Setting.where({user: 1, key: 'foo'}).fetch()
  await userSetting.save({value: {confirmed: true, order: 66}})
}



via Hedge

No comments:

Post a Comment