X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=t%2Fhelper%2Fcsv.t;h=3023833712d988a5bec596f36c06f090fb11fe6d;hb=5e9aaf1c3e83467ed4f6550627f8c7e6ec6fa811;hp=434626f8f4385a704612d3629f585350f34404b4;hpb=0fb93bcfea648e356bc5e50f7013f6b91db187ef;p=kivitendo-erp.git diff --git a/t/helper/csv.t b/t/helper/csv.t index 434626f8f..302383371 100644 --- a/t/helper/csv.t +++ b/t/helper/csv.t @@ -1,14 +1,19 @@ -use Test::More tests => 39; -use SL::Dispatcher; -use Data::Dumper; +use Test::More tests => 47; + +use lib 't'; use utf8; +use Data::Dumper; +use Support::TestSetup; + use_ok 'SL::Helper::Csv'; -my $csv; -$csv = SL::Helper::Csv->new( +Support::TestSetup::login(); + +my $csv = SL::Helper::Csv->new( file => \"Kaffee\n", header => [ 'description' ], + class => 'SL::DB::Part', ); isa_ok $csv->_csv, 'Text::CSV_XS'; @@ -16,22 +21,16 @@ isa_ok $csv->_io, 'IO::File'; isa_ok $csv->parse, 'SL::Helper::Csv', 'parsing returns self'; is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'simple case works'; -$csv->class('SL::DB::Part'); - is $csv->get_objects->[0]->description, 'Kaffee', 'get_object works'; #### -SL::Dispatcher::pre_startup_setup(); - -$::form = Form->new; $::myconfig{numberformat} = '1.000,00'; $::myconfig{dateformat} = 'dd.mm.yyyy'; -$::locale = Locale->new('de'); $csv = SL::Helper::Csv->new( file => \"Kaffee;0.12;12,2;1,5234\n", header => [ 'description', 'sellprice', 'lastcost_as_number', 'listprice' ], - dispatch => { listprice => 'listprice_as_number' }, + profile => { listprice => 'listprice_as_number' }, class => 'SL::DB::Part', ); $csv->parse; @@ -50,7 +49,7 @@ Kaffee,0.12,'12,2','1,5234' EOL sep_char => ',', quote_char => "'", - dispatch => { listprice => 'listprice_as_number' }, + profile => { listprice => 'listprice_as_number' }, class => 'SL::DB::Part', ); $csv->parse; @@ -202,7 +201,7 @@ $csv->parse; print Dumper($csv->errors); -my @mm = $csv->get_objects->[0]->makemodel; +@mm = $csv->get_objects->[0]->makemodel; is scalar @mm, 1, 'multiple one-to-many dispatch'; is $csv->get_objects->[0]->makemodels->[0]->model, 'Chair 0815', '...check 1'; is $csv->get_objects->[0]->makemodels->[0]->make, '213', '...check 2'; @@ -279,6 +278,8 @@ is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'eol bug at the end o $csv = SL::Helper::Csv->new( file => \"Description\nKaffee", class => 'SL::DB::Part', + case_insensitive_header => 1, + profile => { description => 'description' }, ); $csv->parse; is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'case insensitive header from csv works'; @@ -289,8 +290,70 @@ $csv = SL::Helper::Csv->new( file => \"Kaffee", header => [ 'Description' ], class => 'SL::DB::Part', + case_insensitive_header => 1, + profile => { description => 'description' }, ); $csv->parse; is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'case insensitive header as param works'; +##### + +$csv = SL::Helper::Csv->new( + file => \"\x{FEFF}description\nKaffee", + class => 'SL::DB::Part', + encoding => 'utf8', +); +$csv->parse; +is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'utf8 BOM works (bug 1872)'; + +##### + +$csv = SL::Helper::Csv->new( + file => \"Kaffee", + header => [ 'Description' ], + class => 'SL::DB::Part', +); +$csv->parse; +is_deeply $csv->get_data, undef, 'case insensitive header without flag ignores'; + +##### + +$csv = SL::Helper::Csv->new( + file => \"Kaffee", + header => [ 'foo' ], + class => 'SL::DB::Part', + profile => { foo => '' }, +); +$csv->parse; + +is_deeply $csv->get_data, [ { foo => 'Kaffee' } ], 'empty path still gets parsed into data'; +ok $csv->get_objects->[0], 'empty path gets ignored in object creation'; + +##### + +$csv = SL::Helper::Csv->new( + file => \"Kaffee", + header => [ 'foo' ], + class => 'SL::DB::Part', + strict_profile => 1, + profile => { foo => '' }, +); +$csv->parse; + +is_deeply $csv->get_data, [ { foo => 'Kaffee' } ], 'empty path still gets parsed into data (strict profile)'; +ok $csv->get_objects->[0], 'empty path gets ignored in object creation (strict profile)'; + +$csv = SL::Helper::Csv->new( + file => \"Phil", + header => [ 'CVAR_grOUnDHog' ], + class => 'SL::DB::Part', + strict_profile => 1, + case_insensitive_header => 1, + profile => { cvar_Groundhog => '' }, +); +$csv->parse; + +is_deeply $csv->get_data, [ { cvar_Groundhog => 'Phil' } ], 'using empty path to get cvars working'; +ok $csv->get_objects->[0], '...and not destorying the objects'; + # vim: ft=perl