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 |
|
|
|