Re: Re: change in SQLDirectory: csv instead of sql

Hi,
I also have updated the default-sql-directories-bundle.xml to the new format, 
but
I overlooked this first and it was committed a bit later, please try to update 
again.


Another thing that I forgot to point out:
The script setup-default-directories.sql has been split into users.csv, 
groups.csv and user2group.csv.
The user2group.csv is used when defining the relations, in default-sql-directories-bundle, to specify the data to load 
for the relation table:

      <references>
        <tableReference field="groups" directory="groupDirectory"
          table="user2group" sourceColumn="userId" targetColumn="groupId" 
schema="user2group"
          master="true" dataFile="user2group.csv" />
      </references>



Vincent Dutat wrote:
> 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
>
> _______________________________________________
> ECM mailing list
> ECM-FQDHc1wsLCVb90+sfpvX0g@xxxxxxxxxxxxxxxx
> http://lists.nuxeo.com/mailman/listinfo/ecm