find_by_version

gistfile1.rb

# takes something like key="version" operator="<=" value="1.3" 

def self.find_by_version(key, operator, value)
      major, minor = value.split('.')
      major ||= 0
      if /[<>]/ =~ operator
        minor ||= 0
        query = where("major #{operator} :major OR (major = :major AND minor #{operator} :minor)", :major => major, :minor => minor)
      else
        if minor.nil?
          query = where("major #{operator} (?)", major)
        else
          query = where("major #{operator} (?) and minor #{operator} (?)", major, minor)
        end
      end
      _, conditions = query.to_sql.split("WHERE")
      { :conditions => conditions }
    end