Re: Fetching a list of objects from a list of primary keys

2016-09-14 Thread John Huss
rburgskaya > > > http://grokbase.com/t/cayenne/user/164cdjb5ts/fetching-a-list-of-objects-from-a-list-of-primary-keys > Confidentiality Notice: This e-mail and accompanying documents contain > confidential information intended for a specific individual and purpose. > This e-mailed i

Re: Fetching a list of objects from a list of primary keys

2016-09-14 Thread Oksana Peterburgskaya
one query otherwise we are hit with db-related performance issues. Thank you very much, Oksana Peterburgskaya http://grokbase.com/t/cayenne/user/164cdjb5ts/fetching-a-list-of-objects-from-a-list-of-primary-keys Confidentiality Notice: This e-mail and accompanying documents contain confidential i

Re: Fetching a list of objects from a list of primary keys

2016-04-14 Thread Hugi Thordarson
Great, thanks! - hugi > On 14. apr. 2016, at 08:50, Andrus Adamchik wrote: > > Here is a shorter version: > > ExpressionFactory.inDbExp( User.ID_PK_COLUMN, 1, 2, 3) > >> On Apr 14, 2016, at 11:15 AM, Hugi Thordarson wrote: >> >> Ah, of course, I can qualify on the DB path even if “id” is

Re: Fetching a list of objects from a list of primary keys

2016-04-14 Thread Andrus Adamchik
Here is a shorter version: ExpressionFactory.inDbExp( User.ID_PK_COLUMN, 1, 2, 3) > On Apr 14, 2016, at 11:15 AM, Hugi Thordarson wrote: > > Ah, of course, I can qualify on the DB path even if “id” is not a class > attribute. Is this the correct way to go about this? > > new ASTIn( new ASTDbP

Re: Fetching a list of objects from a list of primary keys

2016-04-14 Thread Hugi Thordarson
Ah, of course, I can qualify on the DB path even if “id” is not a class attribute. Is this the correct way to go about this? new ASTIn( new ASTDbPath( User.ID_PK_COLUMN ), new ASTList( someListOfIDs() ) ) Thanks, - hugi > On 14. apr. 2016, at 06:34, Andrus Adamchik wrote: > > Actually a sim

Re: Fetching a list of objects from a list of primary keys

2016-04-13 Thread Andrus Adamchik
Actually a simple IN qualifier should work. Andrus > On Apr 12, 2016, at 11:38 AM, Hugi Thordarson wrote: > > Hi all. > I have a list of primary keys [3,4,5,etc…] and I’d like to fetch all the > corresponding objects in one go. > Do I have to expose the primary key of my entity to do this or i

Fetching a list of objects from a list of primary keys

2016-04-12 Thread Hugi Thordarson
Hi all. I have a list of primary keys [3,4,5,etc…] and I’d like to fetch all the corresponding objects in one go. Do I have to expose the primary key of my entity to do this or is there some method like Cayenne.objectForPK() that can accept a list of keys and return multiple objects? Cheers, -