X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F15oracle-parser.t;h=4660857db47306d5afe6c235ed3afaa858004603;hb=bb44ccb55047c9425c88ee0e1bbd27f372e5ed23;hp=6377ad25fb073d72e78bbada27554ef36b67da31;hpb=fbc0552f2fa97295f7ffd616b7ed8af30e8e025e;p=dbsrgits%2FSQL-Translator.git diff --git a/t/15oracle-parser.t b/t/15oracle-parser.t index 6377ad2..4660857 100644 --- a/t/15oracle-parser.t +++ b/t/15oracle-parser.t @@ -5,17 +5,10 @@ use strict; use Test::More; use SQL::Translator; use SQL::Translator::Schema::Constants; +use Test::SQL::Translator qw(maybe_plan); -eval { - require SQL::Translator::Parser::Oracle; - SQL::Translator::Parser::Oracle->import('parse'); -}; -if ($@) { - plan skip_all => "$@"; -} -else { - plan tests => 76; -} +maybe_plan(76, 'SQL::Translator::Parser::Oracle'); +SQL::Translator::Parser::Oracle->import('parse'); my $t = SQL::Translator->new( trace => 0 ); my $sql = q[ @@ -56,10 +49,11 @@ my $sql = q[ start_position NUMBER(11,2) NOT NULL, stop_position NUMBER(11,2) NOT NULL, comments long, - UNIQUE ( qtl_accession_id ), FOREIGN KEY ( qtl_trait_id ) REFERENCES qtl_trait ); + CREATE UNIQUE INDEX qtl_accession ON qtl ( qtl_accession_id ); + CREATE TABLE qtl_trait_synonym ( qtl_trait_synonym_id NUMBER(11) NOT NULL