X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FProducer%2FYAML.pm;h=5287e24a7f9739f19ad52135a205ee3301bcb028;hb=25a2e5c63b2aa571529742c91931e2bf03244b0a;hp=74fbece520caaa2c087c1b4f30ff5407d82abc20;hpb=c16f976a33b15350f4e6739388ac9701f7f5fa8c;p=dbsrgits%2FSQL-Translator.git diff --git a/lib/SQL/Translator/Producer/YAML.pm b/lib/SQL/Translator/Producer/YAML.pm index 74fbece..5287e24 100644 --- a/lib/SQL/Translator/Producer/YAML.pm +++ b/lib/SQL/Translator/Producer/YAML.pm @@ -1,10 +1,9 @@ package SQL::Translator::Producer::YAML; # ------------------------------------------------------------------- -# $Id: YAML.pm,v 1.6 2003-10-17 19:48:38 dlc Exp $ +# $Id: YAML.pm,v 1.9 2004-03-09 19:19:49 kycl4rk Exp $ # ------------------------------------------------------------------- -# Copyright (C) 2003 darren chamberlain , -# Ken Y. Clark . +# Copyright (C) 2002-4 SQLFairy Authors # # This program is free software; you can redistribute it and/or # modify it under the terms of the GNU General Public License as @@ -42,7 +41,7 @@ takes a long time. use strict; use vars qw($VERSION); -$VERSION = sprintf "%d.%02d", q$Revision: 1.6 $ =~ /(\d+)\.(\d+)/; +$VERSION = sprintf "%d.%02d", q$Revision: 1.9 $ =~ /(\d+)\.(\d+)/; use YAML qw(Dump); @@ -69,6 +68,18 @@ sub produce { map { ($_->name => view_procedure($_)) } $schema->get_procedures, }, + }, + translator => { + add_drop_table => $translator->add_drop_table, + filename => $translator->filename, + no_comments => $translator->no_comments, + parser_args => $translator->parser_args, + producer_args => $translator->producer_args, + parser_type => $translator->parser_type, + producer_type => $translator->producer_type, + show_warnings => $translator->show_warnings, + trace => $translator->trace, + version => $translator->version, } }); } @@ -78,15 +89,17 @@ sub view_table { my $table = shift; return { - 'name' => $table->name, - 'order' => $table->order, - 'options' => $table->options || [], - 'comments' => $table->comments || '', - 'indices' => { - map { ($_->name => view_index($_)) } - $table->get_indices - }, - 'fields' => { + 'name' => $table->name, + 'order' => $table->order, + 'options' => $table->options || [], + 'comments' => $table->comments || '', + 'constraints' => [ + map { view_constraint($_) } $table->get_constraints + ], + 'indices' => [ + map { view_index($_) } $table->get_indices + ], + 'fields' => { map { ($_->name => view_field($_)) } $table->get_fields }, @@ -94,6 +107,25 @@ sub view_table { } # ------------------------------------------------------------------- +sub view_constraint { + my $constraint = shift; + + return { + 'deferrable' => scalar $constraint->deferrable, + 'expression' => scalar $constraint->expression, + 'fields' => scalar $constraint->fields, + 'match_type' => scalar $constraint->match_type, + 'name' => scalar $constraint->name, + 'options' => scalar $constraint->options, + 'on_delete' => scalar $constraint->on_delete, + 'on_update' => scalar $constraint->on_update, + 'reference_fields' => scalar $constraint->reference_fields, + 'reference_table' => scalar $constraint->reference_table, + 'type' => scalar $constraint->type, + }; +} + +# ------------------------------------------------------------------- sub view_field { my $field = shift;