Re: [castor-dev] in- or contains-operator

[michael simons]

Hello Alexey,

A list like the ones you showed would get rather large. I must assume about 
100 000 Tour instances that might be driven by the given vehicle, but I 
think I have to give it a try.

The contains operator was just a shot in the dark by me.

thanks,
michael
At 16:07 02.07.2003 +0400, you wrote:
Hi,

1. IN LIST operator support syntax like:

select o from Object o where id in list(1, 2, 3, 4), if values is
numeric and
select o from Object o where id in list("1", "2", "3", "4"), if values
is stringable
To perform automatical list OQL generation I use my framework
(http://sourceforge.net/projects/phantom-castor/) it have OQLPreparator
for it. For example:
List idList = new ArrayList();
idList.add("1");
idList.add("2");
idList.add("3");
String oql = OQLPreparator.prepareOQL(
  new Select(A.class),
  new WhereInList("id", idList)
);
The result will be:
SELECT o FROM package.to.class.A o WHERE id IN LIST("1", "2", "3")
2. What is "contains" operator? I don't know it... Are you sure that it
is avable now?
http://www.castor.org/oql.html#Syntax
Thanks!

-----Original Message-----
From: michael simons [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 3:53 PM
To: [EMAIL PROTECTED]
Subject: [castor-dev] in- or contains-operator
Hi all,

I want to do a query like the following

query = db.getOQLQuery("select t from Tour where $1 in
LIST(t.vehicles)"); query.bind(aVehicle);
or

query = db.getOQLQuery("select t from Tour where t.vehicles
contains($1)"); query.bind(aVehicle);
Does anybody know how to do this (both my attempts lead to exceptions)?

Regards,
michael
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev
----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
       unsubscribe castor-dev