ranking.rb

# == Schema Information
#
# Table name: restaurants_menu_item_rankings
#
#  id             :integer
#  menu_id        :integer
#  menu_item_name :string
#  count          :decimal(, )
#

class Restaurants::MenuItemRanking < ApplicationRecord

  attribute :total, :integer
  attribute :rank, :integer
  attribute :percent_tank, :float

  belongs_to :menu

  def self.refresh
    Scenic.database.refresh_materialized_view(table_name, concurrently: false, cascade: false)
  end

  def self.default_scope
    self.select(
      'restaurants_menu_item_rankings.*',
      'sum(count) over () as total',
      'rank() over (order by count desc) as rank',
      'percent_rank() over (order by count desc) as percent_rank'
    )
  end
end