Here's the patch file that weas supposed to be attached to the last email.
------------------------------------
Will Glass-Husain <[EMAIL PROTECTED]>
Forio Business Simulations
office: (415) 440-7500
mobile: (415) 235-4293
cvs diff (in directory D:\Will\Forio\repo\jakarta-turbine-torque\src\templates\sql)
cvs server: Diffing .
cvs server: Diffing base
cvs server: Diffing base/cloudscape
cvs server: Diffing base/db2
cvs server: Diffing base/db2400
cvs server: Diffing base/hypersonic
cvs server: Diffing base/interbase
cvs server: Diffing base/mssql
Index: base/mssql/drop.vm
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/base/mssql/drop.vm,v
retrieving revision 1.2
diff -r1.2 drop.vm
7c7
< DECLARE @reftable nvarchar(60), @constraintname nvarchar(60)
---
> DECLARE @reftable$velocityCount nvarchar(60), @constraintname$velocityCount
>nvarchar(60)
19c19
< FETCH NEXT from refcursor into @reftable, @constraintname
---
> FETCH NEXT from refcursor into @reftable$velocityCount,
>@constraintname$velocityCount
22,23c22,23
< exec ('alter table '+@reftable+' drop constraint '+@constraintname)
< FETCH NEXT from refcursor into @reftable, @constraintname
---
> exec ('alter table '+@reftable$velocityCount+' drop constraint
>'+@constraintname$velocityCount)
> FETCH NEXT from refcursor into @reftable$velocityCount,
>@constraintname$velocityCount
cvs server: Diffing base/mysql
cvs server: Diffing base/oracle
cvs server: Diffing base/postgresql
cvs server: Diffing base/sapdb
cvs server: Diffing base/sybase
cvs server: Diffing db-init
cvs server: Diffing db-init/db2400
cvs server: Diffing db-init/hypersonic
cvs server: Diffing db-init/mssql
cvs server: Diffing db-init/mysql
cvs server: Diffing db-init/oracle
cvs server: Diffing db-init/postgresql
cvs server: Diffing db-init/sapdb
cvs server: Diffing db-init/sybase
cvs server: Diffing id-table
Index: id-table/Control.vm
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/id-table/Control.vm,v
retrieving revision 1.4
diff -r1.4 Control.vm
5c5
< #set ( $initialID = $initialID + 10 )
---
> #set ( $initialID = $initialID + 100 )
Index: id-table/idtable.cloudscape
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/id-table/idtable.cloudscape,v
retrieving revision 1.2
diff -r1.2 idtable.cloudscape
1,4c1,4
< #foreach ($tbl in $tables)
< insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
($initialID, '$tbl.Name', 100, 10);
< #set ( $initialID = $initialID + 1 )
< #end
---
> #foreach ($tbl in $tables)
> insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
>($initialID, '$tbl.Name', 1000, 10);
> #set ( $initialID = $initialID + 1 )
> #end
Index: id-table/idtable.db2
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/id-table/idtable.db2,v
retrieving revision 1.2
diff -r1.2 idtable.db2
2c2
< insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
($initialID, '$tbl.Name', 100, 10);
---
> insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
>($initialID, '$tbl.Name', 1000, 10);
Index: id-table/idtable.db2400
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/id-table/idtable.db2400,v
retrieving revision 1.2
diff -r1.2 idtable.db2400
2c2
< insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
($initialID, '$tbl.Name', 100, 10);
---
> insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
>($initialID, '$tbl.Name', 1000, 10);
Index: id-table/idtable.hypersonic
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/id-table/idtable.hypersonic,v
retrieving revision 1.2
diff -r1.2 idtable.hypersonic
2c2
< insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
($initialID, '$tbl.Name', 100, 10);
---
> insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
>($initialID, '$tbl.Name', 1000, 10);
Index: id-table/idtable.interbase
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/id-table/idtable.interbase,v
retrieving revision 1.2
diff -r1.2 idtable.interbase
2c2
< insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
($initialID, '$tbl.Name', 100, 10);
---
> insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
>($initialID, '$tbl.Name', 1000, 10);
Index: id-table/idtable.mssql
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/id-table/idtable.mssql,v
retrieving revision 1.2
diff -r1.2 idtable.mssql
2c2
< insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
($initialID, '$tbl.Name', 100, 10);
---
> insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
>($initialID, '$tbl.Name', 1000, 10);
Index: id-table/idtable.mysql
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/id-table/idtable.mysql,v
retrieving revision 1.2
diff -r1.2 idtable.mysql
2c2
< insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
($initialID, '$tbl.Name', 100, 10);
---
> insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
>($initialID, '$tbl.Name', 1000, 10);
Index: id-table/idtable.oracle
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/id-table/idtable.oracle,v
retrieving revision 1.2
diff -r1.2 idtable.oracle
2c2
< insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
($initialID, '$tbl.Name', 100, 10);
---
> insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
>($initialID, '$tbl.Name', 1000, 10);
Index: id-table/idtable.postgresql
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/id-table/idtable.postgresql,v
retrieving revision 1.2
diff -r1.2 idtable.postgresql
2c2
< insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
($initialID, '$tbl.Name', 100, 10);
---
> insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
>($initialID, '$tbl.Name', 1000, 10);
Index: id-table/idtable.sapdb
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/id-table/idtable.sapdb,v
retrieving revision 1.2
diff -r1.2 idtable.sapdb
2c2
< insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
($initialID, '$tbl.Name', 100, 10);
---
> insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES
>($initialID, '$tbl.Name', 1000, 10);
Index: id-table/idtable.sybase
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/id-table/idtable.sybase,v
retrieving revision 1.2
diff -r1.2 idtable.sybase
2c2
< insert into ID_TABLE (ID_TABLE_ID, TABLE_NAME, NEXT_ID, QUANTITY) VALUES
($initialID, '$tbl.Name', 100, 10);
---
> insert into ID_TABLE (ID_TABLE_ID, TABLE_NAME, NEXT_ID, QUANTITY) VALUES
>($initialID, '$tbl.Name', 1000, 10);
cvs server: Diffing load
cvs server: Diffing load/db2400
Index: load/db2400/row.vm
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/load/db2400/row.vm,v
retrieving revision 1.1
diff -r1.1 row.vm
1,2c1,2
< INSERT INTO $row.Table.Name (##
< #set ($comma="")#foreach($col in
$row.ColumnValues)$comma${col.Column.Name}#set($comma=",")#end)
---
> INSERT INTO $row.Table.Name (##
> #set ($comma="")#foreach($col in
>$row.ColumnValues)$comma${col.Column.Name}#set($comma=",")#end)
Index: load/db2400/val.vm
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/load/db2400/val.vm,v
retrieving revision 1.1
diff -r1.1 val.vm
1c1
< #if($column.Column.TorqueType=="VARCHAR" || $column.Column.TorqueType=="LONGVARCHAR"
)'$column.Value'#else$column.Value#end
---
> #if($column.Column.TorqueType=="VARCHAR" ||
>$column.Column.TorqueType=="LONGVARCHAR"||
>$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
\ No newline at end of file
cvs server: Diffing load/hypersonic
Index: load/hypersonic/val.vm
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/load/hypersonic/val.vm,v
retrieving revision 1.2
diff -r1.2 val.vm
1c1
< #if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
---
> #if($column.Column.TorqueType=="VARCHAR" ||
>$column.Column.TorqueType=="LONGVARCHAR"||
>$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
\ No newline at end of file
cvs server: Diffing load/mssql
Index: load/mssql/row.vm
===================================================================
RCS file: /home/cvspublic/jakarta-turbine-torque/src/templates/sql/load/mssql/row.vm,v
retrieving revision 1.2
diff -r1.2 row.vm
3c3,5
< VALUES (#set ($comma="")#foreach($col in
$row.ColumnValues)$comma${generator.parse("sql/load/mssql/val.vm", "", "column",
$col)}#set ($comma=",")#end);
---
> VALUES (#set ($comma="")#foreach($col in
>$row.ColumnValues)$comma${generator.parse("sql/load/mssql/val.vm", "", "column",
>$col)}#set ($comma=",")#end);
> GO
>
Index: load/mssql/val.vm
===================================================================
RCS file: /home/cvspublic/jakarta-turbine-torque/src/templates/sql/load/mssql/val.vm,v
retrieving revision 1.2
diff -r1.2 val.vm
1c1
< #if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
---
> #if($column.Column.TorqueType=="VARCHAR" ||
>$column.Column.TorqueType=="LONGVARCHAR"||
>$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
\ No newline at end of file
cvs server: Diffing load/mysql
Index: load/mysql/val.vm
===================================================================
RCS file: /home/cvspublic/jakarta-turbine-torque/src/templates/sql/load/mysql/val.vm,v
retrieving revision 1.2
diff -r1.2 val.vm
1c1
< #if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
---
> #if($column.Column.TorqueType=="VARCHAR" ||
>$column.Column.TorqueType=="LONGVARCHAR"||
>$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
cvs server: Diffing load/oracle
Index: load/oracle/val.vm
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/load/oracle/val.vm,v
retrieving revision 1.2
diff -r1.2 val.vm
1c1
< #if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
---
> #if($column.Column.TorqueType=="VARCHAR" ||
>$column.Column.TorqueType=="LONGVARCHAR"||
>$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
\ No newline at end of file
cvs server: Diffing load/postgresql
Index: load/postgresql/val.vm
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/load/postgresql/val.vm,v
retrieving revision 1.2
diff -r1.2 val.vm
1c1
< #if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
---
> #if($column.Column.TorqueType=="VARCHAR" ||
>$column.Column.TorqueType=="LONGVARCHAR"||
>$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
\ No newline at end of file
cvs server: Diffing load/sapdb
Index: load/sapdb/val.vm
===================================================================
RCS file: /home/cvspublic/jakarta-turbine-torque/src/templates/sql/load/sapdb/val.vm,v
retrieving revision 1.1
diff -r1.1 val.vm
1c1
< #if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
---
> #if($column.Column.TorqueType=="VARCHAR" ||
>$column.Column.TorqueType=="LONGVARCHAR"||
>$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
cvs server: Diffing load/sybase
Index: load/sybase/row.vm
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/load/sybase/row.vm,v
retrieving revision 1.1
diff -r1.1 row.vm
3c3
< VALUES (#set ($comma="")#foreach($col in
$row.ColumnValues)$comma${generator.parse("sql/load/sybase/val.vm", "", "column",
$col)}#set ($comma=",")#end);
\ No newline at end of file
---
> VALUES (#set ($comma="")#foreach($col in
>$row.ColumnValues)$comma${generator.parse("sql/load/sybase/val.vm", "", "column",
>$col)}#set ($comma=",")#end);
Index: load/sybase/val.vm
===================================================================
RCS file:
/home/cvspublic/jakarta-turbine-torque/src/templates/sql/load/sybase/val.vm,v
retrieving revision 1.2
diff -r1.2 val.vm
1c1
< #if($column.Column.TorqueType=="VARCHAR" ||
$column.Column.TorqueType=="LONGVARCHAR")'$column.Value'#else$column.Value#end
---
> #if($column.Column.TorqueType=="VARCHAR" ||
>$column.Column.TorqueType=="LONGVARCHAR"||
>$column.Column.TorqueType=="DATE")'$column.Value'#else$column.Value#end
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
