[OFBiz] Users - Counting Records in Ofbiz

[cjhowe]

that would be an interesting addition to WebTools.
Kind of a phpmyAdmin type concept going on but with
that functionality over the multitude of databases
that ofbiz supports.  Add a couple of timed services
and you have a database monitoring program.  When is
there going to come a time when we can simply
conceptulize processes and not have to code them? :)

========David wrote:

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
> Users at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/users

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2363 bytes
Desc: not available
Url : http://lists.ofbiz.org/pipermail/users/attachments/20050804/35f2db17/smime.bin
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[David E. Jones]

Probably as soon as the computer is as smart as you, but then you'd  
have to watch out for the computer cutting you out of the loop... ;)

-David


On Aug 4, 2005, at 7:59 PM, Chris Howe wrote:

> that would be an interesting addition to WebTools.
> Kind of a phpmyAdmin type concept going on but with
> that functionality over the multitude of databases
> that ofbiz supports.  Add a couple of timed services
> and you have a database monitoring program.  When is
> there going to come a time when we can simply
> conceptulize processes and not have to code them? :)
>
> ========David wrote:
>
> 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
>> Users at lists.ofbiz.org
>> http://lists.ofbiz.org/mailman/listinfo/users
>>
>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: smime.p7s
> Type: application/pkcs7-signature
> Size: 2363 bytes
> Desc: not available
> Url : http://lists.ofbiz.org/pipermail/users/attachments/ 
> 20050804/35f2db17/smime.bin
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>

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