Re: [cgiapp] C::A::Generator (was BOF Minutes)

[David Emery <suppressed>]

On Date: Thu, 30 Jun 2005 23:11:02 -0400, Jason Purdy <suppressed> wrote:
> - Generator - something that would help kickstart the application.  We 
> do have CGI::Application::Generator, but it could do with an update, 
> especially with creating test scripts at the same time.

I'm curious as to how many CAP users, like me, already have their own
homegrown Generator-like thangs. (A show of virtual hands, perhaps)

My own (I call it the CGIAppitizer) works pretty well for my own way
of doing things, but it would be a long road to making into something
useful to others.

For a general-use generator I think starting with SQLFairy aka
SQL::Translator could be a good way to go. Besides having the most
outrageous logo in the open source world, they've put some quality
time into the SQL parsing aspect. It seems to detect table
relationships well and will currently output Class::DBI classes
among other things.

http://sqlfairy.sourceforge.net/
http://search.cpan.org/~kclark/SQL-Translator-0.07/lib/SQL/Translator.pm

Here's a relevant snippet from the manual:
Given that so many applications interact with SQL databases, it's no
wonder that people have automated code to deal with this
interaction. Class::DBI from CPAN is one such module that allows a
developer to .... Obviously, the schema already describes itself, so
it only makes sense that you should be able to generate this kind of
code directly from the schema. The "ClassDBI" producer in SQLFairy
does just this, creating a Perl module that inherits from Class::DBI
and sets up most of the code needed to interact with the database.


Dave

---------------------------------------------------------------------
Web Archive:  http://www.mail-archive.com/suppressed/
              http://marc.theaimsgroup.com/?l=cgiapp&r=1&w=2
To unsubscribe, e-mail: suppressed
For additional commands, e-mail: suppressed