cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack O'Connor <jo4...@bristol.ac.uk>
Subject Re: show table status
Date Fri, 20 Jul 2007 14:24:29 GMT
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:
> 
> http://cayenne.apache.org/doc20/sqltemplate-query.html
> 
> 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 <jo4185@bristol.ac.uk> 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
>>

Mime
View raw message