On Dec 30, 2009, at 9:59 PM, Andrus Adamchik wrote:
I'd like to see if a similar approach can be extended to query
building. Although that'll be a entirely different level of effort.
Or maybe it is not that hopeless and we can use a set of user-facing
query "builders" without affecting our backend implementations. Just
prototyped a builder that can create EJBQL/SelectQuery with
parameterized result type that can be tied to
ObjectContext.performQuery()...
public interface Query<T> ...
public class Select<T> implements Query<T>...
Here is now we can build correctly parameterized queries for different
result types. Also shows other EJBQL features, like subqueries. While
it adds some more terse API compared to SelectQuery, parameterization
is the main point here. I guess this is a good way to make EJBQLQuery
finally usable:
void query_newAPI_EntityResult() {
Select<Artist> query = Select.entity(Artist.class);
query.setDistinct();
Select<Painting> subquery = Select.entity(Painting.class);
subquery.setWhere(Painting.NAME.like("X%"));
Expression clause1 = Artist.NAME.eq("X");
Expression clause2 = Artist.PAINTINGS.dot(Painting.NAME).eq("Y");
Expression clause3 = Exists.in(subquery);
query.setWhere(All.of(clause1, clause2, clause3));
query.addOrderByAscending(Artist.NAME);
query.addOrderByAscending(Artist.PAINTINGS.dot(Painting.NAME));
query.addDisjointPrefetch(Artist.PAINTINGS);
}
void query_newAPI_ScalarResult() {
Select<Date> query = Select.scalar(Artist.class, Artist.DATE_OF_BIRTH);
Expression clause1 = Artist.NAME.eq("X");
Expression clause2 = Artist.PAINTINGS.dot(Painting.NAME).eq("Y");
query.setWhere(Any.of(clause1, clause2));
}
void query_newAPI_MixedResult() {
// fetching Artist entity plus paintings count
Select<Object[]> query = Select.mixed(Artist.class,
new Key<Artist>(""), Artist.PAINTINGS.count());
Expression clause1 = Artist.NAME.eq("X");
Expression clause2 = Artist.PAINTINGS.dot(Painting.NAME).eq("Y");
query.setWhere(Any.of(clause1, clause2));
}
void query_newAPI_GenericObject() {
Select<Persistent> query = Select.generic(Persistent.class,
"MyGenericEntity");
Expression clause1 = new Key<String>("name").eq("X");
Expression clause2 = new Key<Integer>("age").eq(5);
query.setWhere(All.of(clause1, clause2));
}
void query_newAPI_DataRow() {
Select<DataRow> query = Select.dataRow(Artist.class);
Expression clause1 = Artist.NAME.eq("X");
Expression clause2 = Artist.PAINTINGS.dot(Painting.NAME).eq("Y");
query.setWhere(All.of(clause1, clause2));
}
Andrus
