Re: Code Generation in Perl

[prev] [thread] [next] [Date index for 2004/06/16]

Tim,

SQL::Translator already has an XML format it can dump the schema in.  It
isn't totally roundtrippable though, as we don't yet model some of the
more advanced DDL features like triggers.

If you're specifically interested in dumping out XML in the AppML format
being discussed here, it wouldn't be difficult to make a SQL::Translator
template to do it.

-Allen


On Wed, 16 Jun 2004, Tim Bunce wrote:

> On Wed, Jun 16, 2004 at 10:57:57AM -0300, Nelson Ferraz wrote:
> > Tim Bunce wrote:
> > >>The database creation scripts are generated automatically, and I use 
> > >>Class::DBI to achieve database independence and to make the resulting 
> > >>code more mantainable.
> > >
> > >Is there a tool to automatically create the XML from a database schema
> > >(and so easily 'bootstrap' a new development project)?
> > 
> > This is a good idea.
> > 
> > Take a look on SQLFairy (http://sqlfairy.sourceforge.net/) cited by 
> > Brian O'Connor.
> > 
> > It may be useful to parse a SQL create script, and then, generate a XML 
> > output.
> 
> I was only curious. I was really only suggesting that you provide
> one if you didn't already :)
> 
> Tim.
>