X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F03mysql-to-oracle.t;h=664d4e9aa77dd5dcaf08078cfd4ef30b4dc601cf;hb=27ae9ae744f9731e58ff047eda8d02f9b96bc86f;hp=a40a219ae57b0c4e537e7136e74c2de15937d98d;hpb=ac1f1387e9645f3b09a7886999221ddc274d72a9;p=dbsrgits%2FSQL-Translator.git

diff --git a/t/03mysql-to-oracle.t b/t/03mysql-to-oracle.t
index a40a219..664d4e9 100644
--- a/t/03mysql-to-oracle.t
+++ b/t/03mysql-to-oracle.t
@@ -1,7 +1,10 @@
 #!/usr/local/bin/perl
 # vim: set ft=perl:
 
-BEGIN { print "1..1\n" }
+use strict;
+use Test::More;
+use SQL::Translator;
+use Test::SQL::Translator qw(maybe_plan);
 
 my $create = q|
 CREATE TABLE random (
@@ -9,17 +12,26 @@ CREATE TABLE random (
     foo varchar(255) not null default '',
     updated timestamp
 );
+CREATE UNIQUE INDEX random_foo_update ON random(foo,updated);
+CREATE INDEX random_foo ON random(foo);
+
 |;
 
-use SQL::Translator;
-use Data::Dumper;
+BEGIN {
+    maybe_plan(3,
+        'SQL::Translator::Parser::MySQL',
+        'SQL::Translator::Producer::Oracle');
+}
 
-$SQL::Translator::DEBUG = 0;
+my $tr       = SQL::Translator->new(
+    parser   => "MySQL",
+    producer => "Oracle",
+    quote_table_names => 0,
+    quote_field_names => 0,
+);
 
-my $tr = SQL::Translator->new(parser   => "MySQL",
-                              producer => "Oracle"
-                              #producer => "SQL::Translator::Producer::Oracle::translate"
-                              #producer => sub { Dumper($_[1]) }
-                             );
+my $output = $tr->translate(\$create);
 
-print $tr->translate(\$create);
+ok( $output, 'Translate MySQL to Oracle' );
+ok( $output =~ /CREATE INDEX random_foo /, 'Normal index definition translated.');
+ok( $output =~ /CREATE UNIQUE INDEX random_foo_update /, 'Unique index definition translated.');