You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@turbine.apache.org by jv...@apache.org on 2001/09/25 21:32:16 UTC

cvs commit: jakarta-turbine-2/conf/torque/templates/sql/db-init/sybase unix.vm windows.vm

jvanzyl     01/09/25 12:32:16

  Modified:    conf/torque/templates/sql/db-init/mssql unix.vm
               conf/torque/templates/sql/db-init/mysql unix.vm windows.vm
               conf/torque/templates/sql/db-init/postgresql unix.vm
               conf/torque/templates/sql/db-init/sybase unix.vm windows.vm
  Log:
  - changing the db-init templates to use the data model for the
    creation of the databases instead of the project name. this
    will now allow the proper creation of the databases for
    a multi-database project (tambora).
  
    the torque tasks have been changed accordingly in the 2.x tree
    and i will make the corresponding changes in the 3.x tree.
  
  Revision  Changes    Path
  1.2       +4 -3      jakarta-turbine-2/conf/torque/templates/sql/db-init/mssql/unix.vm
  
  Index: unix.vm
  ===================================================================
  RCS file: /home/cvs/jakarta-turbine-2/conf/torque/templates/sql/db-init/mssql/unix.vm,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- unix.vm	2001/08/16 05:07:01	1.1
  +++ unix.vm	2001/09/25 19:32:15	1.2
  @@ -1,5 +1,6 @@
   #!/bin/sh
   
  -dropdb $databaseName
  -createdb $databaseName
  -
  +#foreach ($databaseModel in $appData.Databases)
  +dropdb $databaseModel.Name
  +createdb $databaseModel.Name
  +#end
  
  
  
  1.2       +4 -2      jakarta-turbine-2/conf/torque/templates/sql/db-init/mysql/unix.vm
  
  Index: unix.vm
  ===================================================================
  RCS file: /home/cvs/jakarta-turbine-2/conf/torque/templates/sql/db-init/mysql/unix.vm,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- unix.vm	2001/08/16 05:07:01	1.1
  +++ unix.vm	2001/09/25 19:32:16	1.2
  @@ -18,5 +18,7 @@
       #set ($host = "")
   #end
   
  -mysqladmin $user $password $host --force drop $databaseName
  -mysqladmin $user $password $host --force create $databaseName
  +#foreach ($databaseModel in $appData.Databases)
  +mysqladmin $user $password $host --force drop $databaseModel.Name
  +mysqladmin $user $password $host --force create $databaseModel.Name
  +#end
  
  
  
  1.2       +4 -2      jakarta-turbine-2/conf/torque/templates/sql/db-init/mysql/windows.vm
  
  Index: windows.vm
  ===================================================================
  RCS file: /home/cvs/jakarta-turbine-2/conf/torque/templates/sql/db-init/mysql/windows.vm,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- windows.vm	2001/08/16 05:07:01	1.1
  +++ windows.vm	2001/09/25 19:32:16	1.2
  @@ -19,5 +19,7 @@
       #set ($host = "")
   #end
   
  -mysqladmin $user $password $host --force drop $databaseName
  -mysqladmin $user $password $host --force create $databaseName
  +#foreach ($databaseModel in $appData.Databases)
  +mysqladmin $user $password $host --force drop $databaseModel.Name
  +mysqladmin $user $password $host --force create $databaseModel.Name
  +#end
  
  
  
  1.2       +4 -2      jakarta-turbine-2/conf/torque/templates/sql/db-init/postgresql/unix.vm
  
  Index: unix.vm
  ===================================================================
  RCS file: /home/cvs/jakarta-turbine-2/conf/torque/templates/sql/db-init/postgresql/unix.vm,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- unix.vm	2001/08/16 05:07:01	1.1
  +++ unix.vm	2001/09/25 19:32:16	1.2
  @@ -1,4 +1,6 @@
   #!/bin/sh
   
  -dropdb $databaseName
  -createdb $databaseName
  +#foreach ($databaseModel in $appData.Databases)
  +dropdb $databaseModel.Name
  +createdb $databaseModel.Name
  +#end
  
  
  
  1.2       +4 -2      jakarta-turbine-2/conf/torque/templates/sql/db-init/sybase/unix.vm
  
  Index: unix.vm
  ===================================================================
  RCS file: /home/cvs/jakarta-turbine-2/conf/torque/templates/sql/db-init/sybase/unix.vm,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- unix.vm	2001/08/16 05:07:01	1.1
  +++ unix.vm	2001/09/25 19:32:16	1.2
  @@ -1,9 +1,11 @@
  +#foreach ($databaseModel in $appData.Databases)
   USE MASTER
   ;
   
  -DROP DATABASE $databaseName
  +DROP DATABASE $databaseModel.Name
   ;
   
  -CREATE DATABASE $databaseName
  +CREATE DATABASE $databaseModel.Name
   ON $sybaseDatadev = $sybaseDatasize
   LOG ON $sybaseLogdev = $sybaseLogsize
  +#end
  
  
  
  1.2       +4 -2      jakarta-turbine-2/conf/torque/templates/sql/db-init/sybase/windows.vm
  
  Index: windows.vm
  ===================================================================
  RCS file: /home/cvs/jakarta-turbine-2/conf/torque/templates/sql/db-init/sybase/windows.vm,v
  retrieving revision 1.1
  retrieving revision 1.2
  diff -u -r1.1 -r1.2
  --- windows.vm	2001/08/16 05:07:01	1.1
  +++ windows.vm	2001/09/25 19:32:16	1.2
  @@ -1,9 +1,11 @@
  +#foreach ($databaseModel in $appData.Databases)
   USE MASTER
   ;
   
  -DROP DATABASE $databaseName
  +DROP DATABASE $databaseModel.Name
   ;
   
  -CREATE DATABASE $databaseName
  +CREATE DATABASE $databaseModel.Name
   ON $sybaseDatadev = $sybaseDatasize
   LOG ON $sybaseLogdev = $sybaseLogsize
  +#end
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-dev-help@jakarta.apache.org