Ruby on Rails

It does have named scopes but I am not sure what that would bring to the
table. How would one do it using named scopes?

Norm

On 04/25/2015 01:52 PM, Walter Lee Davis wrote:
> I can't recall, does Rails 2.3 have named scopes? You may be able to do this with one of those. It's been quite a while since I worked in 2.3.
>
> Walter
>
> On Apr 25, 2015, at 3:06 PM, Norm Scherer <normscherer@earthlink.net> wrote:
>
>> I have an app running Rails 2.3 with Ruby 1.8.7. Upgrading is not in the cards for a while. I am trying to make it database agnostic so I want to eliminate the use of find_by_sql. I have got it down to only one find left but I have not been able to figure out how to do this by a find.
>>
>> I have two tables:
>> Reservation belongs_to :space
>> int space_id
>> date startdate
>> date enddate
>> and a bunch of other stuff
>>
>> Space - has many reservations
>> containing a bunch of stuff about spaces
>>
>> I want to fetch the spaces which are not used by a reservation meeting certain conditions.
>> The current find is:
>> all_spaces = find_by_sql("SELECT * FROM spaces
>> WHERE id NOT IN (SELECT space_id FROM reservations
>> WHERE enddate > \'#{start_dt}\'
>> AND startdate < \'#{end_dt}\')
>> ")
>> Is there a way I can just use a Space.all ...?
>>
>> Norm
>>
>> --
>> You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
>> To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
>> To post to this group, send email to rubyonrails-talk@googlegroups.com.
>> To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/553BE59C.9040001%40earthlink.net.
>> For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/553E747A.20505%40earthlink.net.
For more options, visit https://groups.google.com/d/optout.