Solution: Getting will_paginate and acts_as_taggable to play

Rails
1

I’m using both will_paginate http://errtheblog.com/post/4791 and
acts_as_taggable plugins on the app http://www.themotherhood.net/ I’m
working on. The tagged results need to be paged just like other lists.
Here’s my hack to get the two to work together:

RAILS_ROOT/lib/paginated_tags.rb in lib:

module ActiveRecord
module Acts #:nodoc:
module Taggable #:nodoc:
module SingletonMethods

    def find_tagged_with(list,*args)
      #build the limit sql
      options = args.last.is_a?(Hash) ? args.pop.symbolize_keys : {}
      limit,offset = options.delete(:limit), options.delete(:offset)

unless options.empty?
scope = (limit && offset) ? “LIMIT #{offset}, #{limit}” : “”

      find_by_sql([
        "SELECT #{table_name}.* FROM #{table_name}, tags, taggings " 

  •       "WHERE #{table_name}.#{primary_key} = taggings.taggable_id " 

  •       "AND taggings.taggable_type = ? " +
      "AND taggings.tag_id = tags.id AND tags.name IN (?)

#{scope}",
acts_as_taggable_options[:taggable_type], list
])

    end
    #will_paginate will call find_all_tagged_with
    alias find_all_tagged_with find_tagged_with
  end
end

end
end

I can now call a method like this:

@stories = Story.paginate_tagged_with(“goo”, :total_entries => 2, :page
=>
params[:page])

You have to manually pass in the total_entries, but hacking the code
where
total_entries is set in the will_paginate finder method could get around
this.

  • Nathan Verni