Reduce $Id to its normal form

[dbsrgits/SQL-Translator.git] / t / 08postgres-to-mysql.t

diff --git a/t/08postgres-to-mysql.t b/t/08postgres-to-mysql.t
index d7f6d2c..775bae8 100644 (file)
--- a/t/08postgres-to-mysql.t
+++ b/t/08postgres-to-mysql.t
@@ -2,9 +2,16 @@
 # vim: set ft=perl:
 
 use strict;
-use Test::More 'no_plan'; # tests => 1;
+use Test::More;
 use SQL::Translator;
 use Data::Dumper;
+use Test::SQL::Translator qw(maybe_plan);
+
+BEGIN {
+    maybe_plan(1, 
+        'SQL::Translator::Parser::MySQL',
+        'SQL::Translator::Producer::PostgreSQL');
+}
 
 my $create = q|
 
@@ -45,6 +52,21 @@ create index cvterm_idx1 on cvterm (cv_id);
 -- unique within a given cv
 
 
+COMMENT ON TABLE cvterm IS
+ 'A term, class or concept within an ontology
+  or controlled vocabulary';
+COMMENT ON COLUMN cvterm.cv_id IS
+ 'The cv/ontology/namespace to which this cvterm belongs';
+COMMENT ON COLUMN cvterm.name IS
+ 'A concise human-readable name describing the meaning of the cvterm';
+COMMENT ON COLUMN cvterm.termdefinition IS
+ 'A human-readable text definition';
+COMMENT ON COLUMN cvterm.dbxref_id IS
+ 'A human-readable text definition';
+COMMENT ON INDEX cvterm_c1 IS 
+ 'the OBO identifier is globally unique';
+
+
 -- ================================================
 -- TABLE: cvrelationship
 -- ================================================
@@ -131,4 +153,4 @@ my $tr = SQL::Translator->new(
     producer => "MySQL"
 );
 
-ok( $tr->translate(\$create), 'Translate PG2My' );
+ok( $tr->translate(\$create), 'Translate PG2My' ) or diag($tr->error);