From 0e22855375f10343d77fdcc83b323a992325649f Mon Sep 17 00:00:00 2001 From: Harald Eilertsen Date: Fri, 14 Nov 2014 10:52:40 +0100 Subject: Make csv-parsing a method. --- parse_report.rb | 30 ++++++++++++++++++------------ 1 file changed, 18 insertions(+), 12 deletions(-) (limited to 'parse_report.rb') diff --git a/parse_report.rb b/parse_report.rb index b8a2bcc..714c746 100644 --- a/parse_report.rb +++ b/parse_report.rb @@ -1,19 +1,23 @@ require 'sale' require 'csv' -csv_opts = { - :col_sep => ";", - :skip_lines => /^(Notes|The |;)/, - :headers => true, - :converters => :all, -} - -sales = [] - -CSV.foreach(ARGV[0], csv_opts) do |row| - if row.count > 0 - sales << SalesReporter::Sale.new(row["Date"], row["revenue EUR"], row["quantity"], row["Country"], row["Shop"]) +def parse_csv(csv_file) + csv_opts = { + :col_sep => ";", + :skip_lines => /^(Notes|The |;)/, + :headers => true, + :converters => :all, + } + + sales = [] + + CSV.foreach(csv_file, csv_opts) do |row| + if row.count > 0 + sales << SalesReporter::Sale.new(row["Date"], row["revenue EUR"], row["quantity"], row["Country"], row["Shop"]) + end end + + sales end def load_reports @@ -22,6 +26,8 @@ def load_reports end end +sales = parse_csv(ARGV[0]) + load_reports SalesReporter::Reports::SalesByDate.render(sales) -- cgit v1.2.3