cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcin Skladaniec <mar...@ish.com.au>
Subject Re: NamedQuery / SQLTemplate keyPath validation
Date Tue, 10 Jun 2008 21:58:04 GMT
there is no simple way, see what I did in allRecordsCount in  
ListController. Yo wont translate IN statement and other easily though
Marcin

On 10/06/2008, at 4:26 PM, Lachlan Deck wrote:

> Hi there,
>
> (question related to ROP)
>
> say I've got an Expression (whether complex or otherwise) and I want  
> to utilise that Expression in a NamedQuery or SQLTemplate... what's  
> the easiest way to transform the expression to an sql equivalent  
> string? (i.e., such that, e.g.,, boolean values are transformed from  
> say true to 1 (if using an int column), dates are formatted  
> appropriately etc, comparison operators are transformed (e.g., != to  
> <>) etc.
>
> I see that there's a QueryAssembler and QualifierTranslator etc, but  
> what I'm looking for, I guess, is a something like  
> expression.toSQLString(baseEntity).
>
> Any suggestions?
>
> Thanks.
>
> with regards,
> --
>
> Lachlan Deck
>


Mime
View raw message