I am having problems deploying from a single content record to a database schema with three tables, two data tables and one associative table. Referential integrity is being enforced in the DB with foreign key constraints, so I can only deploy data to table1, then table2, and finally to the AssociativeTable. Looks something like this:
Table1
ID
Name
AssociativeTable1
Table1ID
Table2ID
Table2
ID
Name
I can't figure out if it is possible to deploy to these tables without removing the constraints first. The way you set up a datadeploy config file forces you into a chain of parent, child, grandchild etc., so that datadeploy will always want to deploy to Table1, then the AssociativeTable, and finally Table2.
Sample DD config file is below. The only way I've been able to get this to work is to remove the table constraints, deploy, and add the constraints back. Is this possible?
-John
<?xml version="1.0" encoding="utf-8" standalone="no"?>
<data-deploy-configuration>
<data-deploy-elements filepath="path/to/database.xml" />
<client>
<deployment name="testassoc">
<source>
<teamsite-templating-records custom="yes" options="wide" area="path/to/STAGING" include-extended-attributes="yes">
<path name="templatedata/path/to/data" />
</teamsite-templating-records>
</source>
<destinations>
<database use="DevDB" update-type="standalone" state-field="state" enforce-ri="yes">
<dbschema>
<!-- === Table: table_one === -->
<group name="table_one" table="table_one" root-group="yes">
<attrmap>
<column name="ID" data-type="INTEGER" value-from-element="page/0/ID/0" allows-null="no" />
<column name="Path" data-type="VARCHAR(256)" value-from-field="path" allows-null="no" />
<column name="Name" data-type="VARCHAR(256)" value-from-element="page/0/Name/0" allows-null="no" />
</attrmap>
<keys>
<primary-key>
<key-column name="ID" />
</primary-key>
</keys>
</group>
<!-- === Table: table_assoc === -->
<group name="table_assoc" table="table_assoc" root-group="no">
<attrmap>
<column name="TableOneID" data-type="INTEGER" value-from-field="page/0/ID/0" allows-null="no" />
<column name="TableTwoID" data-type="INTEGER" value-from-element="page/0/Group/0/ID/0" allows-null="no" />
</attrmap>
<keys>
<primary-key>
<key-column name="TableOneID" />
<key-column name="TableTwoID" />
</primary-key>
<foreign-key parent-group="table_one" ri-constraint-rule="ON DELETE CASCADE">
<column-pair parent-column="ID" child-column="TableOneID" />
</foreign-key>
</keys>
</group>
<!-- === Table: table_two === -->
<group name="table_two" table="table_two" root-group="no">
<attrmap>
<column name="ID" data-type="INTEGER" value-from-field="page/0/Group/0/ID/0" allows-null="no" />
<column name="Name" data-type="VARCHAR(256)" value-from-element="page/0/Group/0/Name/0" allows-null="no" />
</attrmap>
<keys>
<primary-key>
<key-column name="ID" />
</primary-key>
<foreign-key parent-group="table_assoc" ri-constraint-rule="ON DELETE CASCADE">
<column-pair parent-column="TableTwoID" child-column="ID" />
</foreign-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>
