thr3ads.net - Rails - How can I write this find with AR? [Feb 2007]

If this information is useful, please help other people find it:
Share via:

Drew Olson

2007-Feb-21 15:07 UTC

How can I write this find with AR?

All -

I have an array of values arr =
[''a'',''b'',''c''] and I want
to find all
records such that :value is contained within the array. Something like:

Record.find(:all,:conditions=>{:value=>arr.include?})

Does AR support this, and if so what is the syntax?

Thanks,
Drew

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Ben

2007-Feb-21 15:11 UTC

head link

Re: How can I write this find with AR?

Drew Olson wrote:> All -
> 
> I have an array of values arr =
[''a'',''b'',''c''] and I want
to find all
> records such that :value is contained within the array. Something like:
> 
> Record.find(:all,:conditions=>{:value=>arr.include?})
> 
> Does AR support this, and if so what is the syntax?
> 
> Thanks,
> Drew
I''m out of office so cant really test but you could probably do
something along the lines of:
Record.find(:all,:conditions=>{ "value IN (?), arr.join(",")
})

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Drew Olson

2007-Feb-21 15:30 UTC

head link

Re: How can I write this find with AR?

Ben wrote:> 
> I''m out of office so cant really test but you could probably do
> something along the lines of:
> Record.find(:all,:conditions=>{ "value IN (?),
arr.join(",") })
Thanks for putting me on the right track. It seems I can do:

Record.find(:all,:conditions=>["value IN (?)", arr])

-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Chris Hall

2007-Feb-21 15:54 UTC

head link

Re: How can I write this find with AR?

you can also do

Model.find_all_by_value([''a'', ''b'',
''c''])

ex:

authors = [''Hemingway'', ''Dickinson'',
''Shakespeare'']
Books.find_all_by_author(authors)

where ''author'' is a column in the ''books''
table

On 2/21/07, Drew Olson
<rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:>
> Ben wrote:
> >
> > I''m out of office so cant really test but you could probably
do
> > something along the lines of:
> > Record.find(:all,:conditions=>{ "value IN (?),
arr.join(",") })
>
> Thanks for putting me on the right track. It seems I can do:
>
> Record.find(:all,:conditions=>["value IN (?)", arr])
>
> --
> Posted via http://www.ruby-forum.com/.
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Drew Olson

2007-Feb-21 16:47 UTC

head link

Re: How can I write this find with AR?

Chris Hall wrote:> you can also do
> 
> Model.find_all_by_value([''a'', ''b'',
''c''])
Wow, much cleaner. Thanks for that!

-Drew


-- 
Posted via http://www.ruby-forum.com/.

--~--~---------~--~----~------------~-------~--~----~
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Simon Pasquier

2007-Feb-21 19:51 UTC

head link

Re: How can I write this find with AR?

You can simply do
Record.find(:all, :conditions => {:value => arr})

Simon

Drew Olson wrote:> All -
>
> I have an array of values arr =
[''a'',''b'',''c''] and I want
to find all
> records such that :value is contained within the array. Something like:
>
> Record.find(:all,:conditions=>{:value=>arr.include?})
>
> Does AR support this, and if so what is the syntax?
>
> Thanks,
> Drew
>
>   

--~--~---------~--~----~------------~-------~--~----~
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Jakob Skjerning

2007-Feb-21 21:16 UTC

head link

Re: How can I write this find with AR?

On Feb 21, 2007, at 16:07 , Drew Olson wrote:
> I have an array of values arr =
[''a'',''b'',''c''] and I want
to find all
> records such that :value is contained within the array. Something  
> like:
>
> Record.find(:all,:conditions=>{:value=>arr.include?})
>
> Does AR support this, and if so what is the syntax?
Does :conditions => [''value IN (?)'', arr] do what you need?

--
Jakob Skjerning - http://mentalized.net



--~--~---------~--~----~------------~-------~--~----~
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---

Rails - Feb 2007 - How can I write this find with AR?

How can I write this find with AR?

Re: How can I write this find with AR?

Re: How can I write this find with AR?

Re: How can I write this find with AR?

Re: How can I write this find with AR?

Re: How can I write this find with AR?

Re: How can I write this find with AR?