I did something ages ago to convert an XML formatted file
into the relevant SQL (was for postgress and I got it working
for MySQL once as well). The nice thing was it also spat
out the HTML documentation for the table as well.
http://leo.cuckoo.org/projects/xml_db_schema/
It's very rough and I wo
On Wed 17 Sep 2003, Jonathan Peterson <[EMAIL PROTECTED]> wrote:
> Really? I just write the SQL in text files and run them through the
> database's built in client.
I don't want the hassle of having to work out where to install these
text files.
Kake
Kate L Pugh wrote:
> So you're starting a new project, and you've designed a database
> schema, and you want to write some code to set up the tables in the
> database.
I use a template to generate the setup script for me.
A
On Wed, Sep 17, 2003 at 02:51:28PM +0100, alex wrote:
> I know it isn't exactly what you want - it being java and not perl, but it
> might help. I can't remember if anyone directed me to a perl version.
Seems like it went through the typical sourceforge lifecycle.
Mailing list post:
http://www
At 14:10 17/09/03, Kate L Pugh wrote:
Now I hate doing things over and over again. I just found myself
copying and pasting this code for the second time this month, and it
makes me feel dirty. Surely there is a simple module on CPAN that I
can pass a big pile of CREATE TABLE statements to, and it
On Wed, Sep 17, 2003 at 02:46:16PM +0100, Jonathan Peterson wrote:
>[Kake]
>> So you write the following module:
>Really? I just write the SQL in text files and run them through the
>database's built in client.
I write the table definitions in a different format and run them through
a converter t
> So you're starting a new project, and you've designed a database
> schema, and you want to write some code to set up the tables in the
> database. You know this won't be a one-off, since you'll want to
> initialise a test database every time you run your tests, plus you
> plan to deploy your app
On Wed, Sep 17, 2003 at 02:10:49PM +0100, Kate L Pugh wrote:
> Now I hate doing things over and over again. I just found myself
> copying and pasting this code for the second time this month, and it
> makes me feel dirty. Surely there is a simple module on CPAN that I
> can pass a big pile of CRE
So you're starting a new project, and you've designed a database
schema, and you want to write some code to set up the tables in the
database. You know this won't be a one-off, since you'll want to
initialise a test database every time you run your tests, plus you
plan to deploy your application i