view release on metacpan or  search on metacpan

nls/export-js.pl  view on Meta::CPAN

#!/usr/bin/perl
use DBIx::Connector;
use Encode;
use JSON;
use Data::Dumper;

my $dbuser = ((getpwuid $>)[0]);
my $dbname = $dbuser;
my $dbpass = "";
my $conn;
my $fname;
my $lang;

for (my $i = 0; $i < @ARGV; ++$i) {
	if ($ARGV[$i] =~ /^-\S/) {
		$ARGV[$i] =~ /^-dbname/ && do {
			$dbname = $ARGV[$i + 1];
			++$i;
		};
		$ARGV[$i] =~ /^-dbuser/ && do {
			$dbuser = $ARGV[$i + 1];
			++$i;
		};
		$ARGV[$i] =~ /^-dbpass/ && do {
			$dbpass = $ARGV[$i + 1];
			++$i;
		};
		$ARGV[$i] =~ /^-lang/ && do {
			$lang = $ARGV[$i + 1];
			++$i;
		};
	} else {
		$fname = $ARGV[$i];
	}
}

if (!$lang && $fname) {
	($lang) = $fname =~ /[^a-z]([a-z]{2})\./i;
	$lang = lc $lang if $lang;
}

die <<USAGE if not $fname or not $lang;
export-js.pl [options] filename
  -dbname  full dsn or PostreSQL db name
  -dbuser  db user
  -dbpass  db password
  -lang    short lang code (ISO 639-1:2002) or language name
USAGE

sub db_connect {
	$dbname = "dbi:Pg:dbname=$dbname" if $dbname !~ /^dbi:/;
	my ($driver) = $dbname =~ /^dbi:([^:]+):/;
	my $attrs = {
		AutoCommit          => 1,
		PrintError          => 0,
		AutoInactiveDestroy => 1,
		RaiseError          => 1,
	};
	$attrs->{pg_enable_utf8}    = 1 if $driver eq 'Pg';
	$attrs->{mysql_enable_utf8} = 1 if $driver eq 'mysql';
	$conn = DBIx::Connector->new($dbname, $dbuser, $dbpass, $attrs)
		or die "SQL_connect: " . DBI->errstr();
	$conn->mode('fixup');
	$conn;
}

sub _quote_var {