Hi Ken,
When trying to update SQLT from svn, I noticed that my version of
ParseRD is labeled too old. When I went to update that with the cpan
shell, it failed because one of the tests requires perl 5.10. Do you
know if this is a problem? Should I continue to use the old ParseRD
(1.94) or force the install of 1.962.2? Or build a new perl 5.10 from
source?
Thanks,
Scott
On Tue, Aug 25, 2009 at 4:01 PM, Ken Youens-Clark<kycl...@gmail.com> wrote:
> 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
>
>
--
------------------------------------------------------------------------
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
