开发者

Searching and comparing ActiveRecord attributes to find largest value

开发者 https://www.devze.com 2022-12-29 15:30 出处:网络
I have a model that would look something like: my_diet = Diet.new my_diet.food_type_1 = \"beef\" my_diet.food_type_1_percentage = 40

I have a model that would look something like:

my_diet = Diet.new
my_diet.food_type_1 = "beef"
my_diet.food_type_1_percentage = 40
my_diet.food_type_2 = "carrots"
my_diet.food_type_2_percentage = 50
my_diet.food_type_3 = "beans"
my_diet.food_type_3_percentage = 5
my_diet.food_type_4 = "chicken"
my_diet.food_type_4_percentage = 5

I need to find which food_type has the highest percentage. So far I've tried creating a hash out of the attibutes and percentages then sorting the hash (see below) but it feels like there must be a cleaner way to do it.

  food_type_percentages = { :food_type_1 => my_diet.foo_type_percentage_1_percentage.nil? ? 0 : my_dient.food_type_1_percentage,
                            :food_type_2 => my_diet.foo_type_percentage_2_percentage.nil? 开发者_运维知识库? 0 : my_dient.food_type_2_percentage,
                            :food_type_3 => my_diet.foo_type_percentage_3_percentage.nil? ? 0 : my_dient.food_type_3_percentage,
                            :food_type_4 => my_diet.foo_type_percentage_4_percentage.nil? ? 0 : my_dient.food_type_4_percentage
  }
  food_type_percentages.sort {|a,b| a[1]<=>b[1]}.last

Any ideas?

Thanks!


To find the max value amongst columns of an existent row in the DB, do the following:

d = Diet.first(:select => "*, GREATEST(
                 food_type_1_percentage, 
                 food_type_2_percentage, 
                 food_type_3_percentage, 
                 food_type_4_percentage) AS top_food_type_percentage,
       CASE GREATEST(
                 food_type_1_percentage, 
                 food_type_2_percentage, 
                 food_type_3_percentage, 
                 food_type_4_percentage)
         WHEN food_type_1_percentage THEN food_type_1
         WHEN food_type_2_percentage THEN food_type_2
         WHEN food_type_3_percentage THEN food_type_3
         WHEN food_type_4_percentage THEN food_type_4
       END AS top_food_type")


d.top_food_type # carrots
d.top_food_type_percentage # 50

If you are trying to find the top food type in the current model instance then

class Diet < ActiveRecord::Base

  def top_food_type
    send(top_food_type_col)
  end

  def top_food_type_percentage
    send("#{top_food_type_col}_percentage")
  end

  FOOD_TYPE_COL = %w(food_type_1 food_type_2 food_type_3 food_type_4)

  def top_food_type_col
    @top_food_type_col ||= FOOD_TYPE_COL.sort do |a, b| 
     send("#{a}_percentage") <=> send("#{b}_percentage")
    end.last
  end
end

Now you can do the following:

d = Diet.new
....
....
....
d.top_food_type # carrots
d.top_food_type_percentage # 50


I assume food_percentage is the column

if you just want to find out ref this

Diet.maximum('food_percentage') # gives 50

OR you want complete record use this

Diet.find(:first, :order=> 'food_percentage DESC', :limit=>1)
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号