Change transaction "SET CONSTRAINTS"?

[olalonde]

Is it possible to modify the SET CONSTRAINTS of a transaction?

I have a transaction which inserts a book and then inserts a paragraph which references the book. The transaction is failing because I assume the paragraph is inserted before the book was committed. I would therefore need to set the transaction to SET CONSTRAINTS DEFERRED.

[olalonde]

Oops, I was mistaken, I forgot to add the { transacting: t } option to the paragraph insert. That being said, I'm still wondering about how to set constraints on a transaction. Can I pass the transaction to .raw?

[rhys-vdw]

There is no built in API for this currently, but you can pass it to raw.

bookshelf.transaction(function(trx) {
  trx.raw('set constraints deferred')
  .then(function() {
    // ...
  });
});

[rhys-vdw]

Relevant issue is being tracked for knex: knex/knex#581

[crunchtime-ali]

The project leadership of Bookshelf recently changed. In an effort to advance the project we close all issues older than one year.

If you think this issue needs to be re-evaluated please post a comment on why this is still important and we will re-open it.

We also started an open discussion about the future of Bookshelf.js here #1600. Feel free to drop by and give us your opinion.
Let's make Bookshelf great again