Re: autogenerating has_a and has_many from foreign keys

[prev] [thread] [next] [Date index for 2004/12/13]

>>>>> "Jason" == Jason Gessner <jason@xxxxxxxx.xxx> writes:

Jason> Perhaps this could be worked into the SQL::Translator (SQL Fairy)
Jason> stuff as well.  It looks like that project will generate relationships
Jason> based on field names, but it doesn't say if it will actually query for
Jason> foreign key relationships.

Jason> Aside from a rather disturbing logo, the SQL::Translator project seems nice.

Jason> http://sqlfairy.sourceforge.net/

SQL::Translator is broken with respect to Pg... and has been for a
long time.  I've just been ignoring it rather than sending patches
though.  Maybe my mistake.

Also, SQL::Translator doesn't understand the fetching of foreign key
info directly from the database.  You have to "parse" the schema
dump (yuck), which it also doesn't do right for Pg. :)

        -- 
        Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@xxxxxxxxxx.xxx> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!