X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F10excel.t;h=5c2e1488e7a4eb3f19e7c27f343f398b318aef33;hb=0444e6867c6c2cad9473ec285de3a2cff3cafee5;hp=9ec0eff1f6d8560875eecea53b070e57234041f2;hpb=cc558ea239a8159c1c091d571e606de66eaef06b;p=dbsrgits%2FSQL-Translator.git

diff --git a/t/10excel.t b/t/10excel.t
index 9ec0eff..5c2e148 100644
--- a/t/10excel.t
+++ b/t/10excel.t
@@ -1,10 +1,15 @@
 #!/usr/bin/perl
 # vim: set ft=perl:
 
-use Test::More tests => 31;
+use Test::More;
 use SQL::Translator;
-use SQL::Translator::Parser::Excel 'parse';
 use SQL::Translator::Schema::Constants;
+use Test::SQL::Translator qw(maybe_plan);
+
+BEGIN {
+    maybe_plan(31, 'SQL::Translator::Parser::Excel');
+    SQL::Translator::Parser::Excel->import('parse');
+}
 
 my $tr     = SQL::Translator->new(parser => "Excel");
 my $t      = $tr->translate(filename => "t/data/Excel/t.xls");
@@ -38,15 +43,21 @@ is( $f3->size, 1, 'Size is "1"' );
 is( $f3->is_primary_key, 0, 'Field is not PK' );
 
 my $f4 = shift @fields;
-is( $f4->name, 'math', 'Fourth field name is "math"' );
-is( lc $f4->data_type, 'float', 'Data type is "float"' );
-is( $f4->size, '3,1', 'Size is "3,1"' );
-is( $f4->is_primary_key, 0, 'Field is not PK' );
+TODO: {
+    eval { require Spreadsheet::ParseExcel };
+       todo_skip "Bug in Spreadsheet::ParseExcel, http://rt.cpan.org/Public/Bug/Display.html?id=39892", 4
+               if ( $Spreadsheet::ParseExcel::VERSION > 0.32 and $Spreadsheet::ParseExcel::VERSION < 0.41 );
+
+       is( $f4->name, 'math', 'Fourth field name is "math"' );
+       is( lc $f4->data_type, 'float', 'Data type is "float"' );
+       is( $f4->size, '3,1', 'Size is "3,1"' );
+       is( $f4->is_primary_key, 0, 'Field is not PK' );
+}
 
 my $f5 = shift @fields;
 is( $f5->name, 'bitmap', 'Fifth field name is "bitmap"' );
 is( lc $f5->data_type, 'char', 'Data type is "char"' );
-is( $f5->size, 0, 'Size is "0"' );
+is( $f5->size, 1, 'Size is "1"' );
 is( $f5->is_primary_key, 0, 'Field is not PK' );
 
 my $f6 = shift @fields;
@@ -56,7 +67,7 @@ is( $f6->size, 10, 'Size is "10"' );
 is( $f6->is_primary_key, 0, 'Field is not PK' );
 
 my $f7 = shift @fields;
-is( $f7->name, 'silly_field_with_random_characters', 
+is( $f7->name, 'silly_field_with_random_characters',
     'Seventh field name is "silly_field_with_random_characters"' );
 is( lc $f7->data_type, 'char', 'Data type is "CHAR"' );
 is( $f7->size, 11, 'Size is "11"' );