trunk/t/2-input-excel.t

#!/usr/bin/perl -w

use strict;
use blib;

use Test::More tests => 45;

BEGIN {
use_ok( 'WebPAC::Test' );
use_ok( 'WebPAC::Input' );
}

my $module = 'WebPAC::Input::Excel';
diag "testing with $module";

our ($input,$db,$size);

sub open_xls {

        ok($input = new WebPAC::Input(
                module => $module,
                no_progress_bar => 1,
                %LOG,
        ), "new $module");

        my $path = shift;
        $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;
        if ($mfn <= 10 || $mfn == 20) {
                ok($rec, "fetch $mfn");
        } else {
                ok(! $rec, "empty $mfn");
        }

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

        diag "rec: ", dump($rec), "\n" if $debug;
}

open_xls('stara-signatura.xls');

foreach my $mfn ( 20 .. 23 ) {
        diag dump( $input->fetch( $mfn ) ) if $debug;
}
1	dpavlin	498	#!/usr/bin/perl -w
2
3	dpavlin	949	use strict;
4	dpavlin	498	use blib;
5
6	dpavlin	949	use Test::More tests => 45;
7	dpavlin	498
8			BEGIN {
9	dpavlin	949	use_ok( 'WebPAC::Test' );
10	dpavlin	727	use_ok( 'WebPAC::Input' );
11	dpavlin	498	}
12
13			my $module = 'WebPAC::Input::Excel';
14			diag "testing with $module";
15
16	dpavlin	1095	our ($input,$db,$size);
17	dpavlin	498
18	dpavlin	1095	sub open_xls {
19	dpavlin	498
20	dpavlin	1095	ok($input = new WebPAC::Input(
21			module => $module,
22			no_progress_bar => 1,
23			%LOG,
24			), "new $module");
25
26			my $path = shift;
27			$path = "$abs_path/data/$path";
28			ok(my $db = $input->open( path => $path ), "open $path");
29			ok($size = $input->size, "size $size");
30			return $db;
31			}
32
33
34			open_xls('excel_95.xls');
35
36	dpavlin	498	foreach my $mfn ( 1 ... $size ) {
37			my $rec = $input->fetch;
38			if ($mfn <= 10 \|\| $mfn == 20) {
39			ok($rec, "fetch $mfn");
40			} else {
41			ok(! $rec, "empty $mfn");
42			}
43
44			cmp_ok($input->pos, '==', $mfn, "pos $mfn");
45
46	dpavlin	949	diag "rec: ", dump($rec), "\n" if $debug;
47	dpavlin	498	}
48
49	dpavlin	1095	open_xls('stara-signatura.xls');
50
51			foreach my $mfn ( 20 .. 23 ) {
52			diag dump( $input->fetch( $mfn ) ) if $debug;
53			}