Get Knex.js transactions working with ES7 async/await

by

I couldn’t find a solid answer for this anywhere (with rollbacks and commits) so here’s my solution.

First you need to “Promisify” the knex.transaction function. There are libraries for this, but for a quick example I did this:

const promisify = (fn) => new Promise((resolve, reject) => fn(resolve));

This example creates a blog post and a comment, and rolls back both if there’s an error with either.

const trx = await promisify(db.transaction);

try {
  const postId = await trx('blog_posts')
  .insert({ title, body })
  .returning('id'); // returns an array of ids

  const commentId = await trx('comments')
  .insert({ post_id: postId[0], message })
  .returning('id'); 

  await trx.commit();
} catch (e) {
  await trx.rollback();
}

More Related Contents:

  1. Combination of async function + await + setTimeout
  2. What’s wrong with awaiting a promise chain?
  3. Are there performance concerns with `return await`?
  4. Async/Await Class Constructor
  5. How can I use async/await at the top level?
  6. Difference between `return await promise` and `return promise`
  7. Syntax for an async arrow function
  8. Limited parallelism with async/await in Typescript/ES7
  9. How can I wait In Node.js (JavaScript)? l need to pause for a period of time
  10. Await is a reserved word error inside async function
  11. In JavaScript how do I/should I use async/await with XMLHttpRequest?
  12. Can’t throw error from within an async promise executor function
  13. for await of VS Promise.all
  14. try..catch not catching async/await errors
  15. How to use ES8 async/await with streams?
  16. Async/Await inside Array#map()
  17. How to return an Ajax result using async/await? [duplicate]
  18. In JavaScript, does using await inside a loop block the loop?
  19. ES8 Immediately invoked async function expression
  20. Async / await vs then which is the best for performance?
  21. What is the benefit of prepending async to a function that returns a promise?
  22. Puppeteer doesn’t close browser
  23. Wait promise inside for loop
  24. Using for await…of with synchronous iterables
  25. How to use Array.prototype.filter with async?
  26. How does javascript async/await actually work?
  27. Transpile Async Await proposal with Babel.js?
  28. How can I Interleave / merge async iterables?
  29. Implement async/await in sort function of arrays javascript
  30. JS async/await – why does await need async?

Leave a Comment