Very cool, thanks.
This will allow us to stop bothering with the different dialects scripts. As a bonus, CSV is quite easier to maintain in your favorite spreadsheet than a SQL script.

(For interested developers, note that we use the Hibernate Dialect class to deal with the SQL generation, and Hibernate knows about a lot of databases.)

Florent

On 24 May 2007, at 14:52, George Lefter wrote:

Hi,

Because there were problems with the portability of sql scripts among different sql engines, I have changed org.nuxeo.platform.ecm.directory.sql to create the tables based on the schema description and to populate them from csv files. The csv file must have as a first line the list of column names separated with comma.

Also I renamed attributes "sqlScript" to "dataFile" and "executeScriptPolicy" with "createTablePolicy" in the directory configurations.

_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm


--
Florent Guillaume, Director of R&D, Nuxeo
Open Source Enterprise Content Management (ECM)
http://www.nuxeo.com   http://www.nuxeo.org   +33 1 40 33 79 87



_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm

Reply via email to