Just try it :-)
Don't forget to call "setFetchingDataRows(true)" as mentioned by
Michael. This is what makes the difference. The result will be a list
of Maps.
Andrus
On Jul 20, 2007, at 8:45 PM, Jack O'Connor wrote:
> 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 - 14:04:25 EDT