# |
Sep 13th 2009, 14:10 |
ionas82 |
that would reduce code size ;) |
# |
Sep 13th 2009, 14:09 |
ionas82 |
markstory, I could save multiple records with saveAll that has internal transactions as far as I got it right |
# |
Sep 13th 2009, 14:08 |
ionas82 |
if I do I will remember that |
# |
Sep 13th 2009, 14:08 |
ionas82 |
for now I do not require them often |
# |
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? |