Perrin Harkins wrote: > On 3/16/07, James Masters <[EMAIL PROTECTED]> wrote: >> Just wondering - does Rose deal with transactions, rollbacks etc. "under the >> hood" (or "under the bonnet" as we say in England) and is therefore ACID >> compliant? > > You really don't need any help from your object-relational mapper to > use transactions -- you can just call commit or rollback on your > database handle. However, Rose has convenience methods that wrap > these functions. If you search the documentation for "transaction" > you should find what you're looking for. > > - Perrin
Totally a side tangent, but when you start using your schema classes from RDBO/DBIC/CDBI in things like Catalyst as Models, and maybe using many of them at the same time in one transaction, that whole "Just use the dbh" falls apart. God forbid, what if I'm using some classes that are based on DBIC and some that are based on RDBO from two different 3rd parties. I wish there were something, a module, a way to abstract DB trasactions up a level into controllers. ## Some function way above DBI DBI::Transaction->start; $rdboclass->delete(...); $otherdbiclass->add(...); $dbicclass->update(...); DBI::Transaction->commit; I just lothe having to dig into individual modules to get a dbh to do a transaction, or even use helper methods. Granted, this falls apart when you're talking about multiple database, but if all of your modules hit on DB, there should be a decent way to just start/commit/rollback a transaction without having to dive in deep. -=Chris
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________ Rose-db-object mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/rose-db-object
