Class: BStats::PlayerBattingStat

Inherits:
ActiveRecord::Base
  • Object
show all
Defined in:
lib/bstats/player_batting_stat.rb

Class Method Summary collapse

Class Method Details

.calculate_batting_average(hits, at_bats) ⇒ Object 



39
40
41
 
# File 'lib/bstats/player_batting_stat.rb', line 39

def self.calculate_batting_average(hits, at_bats)
	[0, "0", ""].include?(at_bats) ? 0 : (hits.to_f / at_bats.to_f).round(3)
end

.calculate_slugging_percentage(hits, doubles, triples, home_runs, at_bats) ⇒ Object 



43
44
45
 
# File 'lib/bstats/player_batting_stat.rb', line 43

def self.calculate_slugging_percentage(hits, doubles, triples, home_runs, at_bats)
	[0, "0", ""].include?(at_bats) ? 0 : (((hits - doubles - triples - home_runs) + (2 * doubles) + (3 * triples) + (4 * home_runs)).to_f / at_bats).round(3)
end

.import_csv(file) ⇒ Object 



11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
 
# File 'lib/bstats/player_batting_stat.rb', line 11

def self.import_csv(file)
	begin
		CSV.foreach(file, headers: true) do |row|
			stat = PlayerBattingStat.new()
			stat.external_id = row['playerID'].to_s
			stat.year = row['yearID'].to_s
			stat.league = row['league'].to_s
			stat.team_id = row['teamID'].to_s
			stat.games = row['G'].to_i
			stat.at_bats = row['AB'].to_i
			stat.runs = row['R'].to_i
			stat.hits = row['H'].to_i
			stat.doubles = row['2B'].to_i
			stat.triples = row['3B'].to_i
			stat.home_runs = row['HR'].to_i
			stat.runs_batted_in = row['RBI'].to_i
			stat.stolen_bases = row['SB'].to_i
			stat.caught_stealing = row['CS'].to_i
			stat.batting_average = self.calculate_batting_average(stat.hits, stat.at_bats)
			stat.slugging_percentage = self.calculate_slugging_percentage(stat.hits, stat.doubles, stat.triples, stat.home_runs, stat.at_bats)
			stat.save
		end
	rescue CSV::MalformedCSVError => e
		# certain csv's have file endings that the CSV library doesn't like. Windows may or may not have something to do with that
		# TODO: log file ending failure
	end
end