You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by ta...@apache.org on 2004/02/28 21:58:12 UTC

cvs commit: jakarta-jetspeed-2 maven.xml project.properties

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: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org