[OFBiz] Users - Counting Records in Ofbiz

[Robert Riggins]

I'm creating services that delete records and related records from our Ofbiz application.

 

As I'm testing, I find I'd like to have a count of the records before and after the database inserts and deletes. By this, I mean I'd like to know how many records are created or deleted throughout the database. I don't know all the related entity relationships so I can't just perform counts on certain tables. I may miss some inserts that way

 

Does anyone have suggestions about how to do this?

 

Thanks,

Rob Riggins

Integral Business Solutions

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[David E. Jones]

How are you doing the deletes of related records? If it is through  
cascading deletes then unless the JDBC driver gets the count of those  
back from the database you might be out of luck... If you are using  
the removeRelated stuff in the Entity Engine you can get the counts.  
Note that with the meta data of the data model available you can use  
the ModelEntity and related objects to go through all relationships  
and do a delete with generic code, ie without writing code for each  
entity. I don't know off the top of my head if anything that does  
this already exists somewhere or not, but it might be a nice addition.

-David


On Aug 4, 2005, at 1:31 PM, Robert Riggins wrote:

> I'm creating services that delete records and related records from  
> our Ofbiz application.
>
> As I'm testing, I find I'd like to have a count of the records  
> before and after the database inserts and deletes. By this, I mean  
> I'd like to know how many records are created or deleted throughout  
> the database. I don't know all the related entity relationships so  
> I can't just perform counts on certain tables. I may miss some  
> inserts that way
>
> Does anyone have suggestions about how to do this?
>
> Thanks,
> Rob Riggins
> Integral Business Solutions
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users