Transaction Model

[yisraelU]

We should probably have a model for Sql Transactions ,plus isolation levels

• set isolation level
• run multiple statements in one transaction
• Rollback feature

[LA-94]

Good day!

Please tell me when the completion of the "run multiple statements in one transaction" task is planned?

I have not found a way to disable the auto commit of a transaction so that the ZConnectionPool.transaction method rolls back several statements.

As I understand it, some kind of option is needed to disable autocommit in the ZConnectionPoll.make method so that the ZIO.unless(autocommitMode)(connection.rollback.ignoreLogged) line worked

There is no way to disable autocommit in the external Postgresql database properties

For example, the transaction will not roll back here and the first expression will remain committed:

transaction {
    for {
       _ <- SqlFragment(...).execute
       _ <- SqlFragment(...).execute.zipRight(ZIO.fail(new RuntimeException("SOME PROBLEM"))
    } yield()
}