I applied Skip's version of (1). I applied (2) but changed 100 to 1000.
Also applied (3) and (4). I did not apply (5) as I do not think it is generally a good idea to skip over an error. Please use cvs diff -u format in the future. thanks, john mcnally On Thu, 2002-05-02 at 01:00, Will Glass-Husain wrote: > > 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]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
