Len Jaffe wrote:
>
> Do you mean that when I use DBIC, AutoCommit isn't used to set the
> underlying DB's autocommit setting?
>
> When I set AutoCommit, I expect every C,U, & D operation to commit
> without my intervention, and when I unset AutoCommit, I expect to have
> to begin/commit all of my own transactions. I find I need to do my own
> TX control when I am, for example, turning a shopping cart into an
> order, which tends to need to be atomic across inserts into several tables.
I *always* use AutoCommit => 1 and $schema->txn_do. Just seems less
complicated that way, and frees me from worrying about exactly how stuff is
handled under the hood.
Just because I know how to use the DBI API doesn't mean I have any great
desire to when DBIC can handle it for me :)
--
Matt S Trout Offering custom development, consultancy and support
Technical Director contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd. mst (at) shadowcatsystems.co.uk for more information
+ Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/[email protected]/