Skip to content

Instantly share code, notes, and snippets.

@syrm
Created December 10, 2010 08:50
Show Gist options
  • Save syrm/735982 to your computer and use it in GitHub Desktop.
Save syrm/735982 to your computer and use it in GitHub Desktop.
game = Game.select{[
count(:over, :* => true){}.as(nb_game),
sum({1 => 1}.case(0, :result_id)).as(nb_win),
sum(psr_gain).as(psr_gain),
sum(nb_death).as(nb_death),
sum(nb_hero_kill).as(nb_hero_kill),
sum(nb_hero_assist).as(nb_hero_assist),
sum(nb_first_kill).as(nb_first_kill),
sum(nb_kill_combo_2).as(nb_kill_combo_2),
sum(nb_kill_combo_3).as(nb_kill_combo_3),
sum(nb_kill_combo_4).as(nb_kill_combo_4),
sum(nb_kill_combo_5).as(nb_kill_combo_5),
sum(nb_kill_chain_3).as(nb_kill_chain_3),
sum(nb_kill_chain_4).as(nb_kill_chain_4),
sum(nb_kill_chain_5).as(nb_kill_chain_5),
sum(nb_kill_chain_6).as(nb_kill_chain_6),
sum(nb_kill_chain_7).as(nb_kill_chain_7),
sum(nb_kill_chain_8).as(nb_kill_chain_8),
sum(nb_kill_chain_9).as(nb_kill_chain_9),
sum(nb_kill_chain_10).as(nb_kill_chain_10),
sum(nb_kill_chain_15).as(nb_kill_chain_15),
sum(nb_smackdown).as(nb_smackdown),
sum(nb_humiliation).as(nb_humiliation),
sum(nb_wards).as(nb_wards),
sum(nb_creep_kill).as(nb_creep_kill),
sum(nb_neutral_kill).as(nb_neutral_kill),
sum(nb_denies).as(nb_denies),
sum(length).as(length),
sum(gold_min).as(gold_min),
sum(xp_min).as(xp_min)
]}.filter('player_id = ?', player.id).group(:player_id).first
#<Game @values={:nb_game=>1, :nb_win=>0, :psr_gain=>0, :nb_death=>13, :nb_hero_kill=>13, :nb_hero_assist=>19, :nb_first_kill=>0, :nb_kill_combo_2=>0, :nb_kill_combo_3=>0, :nb_kill_combo_4=>0, :nb_kill_combo_5=>0, :nb_kill_chain_3=>0, :nb_kill_chain_4=>0, :nb_kill_chain_5=>0, :nb_kill_chain_6=>0, :nb_kill_chain_7=>0, :nb_kill_chain_8=>0, :nb_kill_chain_9=>0, :nb_kill_chain_10=>0, :nb_kill_chain_15=>0, :nb_smackdown=>0, :nb_humiliation=>0, :nb_wards=>0, :nb_creep_kill=>179, :nb_neutral_kill=>26, :nb_denies=>9, :length=>103, :gold_min=>252, :xp_min=>742}>
Why I can't access the property with game.nb_game, game.nb_win etc ?
I get the error "undefined method"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment