X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F18ttschema-producer.t;h=3118da8156b939cdaacbb871004d0a78f0cc8c03;hb=aee4b66eb2152b7066ced4def46e0223eb1649b1;hp=909a01511d0a96f7cd84bfc55c40a73dea723c90;hpb=bdf60588bb1e35e284bdc02c43d0ffe691994465;p=dbsrgits%2FSQL-Translator.git diff --git a/t/18ttschema-producer.t b/t/18ttschema-producer.t index 909a015..3118da8 100644 --- a/t/18ttschema-producer.t +++ b/t/18ttschema-producer.t @@ -1,4 +1,4 @@ -#!/usr/bin/perl -w +#!/usr/bin/perl -w # vim:filetype=perl # Before `make install' is performed this script should be runnable with @@ -46,8 +46,11 @@ use SQL::Translator::Producer::TTSchema; my $out; lives_ok { $out = $obj->translate; } "Translate ran"; ok $out ne "" ,"Produced something!"; - local $/ = undef; # slurp - eq_or_diff $out, ,"Output looks right"; + eq_or_diff + $out, + do { local (@ARGV, $/) = "$Bin/data/template/testresult_basic.txt"; <> }, + "Output looks right" + ; } # Test passing of Template config @@ -82,254 +85,3 @@ use SQL::Translator::Producer::TTSchema; Table: Another} ,"Output looks right"; } - - -__DATA__ -Schema: -Database: - -Foo: bar -Hello: world - -Table: Basic -========================================================================== - -Fields - id - data_type: int - size: 10 - is_nullable: 0 - default_value: - is_primary_key: 1 - is_unique: 0 - is_auto_increment: 1 - is_foreign_key: 0 - foreign_key_reference: - is_valid: 1 - order: 1 - table: Basic - - title - data_type: varchar - size: 100 - is_nullable: 0 - default_value: hello - is_primary_key: 0 - is_unique: 1 - is_auto_increment: 0 - is_foreign_key: 0 - foreign_key_reference: - is_valid: 1 - order: 2 - table: Basic - - description - data_type: text - size: 0 - is_nullable: 1 - default_value: - is_primary_key: 0 - is_unique: 0 - is_auto_increment: 0 - is_foreign_key: 0 - foreign_key_reference: - is_valid: 1 - order: 3 - table: Basic - - email - data_type: varchar - size: 500 - is_nullable: 1 - default_value: - is_primary_key: 0 - is_unique: 1 - is_auto_increment: 0 - is_foreign_key: 0 - foreign_key_reference: - is_valid: 1 - order: 4 - table: Basic - - explicitnulldef - data_type: varchar - size: 0 - is_nullable: 1 - default_value: - is_primary_key: 0 - is_unique: 0 - is_auto_increment: 0 - is_foreign_key: 0 - foreign_key_reference: - is_valid: 1 - order: 5 - table: Basic - - explicitemptystring - data_type: varchar - size: 0 - is_nullable: 1 - default_value: - is_primary_key: 0 - is_unique: 0 - is_auto_increment: 0 - is_foreign_key: 0 - foreign_key_reference: - is_valid: 1 - order: 6 - table: Basic - - emptytagdef - data_type: varchar - size: 0 - is_nullable: 1 - default_value: - is_primary_key: 0 - is_unique: 0 - is_auto_increment: 0 - is_foreign_key: 0 - foreign_key_reference: - is_valid: 1 - order: 7 - table: Basic - - another_id - data_type: int - size: 10 - is_nullable: 1 - default_value: 2 - is_primary_key: 0 - is_unique: 0 - is_auto_increment: 0 - is_foreign_key: 1 - foreign_key_reference: Another - is_valid: 1 - order: 8 - table: Basic - - timest - data_type: timestamp - size: 0 - is_nullable: 1 - default_value: - is_primary_key: 0 - is_unique: 0 - is_auto_increment: 0 - is_foreign_key: 0 - foreign_key_reference: - is_valid: 1 - order: 9 - table: Basic - - -Indices - titleindex - table: Basic - fields: title - type: NORMAL - options: - is_valid: 1 - - -Constraints - ? - type: PRIMARY KEY - fields: id - expression: - match_type: - reference_fields: - reference_table: - deferrable: 1 - on_delete: - on_update: - options: - is_valid: 1 - - emailuniqueindex - type: UNIQUE - fields: email - expression: - match_type: - reference_fields: - reference_table: - deferrable: 1 - on_delete: - on_update: - options: - is_valid: 1 - - very_long_index_name_on_title_field_which_should_be_truncated_for_various_rdbms - type: UNIQUE - fields: title - expression: - match_type: - reference_fields: - reference_table: - deferrable: 1 - on_delete: - on_update: - options: - is_valid: 1 - - ? - type: FOREIGN KEY - fields: another_id - expression: - match_type: - reference_fields: id - reference_table: Another - deferrable: 1 - on_delete: - on_update: - options: - is_valid: 1 - -Table: Another -========================================================================== - -Fields - id - data_type: int - size: 10 - is_nullable: 0 - default_value: - is_primary_key: 1 - is_unique: 0 - is_auto_increment: 1 - is_foreign_key: 0 - foreign_key_reference: - is_valid: 1 - order: 1 - table: Another - - num - data_type: numeric - size: 10,2 - is_nullable: 1 - default_value: - is_primary_key: 0 - is_unique: 0 - is_auto_increment: 0 - is_foreign_key: 0 - foreign_key_reference: - is_valid: 1 - order: 2 - table: Another - - -Indices - -Constraints - ? - type: PRIMARY KEY - fields: id - expression: - match_type: - reference_fields: - reference_table: - deferrable: 1 - on_delete: - on_update: - options: - is_valid: 1 -