trunk/t/2-input-excel.t

#!/usr/bin/perl -w

use Test::More tests => 45;
use Test::Exception;
use Cwd qw/abs_path/;
use blib;
use strict;

use Data::Dumper;

my $debug = 1;

BEGIN {
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,
), "new");

ok(my $db = $input->open(
        path => "$abs_path/data/excel_95.xls"
), "open");
ok(my $size = $input->size, "size");

foreach my $mfn ( 1 ... $size ) {
        my $rec = $input->fetch;
        if ($mfn <= 10 || $mfn == 20) {
                ok($rec, "fetch $mfn");
        } else {
                ok(! $rec, "empty $mfn");
        }

        cmp_ok($input->pos, '==', $mfn, "pos $mfn");

        diag "rec: ", Dumper($rec), "\n";
}

1	dpavlin	498	#!/usr/bin/perl -w
2
3			use Test::More tests => 45;
4			use Test::Exception;
5			use Cwd qw/abs_path/;
6			use blib;
7			use strict;
8
9			use Data::Dumper;
10
11			my $debug = 1;
12
13			BEGIN {
14	dpavlin	727	use_ok( 'WebPAC::Input' );
15	dpavlin	498	}
16
17			ok(my $abs_path = abs_path($0), "abs_path");
18			$abs_path =~ s#/[^/]*$#/#;
19
20			my $module = 'WebPAC::Input::Excel';
21			diag "testing with $module";
22
23			ok(my $input = new WebPAC::Input(
24			module => $module,
25			no_log => 0,
26			no_progress_bar => 1,
27			debug => $debug,
28			), "new");
29
30			ok(my $db = $input->open(
31			path => "$abs_path/data/excel_95.xls"
32			), "open");
33			ok(my $size = $input->size, "size");
34
35			foreach my $mfn ( 1 ... $size ) {
36			my $rec = $input->fetch;
37			if ($mfn <= 10 \|\| $mfn == 20) {
38			ok($rec, "fetch $mfn");
39			} else {
40			ok(! $rec, "empty $mfn");
41			}
42
43			cmp_ok($input->pos, '==', $mfn, "pos $mfn");
44
45			diag "rec: ", Dumper($rec), "\n";
46			}
47