Log message #1034056

# At Username Text
# Sep 13th 2009, 14:08 markstory transactions that is.
# Sep 13th 2009, 14:08 markstory I think matt curry made a behavior for this as well.
# Sep 13th 2009, 14:08 ionas82 great thank you
# Sep 13th 2009, 14:07 markstory $db = $this->getDataSource()
# Sep 13th 2009, 14:07 ionas82 okay and I should initialize a $db model (DboSource)
# Sep 13th 2009, 14:06 markstory $db->commit() etc.
# Sep 13th 2009, 14:06 markstory $db->begin()
# Sep 13th 2009, 14:06 ionas82 yes markstory I got that
# Sep 13th 2009, 14:06 markstory you are using the wrong table types.
# Sep 13th 2009, 14:06 ionas82 but how should I call transactions
# Sep 13th 2009, 14:06 markstory and everything to do with your database
# Sep 13th 2009, 14:06 ionas82 thats fine
# Sep 13th 2009, 14:06 markstory it has nothing to do with cake.
# Sep 13th 2009, 14:06 ionas82 on innodb?
# Sep 13th 2009, 14:06 markstory use innodb
# Sep 13th 2009, 14:05 ionas82 using saveAll ? atomic: If true (default), will attempt to save all records in a single transaction.
# Sep 13th 2009, 14:05 markstory not use myisam
# Sep 13th 2009, 14:05 ionas82 markstory, what's the recommended way to enable transactions?
# Sep 13th 2009, 14:05 ionas82 but I get that MyISAM doesn't do it simply
# Sep 13th 2009, 14:05 ionas82 markstory, I have no clue (as you see)
# Sep 13th 2009, 14:05 markstory because that is unpossible
# Sep 13th 2009, 14:05 savant1 book search sucks :)
# Sep 13th 2009, 14:05 foofoo http://api.cakephp.org/search/rollback
# Sep 13th 2009, 14:05 markstory ionas: and you expect transactions to work on myisam?
# Sep 13th 2009, 14:04 ionas82 ah now
# Sep 13th 2009, 14:04 ionas82 book search not working :E
# Sep 13th 2009, 14:04 ionas82 hm
# Sep 13th 2009, 14:04 ionas82 ~transaction
# Sep 13th 2009, 14:04 ionas82 foofoo, I will consider that but first dig into mark's direction
# Sep 13th 2009, 14:03 foofoo myisam doesn't support transactions, so if that's an abstraction to transactional storage engine stuff then you need to switch to innodb
# Sep 13th 2009, 14:03 ionas82 yeah its a dbo method
# Sep 13th 2009, 14:03 ionas82 okay
# Sep 13th 2009, 14:03 ionas82 hm
# Sep 13th 2009, 14:03 ionas82 myisam
# Sep 13th 2009, 14:02 markstory because last I checked it was a dbo method.
# Sep 13th 2009, 14:02 markstory when did models get a rollback method?
# Sep 13th 2009, 14:02 foofoo ionas82: what storage engine are you using on your tables?
# Sep 13th 2009, 13:59 ionas82 I am on MySQL 5
# Sep 13th 2009, 13:57 ionas82 http://book.cakephp.org/search/rollback working for you?
# Sep 13th 2009, 13:57 ionas82 hm
# Sep 13th 2009, 13:56 ionas82 http://monmonja.com/blog/2008/07/transaction-on-cakephp-12/