On May 25, 8:48 am, eugene miretsky
<eugene.miret...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>
wrote:> Hi,
>
> Here is my problem. I store some of my data in a MYSQL DB and some of it in
> Redis. In my search I need to be able to combine results from both.
> Right now my code looks like this:
> scope = User.scoped({})
> cope = scope.where("users.gender = ?", gender)
> cope = scope.where("users.age = ?", age)
> etc..
> I want to take the result and either sort it using the data that''s
in
> Redis. It is possible do create a scope for that?
> The best I could come up with was users = User.search().sort_by {|user|
> ...} . The problem with is is that it returns an array instead of an active
> record associations, so now pagination doesn''t work.
>
This kind of stuff never works very nicely in my past experience - you
end up having to fetch "too many" records from one of your datasources
because you don''t know what ordering the other one is going to impose.
If you''re using will paginate you should be able to paginate arrays if
you do require ''will_paginate/array''
Fred
--
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-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.