Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
MIME-Version: 1.0
In-Reply-To: <479ffcd60903262019x3cfe35e2u256337f69b9f74f4@mail.gmail.com>
References: <479ffcd60903260955l770d113aw6dde67e89d31de88@mail.gmail.com>
	 <3219fff70903261233n69492272lbb9e9632572f6118@mail.gmail.com>
	 <479ffcd60903262019x3cfe35e2u256337f69b9f74f4@mail.gmail.com>
Date: Fri, 27 Mar 2009 12:47:49 -0400
Message-ID: <5adb61290903270947qfb200a5u3ca034475499c263@mail.gmail.com>
Subject: Re: Internal row comparison in ExpressionFactory
From: Michael Gentry <mgentry@masslight.net>
To: user@cayenne.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Use "likeIgnoreCase" instead of "like" ...


On Thu, Mar 26, 2009 at 11:19 PM, John Armstrong <siberian@gmail.com> wrote=
:
> I couldn't quite get the EJBQL syntax right so I ended up using fromStrin=
g
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Expression qual =3D Expression.fromString(=
"code like $license and
> claimedunits < totalunits");
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0java.util.Map params =3D new java.util.Has=
hMap();
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0params.put("license", licenseCode.trim());
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0SelectQuery query =3D new SelectQuery(Lice=
nse.class,
> qual).queryWithParameters(params);
>
> Seemed to work although I need to tweak the like for case
> insensitivity. I'll do that tomorrow.
>
> Thanks-
> John-
>
> On Thu, Mar 26, 2009 at 12:33 PM, Andrey Razumovsky
> <razumovsky.andrey@gmail.com> wrote:
>> Hi John,
>>
>> You should try EJBQL:
>> select t0 from License t0 where t0.claimedunits < t0.totalunits AND ....
>>
>> http://cayenne.apache.org/doc/ejbqlquery.html
>>
>> 2009/3/26 John Armstrong <siberian@gmail.com>
>>
>>> Hi, I need to do a selection on a table partially based on comparing
>>> two elements
>>> of that table. Basically a 'total' and a 'current' where total is a
>>> changing value and needs to be compared to current to see if the row
>>> is valid. Its a floating license system for an app I am building.
>>>
>>> This obviously does not work since it expects a numeric, not a string,
>>> in the value:
>>>
>>> Expression qual =3D ExpressionFactory.likeIgnoreCaseExp(
>>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0com.pgi.Lice=
nse.CODE_PROPERTY,
>>> licenseCode.trim())
>>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0.andExp(
>>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 =A0 =A0ExpressionFactory.lessExp(
>>>
>>> com.pgi.License.CLAIMEDUNITS_PROPERTY,
>>>
>>> com.pgi.License.TOTALUNITS_PROPERTY));
>>>
>>> How can I get to to generate SQL like this :
>>>
>>> SELECT t0.license, t0.code, t0.licensetype, t0.product, t0.id,
>>> t0.validfrom, t0.totalunits, t0.user, t0.validto, t0.datecreated,
>>> t0.claimedunits FROM license t0 WHERE (UPPER(t0.code) LIKE
>>> UPPER('7GEN-BTPTDF')) AND (t0.claimedunits < t0.totalunits);
>>>
>>> How would I structure an Expression so that it does an internal
>>> comparison. I know an SQLTemplate can do it, is this one of those
>>> times that ExpressionFactory is not really suited to the task?
>>>
>>>
>>> J
>>>
>>
>