Scott,
This works for me. I've been on OS X for years and have developed
SQLT on it no problem. I used "sqlfairy/t/data/pgsql/turnkey.sql" for
my test data. I had to comment out the skip_tables stuff, of course.
Does it work for you if you comment that out, too?
BTW, I added a "--skip-tables" option to "sqlt-graph" since I needed
that for a project. Want me to add this to "sqlt-diagram," too? I
think that would be easier than the script you've written here.
ky
On Aug 19, 2009, at 9:21 AM, Scott Cain wrote:
> Hello,
>
> I recently switched from Linux to Mac OS X as my main development
> machine, and I'm having some problems getting sqlfairy running. I'm
> guessing it's due to both my forgetting what I did on the Linux side
> years ago to set it up, as well as my lack of familiarity with the Mac
> OS. I installed sqlfairy 0.10 from the cpan shell.
>
> So, the problem I'm having is that the producers aren't producing
> anything, but aren't giving me any feedback in the form of warnings or
> errors. Below is a simple script I use to generate diagrams from
> input sql files. If I set $SQL::Translator::DEBUG to 1, I get some
> feedback, including a dumpout of the entire schema, so I know that
> sqlfairy is at least reading and parsing the sql file. It just stops
> after that.
>
> I know that libgd is installed and working correctly (I use it for
> another app). I also installed GraphViz (from a pkg file) and
> GraphViz.pm (from cpan). The html producer doesn't do anything
> either.
>
> Does anybody have debugging suggestions?
>
> Thanks,
> Scott
>
> Here's the script:
>
> #!/usr/bin/perl
>
> use SQL::Translator;
> use Data::Dumper;
> use lib './bin';
> use Skip_tables qw( @skip_tables );
>
> $SQL::Translator::DEBUG = 0;
>
> my $in = shift;
> open(IN,$in) || die "couldn't open $in: $!";
>
> my @create = <IN>;
> my $create = join '', @create;
>
> my $tr = SQL::Translator->new(
> parser => "PostgreSQL",
> producer => "Diagram",
> producer_args => {add_color=>1},
> filters => [
> sub {
> my $schema = shift;
> foreach (@skip_tables) {
> $schema->drop_table($_);
> }
> },
> ],
>
> );
>
> print $tr->translate(\$create);
>
> -----------------------------------------------------------------------
> Scott Cain, Ph. D. scott at scottcain dot net
> GMOD Coordinator (http://gmod.org/) 216-392-3087
> Ontario Institute for Cancer Research
>
>
>
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008
> 30-Day
> trial. Simplify your report design, integration and deployment - and
> focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now. http://p.sf.net/sfu/bobj-july
> --
> sqlfairy-developers mailing list
> sqlfairy-developers@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
--
sqlfairy-developers mailing list
sqlfairy-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
