added header_first to WebPAC::Input::CSV

[webpac2] / t / 2-input-excel.t

diff --git a/t/2-input-excel.t b/t/2-input-excel.t
index 3c9249f..09f2314 100755 (executable)
--- a/t/2-input-excel.t
+++ b/t/2-input-excel.t
@@ -1,36 +1,35 @@
 #!/usr/bin/perl -w
 
-use Test::More tests => 45;
-use Test::Exception;
-use Cwd qw/abs_path/;
-use blib;
 use strict;
+use lib 'lib';
 
-use Data::Dumper;
-
-my $debug = 1;
+use Test::More tests => 75;
 
 BEGIN {
-use_ok( 'WebPAC::Input::Excel' );
+use_ok( 'WebPAC::Test' );
+use_ok( 'WebPAC::Input' );
 }
 
-ok(my $abs_path = abs_path($0), "abs_path");
-$abs_path =~ s#/[^/]*$#/#;
-
 my $module = 'WebPAC::Input::Excel';
 diag "testing with $module";
 
 ok(my $input = new WebPAC::Input(
        module => $module,
-       no_log => 0,
        no_progress_bar => 1,
-       debug => $debug,
+       %LOG,
 ), "new");
 
-ok(my $db = $input->open(
-       path => "$abs_path/data/excel_95.xls"
-), "open");
-ok(my $size = $input->size, "size");
+our ($db,$size);
+
+sub open_xls {
+       my $path = shift || die "no path?";
+       $path = "$abs_path/data/$path";
+       ok(my $db = $input->open( path => $path ), "open $path");
+       ok($size = $input->size, "size $size");
+       return $db;
+}
+
+open_xls('excel_95.xls');
 
 foreach my $mfn ( 1 ... $size ) {
        my $rec = $input->fetch;
@@ -42,6 +41,13 @@ foreach my $mfn ( 1 ... $size ) {
 
        cmp_ok($input->pos, '==', $mfn, "pos $mfn");
 
-       diag "rec: ", Dumper($rec), "\n";
+       diag "rec: ", dump($rec), "\n" if $debug;
+}
+
+open_xls('stara-signatura.xls');
+for ( 1 .. 14 ) {
+       ok( $input->seek( $_ ), "seek $_");
+       ok( my $rec = $input->fetch, "fetch $_" );
+       diag dump( $rec ) if $debug;
 }