X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FSQL%2FTranslator%2FProducer%2FClassDBI.pm;h=7e682940df60bc19c451a9006d1708786b9f518f;hb=282bf498899061be19ec7fd7ce16bf25a562fdcf;hp=42f02b3c18e8ce56fc0d7191fcd3811c8758b307;hpb=b03926cdac036bdbcf69e478ca29e1121c814646;p=dbsrgits%2FSQL-Translator.git diff --git a/lib/SQL/Translator/Producer/ClassDBI.pm b/lib/SQL/Translator/Producer/ClassDBI.pm old mode 100755 new mode 100644 index 42f02b3..7e68294 --- a/lib/SQL/Translator/Producer/ClassDBI.pm +++ b/lib/SQL/Translator/Producer/ClassDBI.pm @@ -20,7 +20,7 @@ package SQL::Translator::Producer::ClassDBI; use strict; use vars qw[ $VERSION $DEBUG ]; -$VERSION = '1.99'; +$VERSION = '1.59'; $DEBUG = 1 unless defined $DEBUG; use SQL::Translator::Schema::Constants; @@ -33,20 +33,22 @@ my %CDBI_auto_pkgs = ( Oracle => 'Oracle', ); -# ------------------------------------------------------------------- sub produce { - my $t = shift; - my $create = undef; - local $DEBUG = $t->debug; + my $t = shift; + local $DEBUG = $t->debug; my $no_comments = $t->no_comments; my $schema = $t->schema; my $args = $t->producer_args; + my @create; + if ( my $fmt = $args->{'format_pkg_name'} ) { $t->format_package_name( $fmt ); } + if ( my $fmt = $args->{'format_fk_name'} ) { $t->format_fk_name( $fmt ); } + my $db_user = $args->{'db_user'} || ''; my $db_pass = $args->{'db_password'} || ''; my $main_pkg_name = $args->{'package_name'} || @@ -55,9 +57,9 @@ sub produce { my $header = header_comment( __PACKAGE__, "# " ); my $parser_type = ( split /::/, $t->parser_type )[-1]; my $from = $CDBI_auto_pkgs{$parser_type} || ''; - my $dsn = $args->{'dsn'} || sprintf( 'dbi:%s:_', - $CDBI_auto_pkgs{ $parser_type } - ? $CDBI_auto_pkgs{ $parser_type } : $parser_type + my $dsn = $args->{'dsn'} || sprintf( 'dbi:%s:_', + $CDBI_auto_pkgs{ $parser_type } + ? $CDBI_auto_pkgs{ $parser_type } : $parser_type ); my $sep = '# ' . '-' x 67; @@ -177,11 +179,11 @@ sub produce { { next unless $field->is_foreign_key; - next unless ( + next unless ( $field->foreign_key_reference->reference_table eq $table_name - || - $field->foreign_key_reference->reference_table eq $link + || + $field->foreign_key_reference->reference_table eq $link ); push @lk_fields, @@ -270,7 +272,7 @@ sub produce { my $table_name = $table->name; my $field_name = $field->name; # my $fk_method = $t->format_fk_name( $table_name, $field_name ); - my $fk_method = join('::', $table_pkg_name, + my $fk_method = join('::', $table_pkg_name, $t->format_fk_name( $table_name, $field_name ) ); my $fk = $field->foreign_key_reference; @@ -316,7 +318,7 @@ sub produce { # Now build up text of package. # my $base_pkg = sprintf( 'Class::DBI%s', $from ? "::$from" : '' ); - $create .= join ( "\n", + push @create, join ( "\n", "package $main_pkg_name;\n", $header, "use strict;", @@ -331,7 +333,7 @@ sub produce { my $pkg = $packages{$pkg_name} or next; next unless $pkg->{'pkg_name'}; - $create .= join ( "\n", + push @create, join ( "\n", $sep, "package " . $pkg->{'pkg_name'} . ";", "use base '" . $pkg->{'base'} . "';", @@ -339,46 +341,50 @@ sub produce { ); if ( $from ) { - $create .= - $pkg->{'pkg_name'}."->set_up_table('".$pkg->{'table'}."');\n\n"; + push @create, join('', + $pkg->{'pkg_name'}, + "->set_up_table('", + $pkg->{'table'}, + "');\n\n" + ); } else { my $table = $schema->get_table( $pkg->{'table'} ); my @field_names = map { $_->name } $table->get_fields; - - $create .= join("\n", + + push @create, join("\n", $pkg_name."->table('".$pkg->{'table'}."');\n", $pkg_name."->columns(All => qw/". join(' ', @field_names)."/);\n\n", ); } - $create .= "\n"; + push @create, "\n"; if ( my $pk = $pkg->{'pk_accessor'} ) { - $create .= $pk; + push @create, $pk; } if ( my @has_a = @{ $pkg->{'has_a'} || [] } ) { - $create .= $_ for @has_a; + push @create, $_ for @has_a; } foreach my $has_many_key ( keys %{ $pkg->{'has_many'} } ) { if ( my @has_many = @{ $pkg->{'has_many'}{$has_many_key} || [] } ) { - $create .= $_ for @has_many; + push @create, $_ for @has_many; } } } - $create .= "1;\n"; + push @create, "1;\n"; - return $create; + return wantarray + ? @create + : join('', @create); } 1; -# ------------------------------------------------------------------- - =pod =head1 NAME @@ -390,7 +396,7 @@ SQL::Translator::Producer::ClassDBI - create Class::DBI classes from schema Use this producer as you would any other from SQL::Translator. See L for details. -This package utilizes SQL::Translator's formatting methods +This package uses SQL::Translator's formatting methods format_package_name(), format_pk_name(), format_fk_name(), and format_table_name() as it creates classes, one per table in the schema provided. An additional base class is also created for database connectivity @@ -400,4 +406,4 @@ configuration. See L for details on how this works. Allen Day Eallenday@ucla.eduE, Ying Zhang Ezyolive@yahoo.comE, -Ken Y. Clark Ekclark@cpan.orgE. +Ken Youens-Clark Ekclark@cpan.orgE.