Re: show table status

From: Jack O'Connor (jo418..ristol.ac.uk)
Date: Fri Jul 20 2007 - 13:45:15 EDT

  • Next message: Andrus Adamchik: "Re: show table status"

    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