Re: [Rails] in standby for an annoying problem.

On 14 November 2012 21:07, Mauro <mrsanna1@gmail.com> wrote:
> I have a model Reservation with reserved_from and reserve_to
> attributes of type date.
> I want create a scope of all reservations where Date.today is between
> reserved_from and reserved_to.
> In the model I've done:
>
> def self.today_reservation
> find_each do |res|
> if (Date.today).between?(res.reserved_from, res.reserved_to)
> return
> else
> puts "false"
> end
> end
> end
> scope :today_reservations, today_reservation
>
> but it doesn't work.
> If reserved_from is 2012-11-01 and reserved_to is 2012-11-02 and
> Date.today is 2012-11-14 the method above method return an
> activerecord relation.

That is not how scopes work. You need something like (not tested)
scope :today_reservations, lambda { where("reserved_from > ? and
reserved_to <= ?", Date.today, Date.today ) }

I expect there is a neater way to do it. Make sure your automated
tests check it on the end points of the range.

Colin


> Some advice?
> Thank you.
>
> --
> 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@googlegroups.com.
> To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>

--
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@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.