# |
Sep 11th 2009, 16:00 |
ifunk |
icelander: i think that depends on where you live and who you want to validate |
# |
Sep 11th 2009, 16:00 |
tom_m |
cool. thanks ifunk. really good idea |
# |
Sep 11th 2009, 15:59 |
tom_m |
for scaling/speed/connections |
# |
Sep 11th 2009, 15:59 |
icelander |
What's the validation criteria for phone fields? |
# |
Sep 11th 2009, 15:59 |
tom_m |
then i dont have to worry about what harm a lock would do |
# |
Sep 11th 2009, 15:58 |
tom_m |
mmm i like |
# |
Sep 11th 2009, 15:58 |
ifunk |
tom_m: yeh i think cake would 404 if you don't use transactoins |
# |
Sep 11th 2009, 15:58 |
tom_m |
i already am using saveall but i guess if i wasn't there'd be issues |
# |
Sep 11th 2009, 15:58 |
tom_m |
right |
# |
Sep 11th 2009, 15:58 |
tom_m |
it rollsback |
# |
Sep 11th 2009, 15:58 |
ifunk |
tom_m: and then remember to use saveAll, as it will use transactions |
# |
Sep 11th 2009, 15:58 |
tom_m |
then if the sql query fails because mysql says no |
# |
Sep 11th 2009, 15:58 |
tom_m |
i like that |
# |
Sep 11th 2009, 15:57 |
tom_m |
o |
# |
Sep 11th 2009, 15:57 |
ifunk |
tom_m: yeh table settings |
# |
Sep 11th 2009, 15:57 |
ifunk |
jjwdesign: yeh, sorry i meant $controller->{$whatever_variable_you_have_your_config_in} |
# |
Sep 11th 2009, 15:57 |
tom_m |
table settings or something in my.cnf for mysql? |
# |
Sep 11th 2009, 15:57 |
tom_m |
ifunk how would i do that? |
# |
Sep 11th 2009, 15:56 |
jjwdesign |
$controller->criteria_conditions ,.... works. |
# |
Sep 11th 2009, 15:56 |
ifunk |
you could use a unique constraint on the db as a second measure, in addition to the cakephp validation |
# |
Sep 11th 2009, 15:56 |
tom_m |
but then i dont know what happens if that presents other issues |
# |
Sep 11th 2009, 15:56 |
tom_m |
i also wonder if i can add the FOR UPDATE; into the query... |
# |
Sep 11th 2009, 15:55 |
tom_m |
so say in the case of tagging |
# |
Sep 11th 2009, 15:55 |
tom_m |
i guess i can make a cleanup cron that goes in an removes duplicates and changes associations |
# |
Sep 11th 2009, 15:55 |
jjwdesign |
ifuck: $controller->{$criteria_conditions} --- debugs as "empty property" |
# |
Sep 11th 2009, 15:55 |
ifunk |
it happened to me from someone double-clicking a button in flash, which meant two requests being sent by the same user at the same time |
# |
Sep 11th 2009, 15:55 |
ifunk |
probably |
# |
Sep 11th 2009, 15:54 |
tom_m |
is the odds of all this really low? |
# |
Sep 11th 2009, 15:54 |
tom_m |
where a transaction... dpeneding on how much is going on bofore the commit |
# |
Sep 11th 2009, 15:53 |
ifunk |
yeh it's happened to me before |
# |
Sep 11th 2009, 15:53 |
tom_m |
but i mean is it more like splitting hairs at that point? |
# |
Sep 11th 2009, 15:53 |
tom_m |
really? |
# |
Sep 11th 2009, 15:53 |
ifunk |
tom_m: yeh, but you can run into that without transactions as well |
# |
Sep 11th 2009, 15:52 |
tom_m |
so if two people save the same exact records at a time with saveAll() ... might as well forget about validation for unique and such huh |
# |
Sep 11th 2009, 15:52 |
ifunk |
tom_m: all i ever see is "begin transaction" and "commit" in logs |
# |
Sep 11th 2009, 15:52 |
icelander |
Is there a way to do phone validation that allows for extensions? |
# |
Sep 11th 2009, 15:52 |
ifunk |
tom_m: i don't think so |
# |
Sep 11th 2009, 15:51 |
tom_m |
does anyone know off the top of their head if saveAll() in cake with the TRANSACTION will lock for update? |
# |
Sep 11th 2009, 15:50 |
ifunk |
then in your component look for $controller->{$criteria_conditions} |
# |
Sep 11th 2009, 15:50 |
ifunk |
into this: 'criteria_conditions' => 'criteria_conditions', |
# |
Sep 11th 2009, 15:49 |
ifunk |
i would prob suggest turning this: 'criteria_conditions' => $criteria_conditions, |