The Dev Blog

script/plugin install svn://rubyforge.org/var/svn/acts-as-rated/trunk/acts_as_rated

class Book < ActiveRecord::Base
  acts_as_rated
end

u = User.find_by_name "guy"
b = Book.find "Catch 22"
b.rate 5, u 
u = User.find_by_name "john"
b.rate 3, u

b.rating_average # => 4
Book.find_by_rating 2..3 # => [<Book:"Catch 22">]

b.find_rated_by User.find_by_name("guy") # => [<Book:"Catch 22">]

Posted in acts_as_rated, Rails, Ruby | 8 comments

Comments

1. nukeedit
   Tiago Serafim said 1 day later:
   

   Hi,

   This plugin is exactly what i´ve looking for... Thank you very much!

2. nukeedit
   Guy Naor said 2 days later:
   

   Thanks!

   If you find anything you think I should fix or add (or remove ;-) ), let me know!

3. nukeedit
   Starburger said 3 days later:
   

   That looks fine!

   Have you ever tried it on mySQL (although not fully tested)?

4. nukeedit
   Guy Naor said 3 days later:
   

   I didn't test it with MySQL, I just don't have it installed. I'm a 100% Postgres guy ;-)

   But I think MySQL should be fine. There is only one somewhat complex query used to get the rating average if not using added rating statistic fields or the external rating statistics table. This query uses AVG() and COALESCE() SQL functions. So if the database supports those, it should work.

   Guy.

5. nukeedit
   Tiago Serafim said 11 days later:
   

   Hi again,

   I tested the plugin with MySQL 4.1(comes within InstantRails) and I had some issues...to be more clear, 9 assertions failed.

   To solve them, I had to explicitly use ":decimal, :precision => 10, :scale => 2" instead of ":decimal" ... this should fix 8 of 9 assertions

   The remaining one was because the weirdness of mysql´s round function[1]... I don´t know how to fix this, but I think this won´t be a major problem... at least here, within my project.

   I also created another method called "rated_by_rater?" that I needed to use the "css rating star" thing. Here it is:

       def rated_by_rater? rater
   
         rating_class = acts_as_rated_options[:rating_class].constantize
         if !(acts_as_rated_options[:rater_class].constantize === rater)
           raise RateError, "The rater object must be the one used when defining acts_as_rated (or a descendent of it). other objects are not acceptable" 
         end
         raise RateError, "Rater must be a valid and existing object" if rater.nil? || rater.id.nil?
         raise RateError, 'Rater must be a valid rater' if !rating_class.column_names.include? "rater_id"
         r = ratings.find(:first, :conditions => ['rater_id = ?', rater.id])
   
         !r.nil?
   
       end
   

   I know that I should´ve wrote some tests for this, but since I´m a TDD/ruby newbie and it´s almost a copy of the first part of "unrate" method, it should work fine...

   Thanks again for this great plugin, cheers, Tiago

   [1] http://joseph.randomnetworks.com/archives/2004/11/08/mysqls-funny-math/

6. nukeedit
   Guy Naor said 12 days later:
   

   Tiago,

   Thanks for the fixes to make it work with MySQL.

   I also added the rated_by_rater? function, but change the name to rated_by?

   I also mede it a bit more efficient, by using count instead of find. The reason is that this way the data isn't loaded from the DB, which would have been a waste as we throw it away after checking it.

   I have some problems connecting to RubyForge at the moment. But I will upload it soon.

   Guy

7. nukeedit
   Tiago Serafim said 12 days later:
   

   Guy,

   Thanks for the reply!

   the new method´s name and the change you made are nice! I´ll update my code ASAP.

   Tiago

8. nukeedit
   Zach said 28 days later:
   

   YES! HAHAHA! I love it, exactly what I've needed!

RSS feed for this post

Comments are disabled

© 2006 Famundo LLC. All rights Reserved. Privacy Policy Terms of Use