cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <>
Subject Re: show table status
Date Fri, 20 Jul 2007 14:48:19 GMT
In this case it is needed to pick the right database (Cayenne  
potentially can access more than one). You can use an arbitrary class  
from your model in this case.


On Jul 20, 2007, at 5:24 PM, Jack O'Connor wrote:

> Thanks for the reply, but all the SQLTemplates on that page require  
> a class/table to refer to (all the examples are for Artist.class).  
> The MySQL command "show table status" doesn't apply to any  
> particular class...
> Jack
> Michael Gentry wrote:
>> I would think you'd be able to use an SQLTemplate to perform that  
>> kind of query:
>> You'll want to call setFetchingDataRows(true) on your SQLTemplate
>> object, too, otherwise Cayenne will try to make CayenneDataObjects  
>> out
>> of it.  Do this before you run performQuery().
>> /dev/mrg
>> On 7/19/07, Jack O'Connor <> wrote:
>>> Hi all, in my project I need to extract the total db size(kb). Im  
>>> using
>>> Cayenne 1.2.3 and MySQL and I found the SQL command "show table  
>>> status
>>> from <db name>" which displays a table of information about all  
>>> of the
>>> tables in a certain db. This table has columns like "Name"(of  
>>> table),
>>> "Data_length" and "Index_length", and apparently the best way to  
>>> extract
>>> the size(kb) of a db is to sum the Data_length and Index_length  
>>> columns
>>> of this table.
>>> Does anyone know how I can get the results of this query into java?
>>> Many Thanks
>>> Jack

View raw message