Module: CSVR::Parse

Included in:
App
Defined in:
lib/csvr/parse.rb

Class Method Summary collapse

Class Method Details

.filter(hash, filters) ⇒ Object 



63
64
65
66
67
68
69
70
71
72
73
 
# File 'lib/csvr/parse.rb', line 63

def filter(hash, filters)

	hash.each do |key, value|
		filters.each do |filter|
			match = value.match(filter) if value.respond_to? :match
			return hash if match
		end
	end

	return nil
end

.headers(file) ⇒ Object 



9
10
11
12
13
14
15
16
 
# File 'lib/csvr/parse.rb', line 9

def headers(file)

	File.open(file) do |fi| 
		1.times do 
			return CSV.parse_line(fi.readline)
		end
	end
end

.index(file, columns) ⇒ Object 



18
19
20
21
22
23
24
25
 
# File 'lib/csvr/parse.rb', line 18

def index(file, columns)

	array = headers(file)
	hash = {}
	array.each{|value| hash[array.index(value)] = value if columns.include?(value) }

	return hash
end

.maximum(file) ⇒ Object 



75
76
77
 
# File 'lib/csvr/parse.rb', line 75

def maximum(file)
	return %x{wc -l < "#{file}"}.to_i
end

.rows(file, headers, filters = nil) ⇒ Object 



27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
 
# File 'lib/csvr/parse.rb', line 27

def rows(file, headers, filters = nil)

	index = index(file, headers)

	File.open(file) do |fi|

		#TODO: Skip the first line. The code below creates an EOF Error

		# lines = fi.each_line
		# lines.next

		values = []
		counter = 0

		maximum(file).times do 

			counter += 1
			puts "Parsing #{counter}"

			row = CSV.parse_line(fi.readline)

			hash = {}

			index.each do |k, v| 
				row[k].gsub!(/[']/, '') if row[k].respond_to? :gsub
				hash[v] = row[k]
			end

			filters ? values << filter(hash, filters) : values << hash

		end

		return values.compact
	end
end