#!/usr/bin/perl
use Text::CSV;
use Text::CSV::SQLhelper;
use strict;
use warnings;
use Getopt::Std;
$Getopt::Std::STANDARD_HELP_VERSION = 1;
#version function
sub main::VERSION_MESSAGE {
print "text-csv-sqlhelper 0.0.0\n";
}
#print help
sub main::HELP_MESSAGE {
print "\n".
"-f <file>\n".
"-e <eol>\n".
"-s <sep_char>\n".
"-q <quote_char>\n".
"-b <blank_is_undef>\n".
"-w <allow_whitespace>\n".
"-l <allow_loose_quotes>\n".
"-E <escape_char>\n".
"-L <allow_loose_escapes>\n".
"-a <always_quote>\n".
"-Q <quote_space>\n".
"-n <quote_null>\n".
"-p <print type>\n";
}
my %opts=();
getopts('f:e:s:q:b:w:l:E:L:a:Q:n:p:', \%opts);
#the hash that will be passed to Text::CSV
my %newValues=(
quote_char => '"',
escape_char => '"',
sep_char => ',',
eol => $\,
always_quote => 0,
quote_space => 1,
quote_null => 1,
binary => 0,
keep_meta_info => 0,
allow_loose_quotes => 0,
allow_loose_escapes => 0,
allow_whitespace => 0,
blank_is_undef => 0,
empty_is_undef => 0,
verbatim => 0,
auto_diag => 0,
);
#sets the defaults
if (defined($opts{e})) {
$newValues{eol}=$opts{e};
}
if (defined($opts{s})) {
$newValues{sep_char}=$opts{s};
}
if (defined($opts{q})) {
$newValues{quote_char}=$opts{q};
}
if (defined($opts{b})) {
$newValues{blank_is_undef}=$opts{b};
}
if (defined($opts{w})) {
$newValues{allow_whitespace}=$opts{w};
}
if (defined($opts{l})) {
$newValues{allow_loose_quotes}=$opts{l};
}
if (defined($opts{E})) {
$newValues{escape_char}=$opts{E};
}
if (defined($opts{L})) {
$newValues{allow_loose_escapes}=$opts{L};
}
if (defined($opts{a})) {
$newValues{always_quote}=$opts{a};
}
if (defined($opts{Q})) {
$newValues{quote_space}=$opts{Q};
}
if (defined($opts{n})) {
$newValues{quote_null}=$opts{n};
}
#sets up Text::CSV
my $csv=Text::CSV->new(\%newValues);
#setups the helper
my $helper=Text::CSV::SQLhelper->new({csv=>$csv});
#exit with the error code
if ($helper->error) {
exit $helper->error;
}
my @columns=$helper->processFile($opts{f});
my $int=0;
#SQL variable type print
if ((!defined($opts{p})) || ($opts{p} eq 'sql')) {
while (defined($columns[$int])) {
print $columns[$int]->{sql};
if (defined($columns[++$int ])) {
print ", ";
}
}
print "\n";
exit 0;
}
#use Dumper to print it
if ($opts{p} eq 'dump') {
use Data::Dumper;
print Dumper(\@columns);
exit 0;
}
#generic print
if ($opts{p} eq 'print') {
while (defined($columns[$int])) {
print $int.":sql:".$columns[$int]->{sql}."\n".
$int.":allownull:".$columns[$int]->{allownull}."\n".
$int.":max:".$columns[$int]->{max}."\n".
$int.":min:".$columns[$int]->{min}."\n".
$int.":type:".$columns[$int]->{type}."\n";
$int++;
}
exit 0;
}
=head1 NAME
text-csv-sqlhelper - List tables available for a data sources.
=head1 SYNOPSIS
text-csv-sqlhelper B<-f> <file> [B<-e <eol> [B<-s> <sep_char>] [B<-q> <quote_char>] [B<-b> <blank_is_undef>] [B<-w> <allow_whitespace>] [B<-l> <allow_loose_quotes>] [B<-E> <escape_char>] [B<-L> <allow_loose_escapes>] [B<-a> <always_quote>] [B<-Q> <quote_space>] [B<-n> <quote_null>] [B<-p> <print type>]
=head1 SWTICHES
=head2 -f <file>
The file to read.
=head2 -e <eol>
See the new section for "Text::SQL".
=head2 -s <sep_char>
See the new section for "Text::SQL".
=head2 -q <quote_char>
See the new section for "Text::SQL".
=head2 -b <blank_is_undef>
See the new section for "Text::SQL".
=head2 -w <allow_whitespace>
See the new section for "Text::SQL".
=head2 -l <allow_loose_quotes>
See the new section for "Text::SQL".
=head2 -E <escape_char>
See the new section for "Text::SQL".
=head2 -L <allow_loose_escapes>
See the new section for "Text::SQL".
=head2 -a <always_quote>
See the new section for "Text::SQL".
=head2 -Q <quote_space>
See the new section for "Text::SQL".
=head2 -n <quote_null>
See the new section for "Text::SQL".
=head2 -p <print type>
Print the data using one of the specified print types.
If none is specified, "sql" is used.
=head3 sql
Prints them the SQL variable information on a single line seperated by ", ".
=head3 dump
Prints the returned columns array via Data::Dumper;
=head3 print
Prints each every variable for each column in the form "$column:$variable:$value".
=head1 EXIT CODES
Any non-zero exit codes are the error codes returned by "Text::CSV::SQLhelper".
=head1 AUTHOR
Copyright (c) 2010, Zame C. Bowers <vvelox@vvelox.net>
All rights reserved.
Redistribution and use in source and binary forms, with or without
modification, are permitted provided that the following conditions are met:
* Redistributions of source code must retain the above copyright notice,
this list of conditions and the following disclaimer.
* Redistributions in binary form must reproduce the above copyright
notice, this list of conditions and the following disclaimer in the
documentation and/or other materials provided with the distribution.
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE
FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS` OR
SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF
THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
=head1 Changelog
=head2 2010-04-01/07:30 0.0.0
Initial release.
=cut