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(1,
+ 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;