7 use Test::SQL::Translator qw(maybe_plan);
11 id int auto_increment PRIMARY KEY,
12 foo varchar(255) not null default '',
13 bar enum('wibble','wo''bble'),
16 CREATE UNIQUE INDEX random_foo_update ON random(foo,updated);
17 CREATE INDEX random_foo ON random(foo);
23 'SQL::Translator::Parser::MySQL',
24 'SQL::Translator::Producer::Oracle');
27 my $tr = SQL::Translator->new(
30 quote_table_names => 0,
31 quote_field_names => 0,
34 my $output = $tr->translate(\$create);
36 ok( $output, 'Translate MySQL to Oracle' );
37 ok( $output =~ /CREATE INDEX random_foo /, 'Normal index definition translated.');
38 ok( $output =~ /CREATE UNIQUE INDEX random_foo_update /, 'Unique index definition translated.');
39 ok( $output =~ /\QCHECK (bar IN ('wibble', 'wo''bble'))\E/, 'Enum translated and escaped.');