OK, but then if I use
SQLTemplate select = new SQLTemplate(Artist.class, "show table status");
List artists = dataContext.performQuery(select);
Surely I will have Artist objects, and will only be able to use that
classes defined "getters and setters"? i.e. How will I extract data from
columns: data_length and index_length?
Thanks
Jack
Andrus Adamchik wrote:
> 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.
>
> Andrus
>
>
> 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:
>>> 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 <jo418..ristol.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
>>>>
>>
>
This archive was generated by hypermail 2.0.0 : Fri Jul 20 2007 - 13:50:00 EDT