I have a database of movies with attributes. I'd like to return a queried batch of those movies in random order to a template with pagination. I'm using will_paginate. I tried the following:
## MoviesController
movies = Movie.get_movies(query_string) # a method in Movie model that takes in
# a query_string and fetches movies
# with user-set params
@movies = movies.order('random()').page(params[:page]).per_page(16)
This works nicely, except movies are repeated from page to page. Solutions to this problem have been posted here and here. Those links explain that, because the random() seed is reset from page to page, there is no consistency and OFFSET is rendered useless. They offer great solutions for MySQL users, as its rand(n) function takes a seed n. Postgres, however, doesn't do this. You have to declare setseed(n) in SELECT before issuing random() in ORDER.
So I tried the postgres way to set the seed:
@movies = movies.select('setseed(.5)').order('random()').page(params[:page]).per_page(16)
Curiously, that returned Movie objects with absolutely no attributes. The following was raised from the template:
ActiveModel::MissingAttributeError in Movies#action
missing attribute: some_movie_attribute
I debugged this and, once the stack reached action_controller/metal, @movies contained:
[#<Movie >, #<Movie >, #<Movie >, #<Movie >, #<Movie >, #<Movie >, #<Movie >, #<Movie >, #<Movie >, #<Movie >, #<Movie >, #<Movie >, #<Movie >, #<Movie >, #<Movie >, #<Movie >]
That number of Movie objects (18) corresponds to the number of movies returned from the query.
I also tried the following to see if setseed(n) was the problem by removing the random order method:
@movies = movies.select('setseed(.5)').page(params[:page]).per_page(16)
This returned the same non-attribute Movie objects as layed out above. So it appears that setseed(n) is indeed the issue.
I tried a couple of workarounds, like:
# MoviesController
movies = Movie.get_movies(query_string)
shuf_movs = movies.shuffle ## effectively turns shuf_movs into an array
@movies = shuf_movs.paginate(:page => params[:page], :per_page => 16)
That also returned pages with repeating movies. I thought this was because pagination needed the objects to be ordered by something, and you can't set seeds in Array#shuffle. So I tried writing my own randomization code that would temporarily store an id to be ordered by in the Movie objects. (Please excuse the sloppy code):
# Movie model
attr_accessor :rand_id
# MoviesController
movies = get_movies(query_string)
movies_count = movies.count
r = Random.new
nums = []
rand_movs = []
id = 1
while nums.count != movies_count
num = r.rand(0..movies_count - 1)
if !(nums.include?(num))
movie = movies[num]
movie.rand_id = id
rand_movs << movie
nums << num
id += 1
end
end
@movies = rand_movs.sort_by { |a| a.rand_id }.paginate(:page => params[:page], :per_page => 16)
That still produced repeating movies in different pages. At this point I realize will_paginate doesn't take in what you've sorted by before paginate is called. So I tried this:
@movies = rand_movs.paginate(:order => 'rand_id', :page => params[:page], :per_page => 16)
That still repeats records. :order -> 'rand_id' is ignored because :order only matters when you're dealing with ActiveRecord objects, not arrays.
So setseed(n) appears to be my only hope for achieving randomized non-repeating records using will_paginate. Any ideas?
Thanks!
