ERXEOAttribute tagNameAttribute = new ERXEOAttribute(_entity, _tagsRelationship.name() + "." + ERTag.NAME_KEY);
tagNameAttribute.setName("tagName");
fetchAttributes.addObject(tagNameAttribute);
ERXSQLHelper sqlHelper = ERXSQLHelper.newSQLHelper(_entity.model());
EOQualifier tagNameQualifier = new ERXKey<ERTag>(_tagsRelationship.name()).append(ERTag.NAME).in(tagNames);
EOFetchSpecification fetchSpec = new EOFetchSpecification(_entity.name(), tagNameQualifier, null);
EOSQLExpression sqlExpression = sqlHelper.sqlExpressionForFetchSpecification(editingContext, fetchSpec, 0, -1, fetchAttributes);
NSMutableArray<EOAttribute> groupByAttributes = new NSMutableArray<EOAttribute>();
groupByAttributes.addObjectsFromArray(pkAttrs);
sqlHelper.addGroupByClauseToExpression(groupByAttributes, sqlExpression);
sqlHelper.addHavingCountClauseToExpression(EOQualifier.QualifierOperatorEqual, tagNames.count(), sqlExpression);
// MS: Sketchy, I know, but I don't know how to make it do the
// join for me without also having the tag name field selected. I'm sure it's
// possible if I drop down and use lower level API's than
// sqlExpr.selectStatementForAttributes.
sqlHelper.removeSelectFromExpression(tagNameAttribute, sqlExpression);
NSMutableArray<Object> itemPrimaryKeys = new NSMutableArray<Object>();
NSArray<NSDictionary> rawRows = ERXEOAccessUtilities.rawRowsForSQLExpression(editingContext, _entity.model(), sqlExpression, pkAttrs);
EOAttribute pkAttr = pkAttrs.objectAtIndex(0);
for (NSDictionary rawRow : rawRows) {
Object pk = rawRow.objectForKey(pkAttr.name());
itemPrimaryKeys.addObject(pk);
}
NSMutableArray<EOAttribute> tagsFetchAttributes = new NSMutableArray<EOAttribute>();
// MS: We put this in just because we want to force it to do the join ... We have to
// pull them out later.
tagsFetchAttributes.addObjectsFromArray(_entity.primaryKeyAttributes());
ERXEOAttribute tagIDAttribute = new ERXEOAttribute(_entity, _tagsRelationship.name() + ".id");
tagIDAttribute.setName("id");
tagsFetchAttributes.addObject(tagIDAttribute);
tagsFetchAttributes.addObject(tagNameAttribute);
EOAttribute countAttribute = ERXEOAccessUtilities.createAggregateAttribute(editingContext, "COUNT", ERTag.NAME_KEY, _tagEntity.name(), Number.class, "i", "tagCount", "t2");
tagsFetchAttributes.addObject(countAttribute);
EOQualifier idQualifier = new ERXKey<Object>("id").in(itemPrimaryKeys);
EOFetchSpecification tagsFetchSpec = new EOFetchSpecification(_entity.name(), idQualifier, null);
EOSQLExpression tagsSqlExpression = sqlHelper.sqlExpressionForFetchSpecification(editingContext, tagsFetchSpec, 0, -1, tagsFetchAttributes);
NSMutableArray<EOAttribute> tagsGroupByAttributes = new NSMutableArray<EOAttribute>(new EOAttribute[] { tagNameAttribute, tagIDAttribute });
sqlHelper.addGroupByClauseToExpression(tagsGroupByAttributes, tagsSqlExpression);
// MS: This is lame, but the dynamic attribute is not properly resolved
// inside of EOSQLExpression because it's not actually part of the entity,
// so you can't order-by one of these attributes. So we just have to stick
// it on the end and hope for the best.
tagsSqlExpression.setStatement(tagsSqlExpression.statement() + " ORDER BY tagCount DESC");
for (EOAttribute attribute : _entity.primaryKeyAttributes()) {
sqlHelper.removeSelectFromExpression(attribute, tagsSqlExpression);
tagsFetchAttributes.removeObject(attribute);
}
NSMutableArray<String> relatedTagNames = new NSMutableArray<String>();
NSArray<NSDictionary> tagsRawRows = ERXEOAccessUtilities.rawRowsForSQLExpression(editingContext, _entity.model(), tagsSqlExpression, tagsFetchAttributes);