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
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
