Handling Nested Transactions in `sql.withTransaction`

With a helper like this, what happens if we pass in an Effect that itself is wrapped/piped with its own

sql.withTransaction

sql.withTransaction

? In other words, if we have nested

sql.withTransaction

sql.withTransaction

is there any issue?

    /**
     * Execute a function within a database transaction
     * Automatically rolls back on any error
     */
    withTransaction: <R, E, A>(operation: Effect.Effect<A, E, R>) => {
        return Effect.gen(function* () {
            const sql = yield* SqlClient.SqlClient;
            return yield* sql.withTransaction(operation);
        });
    },

    /**
     * Execute a function within a database transaction
     * Automatically rolls back on any error
     */
    withTransaction: <R, E, A>(operation: Effect.Effect<A, E, R>) => {
        return Effect.gen(function* () {
            const sql = yield* SqlClient.SqlClient;
            return yield* sql.withTransaction(operation);
        });
    },

Effect Community•8mo ago

DiamondDragon

Handling Nested Transactions in `sql.withTransaction`

With a helper like this, what happens if we pass in an Effect that itself is wrapped/piped with its own

sql.withTransaction

sql.withTransaction

? In other words, if we have nested

sql.withTransaction

sql.withTransaction

is there any issue?

    /**
     * Execute a function within a database transaction
     * Automatically rolls back on any error
     */
    withTransaction: <R, E, A>(operation: Effect.Effect<A, E, R>) => {
        return Effect.gen(function* () {
            const sql = yield* SqlClient.SqlClient;
            return yield* sql.withTransaction(operation);
        });
    },

    /**
     * Execute a function within a database transaction
     * Automatically rolls back on any error
     */
    withTransaction: <R, E, A>(operation: Effect.Effect<A, E, R>) => {
        return Effect.gen(function* () {
            const sql = yield* SqlClient.SqlClient;
            return yield* sql.withTransaction(operation);
        });
    },

Handling Nested Transactions in `sql.withTransaction`

Similar Threads

Handling Nested Transactions in `sql.withTransaction`

Similar Threads

Similar Threads

Similar Threads