Methods and systems for recursive saving of hierarchical objects to a database

摘要

Methods and systems include embodiments that recursively save parent, grandparent, and other records in a database that depend from a record. User-provided code within a save event or trigger can thus call further save methods without corrupting the database. Junction objects, objects that reflect records with two or more parents, can also be recursively saved.

主权项

1. A method at a database system having at least a memory and a processor therein, wherein the method comprises:
processing a set of records to be committed to the database system; detecting a fault with a record within the set of records while processing the set of records to be committed to the database system; performing fault recovery for the record having the fault, including at least: (i) determining the record having the fault is a parent record which depends from a field value of a child record, (ii) faulting the child record, (iii) identifying resource limitations counted against governor limits used up by processing the set of records including the record having the fault and the faulted child record, (iv) rolling back the identified resource limitations associated with the record having the fault and the faulted child record, and (v) removing the record having the fault and the faulted child record from the set of records to be committed to the database system resulting in subset of the set records to be committed to the database system; and committing the resulting subset of the set records to be committed to the database system.