Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
MIME-Version: 1.0
In-Reply-To: <pony-eb26d4b97ed24d27e0f8f8afa0aa2a0ef7145fb7-9d44b990a2c06db1e76b7c8ff0c100194719f9e4@user.cayenne.apache.org>
References: <pony-eb26d4b97ed24d27e0f8f8afa0aa2a0ef7145fb7-62a3c4bc2f2de02dd932779eef15b8f4e740db77@user.cayenne.apache.org>
 <CAMi+qzDd6FS4Eb+TaX+o7OAh_0mja8EPt4sQdCySb3X5zbLFVQ@mail.gmail.com> <pony-eb26d4b97ed24d27e0f8f8afa0aa2a0ef7145fb7-9d44b990a2c06db1e76b7c8ff0c100194719f9e4@user.cayenne.apache.org>
From: Nikita Timofeev <ntimofeev@objectstyle.com>
Date: Wed, 4 Oct 2017 15:43:24 +0300
Message-ID: <CAMi+qzB3RrJX5icO3B7AbEtK=CNpzvh-fUDQEHCMmo18dTXCyA@mail.gmail.com>
Subject: Re: ObjectSelect.columnQuery
To: Apache Cayenne <user@cayenne.apache.org>
Content-Type: text/plain; charset="UTF-8"
archived-at: Wed, 04 Oct 2017 12:43:50 -0000

Yes you can add this property:

Property<Cargo> property3 = Property.createSelf(Cargo.class);

But this will eagerly fetch all content of Cargo.

On Wed, Oct 4, 2017 at 3:30 PM, ab@dataloy.com <ab@dataloy.com> wrote:
>
>
> On 2017-10-04 13:57, Nikita Timofeev <ntimofeev@objectstyle.com> wrote:
>> ObjectSelect.columnQuery can select individual columns, as it was
>> designed just for that.
>> However you can also use it to get full entities along with some
>> arbitrary properties (aggregates, dependent objects, etc.).
>> In your case you created property with type of "Cargo" and it returns
>> you collection of Cargo objects.
>> Just use correct type of required column (String, Integer, etc.).
>>
>> However easiest (and also safe) way to use it is via static Properties
>> generated in a superclass of your entity, i.e. something like this:
>>
>> List<String> someStringProperties =
>> ObjectSelect.columnQuery(Cargo.class,
>> Cargo.SOME_STRING_PROPERTY).select(ctx);
>>
>>
>> On Wed, Oct 4, 2017 at 12:45 PM, ab@dataloy.com <ab@dataloy.com> wrote:
>> > Should ObjectSelect.columnQuery  execute a SQL query with just one column selected?
>> >
>> > I am using Cayenne 4.1 but running this code:
>> >
>> > Property<Cargo> property1 = Property.create("area", Cargo.class);
>> >
>> > List<Cargo> select = ObjectSelect.columnQuery(Cargo.class,property1).where(Expression.fromString("area>10")).select(ctx);
>> >
>> > the query executed select all the columns of cargo table.
>> >
>> > I need to specify which columns the queries must return because I have tables with hundreds of columns that I do not need, returning all the columns every time is very time consuming.
>> >
>> > Andrea
>>
>>
>>
>> --
>> Best regards,
>> Nikita Timofeev
> But if I do something like this:
>
> Property<String> property1 = Property.create("area", String.class);
> Property<Double> property2 = Property.create("voyage.flCost", Double.class);
> List<Object[]> select = ObjectSelect.query(Cargo.class).columns(property1,property2).select(ctx);
>
> There is the possibility to get a list of Cargo objects?


-- 
Best regards,
Nikita Timofeev