Boolean algebra

1

(X AND true) OR (X AND false) == X

SQL

1
2
3
4
5

has_many :fight_wins, :class_name => 'Fight', :finder_sql =>
      '#{sanitize_sql_array(
          "SELECT f.* 
           FROM   fights AS f 
           WHERE  f.challenger_id = ?", id)}'

1
2
3
4
5
6
7
8
9
10

Challenger < ActiveRecord::Base
  has_many :challenges, :class_name => 'Fight', :foreign_key => :challenger_id
  has_many :defenses, :class_name => 'Fight', :foreign_key => :challengee_id

  has_many :fight_wins, :class_name => 'Fight', :foreign_key => :winner_id

  def challenger_won
    self.winner_id == self.challenger_id
  end
end