1 use Test::More tests => 58;
7 use Support::TestSetup;
9 use_ok 'SL::Helper::Csv';
11 Support::TestSetup::login();
13 my $csv = SL::Helper::Csv->new(
14 file => \"Kaffee\n", # " # make emacs happy
15 header => [[ 'description' ]],
16 profile => [{ class => 'SL::DB::Part', }],
19 isa_ok $csv->_csv, 'Text::CSV_XS';
20 isa_ok $csv->_io, 'IO::File';
21 isa_ok $csv->parse, 'SL::Helper::Csv', 'parsing returns self';
22 is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'simple case works';
24 is $csv->get_objects->[0]->description, 'Kaffee', 'get_object works';
27 $::myconfig{numberformat} = '1.000,00';
28 $::myconfig{dateformat} = 'dd.mm.yyyy';
30 $csv = SL::Helper::Csv->new(
31 file => \"Kaffee;0.12;12,2;1,5234\n",
32 header => [[ 'description', 'sellprice', 'lastcost_as_number', 'listprice' ]],
33 profile => [{profile => { listprice => 'listprice_as_number' },
34 class => 'SL::DB::Part',}],
38 is $csv->get_objects->[0]->sellprice, 0.12, 'numeric attr works';
39 is $csv->get_objects->[0]->lastcost, 12.2, 'attr helper works';
40 is $csv->get_objects->[0]->listprice, 1.5234, 'dispatch works';
45 $csv = SL::Helper::Csv->new(
47 description,sellprice,lastcost_as_number,listprice,
48 Kaffee,0.12,'12,2','1,5234'
52 profile => [{profile => { listprice => 'listprice_as_number' },
53 class => 'SL::DB::Part',}]
56 is scalar @{ $csv->get_objects }, 1, 'auto header works';
57 is $csv->get_objects->[0]->description, 'Kaffee', 'get_object works on auto header';
62 $csv = SL::Helper::Csv->new(
64 ;;description;sellprice;lastcost_as_number;
65 #####;Puppy;Kaffee;0.12;12,2;1,5234
67 profile => [{class => 'SL::DB::Part'}],
70 is scalar @{ $csv->get_objects }, 1, 'bozo header doesn\'t blow things up';
74 $csv = SL::Helper::Csv->new(
76 description;partnumber;sellprice;lastcost_as_number;
77 Kaffee;;0.12;12,2;1,5234
78 Beer;1123245;0.12;12,2;1,5234
80 profile => [{class => 'SL::DB::Part'}],
83 is scalar @{ $csv->get_objects }, 2, 'multiple objects work';
84 is $csv->get_objects->[0]->description, 'Kaffee', 'first object';
85 is $csv->get_objects->[1]->partnumber, '1123245', 'second object';
89 $csv = SL::Helper::Csv->new(
91 description;partnumber;sellprice;lastcost_as_number;
93 Beer;1123245;0.12;1.5234
95 numberformat => '1,000.00',
96 profile => [{class => 'SL::DB::Part'}],
99 is $csv->get_objects->[0]->lastcost, '1221.52', 'formatnumber';
103 $csv = SL::Helper::Csv->new(
105 "description;partnumber;sellprice;lastcost_as_number;
106 Kaffee;;0.12;1,221.52
107 Beer;1123245;0.12;1.5234
109 numberformat => '1,000.00',
110 profile => [{class => 'SL::DB::Part'}],
112 is $csv->parse, undef, 'broken csv header won\'t get parsed';
116 $csv = SL::Helper::Csv->new(
118 description;partnumber;sellprice;lastcost_as_number;
119 "Kaf"fee";;0.12;1,221.52
120 Beer;1123245;0.12;1.5234
122 numberformat => '1,000.00',
123 profile => [{class => 'SL::DB::Part'}],
125 is $csv->parse, undef, 'broken csv content won\'t get parsed';
126 is_deeply $csv->errors, [ '"Kaf"fee";;0.12;1,221.52'."\n", 2023, 'EIQ - QUO character not allowed', 5, 2 ], 'error';
127 isa_ok( ($csv->errors)[0], 'SL::Helper::Csv::Error', 'Errors get objectified');
131 $csv = SL::Helper::Csv->new(
133 description;partnumber;sellprice;lastcost_as_number;wiener;
134 Kaffee;;0.12;1,221.52;ja wiener
135 Beer;1123245;0.12;1.5234;nein kein wieder
137 numberformat => '1,000.00',
138 ignore_unknown_columns => 1,
139 profile => [{class => 'SL::DB::Part'}],
142 is $csv->get_objects->[0]->lastcost, '1221.52', 'ignore_unkown_columns works';
146 $csv = SL::Helper::Csv->new(
148 description;partnumber;sellprice;lastcost_as_number;buchungsgruppe;
149 Kaffee;;0.12;1,221.52;Standard 7%
150 Beer;1123245;0.12;1.5234;16 %
152 numberformat => '1,000.00',
154 profile => {buchungsgruppe => "buchungsgruppen.description"},
155 class => 'SL::DB::Part',
159 isa_ok $csv->get_objects->[0]->buchungsgruppe, 'SL::DB::Buchungsgruppe', 'deep dispatch auto vivify works';
160 is $csv->get_objects->[0]->buchungsgruppe->description, 'Standard 7%', '...and gets set correctly';
165 $csv = SL::Helper::Csv->new(
167 description;partnumber;sellprice;lastcost_as_number;make_1;model_1;
168 Kaffee;;0.12;1,221.52;213;Chair 0815
169 Beer;1123245;0.12;1.5234;
171 numberformat => '1,000.00',
174 make_1 => "makemodels.0.make",
175 model_1 => "makemodels.0.model",
177 class => 'SL::DB::Part',
181 my @mm = $csv->get_objects->[0]->makemodel;
182 is scalar @mm, 1, 'one-to-many dispatch';
183 is $csv->get_objects->[0]->makemodels->[0]->model, 'Chair 0815', '... and works';
188 $csv = SL::Helper::Csv->new(
190 description;partnumber;sellprice;lastcost_as_number;make_1;model_1;make_2;model_2;
191 Kaffee;;0.12;1,221.52;213;Chair 0815;523;Table 15
193 numberformat => '1,000.00',
196 make_1 => "makemodels.0.make",
197 model_1 => "makemodels.0.model",
198 make_2 => "makemodels.1.make",
199 model_2 => "makemodels.1.model",
201 class => 'SL::DB::Part',
206 print Dumper($csv->errors);
208 @mm = $csv->get_objects->[0]->makemodel;
209 is scalar @mm, 1, 'multiple one-to-many dispatch';
210 is $csv->get_objects->[0]->makemodels->[0]->model, 'Chair 0815', '...check 1';
211 is $csv->get_objects->[0]->makemodels->[0]->make, '213', '...check 2';
212 is $csv->get_objects->[0]->makemodels->[1]->model, 'Table 15', '...check 3';
213 is $csv->get_objects->[0]->makemodels->[1]->make, '523', '...check 4';
217 $csv = SL::Helper::Csv->new(
219 description;partnumber;sellprice;lastcost_as_number;buchungsgruppe;
221 numberformat => '1,000.00',
223 profile => {buchungsgruppe => "buchungsgruppen.1.description"},
224 class => 'SL::DB::Part',
227 is $csv->parse, undef, 'wrong profile gets rejected';
228 is_deeply $csv->errors, [ 'buchungsgruppen.1.description', undef, "Profile path error. Indexed relationship is not OneToMany around here: 'buchungsgruppen.1'", undef ,0 ], 'error indicates wrong header';
229 isa_ok( ($csv->errors)[0], 'SL::Helper::Csv::Error', 'Errors get objectified');
233 $csv = SL::Helper::Csv->new(
235 description;partnumber;sellprice;lastcost;wiener;
236 Kaffee;;0.12;1,221.52;ja wiener
237 Beer;1123245;0.12;1.5234;nein kein wieder
239 numberformat => '1,000.00',
240 ignore_unknown_columns => 1,
243 profile => {lastcost => 'lastcost_as_number'},
244 class => 'SL::DB::Part',
248 is $csv->get_objects->[0]->lastcost, '1221.52', 'strict_profile with ignore';
249 is $csv->get_objects->[0]->sellprice, undef, 'strict profile with ignore 2';
253 $csv = SL::Helper::Csv->new(
255 description;partnumber;sellprice;lastcost;wiener;
256 Kaffee;;0.12;1,221.52;ja wiener
257 Beer;1123245;0.12;1.5234;nein kein wieder
259 numberformat => '1,000.00',
262 profile => {lastcost => 'lastcost_as_number'},
263 class => 'SL::DB::Part',
268 is_deeply( ($csv->errors)[0], [ 'description', undef, 'header field \'description\' is not recognized', undef, 0 ], 'strict_profile without ignore_columns throws error');
272 $csv = SL::Helper::Csv->new(
274 header => [[ 'description' ]],
275 profile => [{class => 'SL::DB::Part'}],
278 is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'eol bug at the end of files';
282 $csv = SL::Helper::Csv->new(
283 file => \"Description\nKaffee",
284 case_insensitive_header => 1,
285 profile => [ {profile => { description => 'description' }, class => 'SL::DB::Part'} ],
288 is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'case insensitive header from csv works';
292 $csv = SL::Helper::Csv->new(
294 header => [[ 'Description' ]],
295 profile => [{profile => { description => 'description' }, {class => 'SL::DB::Part'}],
298 is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'case insensitive header as param works';
302 $csv = SL::Helper::Csv->new(
303 file => \"\x{EF}\x{BB}\x{BF}description\nKaffee",
304 profile => [{class => 'SL::DB::Part'}],
308 is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'utf8 BOM works (bug 1872)';
312 $csv = SL::Helper::Csv->new(
314 header => [[ 'Description' ]],
315 profile => [{class => 'SL::DB::Part'}],
318 is_deeply $csv->get_data, undef, 'case insensitive header without flag ignores';
321 $csv = SL::Helper::Csv->new(
322 file => \"Kaffee;1,50\nSchoke;0,89\n",
324 [ 'datatype', 'description', 'sellprice' ],
327 { profile => { sellprice => 'sellprice_as_number' },
328 class => 'SL::DB::Part',}
332 ok $csv->_check_multiplexed, 'multiplex check works on not-multiplexed data';
333 ok !$csv->is_multiplexed, 'not-multiplexed data is recognized';
336 $csv = SL::Helper::Csv->new(
337 file => \"P;Kaffee;1,50\nC;Meier\n",
339 [ 'datatype', 'description', 'listprice' ],
340 [ 'datatype', 'name' ],
343 { profile => { listprice => 'listprice_as_number' },
344 class => 'SL::DB::Part',
346 { class => 'SL::DB::Customer',
352 ok $csv->_check_multiplexed, 'multiplex check works on multiplexed data';
353 ok $csv->is_multiplexed, 'multiplexed data is recognized';
356 $csv = SL::Helper::Csv->new(
357 file => \"P;Kaffee;1,50\nC;Meier\n",
359 [ 'datatype', 'description', 'listprice' ],
360 [ 'datatype', 'name' ],
363 { profile => { listprice => 'listprice_as_number' },
364 class => 'SL::DB::Part', },
365 { class => 'SL::DB::Customer',
370 ok !$csv->_check_multiplexed, 'multiplex check works on multiplexed data an detects missing row_ident';
373 $csv = SL::Helper::Csv->new(
374 file => \"P;Kaffee;1,50\nC;Meier\n",
376 [ 'datatype', 'description', 'listprice' ],
377 [ 'datatype', 'name' ],
380 { profile => { listprice => 'listprice_as_number' },
382 { class => 'SL::DB::Customer',
388 ok !$csv->_check_multiplexed, 'multiplex check works on multiplexed data an detects missing class';
391 $csv = SL::Helper::Csv->new(
392 file => \"P;Kaffee;1,50\nC;Meier\n", # " # make emacs happy
394 [ 'datatype', 'description', 'listprice' ],
397 { profile => { listprice => 'listprice_as_number' },
398 class => 'SL::DB::Part',
400 { class => 'SL::DB::Customer',
405 ok !$csv->_check_multiplexed, 'multiplex check works on multiplexed data an detects missing header';
409 $csv = SL::Helper::Csv->new(
410 file => \"P;Kaffee;1,50\nC;Meier\n", # " # make emacs happy
412 [ 'datatype', 'description', 'listprice' ],
413 [ 'datatype', 'name' ],
416 { profile => { listprice => 'listprice_as_number' },
417 class => 'SL::DB::Part',
419 { class => 'SL::DB::Customer',
422 ignore_unknown_columns => 1,
425 is_deeply $csv->get_data,
426 [ { datatype => 'P', description => 'Kaffee', listprice => '1,50' }, { datatype => 'C', name => 'Meier' } ],
427 'multiplex: simple case works';
428 is scalar @{ $csv->get_objects }, 2, 'multiplex: multiple objects work';
429 is $csv->get_objects->[0]->description, 'Kaffee', 'multiplex: first object';
430 is $csv->get_objects->[1]->name, 'Meier', 'multiplex: second object';
434 $csv = SL::Helper::Csv->new(
435 file => \"datatype;description;listprice\ndatatype;name\nP;Kaffee;1,50\nC;Meier\n", # " # make emacs happy
437 { profile => { listprice => 'listprice_as_number' },
438 class => 'SL::DB::Part',
440 { class => 'SL::DB::Customer',
443 ignore_unknown_columns => 1,
447 is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'without profile and class works';
451 $csv = SL::Helper::Csv->new(
459 # " # make emacs happy
461 {class => 'SL::DB::Part', row_ident => 'P'},
462 {class => 'SL::DB::Customer', row_ident => 'C'},
464 ignore_unknown_columns => 1,
466 is $csv->parse, undef, 'multiplex: broken csv header won\'t get parsed';
470 $csv = SL::Helper::Csv->new(
477 # " # make emacs happy
479 {class => 'SL::DB::Part', row_ident => 'P'},
480 {class => 'SL::DB::Customer', row_ident => 'C'},
482 header => [ [], ['name'] ],
483 ignore_unknown_columns => 1,
485 ok !$csv->_check_multiplexed, 'multiplex check detects empty header';
489 # set emacs to perl mode