Re: [PHP-DB] MySQL: did anyone start a transaction?

On Fri, May 8, 2009 at 6:23 PM, Bogdan Stancescu <[email protected]> wrote:

> Hello all,
>
> I asked this question on php-general last month
> (http://marc.info/?t=124049230300004&r=1&w=2), and received some answers
> -- but I was directed to this list, so here.
>
> My question is: can I tell programatically whether the next query I'm
> going to execute is already part of a transaction, using MySQL?
>
> The context is thus: I'm writing a PHP library which attempts to
> seamlessly merge database objects and PHP objects. Architecture
> discussion aside (which I'm more than open to, if anyone cares enough to
> talk), I need to know whether the code outside the library has already
> started a transaction or not. I need to know that because I need to
> execute both PHP and SQL from a single external call -- if either one of
> my internal PHP or SQL calls fail, I need to revert to the original
> state before the external call. And since transactions can't be nested,
> I can't unconditionally start a new transaction when the external call
> is being initiated -- therefore I need to know whether the programmer
> has already started a transaction or not.
>
> Thank you,
> Bogdan
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

What about creating a global variable or singleton class to hold the start
of the transaction? This is something worth reading, as it indicates that
the application should manage it (
http://stackoverflow.com/questions/319788/how-do-detect-that-transaction-has-already-been-started)
and that transaction fall outside of OO scope.
-- 

Bastien

Cat, the other other white meat