QueryUnique Broken!

[brain]

Changes in r655 seem to have removed the adhoc query abilities of the QueryUnique? method.

[jmoore]

More like queryUnique gone'' It's been replaced by findByQuery and findAllByQuery. These are intended to take a string identifier for a query. But if the StringQuerySource is configured (as it is by default), then the string identifier can itself be a HQL query.

There are some semantic differences. findByQuery returns an IObject. But there is no way for HQL to specify that there will be a uniqueResult as before. Therefore it's necessary to use the idiom: findAllByQuery().get(0)

  // in summary:
  // if you had a method like this
  (Image) iQuery.queryUnique(
     "from Image i where i.id = ?",
     new Object[]{ imgId }
  );

  // it will now be
  (Image) iQuery.findAllByQuery(
     "from Image i where i.id = :id",
     new Parameters().addId( imgId )
  ).get(0);

[callan]

Okay, how about something like this:

return (ExperimenterGroup) queryService.queryUnique(
                "select g from ExperimenterGroup as g join g.groupExperimenterMap as map where map.child = ?", new Object[] { experimenter });

What should be placed in the Parameters object?

[jmoore]

Change the HQL to this:

"select g from ExperimenterGroup as g 
   join g.groupExperimenterMap as map 
   where map.child.id = :id"

And your parameters are as above:

  new Parameters().addId( experimenter.getId() )