+isa_ok( ($csv->errors)[0], 'SL::Helper::Csv::Error', 'Errors get objectified');
+
+####
+
+$csv = SL::Helper::Csv->new(
+ file => \<<EOL,
+description;partnumber;sellprice;lastcost;wiener;
+Kaffee;;0.12;1,221.52;ja wiener
+Beer;1123245;0.12;1.5234;nein kein wieder
+EOL
+ numberformat => '1,000.00',
+ ignore_unknown_columns => 1,
+ strict_profile => 1,
+ profile => [{
+ profile => {lastcost => 'lastcost_as_number'},
+ class => 'SL::DB::Part',
+ }]
+);
+$csv->parse;
+is $csv->get_objects->[0]->lastcost, '1221.52', 'strict_profile with ignore';
+is $csv->get_objects->[0]->sellprice, undef, 'strict profile with ignore 2';
+
+####
+
+$csv = SL::Helper::Csv->new(
+ file => \<<EOL,
+description;partnumber;sellprice;lastcost;wiener;
+Kaffee;;0.12;1,221.52;ja wiener
+Beer;1123245;0.12;1.5234;nein kein wieder
+EOL
+ numberformat => '1,000.00',
+ strict_profile => 1,
+ profile => [{
+ profile => {lastcost => 'lastcost_as_number'},
+ class => 'SL::DB::Part',
+ }]
+);
+$csv->parse;
+
+is_deeply( ($csv->errors)[0], [ 'description', undef, 'header field \'description\' is not recognized', undef, 0 ], 'strict_profile without ignore_columns throws error');
+
+#####
+
+$csv = SL::Helper::Csv->new(
+ file => \"Kaffee", # " # make emacs happy
+ header => [[ 'description' ]],
+ profile => [{class => 'SL::DB::Part'}],
+);
+$csv->parse;
+is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'eol bug at the end of files';
+
+#####
+
+$csv = SL::Helper::Csv->new(
+ file => \"Description\nKaffee", # " # make emacs happy
+ case_insensitive_header => 1,
+ profile => [{
+ profile => { description => 'description' },
+ class => 'SL::DB::Part'
+ }],
+);
+$csv->parse;
+is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'case insensitive header from csv works';
+
+#####
+
+$csv = SL::Helper::Csv->new(
+ file => \"Kaffee", # " # make emacs happy
+ header => [[ 'Description' ]],
+ case_insensitive_header => 1,
+ profile => [{
+ profile => { description => 'description' },
+ class => 'SL::DB::Part'
+ }],
+);
+$csv->parse;
+is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'case insensitive header as param works';
+
+#####
+
+$csv = SL::Helper::Csv->new(
+ file => \"\x{EF}\x{BB}\x{BF}description\nKaffee", # " # make emacs happy
+ profile => [{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", # " # make emacs happy
+ header => [[ 'Description' ]],
+ profile => [{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", # " # make emacs happy
+ header => [[ 'foo' ]],
+ profile => [{
+ profile => { foo => '' },
+ class => 'SL::DB::Part',
+ }],
+);
+$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", # " # make emacs happy
+ header => [[ 'foo' ]],
+ strict_profile => 1,
+ profile => [{
+ profile => { foo => '' },
+ class => 'SL::DB::Part',
+ }],
+);
+$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", # " # make emacs happy
+ header => [[ 'CVAR_grOUnDHog' ]],
+ strict_profile => 1,
+ case_insensitive_header => 1,
+ profile => [{
+ profile => { cvar_Groundhog => '' },
+ class => 'SL::DB::Part',
+ }],
+
+);
+$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';
+
+#####
+
+$csv = SL::Helper::Csv->new(
+ file => \"description\nKaffee", # " # make emacs happy
+);
+$csv->parse;
+is_deeply $csv->get_data, [ { description => 'Kaffee' } ], 'without profile and class works';
+
+#####
+$csv = SL::Helper::Csv->new(
+ file => \"Kaffee;1,50\nSchoke;0,89\n",
+ header => [
+ [ 'datatype', 'description', 'sellprice' ],
+ ],
+ profile => [
+ { profile => { sellprice => 'sellprice_as_number' },
+ class => 'SL::DB::Part',}
+ ],
+);
+
+ok $csv->_check_multiplexed, 'multiplex check works on not-multiplexed data';
+ok !$csv->is_multiplexed, 'not-multiplexed data is recognized';
+
+#####
+$csv = SL::Helper::Csv->new(
+ file => \"P;Kaffee;1,50\nC;Meier\n",
+ header => [
+ [ 'datatype', 'description', 'listprice' ],
+ [ 'datatype', 'name' ],
+ ],
+ profile => [
+ { profile => { listprice => 'listprice_as_number' },
+ class => 'SL::DB::Part',
+ row_ident => 'P' },
+ { class => 'SL::DB::Customer',
+ row_ident => 'C' }
+ ],
+);
+
+ok $csv->_check_multiplexed, 'multiplex check works on multiplexed data';
+ok $csv->is_multiplexed, 'multiplexed data is recognized';
+
+#####
+$csv = SL::Helper::Csv->new(
+ file => \"P;Kaffee;1,50\nC;Meier\n",
+ header => [
+ [ 'datatype', 'description', 'listprice' ],
+ [ 'datatype', 'name' ],
+ ],
+ profile => [
+ { profile => { listprice => 'listprice_as_number' },
+ class => 'SL::DB::Part', },
+ { class => 'SL::DB::Customer',
+ row_ident => 'C' }
+ ],
+);
+
+ok !$csv->_check_multiplexed, 'multiplex check works on multiplexed data and detects missing row_ident';
+
+#####
+$csv = SL::Helper::Csv->new(
+ file => \"P;Kaffee;1,50\nC;Meier\n",
+ header => [
+ [ 'datatype', 'description', 'listprice' ],
+ [ 'datatype', 'name' ],
+ ],
+ profile => [
+ { profile => { listprice => 'listprice_as_number' },
+ row_ident => 'P' },
+ { class => 'SL::DB::Customer',
+ row_ident => 'C' }
+ ],
+);
+
+ok !$csv->_check_multiplexed, 'multiplex check works on multiplexed data and detects missing class';
+
+#####
+$csv = SL::Helper::Csv->new(
+ file => \"P;Kaffee;1,50\nC;Meier\n", # " # make emacs happy
+ header => [
+ [ 'datatype', 'description', 'listprice' ],
+ ],
+ profile => [
+ { profile => { listprice => 'listprice_as_number' },
+ class => 'SL::DB::Part',
+ row_ident => 'P' },
+ { class => 'SL::DB::Customer',
+ row_ident => 'C' }
+ ],
+);
+
+ok !$csv->_check_multiplexed, 'multiplex check works on multiplexed data and detects missing header';
+
+#####
+
+$csv = SL::Helper::Csv->new(
+ file => \"P;Kaffee;1,50\nC;Meier\n", # " # make emacs happy
+ header => [
+ [ 'datatype', 'description', 'listprice' ],
+ [ 'datatype', 'name' ],
+ ],
+ profile => [
+ { profile => { listprice => 'listprice_as_number' },
+ class => 'SL::DB::Part',
+ row_ident => 'P' },
+ { class => 'SL::DB::Customer',
+ row_ident => 'C' }
+ ],
+ ignore_unknown_columns => 1,
+);
+
+$csv->parse;
+is_deeply $csv->get_data,
+ [ { datatype => 'P', description => 'Kaffee', listprice => '1,50' }, { datatype => 'C', name => 'Meier' } ],
+ 'multiplex: simple case works';
+is scalar @{ $csv->get_objects }, 2, 'multiplex: multiple objects work';
+is $csv->get_objects->[0]->description, 'Kaffee', 'multiplex: first object';
+is $csv->get_objects->[1]->name, 'Meier', 'multiplex: second object';
+
+#####
+
+$csv = SL::Helper::Csv->new(
+ file => \"datatype;description;listprice\ndatatype;name\nP;Kaffee;1,50\nC;Meier\n", # " # make emacs happy
+ profile => [
+ { profile => { listprice => 'listprice_as_number' },
+ class => 'SL::DB::Part',
+ row_ident => 'P' },
+ { class => 'SL::DB::Customer',
+ row_ident => 'C' }
+ ],
+ ignore_unknown_columns => 1,
+);
+
+$csv->parse;
+is scalar @{ $csv->get_objects }, 2, 'multiplex: auto header works';
+is $csv->get_objects->[0]->description, 'Kaffee', 'multiplex: auto header first object';
+is $csv->get_objects->[1]->name, 'Meier', 'multiplex: auto header second object';
+
+######
+
+$csv = SL::Helper::Csv->new(
+ file => \<<EOL,
+datatype;description
+"datatype;name
+P;Kaffee
+C;Meier
+P;Beer
+EOL
+# " # make emacs happy
+ profile => [
+ {class => 'SL::DB::Part', row_ident => 'P'},
+ {class => 'SL::DB::Customer', row_ident => 'C'},
+ ],
+ ignore_unknown_columns => 1,
+);
+is $csv->parse, undef, 'multiplex: broken csv header won\'t get parsed';
+
+######
+
+$csv = SL::Helper::Csv->new(
+ file => \<<EOL,
+datatype;description
+P;Kaffee
+C;Meier
+P;Beer
+EOL
+# " # make emacs happy
+ profile => [
+ {class => 'SL::DB::Part', row_ident => 'P'},
+ {class => 'SL::DB::Customer', row_ident => 'C'},
+ ],
+ header => [ [], ['name'] ],
+ ignore_unknown_columns => 1,
+);
+ok !$csv->_check_multiplexed, 'multiplex check detects empty header';
+