cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Gentry <mgen...@masslight.net>
Subject Re: Specifying what columns to fetch when using DataRows
Date Wed, 19 Oct 2011 14:07:44 GMT
Hi Hugi,

You probably want to use an SQLTemplate and specify the exact columns.
 I don't recall seeing anything to support what you are asking for a
SelectQuery, although it sounds like a useful idea.

Thanks,

mrg


On Wed, Oct 19, 2011 at 7:46 AM, Hugi Thordarson <hugi@karlmenn.is> wrote:
> Hi all.
>
> I'm using DataRow fetching to optimize some queries. How do I specify what columns to
fetch? Can I do something like this:
>
> --------
> SelectQuery q = new SelectQuery( Person.class );
> q.setFetchingDataRows( true );
> q.setDataRowKeyPaths( Arrays.asList( "name", "department.name", "address.city.country"
) );
> --------
>
> For those familar with EOF, I'd do this to achieve the same result:
>
> --------
> EOFetchSpecification fs = new EOFetchSpecification( "Person", null, null );
> fs.setFetchesRawRows( true );
> fs.setRawRowKeyPaths( Arrays.asList( "name", "department.name", "address.city.country"
) );
> --------
>
> Cheers,
> - hugi

Mime
View raw message