Oops my bad.
1. Yeah, it should be map(&:id).
2. Yeah, you won't need Photo.find(:all, :conditions => ["id IN ?",
@photo_ids]).map(&:id) if you have ids already, I was just making it
generic case where condition could be anything.
3. No.That will create ids.length+1 number of queries. And yes, it
will use your filters.
On 9/7/07, Matt Aimonetti <[EMAIL PROTECTED]> wrote:
>
> > However, note that you can do following as of now :
> >
> > ids = Photo.find(:all, :conditions => ["id IN ?", @photo_ids]).amp(&:id)
> > Photo.update(ids, Hash.new( :title => "Ruby rocks" )
>
> Will that create only 1 SQL query? and will that use my filters?
>
> I guess amp(&:id) should read map(&:id) Also, I don't see why you
> would do:
>
> > ids = Photo.find(:all, :conditions => ["id IN ?", @photo_ids]).amp(&:id)
>
> if we already have the ids.
>
> Thanks,
>
> -Matt
>
>
>
>
> On Sep 7, 12:15 pm, Pratik <[EMAIL PROTECTED]> wrote:
> > I think it'd be nice to have 2 variations of mass update statements.
> > Something like destroy_all and delete_all, where one variation does
> > blind sql query ( like delete_all ) and other shows complete respect
> > for AR ( destroy_all )
> >
> > However, note that you can do following as of now :
> >
> > ids = Photo.find(:all, :conditions => ["id IN ?", @photo_ids]).amp(&:id)
> > Photo.update(ids, Hash.new( :title => "Ruby rocks" )
> >
> > On 9/7/07, Matt Aimonetti <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> >
> >
> > > Hi
> >
> > > I noticed that if in my code I use the following:
> >
> > > Photo.update_all("title = 'Ruby rocks' ", "id IN ([EMAIL PROTECTED])")
> >
> > > All my objects are properly updated but none of the filters/callbacks
> > > are triggered. Is that what's expected?
> >
> > > I have a before_update filter set on the Photo class and it gets
> > > totally ignored, I guess the only way to solve this issue is to
> > > enumerate through the objects and update them one after the other :(
> >
> > > Thanks,
> >
> > > -Matt
> >
> > --
> > Cheers!
> > - Pratikhttp://m.onkey.org
>
>
> >
>
--
Cheers!
- Pratik
http://m.onkey.org
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Core" group.
To post to this group, send email to rubyonrails-core@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/rubyonrails-core?hl=en
-~----------~----~----~----~------~----~------~--~---
