load-data not correct working
schema.xml
<?xml version="1.0" encoding="UTF-8"?>
<database name="propel" defaultIdMethod="native" package="lib.model">
<table name="client">
<column name="id" type="INTEGER" required="true" primaryKey="true"/>
<column name="name" type="VARCHAR" size="255"/>
</table>
<table name="folder">
<column name="id" type="INTEGER" required="true" primaryKey="true"/>
<column name="client_id" type="INTEGER" required="true" primaryKey="true" />
<foreign-key foreignTable="client" onDelete="cascade">
<reference local="client_id" foreign="id"/>
</foreign-key>
<column name="folder_id" type="INTEGER"/>
<foreign-key foreignTable="folder" onDelete="cascade">
<reference local="folder_id" foreign="id" />
</foreign-key>
<column name="name" type="VARCHAR" size="255" required="true" />
</table>
</database>
data.yml
Client:
C1:
id: 0
name: Main
Folder:
F1:
id: 0
client_id: C1
name: Root
F2:
id: 1
client_id: C1
folder_id: F1
name: Child1
F3:
id: 2
client_id: C1
folder_id: F2
name: Child2
F4:
id: 3
client_id: C1
folder_id: F3
name: Child3
Folder: original results (folder_id not correct)
id client_id folder_id name
----------------------------------
0 0 (Null) Root
1 0 1 Child1
2 0 1 Child2
3 0 1 Child3
Folder: expected results
id client_id folder_id name
----------------------------------
0 0 (Null) Root
1 0 0 Child1
2 0 1 Child2
3 0 2 Child3
Solution in attachment.
