Log message #1032286

# At Username Text
# 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,