Hi,
Attached is an update to the SQL templates. This is my first try with submitting a diff, please let me know if there is a better format. I have tested it with "ant test" using a mysql profile. I've also used the MS SQL template in my project. Changes: (1) base/mssql/drop.vm. Adds a counter to the local variables @constraintname and @reftable, fixing the bug described in http://www.mail-archive.com/[email protected]/msg07101.html credit to Skip Walker on the solution. http://www.mail-archive.com/[email protected]/msg07106.html (2) templates/sql/id-table/Control.vm. Changes the id_table_id in the id table to start at 100 instead of 10. Without this, including more than 10 tables in the project schema causes the records in the id_table to have overlapping primary keys between the project table records and the turbine security table records. (3) templates/sql/id-table/idtable.* (changed for each database). Changed the first id for each table to be 1000 instead of 100. This is useful if you are loading in initial data with project-datasql, with primary keys for each record being set manually (not by the id broker). Previously you were limited to loading in less than 100 records, now you can load in up to 999. I tested this with mysql and mssql, but went ahead and changed it for all the databases as the change is identical. (4)templates/sql/load/*/val.vm (changed for each database) puts quotes around dates when inserting into a database with project-datasql. (similar to a varchar). I tested this with mysql and mssql, but changed for all the databases. (5) src/templates/sql/load/mssql/row.vm added a "GO" after the insert statement. This prevents an error in an insert statement from stopping the entire file from executing. (each insert is a separate command). Tested this in my project. Best, WILL ------------------------------------ Will Glass-Husain <[EMAIL PROTECTED]> Forio Business Simulations office: (415) 440-7500 mobile: (415) 235-4293 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
