How to execute transaction with massive.js

Question

I'm trying to achieve a very simple thing:

START TRANSACTION;
DELETE FROM table WHERE id = 1;
ROLLBACK;

Running this on the postgres database works perfectly. With massive.js it doesn't:

this.db.run(
   "START TRANSACTION",
   []
); 
setTimeout(() => {
   this.db.run(
       "DELETE FROM table WHERE id = $1"
       [1]
   );
}, 2000);
setTimeout(() => {
   this.db.run(
       "ROLLBACK;"
       []
   );
}, 4000);

It doesn't rollback the changes, just deletes from the database. COMMIT doesn't work as well. What's wrong?

Is there some way to dump queries order?

What is the point of such a transaction, as you end up exactly with nothing? — vitaly-t, Aug 10 '17 at 00:22

score 0 · Answer 1 · edited Jun 20 '20 at 09:12

Massive uses pg-promise underneath, which in turn supports transactions:

db.instance.tx(t => {
    // BEGIN has been executed
    return t.none('DELETE FROM table WHERE id = $1', [123])
        .then(() => {
            // Records have been deleted within the transaction

            throw new Error('Random error to fail the transaction');
            // = the same as returning Promise.reject(new Error('Random...'))
        });
})
    .catch(error => {
        // ROLLBACK has been executed, no records end up deleted.
        console.log(error);
    });

How to execute transaction with massive.js

1 Answers1