gistfile1.rb

    def self.find_by_version(_key, operator, value)
      if ['>', '<', '=', '<=', '>=', '^', 'IN', 'NOT IN'].include?(operator) && value.to_f >= 1
        major, minor = value.split(".")
        case
        when /[<>]/ =~ operator
          minor ||= 0
          query = where("major #{operator} :major OR (major = :major AND minor #{operator} :minor)", :major => major, :minor => minor)
        when minor.nil?
          query = where("major #{operator} (:major)", :major => major)
        else
          query = where("major #{operator} (:major) and minor #{operator} (:minor)", :major => major, :minor => minor)
        end
        _, conditions = query.to_sql.split("WHERE")
      end
      { :conditions => conditions || ""}
    end