action.rb

    #players = select distinct(player) from actions;
    players = repository(:default).adapter.query('select distinct(player) from actions')

    @players = []

    players.each do |name|
      player = {}
      player["name"] = name
      player["won"] = Action.sum(:amount, :conditions => ["player = '#{name}' and amount != 'NULL' and (type = 'award' or type = 'return')"])
      player["lost"] = Action.sum(:amount, :conditions => ["player = '#{name}' and amount != 'NULL' and type != 'award' and type != 'return'"])

      @players << player
    end