Will_paginate with more than one table

Hi you all, I have an app where I do two “finds” in different tables:

@results_m = Man.find(:all)
@results_w = Woman.find(:all)

I can paginate each of one with paginate:
@results_m = Man.paginate([params page stuff here…])
@results_w = Woman.paginate([params page stuff here…])

However, I want to show the two kinds of results in the same view and
with the pagination as if they were only from a single type of resource.
Can will_paginate do the trick somehow? (maybe something like @results =
@results_m + @results_w, which of course also sums the total records in
Man table and Woman table). Or should I do it manually?

However, I want to show the two kinds of results in the same view and
with the pagination as if they were only from a single type of resource.
Can will_paginate do the trick somehow? (maybe something like @results =
@results_m + @results_w, which of course also sums the total records in
Man table and Woman table). Or should I do it manually?

Posted viahttp://www.ruby-forum.com/.

Are you looking for single table inheritance?

Ummm… not exactly. I have an app consisting on database federation,
so basically I have to get the results of one table, get the results of
other one, and merge them.
The problem is that if I paginate the first result I get, let’s say, 10
records, then I paginate the second and I get 10 records, so the
resulting one is 20 records size, not 10. I can paginate also this last
one set of 20 results, but I would lost the total_pages of the original
two first results. Apart from that, the gem should manage which table
and with which limit and offset to ask when I do a request such as
http://…/whatever?page=x

So I’m afraid I shall do it manually somehow. Don’t think any paginating
gem/plugin have a solution to this.

pharrington wrote:

However, I want to show the two kinds of results in the same view and
with the pagination as if they were only from a single type of resource.
Can will_paginate do the trick somehow? (maybe something like @results =
@results_m + @results_w, which of course also sums the total records in
Man table and Woman table). Or should I do it manually?

Posted viahttp://www.ruby-forum.com/.

Are you looking for single table inheritance?

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs