X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=bin%2Fsqlt;h=e4e278727b3bcdb0aec4ea03968cac97b0e29d43;hb=88a4375ca729ba65dc35271cc4f44a2f5ac5a1bb;hp=4a2de7ebc6167c8c6bda15c5db2e77619b24be05;hpb=e107f4d2408c80d2c82ea625082b4aa2a66414d0;p=dbsrgits%2FSQL-Translator.git

diff --git a/bin/sqlt b/bin/sqlt
index 4a2de7e..e4e2787 100755
--- a/bin/sqlt
+++ b/bin/sqlt
@@ -2,10 +2,9 @@
 # vim: set ft=perl:
 
 # -------------------------------------------------------------------
-# $Id: sqlt,v 1.4 2003-10-03 17:08:46 kycl4rk Exp $
+# $Id: sqlt,v 1.12 2004-02-06 17:48:16 kycl4rk Exp $
 # -------------------------------------------------------------------
-# Copyright (C) 2002 Ken Y. Clark <kclar@cpan.org>,
-#                    darren chamberlain <darren@cpan.org>
+# 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
@@ -113,7 +112,7 @@ use Pod::Usage;
 use SQL::Translator;
 
 use vars qw( $VERSION );
-$VERSION = sprintf "%d.%02d", q$Revision: 1.4 $ =~ /(\d+)\.(\d+)/;
+$VERSION = sprintf "%d.%02d", q$Revision: 1.12 $ =~ /(\d+)\.(\d+)/;
 
 my $from;             # the original database
 my $to;               # the destination database 
@@ -145,7 +144,7 @@ GetOptions(
     'add-drop-table'  => \$add_drop_table,
     'attrib-values'   => \$attrib_values,
     'd|debug'         => \$debug,
-    'emit_empty_tags' => \$emit_empty_tags,
+    'emit-empty-tags' => \$emit_empty_tags,
     'f|from|parser:s' => \$from,
     'fs:s'            => \$field_separator,
     'h|help'          => \$help,
@@ -169,6 +168,14 @@ GetOptions(
 ) or pod2usage(2);
 
 my @files = @ARGV; # source files
+unless ( @files ) {
+    if ( defined($from) && $from eq 'DBI' ) {
+        @files = ('!');
+    }
+    else {
+        @files = ('-');
+    }
+}
 
 pod2usage(1) if $help;
 
@@ -215,14 +222,21 @@ if ( $list ) {
     exit(0);
 }
 
-pod2usage(2) unless $from && $to && @files;
+pod2usage( msg => 'Please supply "from" and "to" arguments' ) 
+    unless $from && $to;
 
 $translator->parser($from);
 $translator->producer($to);
 
 for my $file (@files) {
-    my $output = $translator->translate(file => $file) or die
+    my @args = 
+        ($file eq '-') ? (data => \*STDIN) :
+        ($file eq '!') ? (data => '') :
+        (file => $file);
+
+    my $output = $translator->translate(@args) or die
         "Error: " . $translator->error;
+
     print $output;
 }
 
@@ -235,11 +249,11 @@ for my $file (@files) {
 
 =head1 AUTHOR
 
-Ken Y. Clark E<lt>kclark@cpan.orgE<gt>.
+Ken Y. Clark E<lt>kclark@cpan.orgE<gt>,
+darren chamberlain E<lt>darren@cpan.orgE<gt>.
 
 =head1 SEE ALSO
 
-perl, SQL::Translator, Parse::RecDescent, 
-L<http://sqlfairy.sourceforge.net>.
+SQL::Translator, L<http://sqlfairy.sourceforge.net>.
 
 =cut