Xmldoom::doc::UsingTorque Xmldoom::doc::UsingTorque Perl module contains a how to about making Torque generator to work with your database.xml.
Download

Xmldoom::doc::UsingTorque Ranking & Summary

Xmldoom::doc::UsingTorque Tags

Perl module generator Torque generator Torque tutorial Torque

Xmldoom::doc::UsingTorque Description

Xmldoom::doc::UsingTorque Perl module contains a how to about making Torque generator to work with your database.xml. Xmldoom::doc::UsingTorque Perl module contains a how to about making Torque generator to work with your database.xml.Because the format used in the database definition (commonly named database.xml) is the same as Apache Torque, we can use their tools to automatically generate database.xml from the database, or automatically create the database from a database.xml.Basically, the Torque Generator is a set of Ant scripts that call into the Torque engine. So, you need to install Ant as well.SETTING UP THE TORQUE GENERATORFirst, you must download the Torque Generator from their project page:http://db.apache.org/torque/download.htmlMake sure you are downloading the Generator (the page is a little confusing). You'll see that there is a table there with versions going down the Y-axis and product names going across the X-axis. If the page hasn't since this writing, you want the top-cell over to the right one.Once you've got it:1. Extract the archive somewhere. You'll end up with directory named like torque-gen-3.2. Go there.2. Edit a file named build.properties. Most of the setting don't matter for us, so you can skip down to the section labeled "DATABASE SETTINGS" (with a space between each letter). Configuring this section should be pretty self explanitory if you have ever used JDBC in Java before. In case you haven't you can check out the explanation at the end of this document named "BUILD PROPERTIES".3. You need to find and copy the JDBC drivers for your database into the lib/ directory. More on this in the "BUILD PROPERTIES" section.Now you are ready to give it a go.ANT TARGETSTo generate an XML schema from your database, run: ant -f build-torque.xml jdbcMost likely you won't want to use the generated file directly, because it lacks foreign-keys and any of the groovy Xmldoom special features. But it does provide a quick spring-board to allow to copy-paste and modify to get started quickly.To create your database based on the XML description, run: # to initially create the databas ant -f build-torque.xml create-db # will drop and re-create all tables in the database ant -f build-torque.xml insert-sql Requirements: · Perl

Xmldoom::doc::UsingTorque Related Software