Class: CsvReader
- Inherits:
-
Object
show all
- Extended by:
- Forwardable
- Includes:
- Enumerable
- Defined in:
- lib/csvreader/version.rb,
lib/csvreader/base.rb,
lib/csvreader/base.rb,
lib/csvreader/buffer.rb,
lib/csvreader/parser.rb,
lib/csvreader/reader.rb,
lib/csvreader/builder.rb,
lib/csvreader/converter.rb,
lib/csvreader/parser_std.rb,
lib/csvreader/parser_tab.rb,
lib/csvreader/parser_fixed.rb,
lib/csvreader/parser_table.rb,
lib/csvreader/parser_strict.rb
Overview
note: uses a class for now - change to module - why? why not?
Defined Under Namespace
Modules: Version
Classes: Buffer, Builder, Converter, Error, ParseError, Parser, ParserFixed, ParserStd, ParserStrict, ParserTab, ParserTable
Constant Summary
collapse
- DEFAULT =
pre-define CsvReader (built-in) formats/dialect
Builder.new( Parser::DEFAULT )
- NUMERIC =
Builder.new( Parser::NUMERIC )
- HUMAN =
Builder.new( Parser::HUMAN )
- STRICT =
Builder.new( Parser::STRICT )
- RFC4180 =
Builder.new( Parser::RFC4180 )
- EXCEL =
Builder.new( Parser::EXCEL )
- MYSQL =
Builder.new( Parser::MYSQL )
- POSTGRES =
POSTGRESQL = Builder.new( Parser::POSTGRESQL )
- POSTGRES_TEXT =
POSTGRESQL_TEXT = Builder.new( Parser::POSTGRESQL_TEXT )
- TAB =
Builder.new( Parser::TAB )
- TABLE =
Builder.new( Parser::TABLE )
- FIXED =
Builder.new( Parser::FIXED )
- VERSION =
[Version::MAJOR,
Version::MINOR,
Version::PATCH].join('.')
Class Method Summary
collapse
-
.banner ⇒ Object
-
.default ⇒ Object
alternative alias for DEFAULT.
-
.excel ⇒ Object
alternative alias for EXCEL.
-
.f ⇒ Object
-
.fix ⇒ Object
-
.fixed ⇒ Object
-
.foreach(path, sep: nil, converters: nil, parser: nil, **kwargs, &block) ⇒ Object
-
.header(path, sep: nil, parser: nil, **kwargs) ⇒ Object
use header or headers - or use both (with alias)?.
-
.hum ⇒ Object
-
.human ⇒ Object
-
.hxl ⇒ Object
HXL (humanitarian eXchange language).
-
.mysql ⇒ Object
-
.n ⇒ Object
-
.num ⇒ Object
-
.numeric ⇒ Object
-
.open(path, mode = nil, sep: nil, converters: nil, parser: nil, **kwargs, &block) ⇒ Object
-
.parse(str_or_readable, sep: nil, converters: nil, parser: nil, **kwargs, &block) ⇒ Object
-
.parse_line(str_or_readable, sep: nil, converters: nil, **kwargs) ⇒ Object
note: only add parse_line convenience helper for default always use parse (do NOT/NOT/NOT use parse_line) - why? why not? todo/fix: remove parse_line!!!.
-
.postgres ⇒ Object
-
.postgres_text ⇒ Object
-
.postgresql ⇒ Object
-
.postgresql_text ⇒ Object
-
.read(path, sep: nil, converters: nil, parser: nil, **kwargs) ⇒ Object
-
.rfc4180 ⇒ Object
alternative alias for RFC4180.
-
.root ⇒ Object
-
.strict ⇒ Object
alternative alias for STRICT.
-
.tab ⇒ Object
-
.table ⇒ Object
-
.version ⇒ Object
keep (as an alternative to VERSION) - why? why not?.
Instance Method Summary
collapse
Constructor Details
#initialize(str_or_readable, sep: nil, converters: nil, parser: nil, **kwargs) ⇒ CsvReader
Returns a new instance of CsvReader.
110
111
112
113
114
115
116
117
118
119
120
121
122
123
|
# File 'lib/csvreader/reader.rb', line 110
def initialize( str_or_readable, sep: nil, converters: nil, parser: nil, **kwargs )
raise ArgumentError.new( "Cannot parse nil as CSV" ) if str_or_readable.nil?
@io = str_or_readable.is_a?(String) ? StringIO.new(str_or_readable) : str_or_readable
@sep = sep @kwargs = kwargs
@converters = Converter.create_converters( converters )
@parser = parser.nil? ? Parser::DEFAULT : parser
end
|
Class Method Details
.banner ⇒ Object
24
25
26
|
# File 'lib/csvreader/version.rb', line 24
def self.banner
"csvreader/#{VERSION} on Ruby #{RUBY_VERSION} (#{RUBY_RELEASE_DATE}) [#{RUBY_PLATFORM}]"
end
|
.default ⇒ Object
alternative alias for DEFAULT
118
|
# File 'lib/csvreader/base.rb', line 118
def self.default() DEFAULT; end
|
.excel ⇒ Object
alternative alias for EXCEL
128
|
# File 'lib/csvreader/base.rb', line 128
def self.excel() EXCEL; end
|
.f ⇒ Object
138
|
# File 'lib/csvreader/base.rb', line 138
def self.f() fixed; end
|
.fix ⇒ Object
137
|
# File 'lib/csvreader/base.rb', line 137
def self.fix() fixed; end
|
.fixed ⇒ Object
136
|
# File 'lib/csvreader/base.rb', line 136
def self.fixed() FIXED; end
|
.foreach(path, sep: nil, converters: nil, parser: nil, **kwargs, &block) ⇒ Object
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
|
# File 'lib/csvreader/reader.rb', line 59
def self.foreach( path, sep: nil,
converters: nil, parser: nil, **kwargs, &block )
csv = open( path, sep: sep, converters: converters, parser: parser, **kwargs )
if block_given?
begin
csv.each( &block )
ensure
csv.close
end
else
csv.to_enum end
end
|
use header or headers - or use both (with alias)?
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
# File 'lib/csvreader/reader.rb', line 40
def self.( path, sep: nil, parser: nil, **kwargs )
records = []
open( path, sep: sep, parser: parser, **kwargs ) do |csv|
csv.each do |record|
records << record
break end
end
records.size == 0 ? nil : records.first
end
|
.hum ⇒ Object
123
|
# File 'lib/csvreader/base.rb', line 123
def self.hum() human; end
|
.human ⇒ Object
122
|
# File 'lib/csvreader/base.rb', line 122
def self.human() HUMAN; end
|
.hxl ⇒ Object
HXL (humanitarian eXchange language)
124
|
# File 'lib/csvreader/base.rb', line 124
def self.hxl() human; end
|
.mysql ⇒ Object
129
|
# File 'lib/csvreader/base.rb', line 129
def self.mysql() MYSQL; end
|
.n ⇒ Object
121
|
# File 'lib/csvreader/base.rb', line 121
def self.n() numeric; end
|
.num ⇒ Object
120
|
# File 'lib/csvreader/base.rb', line 120
def self.num() numeric; end
|
.numeric ⇒ Object
119
|
# File 'lib/csvreader/base.rb', line 119
def self.numeric() NUMERIC; end
|
.open(path, mode = nil, sep: nil, converters: nil, parser: nil, **kwargs, &block) ⇒ Object
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
|
# File 'lib/csvreader/reader.rb', line 5
def self.open( path, mode=nil,
sep: nil,
converters: nil,
parser: nil, **kwargs, &block )
f = File.open( path, mode ? mode : 'r:bom|utf-8' )
csv = new(f, sep: sep,
converters: converters,
parser: parser, **kwargs )
if block_given?
begin
block.call( csv )
ensure
csv.close
end
else
csv
end
end
|
.parse(str_or_readable, sep: nil, converters: nil, parser: nil, **kwargs, &block) ⇒ Object
78
79
80
81
82
83
84
85
86
87
88
|
# File 'lib/csvreader/reader.rb', line 78
def self.parse( str_or_readable, sep: nil,
converters: nil,
parser: nil, **kwargs, &block )
csv = new( str_or_readable, sep: sep, converters: converters, parser: parser, **kwargs )
if block_given?
csv.each( &block ) else csv.read end
end
|
.parse_line(str_or_readable, sep: nil, converters: nil, **kwargs) ⇒ Object
note: only add parse_line convenience helper for default
always use parse (do NOT/NOT/NOT use parse_line) - why? why not?
todo/fix: remove parse_line!!!
97
98
99
100
101
102
103
104
105
|
# File 'lib/csvreader/reader.rb', line 97
def self.parse_line( str_or_readable, sep: nil,
converters: nil, **kwargs )
records = []
parse( str_or_readable, sep: sep, converters: converters, **kwargs ) do |record|
records << record
break end
records.size == 0 ? nil : records.first
end
|
.postgres ⇒ Object
131
|
# File 'lib/csvreader/base.rb', line 131
def self.postgres() postgresql; end
|
.postgres_text ⇒ Object
133
|
# File 'lib/csvreader/base.rb', line 133
def self.postgres_text() postgresql_text; end
|
.postgresql ⇒ Object
130
|
# File 'lib/csvreader/base.rb', line 130
def self.postgresql() POSTGRESQL; end
|
.postgresql_text ⇒ Object
132
|
# File 'lib/csvreader/base.rb', line 132
def self.postgresql_text() POSTGRESQL_TEXT; end
|
.read(path, sep: nil, converters: nil, parser: nil, **kwargs) ⇒ Object
29
30
31
32
33
34
35
36
37
|
# File 'lib/csvreader/reader.rb', line 29
def self.read( path, sep: nil,
converters: nil,
parser: nil, **kwargs )
open( path,
sep: sep,
converters: converters,
parser: parser, **kwargs ) { |csv| csv.read }
end
|
.rfc4180 ⇒ Object
alternative alias for RFC4180
127
|
# File 'lib/csvreader/base.rb', line 127
def self.rfc4180() RFC4180; end
|
.root ⇒ Object
28
29
30
|
# File 'lib/csvreader/version.rb', line 28
def self.root
File.expand_path( File.dirname(File.dirname(File.dirname(__FILE__))) )
end
|
.strict ⇒ Object
alternative alias for STRICT
126
|
# File 'lib/csvreader/base.rb', line 126
def self.strict() STRICT; end
|
.tab ⇒ Object
134
|
# File 'lib/csvreader/base.rb', line 134
def self.tab() TAB; end
|
.table ⇒ Object
135
|
# File 'lib/csvreader/base.rb', line 135
def self.table() TABLE; end
|
.version ⇒ Object
keep (as an alternative to VERSION) - why? why not?
18
19
20
|
# File 'lib/csvreader/version.rb', line 18
def self.version VERSION
end
|
Instance Method Details
#each(&block) ⇒ Object
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
|
# File 'lib/csvreader/reader.rb', line 143
def each( &block )
if block_given?
kwargs = {}
kwargs[:sep] = @sep if @sep && @parser.respond_to?( :'sep=' )
kwargs[:width] = @kwargs[:width] if @parser.is_a?( ParserFixed )
if @converters.empty?
@parser.parse( @io, kwargs, &block )
else
@parser.parse( @io, kwargs ) do |raw_record|
record = []
raw_record.each_with_index do | value, i |
record << @converters.convert( value, i )
end
block.call( record )
end
end
else
to_enum
end
end
|
#read ⇒ Object
175
|
# File 'lib/csvreader/reader.rb', line 175
def read() to_a; end
|