On Sep 7, 1:12 am, RVince <[email protected]> wrote:
> Hassan,
>
> Same problem though -- it doesn;t save them back. They just all get
> deleted, nothing saved back. Here is my code (all the saves evaluate
> to true, btw) and the log:
As of 2.1 rails has support for partial updates - when you do a save
only changed columns are written back. If there were no changes at all
(as in your case) then the save is a no-op. The change tracking
mechanism doesn't know that you've deleted a bunch of rows. There are
methods for saying 'i've changed this attribute' (foo_will_change!)
but there doesn't seem to be one for "I've changed all the attributes,
just save the whole record", although it shouldn't be hard to write
one. You could also play around with turning off partial updates
(perhaps only for the duration of the relevant bit of code)
Fred
>
> puts "deleting all but 10 channelnotes"
> @cnotes = Channelnote.find(:all, :order => 'tstamp DESC', :limit =>
> 10, :conditions => ["deleted=0"])
> Channelnote.delete_all;
> @cnotes.each { |cnote|
> s = cnote.save!
> puts s
> }
>
> Processing AssociateSessionsController#destroy (for 127.0.0.1 at
> 2009-09-06 20:08:09) [GET]
> Parameters: {"action"=>"destroy",
> "controller"=>"associate_sessions"}
> [4;36;1mAssociate Columns (16.0ms) [0m [0;1mSHOW FIELDS FROM
> `associates` [0m
> [4;35;1mAssociate Load (0.0ms) [0m [0mSELECT * FROM `associates`
> WHERE (`associates`.`id` = '1') LIMIT 1 [0m
> [4;36;1mSQL (0.0ms) [0m [0;1mBEGIN [0m
> [4;35;1mAssociate Update (0.0ms) [0m [0mUPDATE `associates` SET
> `perishable_token` = 'WF_FpyItpFvRCghqAd5W', `updated_at` =
> '2009-09-07 00:08:09', `last_request_at` = '2009-09-07 00:08:09' WHERE
> `id` = 1 [0m
> [4;36;1mSQL (0.0ms) [0m [0;1mCOMMIT [0m
> [4;35;1mChannelnote Load (0.0ms) [0m [0mSELECT * FROM
> `channelnotes` WHERE (deleted=0) ORDER BY tstamp DESC LIMIT 10 [0m
> [4;36;1mChannelnote Delete all (0.0ms) [0m [0;1mDELETE FROM
> `channelnotes` [0m
> [4;35;1mChannelnote Columns (0.0ms) [0m [0mSHOW FIELDS FROM
> `channelnotes` [0m
> [4;36;1mSQL (0.0ms) [0m [0;1mBEGIN [0m
> [4;35;1mSQL (0.0ms) [0m [0mCOMMIT [0m
> [4;36;1mSQL (0.0ms) [0m [0;1mBEGIN [0m
> [4;35;1mSQL (0.0ms) [0m [0mCOMMIT [0m
> [4;36;1mSQL (0.0ms) [0m [0;1mBEGIN [0m
> [4;35;1mSQL (0.0ms) [0m [0mCOMMIT [0m
> [4;36;1mSQL (0.0ms) [0m [0;1mBEGIN [0m
> [4;35;1mSQL (0.0ms) [0m [0mCOMMIT [0m
> [4;36;1mSQL (0.0ms) [0m [0;1mBEGIN [0m
> [4;35;1mSQL (0.0ms) [0m [0mCOMMIT [0m
> [4;36;1mSQL (0.0ms) [0m [0;1mBEGIN [0m
> [4;35;1mSQL (0.0ms) [0m [0mCOMMIT [0m
> [4;36;1mSQL (16.0ms) [0m [0;1mBEGIN [0m
> [4;35;1mSQL (0.0ms) [0m [0mCOMMIT [0m
> [4;36;1mSQL (0.0ms) [0m [0;1mBEGIN [0m
> [4;35;1mSQL (0.0ms) [0m [0mCOMMIT [0m
> [4;36;1mSQL (0.0ms) [0m [0;1mBEGIN [0m
> [4;35;1mSQL (0.0ms) [0m [0mCOMMIT [0m
> [4;36;1mSQL (0.0ms) [0m [0;1mBEGIN [0m
> [4;35;1mSQL (0.0ms) [0m [0mCOMMIT [0m
> Redirected tohttp://localhost:3000/
> Completed in 282ms (DB: 32) | 302 Found [http://localhost/logout]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
