Nesting SQL Transactions in Effect Typescript Library

is it ok to nest sql transactions? as in does effect sql check if the transaction already exists before creating a new one? i tried looking at the source code but couldn't find it

const transactionEffectA = pipe(
    // some sql query
    Effect.void,
    sql.withTransaction
)

const transactionEffectB = pipe(
    transactionEffectA
    // some other sql query
    sql.withTransaction
)

const transactionEffectA = pipe(
    // some sql query
    Effect.void,
    sql.withTransaction
)

const transactionEffectB = pipe(
    transactionEffectA
    // some other sql query
    sql.withTransaction
)

const transactionEffectA = pipe(
    // some sql query
    Effect.void,
    sql.withTransaction
)

const transactionEffectB = pipe(
    transactionEffectA
    // some other sql query
    sql.withTransaction
)

const transactionEffectA = pipe(
    // some sql query
    Effect.void,
    sql.withTransaction
)

const transactionEffectB = pipe(
    transactionEffectA
    // some other sql query
    sql.withTransaction
)

No replies yetBe the first to reply to this messageJoin

Nesting SQL Transactions in Effect Typescript Library

Similar Threads

Similar Threads

Similar Threads