Employee.Department is mandatory; I want to search for and delete rogue departments.
-----Original Message----- From: Michael Gentry [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2008 2:08 PM To: [email protected] 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 <[EMAIL PROTECTED]> 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? >
