Hello,
I find need for an entity cleanup tool that can delete or export an
entity and all related entities excluding seed. I use very drastic database
delete and ant run-install for this purpose while I am getting familiar with
OFBiz. Even in production, I can see need to cleanup entities for signups that
were not completed or some selected past data. I expect something like this to
work as follows:
- If the entity’s primary key is non-numeric,
assume it is seed data and do nothing.
- From each numeric field of the target entity,
find all the related entities and put them on the entity list. (If you
know of Java function and syntax that would do it, I would like to know.)
- Find all entities that use any of the target
entity’s primary keys and add them to this entity list. (Again, I
would want to know Java function to do it.)
- For every entry on the entity list, perform the
find functions 2 and 3 recursively.
- Present the entire list to the admin with
checkbox to include/exclude operation.
- Perform delete or export operation as selected.
I can do this in Java with some help J
Regards,
Vinay Agarwal
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Locked
