Hi there,
I'm having a strange issue with active record in 2.3.2 development env
whereby an update_ attribute within a loop only gets written to the db
if I write (anything) to the logfile, or set a sleep of somewhere
between 0.5 and 1 second.
The function is a remotely called drag and drop list sorter:
def sort
i = 1
params[:cv].each {
>id>
if cv_type = current_user.cv_types.find(id)
if cv_type.update_attribute(:position, i)
sleep 1 # if I remove this it doesn't work any more
i = i+1
end
end
}
render :nothing => true
end
and from the logfile without the sleep command:
CvType Load (0.2ms) SELECT * FROM `cv_types` WHERE
(`cv_types`.`id` = 5 AND (`cv_types`.user_id = 1)) ORDER BY position
SQL (0.1ms) BEGIN
SQL (0.1ms) COMMIT
CvType Load (0.4ms) SELECT * FROM `cv_types` WHERE
(`cv_types`.`id` = 4 AND (`cv_types`.user_id = 1)) ORDER BY position
SQL (0.1ms) BEGIN
SQL (0.1ms) COMMIT
and then with the sleep command:
CvType Load (0.5ms) SELECT * FROM `cv_types` WHERE
(`cv_types`.`id` = 4 AND (`cv_types`.user_id = 1)) ORDER BY position
SQL (0.1ms) BEGIN
CvType Update (0.2ms) UPDATE `cv_types` SET `position` = 1 WHERE
`id` = 4
SQL (0.5ms) COMMIT
CvType Load (0.4ms) SELECT * FROM `cv_types` WHERE
(`cv_types`.`id` = 5 AND (`cv_types`.user_id = 1)) ORDER BY position
SQL (0.1ms) BEGIN
CvType Update (0.2ms) UPDATE `cv_types` SET `position` = 2 WHERE
`id` = 5
SQL (0.6ms) COMMIT
Surely that isn't normal?
I don't mind writing to the logfile, but it seems that something else
is afoot. and I can't think what.
Any insight would be very helpful.
thanks,
dorian
