Re^3: Dancer + SQL::Translator

It is the double bracketed values in the timestamp definition.

CREATE TABLE "ACCOUNT" (
  "ACCOUNT_ID" number(38) NOT NULL,
  "DATE_TIME_UTC" timestamp(6)(11),
  "CURRENCY_ID" number(38) NOT NULL,
  "NAME" varchar2(128) NOT NULL,
  "BALANCE" number(14) NOT NULL,
  "ACCOUNT_TYPE_ID" number(38) NOT NULL,
  "CREATED_BY_USER" varchar2(128),
  "CREATED_DATE_TIME_UTC" timestamp(6)(11),
  "MODIFIED_BY_USER" varchar2(128),
  "MODIFIED_DATE_TIME_UTC" timestamp(6)(11)
);
[download]

When the table was originally created those columns were only timestamps with no precision.

Comment on Re^3: Dancer + SQL::Translator Download Code

Replies are listed 'Best First'.
Re^4: Dancer + SQL::Translator by mje (Curate) on Mar 28, 2012 at 16:18 UTC
I spoke to one of the maintainers of SQL::Translator and after a suggestion from him I arrived at the following which avoids the problem above: `my $translator = SQL::Translator->new( from => 'DBI', to => 'GraphViz', parser_args => { dsn => "dbi:Oracle:xxx", db_user => 'xxx', db_password => 'xxx', producer_args => { output_type => 'png', out_file => 'out.png', natural_join => 1, width => 30.0, height => 30.0, #fontsize => 10 }, }, ); my $sql = $translator->translate( data => '');` [download] unfortunately our schema is quite large and the above produces a png which although looks like it might be correct is unreadable - everything is too small. The png output is limited in size apparently. I tried generating a postscript file as well but I don't seem to be able to produce one of those - nothing is output. Maybe I don't have whatever GraphViz needs to generate postscript.	[reply] [d/l]

Replies are listed 'Best First'.

Re^4: Dancer + SQL::Translator
by mje (Curate) on Mar 28, 2012 at 16:18 UTC

I spoke to one of the maintainers of SQL::Translator and after a suggestion from him I arrived at the following which avoids the problem above:

my $translator = SQL::Translator->new(
    from        => 'DBI',
    to          => 'GraphViz',
    parser_args => {
        dsn         => "dbi:Oracle:xxx",
        db_user     => 'xxx',
        db_password => 'xxx',
        producer_args => {
            output_type   => 'png',
            out_file => 'out.png',
            natural_join  => 1,
            width => 30.0,
            height => 30.0,
            #fontsize => 10
        },
    },
   );
my $sql = $translator->translate( data => '');
[download]

unfortunately our schema is quite large and the above produces a png which although looks like it might be correct is unreadable - everything is too small. The png output is limited in size apparently. I tried generating a postscript file as well but I don't seem to be able to produce one of those - nothing is output. Maybe I don't have whatever GraphViz needs to generate postscript.

[reply]
[d/l]