Re: change in SQLDirectory: csv instead of sql

Hi,

what should we do now with default-sql-directories-bundle.xml located in 
nuxeo.ear/config ?? It's not really compliant with the "directory 
improvements" ...

Florent Guillaume wrote:
> 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
> > ECM-FQDHc1wsLCVb90+sfpvX0g@xxxxxxxxxxxxxxxx
> > http://lists.nuxeo.com/mailman/listinfo/ecm