[Dbix-class] Fwd: ->storage->disconnect() Required After Using SQLite?

[Matt S Trout]

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/ +