adding callbacks to Translator.pm to allow mangling of PK/FK/table names/package...

[dbsrgits/SQL-Translator.git] / lib / SQL / Translator.pm

diff --git a/lib/SQL/Translator.pm b/lib/SQL/Translator.pm
index a0a5aa0..04d4596 100644 (file)
--- a/lib/SQL/Translator.pm
+++ b/lib/SQL/Translator.pm
@@ -1,7 +1,7 @@
 package SQL::Translator;
 
 # ----------------------------------------------------------------------
-# $Id: Translator.pm,v 1.19 2003-03-12 14:19:52 dlc Exp $
+# $Id: Translator.pm,v 1.22 2003-04-17 23:16:28 allenday Exp $
 # ----------------------------------------------------------------------
 # Copyright (C) 2003 Ken Y. Clark <kclark@cpan.org>,
 #                    darren chamberlain <darren@cpan.org>,
@@ -27,7 +27,7 @@ use vars qw( $VERSION $REVISION $DEFAULT_SUB $DEBUG $ERROR );
 use base 'Class::Base';
 
 $VERSION  = '0.01';
-$REVISION = sprintf "%d.%02d", q$Revision: 1.19 $ =~ /(\d+)\.(\d+)/;
+$REVISION = sprintf "%d.%02d", q$Revision: 1.22 $ =~ /(\d+)\.(\d+)/;
 $DEBUG    = 0 unless defined $DEBUG;
 $ERROR    = "";
 
@@ -70,6 +70,14 @@ sub init {
     $self->parser  ($config->{'parser'}   || $config->{'from'} || $DEFAULT_SUB);
     $self->producer($config->{'producer'} || $config->{'to'}   || $DEFAULT_SUB);
 
+       #
+       # Set up callbacks for formatting of pk,fk,table,package names in producer
+       #
+       $self->format_table_name($config->{'format_table_name'});
+       $self->format_package_name($config->{'format_package_name'});
+       $self->format_fk_name($config->{'format_fk_name'});
+       $self->format_pk_name($config->{'format_pk_name'});
+
     #
     # Set the parser_args and producer_args
     #
@@ -483,7 +491,7 @@ sub translate {
         $self->filename($filename);
     }
 
-    if (my $data = ($self->{'data'} || $self->{'datasource'})) {
+    if (my $data = ($args->{'data'} || $args->{'datasource'})) {
         $self->data($data);
     }
 
@@ -491,7 +499,7 @@ sub translate {
     # Get the data.
     # ----------------------------------------------------------------
     my $data = $self->data;
-    unless (length $$data) {
+    unless (ref($data) eq 'SCALAR' and length $$data) {
         return $self->error("Empty data file!");
     }
 
@@ -648,6 +656,38 @@ sub load {
     return 1;
 }
 
+sub format_table_name {
+  my $self = shift;
+  my $sub = shift;
+  $self->{_format_table_name} = $sub if ref($sub) eq 'CODE';
+  return $self->{_format_table_name}->($sub,@_) if defined($self->{_format_table_name});
+  return($sub);
+}
+
+sub format_package_name {
+  my $self = shift;
+  my $sub = shift;
+  $self->{_format_package_name} = $sub if ref($sub) eq 'CODE';
+  return $self->{_format_package_name}->($sub,@_) if defined($self->{_format_package_name});
+  return($sub);
+}
+
+sub format_fk_name {
+  my $self = shift;
+  my $sub = shift;
+  $self->{_format_fk_name} = $sub if ref($sub) eq 'CODE';
+  return $self->{_format_fk_name}->($sub,@_) if defined($self->{_format_fk_name});
+  return($sub);
+}
+
+sub format_pk_name {
+  my $self = shift;
+  my $sub = shift;
+  $self->{_format_pk_name} = $sub if ref($sub) eq 'CODE';
+  return $self->{_format_pk_name}->($sub,@_) if defined($self->{_format_pk_name});
+  return($sub);
+}
+
 # ----------------------------------------------------------------------
 # isa($ref, $type)
 #
@@ -681,6 +721,13 @@ SQL::Translator - convert schema from one database to another
       no_comments    => 0, # Don't include comments in output
       show_warnings  => 0, # Print name mutations, conflicts
       add_drop_table => 1, # Add "drop table" statements
+
+      #make all table names CAPS in producers which support this option
+      format_table_name => sub {my $tablename = shift; return uc($tablename)},
+      #null-op formatting, only here for documentation's sake
+      format_package_name => sub {return shift},
+      format_fk_name      => sub {return shift},
+      format_pk_name      => sub {return shift},
   );
 
   my $output     = $translator->translate(