Callback-free transactions - @transactional decorator

[Omer-Shahar]

I had an idea to write decorators for running transactions in a more convenient way:

// @transactionalClass - applies @transactionalMethod to all methods instead
class DBMethods {
    @transactionalMethod
    async createPostAndRollback() {
        if (!db.isTransacting) throw new Error("Not in transaction");
        await db.insert(posts).values({
            name: "post to be rolled back",
        });
        db.rollback(); // available when isTransacting is true
    }
}

This code will also work when moving some of the logic to another method - without the need to pass the db object as an argument.
The db object imported from db.ts will automatically use the correct object for the transaction.
Notice the new db.isTransacting property, which is true only when running inside a transaction.
If you want to use the global db object even when inside a transaction, you can use the db.baseDB property.

This is the link to the repo.

Feel free to ask questions, add improvements and fix any bugs that you find :)