X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FProducer%2FYAML.pm;h=782ddb125dcb2cbb157deef5705e5dc0997ef38a;hb=55fa814722ea1e01872298e62783896dae1996b6;hp=d58abed431c9cec09e23084e2de1786bcfc6312c;hpb=977651a56d55fa4b2aacb19977667abd7f241c9a;p=dbsrgits%2FSQL-Translator.git diff --git a/lib/SQL/Translator/Producer/YAML.pm b/lib/SQL/Translator/Producer/YAML.pm index d58abed..782ddb1 100644 --- a/lib/SQL/Translator/Producer/YAML.pm +++ b/lib/SQL/Translator/Producer/YAML.pm @@ -1,25 +1,5 @@ package SQL::Translator::Producer::YAML; -# ------------------------------------------------------------------- -# $Id: YAML.pm,v 1.8 2004-02-09 23:02:17 kycl4rk Exp $ -# ------------------------------------------------------------------- -# 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 -# published by the Free Software Foundation; version 2. -# -# This program is distributed in the hope that it will be useful, but -# WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU -# General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program; if not, write to the Free Software -# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA -# 02111-1307 USA -# ------------------------------------------------------------------- - =head1 NAME SQL::Translator::Producer::YAML - A YAML producer for SQL::Translator @@ -40,39 +20,50 @@ takes a long time. =cut use strict; -use vars qw($VERSION); -$VERSION = sprintf "%d.%02d", q$Revision: 1.8 $ =~ /(\d+)\.(\d+)/; +use warnings; +our $VERSION = '1.60'; use YAML qw(Dump); -# ------------------------------------------------------------------- sub produce { - my $translator = shift; - my $schema = $translator->schema; + my $translator = shift; + my $schema = $translator->schema; return Dump({ schema => { - tables => { + tables => { map { ($_->name => view_table($_)) } $schema->get_tables, }, - views => { + views => { map { ($_->name => view_view($_)) } $schema->get_views, }, - triggers => { + triggers => { map { ($_->name => view_trigger($_)) } $schema->get_triggers, }, - procedures => { - map { ($_->name => view_procedure($_)) } + procedures => { + 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, + }, + keys %{$schema->extra} ? ('extra' => { $schema->extra } ) : (), }); } -# ------------------------------------------------------------------- sub view_table { my $table = shift; @@ -80,57 +71,58 @@ sub view_table { 'name' => $table->name, 'order' => $table->order, 'options' => $table->options || [], - 'comments' => $table->comments || '', + $table->comments ? ('comments' => [ $table->comments ] ) : (), 'constraints' => [ map { view_constraint($_) } $table->get_constraints ], 'indices' => [ map { view_index($_) } $table->get_indices ], - 'fields' => { + 'fields' => { map { ($_->name => view_field($_)) } - $table->get_fields + $table->get_fields }, + keys %{$table->extra} ? ('extra' => { $table->extra } ) : (), }; } -# ------------------------------------------------------------------- sub view_constraint { my $constraint = shift; return { 'deferrable' => scalar $constraint->deferrable, 'expression' => scalar $constraint->expression, - 'fields' => scalar $constraint->fields, + 'fields' => [ map { ref $_ ? $_->name : $_ } $constraint->field_names ], '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_fields' => [ map { ref $_ ? $_->name : $_ } $constraint->reference_fields ], 'reference_table' => scalar $constraint->reference_table, 'type' => scalar $constraint->type, + keys %{$constraint->extra} ? ('extra' => { $constraint->extra } ) : (), }; } -# ------------------------------------------------------------------- sub view_field { my $field = shift; return { - 'order' => scalar $field->order, - 'name' => scalar $field->name, - 'data_type' => scalar $field->data_type, - 'size' => [ $field->size ], - 'default_value' => scalar $field->default_value, - 'is_nullable' => scalar $field->is_nullable, - 'is_primary_key' => scalar $field->is_primary_key, - 'is_unique' => scalar $field->is_unique, - 'extra' => { $field->extra }, + 'order' => scalar $field->order, + 'name' => scalar $field->name, + 'data_type' => scalar $field->data_type, + 'size' => [ $field->size ], + 'default_value' => scalar $field->default_value, + 'is_nullable' => scalar $field->is_nullable, + 'is_primary_key' => scalar $field->is_primary_key, + 'is_unique' => scalar $field->is_unique, + $field->is_auto_increment ? ('is_auto_increment' => 1) : (), + $field->comments ? ('comments' => [ $field->comments ]) : (), + keys %{$field->extra} ? ('extra' => { $field->extra } ) : (), }; } -# ------------------------------------------------------------------- sub view_procedure { my $procedure = shift; @@ -141,10 +133,10 @@ sub view_procedure { 'parameters' => scalar $procedure->parameters, 'owner' => scalar $procedure->owner, 'comments' => scalar $procedure->comments, + keys %{$procedure->extra} ? ('extra' => { $procedure->extra } ) : (), }; } -# ------------------------------------------------------------------- sub view_trigger { my $trigger = shift; @@ -152,14 +144,17 @@ sub view_trigger { 'order' => scalar $trigger->order, 'name' => scalar $trigger->name, 'perform_action_when' => scalar $trigger->perform_action_when, - 'database_event' => scalar $trigger->database_event, + 'database_events' => scalar $trigger->database_events, 'fields' => scalar $trigger->fields, 'on_table' => scalar $trigger->on_table, 'action' => scalar $trigger->action, + (defined $trigger->scope ? ( + 'scope' => scalar $trigger->scope, + ) : ()), + keys %{$trigger->extra} ? ('extra' => { $trigger->extra } ) : (), }; } -# ------------------------------------------------------------------- sub view_view { my $view = shift; @@ -168,10 +163,10 @@ sub view_view { 'name' => scalar $view->name, 'sql' => scalar $view->sql, 'fields' => scalar $view->fields, + keys %{$view->extra} ? ('extra' => { $view->extra } ) : (), }; } -# ------------------------------------------------------------------- sub view_index { my $index = shift; @@ -180,13 +175,12 @@ sub view_index { 'type' => scalar $index->type, 'fields' => scalar $index->fields, 'options' => scalar $index->options, + keys %{$index->extra} ? ('extra' => { $index->extra } ) : (), }; } 1; -# ------------------------------------------------------------------- - =head1 SEE ALSO SQL::Translator, YAML, http://www.yaml.org/. @@ -194,6 +188,6 @@ SQL::Translator, YAML, http://www.yaml.org/. =head1 AUTHORS darren chamberlain Edarren@cpan.orgE, -Ken Y. Clark Ekclark@cpan.orgE. +Ken Youens-Clark Ekclark@cpan.orgE. =cut