Emysql Emysql transaction support

I need support for transactions in an application which is using Emysql. While looking through the source code of Emysql, I didn't find direct support for transactions. I was wondering if it is correct that Emysql doesn't support transactions (or should I just call "START TRANSACTION", or via Stored Procedures ) ?

If there is indeed no support for transactions, then is there any reason for it? What is your opinion if I would add it? I just want to make sure if I do it, it can be merged back later and is useful :)

Mar 09 '12 13:03 thijsterlouw

Just 5 cents, I used transaction via stored proc.

Mar 09 '12 17:03 sergey-miryanov

Hi Thijs,

we're at it please look at this discussion: https://github.com/slepher/Emysql/commit/50548682bb3eaa513a82883b40e326269476a6a4

It would be very cool if you tried slepher's transactions and reported your experience, maybe had test cases to contribute.

I'll be at it again next week.

Mar 09 '12 17:03 Eonblast

@sergey-miryanov : exactly, that is the approach we use now.

@Eonblast : very cool! This is exactly what I was thinking of in terms of implementation. I will see how I can contribute to that!

Mar 09 '12 18:03 thijsterlouw

Bump, what is the status of this issue?

Jul 24 '14 15:07 ddosia

+1 I would love to have built-in transactions support. The stored procedure approach (which I'm assuming involves creating SPs that use transaction statements) is less than ideal for situations where the design choice is not to use SPs.

Sep 29 '14 20:09 jfacorro

Status: More or less dead currently. While it would be really nice to support transactions, I feel there are a number of important steps that has to be done first to this library before the txn support can be made stable. As you may realize, I am not working on this library at the moment, so currently there are no-one who are stepping up and doing work.

Sep 30 '14 14:09 jlouis