Hi all. I have a pretty large model where every to-many relationship's delete rule is "Deny" (I like being explicit about the data I delete, especially since the DB in question still doesn't have well specified FKs).
Almost every table in this DB is somehow related to a "Customer" table (sometimes through a chain of tables) that "owns" data. I'm now implementing an operation to nuke a Customer (as in "delete everything related to that customer")—but the data "owned" by the customer is hugely interrelated, even often creating circular relations. Do I have any nice options, given a set of DataObjects, to just tell Cayenne to nuke that darn data without any consideration for normal delete rules? As in "usually I wouldn't allow this and Ashwood is very angry at you—but since you really, really want it…". Note that the whole operation results in a consistent database (even if there are temporary in-memory inconsistencies due to the circular relationships) since the interrelated data is all deleted within the operation. Cheers, - Hugi
