X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F03mysql-to-oracle.t;h=5b64c598dfa689de9a92ef5894b987848941d41b;hb=d1ca5a5cb007ddb2f361d314ae4c26ddd4308aa4;hp=0897878389eb13d806aedc0cfed321b8078c381f;hpb=b4bc8f6f6660b0a69cf2cd63959f65fd7a6e0ca0;p=dbsrgits%2FSQL-Translator.git

diff --git a/t/03mysql-to-oracle.t b/t/03mysql-to-oracle.t
index 0897878..5b64c59 100644
--- a/t/03mysql-to-oracle.t
+++ b/t/03mysql-to-oracle.t
@@ -2,21 +2,40 @@
 # vim: set ft=perl:
 
 use strict;
-use Test::More tests => 1;
+use Test::More;
 use SQL::Translator;
+use Test::SQL::Translator qw(maybe_plan);
 
 my $create = q|
 CREATE TABLE random (
     id int auto_increment PRIMARY KEY,
     foo varchar(255) not null default '',
+    bar enum('wibble','wo''bble'),
     updated timestamp
 );
+CREATE UNIQUE INDEX random_foo_update ON random(foo,updated);
+CREATE INDEX random_foo ON random(foo);
+
 |;
 
+BEGIN {
+    maybe_plan(undef,
+        'SQL::Translator::Parser::MySQL',
+        'SQL::Translator::Producer::Oracle');
+}
+
 my $tr       = SQL::Translator->new(
     parser   => "MySQL",
-    producer => "Oracle"
+    producer => "Oracle",
+    quote_table_names => 0,
+    quote_field_names => 0,
 );
 
-ok( $tr->translate(\$create), 'Translate MySQL to Oracle' );
+my $output = $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.');
+ok( $output =~ /\QCHECK (bar IN ('wibble', 'wo''bble'))\E/, 'Enum translated and escaped.');
 
+done_testing;