in api/src/main/java/com/google/appengine/api/datastore/ValidatedQuery.java [53:276]
private void validateQuery() {
if (query.propertyNameSize() > 0 && query.isKeysOnly()) {
throw new IllegalQueryException(
"projection and keys_only cannot both be set", IllegalQueryType.ILLEGAL_PROJECTION);
}
Set<String> projectionProperties = new HashSet<String>(query.propertyNameSize());
for (String property : query.propertyNames()) {
if (!projectionProperties.add(property)) {
throw new IllegalQueryException(
"cannot project a property multiple times", IllegalQueryType.ILLEGAL_PROJECTION);
}
}
Set<String> groupBySet = Sets.newHashSetWithExpectedSize(query.groupByPropertyNameSize());
for (String name : query.groupByPropertyNames()) {
if (!groupBySet.add(name)) {
throw new IllegalQueryException(
"cannot group by a property multiple times", IllegalQueryType.ILLEGAL_GROUPBY);
}
// TODO: Consider removing this check and relying on the backend to do this sort
// of validation. Note that there are use cases for special properties in projections and
// filters.
if (Entity.RESERVED_NAME.matcher(name).matches()) {
throw new IllegalQueryException(
"group by is not supported for the property: " + name,
IllegalQueryType.ILLEGAL_GROUPBY);
}
}
/* Validate group by properties in orderings. */
Set<String> groupByInOrderSet =
Sets.newHashSetWithExpectedSize(query.groupByPropertyNameSize());
for (Order order : query.orders()) {
if (groupBySet.contains(order.getProperty())) {
groupByInOrderSet.add(order.getProperty());
} else if (groupByInOrderSet.size() != groupBySet.size()) {
throw new IllegalQueryException(
"must specify all group by orderings before any non group by orderings",
IllegalQueryType.ILLEGAL_GROUPBY);
}
}
// Transaction requires ancestor
if (query.hasTransaction() && !query.hasAncestor()) {
throw new IllegalQueryException(
"Only ancestor queries are allowed inside transactions.",
IllegalQueryType.TRANSACTION_REQUIRES_ANCESTOR);
}
// Filters and sort orders require kind.
if (!query.hasKind()) {
for (Filter filter : query.filters()) {
if (!filter.getProperty(0).getName().equals(Entity.KEY_RESERVED_PROPERTY)) {
throw new IllegalQueryException(
"kind is required for non-__key__ filters", IllegalQueryType.KIND_REQUIRED);
}
}
for (Order order : query.orders()) {
if (!(order.getProperty().equals(Entity.KEY_RESERVED_PROPERTY)
&& order.getDirection() == Order.Direction.ASCENDING.getValue())) {
throw new IllegalQueryException(
"kind is required for all orders except __key__ ascending",
IllegalQueryType.KIND_REQUIRED);
}
}
}
/* Validate ancestor, if it exists. */
if (query.hasAncestor()) {
Reference ancestor = query.getAncestor();
if (!ancestor.getApp().equals(query.getApp())) {
throw new IllegalQueryException(
"The query app is " + query.getApp() + " but ancestor app is " + ancestor.getApp(),
IllegalQueryType.ILLEGAL_VALUE);
}
if (!ancestor.getNameSpace().equals(query.getNameSpace())) {
throw new IllegalQueryException(
"The query namespace is "
+ query.getNameSpace()
+ " but ancestor namespace is "
+ ancestor.getNameSpace(),
IllegalQueryType.ILLEGAL_VALUE);
}
}
// Check for unsupported filter values. We only support one property
// per filter and one property with an inequality filter.
String ineqProp = null;
this.isGeo = false;
for (Filter filter : query.filters()) {
int numProps = filter.propertySize();
if (numProps != 1) {
throw new IllegalQueryException(
String.format("Filter has %s properties, expected 1", numProps),
IllegalQueryType.FILTER_WITH_MULTIPLE_PROPS);
}
Property prop = filter.getProperty(0);
String propName = prop.getName();
/* Extra validation for __key__. The filter value must be a key,
* if the query has a kind, the key's kind must match, and the
* app and namespace must match the query. */
if (Entity.KEY_RESERVED_PROPERTY.equals(propName)) {
PropertyValue value = prop.getValue();
if (!value.hasReferenceValue()) {
throw new IllegalQueryException(
Entity.KEY_RESERVED_PROPERTY + " filter value must be a Key",
IllegalQueryType.ILLEGAL_VALUE);
}
ReferenceValue refVal = value.getReferenceValue();
if (!refVal.getApp().equals(query.getApp())) {
throw new IllegalQueryException(
Entity.KEY_RESERVED_PROPERTY
+ " filter app is "
+ refVal.getApp()
+ " but query app is "
+ query.getApp(),
IllegalQueryType.ILLEGAL_VALUE);
}
if (!refVal.getNameSpace().equals(query.getNameSpace())) {
throw new IllegalQueryException(
Entity.KEY_RESERVED_PROPERTY
+ " filter namespace is "
+ refVal.getNameSpace()
+ " but query namespace is "
+ query.getNameSpace(),
IllegalQueryType.ILLEGAL_VALUE);
}
}
if (INEQUALITY_OPERATORS.contains(filter.getOpEnum())) {
if (ineqProp == null) {
ineqProp = propName;
} else if (!ineqProp.equals(propName)) {
throw new IllegalQueryException(
String.format(
"Only one inequality filter per query is supported. "
+ "Encountered both %s and %s",
ineqProp, propName),
IllegalQueryType.MULTIPLE_INEQ_FILTERS);
}
} else if (filter.getOpEnum() == Operator.EQUAL) {
if (projectionProperties.contains(propName)) {
throw new IllegalQueryException(
"cannot use projection on a property with an equality filter",
IllegalQueryType.ILLEGAL_PROJECTION);
} else if (groupBySet.contains(propName)) {
throw new IllegalQueryException(
"cannot use group by on a property with an equality filter",
IllegalQueryType.ILLEGAL_GROUPBY);
}
} else if (filter.getOpEnum() == Operator.CONTAINED_IN_REGION) {
isGeo = true;
if (!filter.hasGeoRegion() || prop.getValue().hasPointValue()) {
throw new IllegalQueryException(
String.format(
"Geo-spatial filter on %s should specify GeoRegion rather than Property Value",
propName),
IllegalQueryType.UNSUPPORTED_FILTER);
}
GeoRegion region = filter.getGeoRegion();
if ((region.hasCircle() && region.hasRectangle())
|| (!region.hasCircle() && !region.hasRectangle())) {
throw new IllegalQueryException(
String.format(
"Geo-spatial filter on %s should specify Circle or Rectangle, but not both",
propName),
IllegalQueryType.UNSUPPORTED_FILTER);
}
} else if (UNSUPPORTED_OPERATORS.contains(filter.getOpEnum())) {
throw new IllegalQueryException(
String.format("Unsupported filter operator: %s", filter.getOp()),
IllegalQueryType.UNSUPPORTED_FILTER);
}
}
if (isGeo) {
if (ineqProp != null) {
throw new IllegalQueryException(
"Inequality filter with geo-spatial query is not supported.",
IllegalQueryType.UNSUPPORTED_FILTER);
}
if (query.hasAncestor()) {
throw new IllegalQueryException(
"Geo-spatial filter on ancestor query is not supported.",
IllegalQueryType.UNSUPPORTED_FILTER);
}
if (query.hasCompiledCursor() || query.hasEndCompiledCursor()) {
throw new IllegalQueryException(
"Start and end cursors are not supported on geo-spatial queries.",
IllegalQueryType.CURSOR_NOT_SUPPORTED);
}
}
if (ineqProp != null && query.groupByPropertyNameSize() > 0) {
if (!groupBySet.contains(ineqProp)) {
throw new IllegalQueryException(
String.format(
"Inequality filter on %s must also be a group by property when "
+ "group by properties are set.",
ineqProp),
IllegalQueryType.ILLEGAL_GROUPBY);
}
}
if (ineqProp != null) {
if (query.orderSize() > 0) {
if (!ineqProp.equals(query.getOrder(0).getProperty())) {
// First order must match the inequality filter.
throw new IllegalQueryException(
String.format(
"The first sort property must be the same as the property to which "
+ "the inequality filter is applied. In your query the first sort property "
+ "is %s but the inequality filter is on %s",
query.getOrder(0).getProperty(), ineqProp),
IllegalQueryType.FIRST_SORT_NEQ_INEQ_PROP);
}
}
}
}