Oct 11th, 2012, 11:03 AM
Handling Related Data (Orders w/ Lines)
I have a design question... When it comes to processing related data, how is this typically done? I've run into scenarios where related data needs to be processed, but I am not clear on how to preserve restarability and handle read/write/commits properly.
A good example of this is where an order contains multiple line items. In the past, I've created a driving query that fetches all orders to be processed, then inside of a processor, I fetch line items and handle them appropriately. This typically means loading the line item, doing more processing on the line, then saving a status against the line. When all lines are complete for an order, I need to update the orders status. Is there a good general practice to follow here?