Employee.Department is mandatory; I want to search for and delete rogue
departments.
-----Original Message-----
From: Michael Gentry [mailto:blacknex..mail.com]
Sent: Thursday, March 06, 2008 2:08 PM
To: use..ayenne.apache.org
Subject: Re: Get the number of FKs
It seems you mainly want a list of employees who are not in a
department, so doing a fetch on Employee where "department = null"
might work (I'm not positive I've ever tried this, but it seems logical
to me).
/dev/mrg
On Thu, Mar 6, 2008 at 1:58 PM, Scott Anderson <sanderso..irvana.com>
wrote:
> I've got a one-to-many relationship (employees belong to a
> department), and I'd like to search for departments that have no
employees.
> Currently, I have something like:
>
> foreach(dept : departments) {
> if(dept.getEmployees().size() == 0)
> context.deleteObject(dept);
> }
>
> When I do this, it has the effect of telling Cayenne to fetch data
> rows for every employee in the database; this will not scale well. Is
> there any way I can get the size of the array without doing a custom
> SELECT query?
>
This archive was generated by hypermail 2.0.0 : Thu Mar 06 2008 - 15:19:46 EST