cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hans Pikkemaat <h.pikkem...@tsi-solutions.nl>
Subject Re: Retrieving Records for a range of primary keys
Date Thu, 17 Dec 2009 14:59:44 GMT
Hi,

This works like a charm.

thanks

Hans

Andrey Razumovsky wrote:
> It has since 3.0. It's already in beta (and RC1 will likely be this year),
> so I advice you to switch.
> Otherwise, try
>
> Expression exp = new ASTBetween(new ASTDbPath(pathSpec), value1, value2);
>
> (not sure this is complatible with 2.0)
>
> 2009/12/17 Hans Pikkemaat <h.pikkemaat@tsi-solutions.nl>
>
>   
>> but the ExpressionFactory doesnt have betweenDbExp.
>>
>> I'm using version 2 btw
>>
>>
>> Andrey Razumovsky wrote:
>>
>>     
>>> Yeah, for range you'll need betweenDbExp, I just got mistreated with
>>> analogue to paginated queries, which use in
>>>
>>> 2009/12/17 Hans Pikkemaat <h.pikkemaat@tsi-solutions.nl>
>>>
>>>
>>>
>>>       
>>>> Hi,
>>>>
>>>> I guess this produces the 'IN' operator.
>>>> This would mean I need to produce all the key values in the range I want
>>>> to
>>>> retrieve?
>>>>
>>>> Is there not a betweenDbExp?
>>>>
>>>> tx
>>>>
>>>> Hans
>>>>
>>>>
>>>> Andrey Razumovsky wrote:
>>>>
>>>>
>>>>
>>>>         
>>>>> If you're using SelectQuery, Expression.inDbExp() is for you to go. See
>>>>> http://cayenne.apache.org/doc/path-expressions.html
>>>>>
>>>>> 2009/12/17 Hans Pikkemaat <h.pikkemaat@tsi-solutions.nl>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>           
>>>>>> Hi,
>>>>>>
>>>>>> Some paginated mechanisms are based on a persistence layer to be
able
>>>>>> to
>>>>>> retrieve records for a range of primary keys.
>>>>>>
>>>>>> I know it is possible to insert the primary key field in the definition
>>>>>> but
>>>>>> then I'm also required to populate it
>>>>>> when I create a record. I'm using a sequence generator to determine
the
>>>>>> key
>>>>>> value of a new record.
>>>>>>
>>>>>> So my question is: without having to insert the key field in the
>>>>>> definition, is it possible to query the table
>>>>>> by primary key range, and if yes, how?
>>>>>>
>>>>>> tx
>>>>>>
>>>>>> Hans Pikkemaat
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>             
>>>>>
>>>>>
>>>>>           
>>>>         
>>>
>>>
>>>       
>>     
>
>
>   



Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message