From: Warren Young
Date: April 5 2005 12:21pm
Subject: Re: Transactions with MySQLPP
List-Archive: http://lists.mysql.com/plusplus/4213
Message-Id: <425282E3.5030902@etr-usa.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Warren Young wrote:

> Tim Murison wrote:
> 
>> I was wondering if MySQLPP supports some kind of mechanism to do
>> transactions.
> 
> 
> Not right now.  Patches thoughtfully considered.

I've thought some more about it, and this is definitely v1.8 or v2.0 
material.  Here's what I just added to the Wishlist:

> Transaction support.  Considering block-level semantics: create a
> "transaction object" on the stack, which takes a ref to the
> Connection object (?) as a ctor parameter.  Transaction object's ctor
> calls a function on the conn telling it to tell the server to begin a
> transaction set.  When the transaction object is destroyed, it tells
> the conn object to commit everything.  Conn object in this situation
> must be created in a higher scope, or on the heap.

That shouldn't be too difficult to do, nor should it be very intrusive 
to the current library design.  I'm thinking 1.8.