PropelLoader

The PropelLoader writes processed rows into a given table by using its TableMap and returns the rows.

Optionally, after loading, it can map the IDs from the database back to the rows.

Configuration

XPath	Type	Description
propel/@propelTableMapClass	Attribute	Fully qualified class name of the TableMap to use.

Children configuration

Only one return child is allowed.

XPath	Type	Description
return/@column	Attribute	Name of the database column to return.
return/@to	Attribute	Name of the field in the row to store the returned value.
return/@key	Attribute	Name of the field to use as a key for mapping the results.

Example

Input data

Row	nameField	taxRateNameField
1	String: StandardTaxes	String: Austria Standard
2	String: StandardTaxes	String: Germany Standard
3	String: ShipmentTaxes	String: Austria Standard
4	String: ShipmentTaxes	String: Germany Standard

Pipeline configuration

<propel propelTableMapClass="\Orm\Zed\Tax\Persistence\Map\SpyTaxSetTableMap">
    <return column="id_tax_set" to="idTaxSet" key="nameField"/>
</propel>

Database output

spy_tax_set

id_tax_set	name
1	StandardTaxes
2	ShipmentTaxes

Pipeline output

Row	name	taxRateName	idTaxSet
1	String: StandardTaxes	String: Austria Standard	Integer: 1
2	String: StandardTaxes	String: Germany Standard	Integer: 1
3	String: ShipmentTaxes	String: Austria Standard	Integer: 2
4	String: ShipmentTaxes	String: Germany Standard	Integer: 2