/[webpac2]/trunk/t/2-input-excel.t
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/t/2-input-excel.t

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 498 by dpavlin, Sun May 14 19:45:45 2006 UTC revision 1100 by dpavlin, Sat Aug 2 23:46:41 2008 UTC
# Line 1  Line 1 
1  #!/usr/bin/perl -w  #!/usr/bin/perl -w
2    
 use Test::More tests => 45;  
 use Test::Exception;  
 use Cwd qw/abs_path/;  
 use blib;  
3  use strict;  use strict;
4    use blib;
5    
6  use Data::Dumper;  use Test::More tests => 49;
   
 my $debug = 1;  
7    
8  BEGIN {  BEGIN {
9  use_ok( 'WebPAC::Input::Excel' );  use_ok( 'WebPAC::Test' );
10    use_ok( 'WebPAC::Input' );
11  }  }
12    
 ok(my $abs_path = abs_path($0), "abs_path");  
 $abs_path =~ s#/[^/]*$#/#;  
   
13  my $module = 'WebPAC::Input::Excel';  my $module = 'WebPAC::Input::Excel';
14  diag "testing with $module";  diag "testing with $module";
15    
16  ok(my $input = new WebPAC::Input(  ok(my $input = new WebPAC::Input(
17          module => $module,          module => $module,
         no_log => 0,  
18          no_progress_bar => 1,          no_progress_bar => 1,
19          debug => $debug,          %LOG,
20  ), "new");  ), "new");
21    
22  ok(my $db = $input->open(  our ($db,$size);
23          path => "$abs_path/data/excel_95.xls"  
24  ), "open");  sub open_xls {
25  ok(my $size = $input->size, "size");          my $args = shift;
26    
27            $args->{path} = "$abs_path/data/" . $args->{path} || die "no path?";
28            ok(my $db = $input->open( %$args ), "open " . dump( $args ));
29            ok($size = $input->size, "size $size");
30            return $db;
31    }
32    
33    open_xls({ path => 'excel_95.xls' });
34    
35  foreach my $mfn ( 1 ... $size ) {  foreach my $mfn ( 1 ... $size ) {
36          my $rec = $input->fetch;          my $rec = $input->fetch;
# Line 42  foreach my $mfn ( 1 ... $size ) { Line 42  foreach my $mfn ( 1 ... $size ) {
42    
43          cmp_ok($input->pos, '==', $mfn, "pos $mfn");          cmp_ok($input->pos, '==', $mfn, "pos $mfn");
44    
45          diag "rec: ", Dumper($rec), "\n";          diag "rec: ", dump($rec), "\n" if $debug;
46  }  }
47    
48    open_xls({ path => 'stara-signatura.xls', input_encoding => 'utf-16' });
49    ok( $input->seek( 790 ), 'seek 790');
50    ok( my $rec = $input->fetch, 'fetch' );
51    diag dump( $rec );
Legend:
Removed from v.498  
changed lines
  Added in v.1100
  ViewVC Help
Powered by ViewVC 1.1.26