taylor 2004/02/28 12:58:12 Modified: . maven.xml project.properties Log: added db.scripts.gen goal to create DDL scripts Revision Changes Path 1.29 +57 -2 jakarta-jetspeed-2/maven.xml Index: maven.xml =================================================================== RCS file: /home/cvs/jakarta-jetspeed-2/maven.xml,v retrieving revision 1.28 retrieving revision 1.29 diff -u -r1.28 -r1.29 --- maven.xml 27 Feb 2004 18:50:27 -0000 1.28 +++ maven.xml 28 Feb 2004 20:58:12 -0000 1.29 @@ -207,6 +207,61 @@ postProcessing="false" ignoreFailures="false"/> </goal> - - + + <goal name="db.scripts.gen" prereqs="torque:init" + description="Build SQL scripts using Torque generator"> + + <echo message="Generating SQL schema creation scripts for HSQLDB"/> + <torque-sql + basePathToDbProps="sql/base/" + contextProperties="${torque.contextProperties}" + controlTemplate="${torque.template.sql}" + idTableXMLFile="${torque.idTableXMLFile}" + outputDirectory="${maven.build.src}/sql/hsql" + outputFile="report.${torque.project}.sql.generation" + sqldbmap="${maven.build.src}/sql/hsql/sqldb.map" + targetDatabase="hypersonic" + useClasspath="true"> + <fileset dir="${torque.schema.dir}" + includes="${torque.schema.sql.includes}" + excludes="${torque.schema.sql.excludes}" + /> + </torque-sql> + + <echo message="Generating SQL schema creation scripts for MySQL"/> + <torque-sql + basePathToDbProps="sql/base/" + contextProperties="${torque.contextProperties}" + controlTemplate="${torque.template.sql}" + idTableXMLFile="${torque.idTableXMLFile}" + outputDirectory="${maven.build.src}/sql/mysql" + outputFile="report.${torque.project}.sql.generation" + sqldbmap="${maven.build.src}/sql/mysql/sqldb.map" + targetDatabase="mysql" + useClasspath="true"> + <fileset dir="${torque.schema.dir}" + includes="${torque.schema.sql.includes}" + excludes="${torque.schema.sql.excludes}" + /> + </torque-sql> + + <echo message="Generating SQL schema creation scripts for Oracle"/> + <torque-sql + basePathToDbProps="sql/base/" + contextProperties="${torque.contextProperties}" + controlTemplate="${torque.template.sql}" + idTableXMLFile="${torque.idTableXMLFile}" + outputDirectory="${maven.build.src}/sql/oracle" + outputFile="report.${torque.project}.sql.generation" + sqldbmap="${maven.build.src}/sql/oracle/sqldb.map" + targetDatabase="oracle" + useClasspath="true"> + <fileset dir="${torque.schema.dir}" + includes="${torque.schema.sql.includes}" + excludes="${torque.schema.sql.excludes}" + /> + </torque-sql> + + </goal> + </project> 1.6 +9 -0 jakarta-jetspeed-2/project.properties Index: project.properties =================================================================== RCS file: /home/cvs/jakarta-jetspeed-2/project.properties,v retrieving revision 1.5 retrieving revision 1.6 diff -u -r1.5 -r1.6 --- project.properties 27 Feb 2004 18:03:27 -0000 1.5 +++ project.properties 28 Feb 2004 20:58:12 -0000 1.6 @@ -20,3 +20,12 @@ org.apache.jetspeed.database.driver = org.hsqldb.jdbcDriver org.apache.jetspeed.database.user = sa org.apache.jetspeed.database.password = + +# --------------------------------------------------------------------------- +# Torque settings +torque.project = portal +torque.schema.sql.includes = *-schema.xml +torque.schema.sql.excludes = +torque.schema.dir = ${maven.src.dir}/schema +torque.idTableXMLFile = +torque.template.sql = sql/base/Control.vm
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]