public void TestMultipleMIAM()
{
MultipleTestMIA src = TestCommonUtils.CreateMultipleMIA("Multiple", Cardinality.Inline, true, false);
TextWriter writer = new StringWriter();
XmlWriter serialiser = new XmlTextWriter(writer);
serialiser.WriteStartElement("Test");
src.Metadata.Serialize(serialiser);
serialiser.WriteEndElement();
Console.WriteLine("XML: {0}", writer);
XmlReader reader = XmlReader.Create(new StringReader(writer.ToString()));
reader.Read(); // Test tag
reader.Read(); // MIAM tag
MultipleMediaItemAspectMetadata dest = MediaItemAspectMetadata.Deserialize(reader) as MultipleMediaItemAspectMetadata;
Assert.IsNotNull(dest, "Dest");
Assert.AreEqual(src.Metadata.AspectId, dest.AspectId, "Aspect ID");
Assert.AreEqual(src.Metadata.AttributeSpecifications.Count, dest.AttributeSpecifications.Count, "Attribute spec count");
AssertMultipleMIAMSpec(src.Metadata.AttributeSpecifications.Values, dest.AttributeSpecifications.Values, src.ATTR_STRING);
Assert.IsNotNull(src.Metadata.UniqueAttributeSpecifications, "Source unique spec");
Assert.IsNotNull(dest.UniqueAttributeSpecifications, "Source unique spec");
Assert.AreEqual(src.Metadata.UniqueAttributeSpecifications.Count, dest.UniqueAttributeSpecifications.Count, "Attribute unique spec count");
AssertMultipleMIAMSpec(src.Metadata.UniqueAttributeSpecifications.Values, dest.UniqueAttributeSpecifications.Values, src.ATTR_ID);
}
public override object GetGroupByValue(MediaItem item)
{
MediaItemAspect aspect = null;
MediaItemAspectMetadata.AttributeSpecification attr = null;
if (_attrs != null)
{
attr = GetAttributeSpecification(item, _attrs, out aspect);
}
else if (_multiAttrs != null)
{
attr = GetAttributeSpecification(item, _multiAttrs, out aspect);
}
if (attr != null)
{
if (attr.IsCollectionAttribute)
{
IEnumerable <string> valueColl = aspect.GetCollectionAttribute <string>(attr);
if (valueColl != null)
{
List <string> values = new List <string>(valueColl);
if (_preSortAttributes)
{
values.Sort();
}
return(values.FirstOrDefault());
}
}
else
{
IList <MultipleMediaItemAspect> aspects;
MultipleMediaItemAspectMetadata metadata = attr.ParentMIAM as MultipleMediaItemAspectMetadata;
if (metadata != null && MediaItemAspect.TryGetAspects(item.Aspects, metadata, out aspects))
{
List <string> values = new List <string>();
foreach (MultipleMediaItemAspect multiAspect in aspects)
{
if (!string.IsNullOrEmpty(multiAspect.GetAttributeValue <string>(attr)))
{
values.Add(multiAspect.GetAttributeValue <string>(attr));
}
}
if (values.Count > 0)
{
if (_preSortAttributes)
{
values.Sort();
}
return(values.FirstOrDefault());
}
}
}
}
return(null);
}
public MultipleMIAQueryBuilder(MIA_Management miaManagement, IEnumerable <QueryAttribute> simpleSelectAttributes,
MultipleMediaItemAspectMetadata requestedMIA,
Guid[] mediaItemIds)
: base(miaManagement, simpleSelectAttributes,
null,
new List <MediaItemAspectMetadata> {
requestedMIA
}, new List <MediaItemAspectMetadata> {
},
new MediaItemIdFilter(mediaItemIds), null, null)
{
}
protected void FilterSelectedAspects(MultipleMediaItemAspectMetadata metadata, MultipleMediaItemAspectMetadata.MultipleAttributeSpecification indexAttribute)
{
IList <MultipleMediaItemAspect> aspects;
if (MediaItemAspect.TryGetAspects(_searchAspects, metadata, out aspects))
{
var relevantAspects = aspects.Where(p => _selectedEditionIndexes.Contains(p.GetAttributeValue <int>(indexAttribute)));
_searchAspects[metadata.AspectId].Clear();
foreach (var aspect in relevantAspects)
{
_searchAspects[metadata.AspectId].Add(aspect);
}
}
}
protected virtual void CompileStatementParts(MIA_Management miaManagement, IFilter filter, IFilter subqueryFilter, Namespace ns, BindVarNamespace bvNamespace,
ICollection <MediaItemAspectMetadata> requiredMIATypes, string outerMIIDJoinVariable, ICollection <TableJoin> tableJoins,
IList <object> resultParts, IList <BindVar> resultBindVars)
{
if (filter == null)
{
return;
}
MediaItemIdFilter mediaItemIdFilter = filter as MediaItemIdFilter;
if (mediaItemIdFilter != null)
{
ICollection <Guid> mediaItemIds = mediaItemIdFilter.MediaItemIds;
if (mediaItemIds.Count == 0)
{
resultParts.Add("1 = 2");
}
else
{
if (mediaItemIds.Count == 1)
{
resultParts.Add(outerMIIDJoinVariable);
BindVar bindVar = new BindVar(bvNamespace.CreateNewBindVarName("V"), mediaItemIds.First(), typeof(Guid));
resultParts.Add(" = @" + bindVar.Name);
resultBindVars.Add(bindVar);
}
else
{
bool first = true;
ICollection <string> clusterExpressions = new List <string>();
foreach (IList <Guid> mediaItemIdsCluster in CollectionUtils.Cluster(mediaItemIds, MAX_IN_VALUES_SIZE))
{
IList <string> bindVarRefs = new List <string>(MAX_IN_VALUES_SIZE);
foreach (Guid mediaItemId in mediaItemIdsCluster)
{
BindVar bindVar = new BindVar(bvNamespace.CreateNewBindVarName("V"), mediaItemId, typeof(Guid));
bindVarRefs.Add("@" + bindVar.Name);
resultBindVars.Add(bindVar);
}
if (!first)
{
resultParts.Add(" OR ");
}
first = false;
resultParts.Add(outerMIIDJoinVariable);
resultParts.Add(" IN (" + StringUtils.Join(", ", bindVarRefs) + ")");
}
resultParts.Add(StringUtils.Join(" OR ", clusterExpressions));
}
}
return;
}
BooleanCombinationFilter boolFilter = filter as BooleanCombinationFilter;
ICollection <IFilter> filterOperands = boolFilter?.Operands; //Work on collection reference to avoid chaning original
if (boolFilter != null && boolFilter.Operator == BooleanOperator.And && boolFilter.Operands.Count > 1 && boolFilter.Operands.ToList().All(x => x is IAttributeFilter))
{
ICollection <IFilter> remainingOperands = new List <IFilter>();
// Special case to do multiple MIA boolean logic first
IDictionary <Guid, ICollection <IAttributeFilter> > multiGroups = new Dictionary <Guid, ICollection <IAttributeFilter> >();
foreach (IAttributeFilter operand in filterOperands)
{
MultipleMediaItemAspectMetadata mmiam = operand.AttributeType.ParentMIAM as MultipleMediaItemAspectMetadata;
if (mmiam != null)
{
Guid key = operand.AttributeType.ParentMIAM.AspectId;
if (!multiGroups.ContainsKey(key))
{
multiGroups[key] = new List <IAttributeFilter>();
}
multiGroups[key].Add(operand);
}
else
{
remainingOperands.Add(operand);
}
}
if (multiGroups.Keys.Count > 0)
{
bool firstGroup = true;
foreach (ICollection <IAttributeFilter> filterGroup in multiGroups.Values)
{
if (firstGroup)
{
firstGroup = false;
}
else
{
resultParts.Add(" AND ");
}
bool firstItem = true;
foreach (IAttributeFilter filterItem in filterGroup)
{
MediaItemAspectMetadata.AttributeSpecification attributeType = filterItem.AttributeType;
if (firstItem)
{
resultParts.Add(outerMIIDJoinVariable);
resultParts.Add(" IN(");
resultParts.Add("SELECT ");
resultParts.Add(MIA_Management.MIA_MEDIA_ITEM_ID_COL_NAME);
resultParts.Add(" FROM ");
resultParts.Add(miaManagement.GetMIATableName(attributeType.ParentMIAM));
resultParts.Add(" WHERE ");
firstItem = false;
}
else
{
resultParts.Add(" AND ");
}
//Empty filter needs to be handled differently to other IAttribute filters
if (filterItem is EmptyFilter)
{
resultParts.Add(miaManagement.GetMIAAttributeColumnName(attributeType));
resultParts.Add(" IS NULL");
}
else
{
BuildAttributeFilterExpression(filterItem, miaManagement.GetMIAAttributeColumnName(attributeType), bvNamespace, resultParts, resultBindVars);
}
}
resultParts.Add(")");
}
// Process remaining operands ?
if (remainingOperands.Count == 0)
{
return;
}
resultParts.Add(" AND ");
filterOperands = remainingOperands;
}
}
if (boolFilter != null)
{
int numOperands = filterOperands.Count;
IEnumerator enumOperands = filterOperands.GetEnumerator();
if (!enumOperands.MoveNext())
{
return;
}
if (numOperands > 1)
{
resultParts.Add("(");
}
CompileStatementParts(miaManagement, (IFilter)enumOperands.Current, subqueryFilter, ns, bvNamespace,
requiredMIATypes, outerMIIDJoinVariable, tableJoins, resultParts, resultBindVars);
while (enumOperands.MoveNext())
{
switch (boolFilter.Operator)
{
case BooleanOperator.And:
resultParts.Add(" AND ");
break;
case BooleanOperator.Or:
resultParts.Add(" OR ");
break;
default:
throw new NotImplementedException(string.Format(
"Boolean filter operator '{0}' isn't supported by the media library", boolFilter.Operator));
}
CompileStatementParts(miaManagement, (IFilter)enumOperands.Current, subqueryFilter, ns, bvNamespace,
requiredMIATypes, outerMIIDJoinVariable, tableJoins, resultParts, resultBindVars);
}
if (numOperands > 1)
{
resultParts.Add(")");
}
return;
}
NotFilter notFilter = filter as NotFilter;
if (notFilter != null)
{
resultParts.Add("NOT (");
CompileStatementParts(miaManagement, notFilter.InnerFilter, subqueryFilter, ns, bvNamespace,
requiredMIATypes, outerMIIDJoinVariable, tableJoins, resultParts, resultBindVars);
resultParts.Add(")");
return;
}
FalseFilter falseFilter = filter as FalseFilter;
if (falseFilter != null)
{
resultParts.Add("1 = 2");
return;
}
// Must be done before checking IAttributeFilter - EmptyFilter is also an IAttributeFilter but must be
// compiled in a different way
EmptyFilter emptyFilter = filter as EmptyFilter;
if (emptyFilter != null)
{
MediaItemAspectMetadata.AttributeSpecification attributeType = emptyFilter.AttributeType;
requiredMIATypes.Add(attributeType.ParentMIAM);
Cardinality cardinality = attributeType.Cardinality;
if (cardinality == Cardinality.Inline || cardinality == Cardinality.ManyToOne)
{
resultParts.Add(new QueryAttribute(attributeType));
resultParts.Add(" IS NULL"); // MTO attributes are joined with left outer joins and thus can also be checked for NULL
}
else if (cardinality == Cardinality.OneToMany)
{
resultParts.Add("NOT EXISTS(");
resultParts.Add("SELECT 1");
resultParts.Add(" FROM ");
resultParts.Add(miaManagement.GetMIACollectionAttributeTableName(attributeType));
resultParts.Add(" V WHERE V.");
resultParts.Add(MIA_Management.MIA_MEDIA_ITEM_ID_COL_NAME);
resultParts.Add("=");
resultParts.Add(outerMIIDJoinVariable);
resultParts.Add(")");
}
else if (cardinality == Cardinality.ManyToMany)
{
resultParts.Add("NOT EXISTS(");
resultParts.Add("SELECT 1");
resultParts.Add(" FROM ");
resultParts.Add(miaManagement.GetMIACollectionAttributeNMTableName(attributeType));
resultParts.Add(" NM INNER JOIN ");
resultParts.Add(miaManagement.GetMIACollectionAttributeTableName(attributeType));
resultParts.Add(" V ON NM.");
resultParts.Add(MIA_Management.FOREIGN_COLL_ATTR_ID_COL_NAME);
resultParts.Add(" = V.");
resultParts.Add(MIA_Management.FOREIGN_COLL_ATTR_ID_COL_NAME);
resultParts.Add(" WHERE NM.");
resultParts.Add(MIA_Management.MIA_MEDIA_ITEM_ID_COL_NAME);
resultParts.Add("=");
resultParts.Add(outerMIIDJoinVariable);
resultParts.Add(")");
}
return;
}
// Must be done before checking IAttributeFilter - EmptyUserDataFilter is also an IAttributeFilter but must be
// compiled in a different way
EmptyUserDataFilter emptyUserDataFilter = filter as EmptyUserDataFilter;
if (emptyUserDataFilter != null)
{
BindVar userIdVar = new BindVar(bvNamespace.CreateNewBindVarName("V"), emptyUserDataFilter.UserProfileId, typeof(Guid));
resultParts.Add("NOT EXISTS(");
resultParts.Add("SELECT 1");
resultParts.Add(" FROM ");
resultParts.Add(UserProfileDataManagement_SubSchema.USER_MEDIA_ITEM_DATA_TABLE_NAME);
resultParts.Add(" WHERE ");
resultParts.Add(UserProfileDataManagement_SubSchema.USER_PROFILE_ID_COL_NAME);
resultParts.Add(" = @" + userIdVar.Name);
resultBindVars.Add(userIdVar);
resultParts.Add(" AND ");
resultParts.Add(UserProfileDataManagement_SubSchema.USER_DATA_KEY_COL_NAME);
resultParts.Add(" = '");
resultParts.Add(emptyUserDataFilter.UserDataKey);
resultParts.Add("' AND ");
resultParts.Add(UserProfileDataManagement_SubSchema.USER_DATA_VALUE_COL_NAME);
resultParts.Add(" IS NOT NULL ");
resultParts.Add(" AND ");
resultParts.Add(UserProfileDataManagement_SubSchema.USER_DATA_VALUE_COL_NAME);
resultParts.Add(" <> '' ");
resultParts.Add(" AND ");
resultParts.Add(MIA_Management.MIA_MEDIA_ITEM_ID_COL_NAME);
resultParts.Add("=");
resultParts.Add(outerMIIDJoinVariable);
resultParts.Add(")");
return;
}
AbstractRelationshipFilter relationshipFilter = filter as AbstractRelationshipFilter;
if (relationshipFilter != null)
{
resultParts.Add(outerMIIDJoinVariable);
resultParts.Add(" IN(");
BuildRelationshipSubquery(relationshipFilter, subqueryFilter, miaManagement, bvNamespace, resultParts, resultBindVars);
resultParts.Add(")");
return;
}
RelationalUserDataFilter relationalUserDataFilter = filter as RelationalUserDataFilter;
if (relationalUserDataFilter != null)
{
BindVar userIdVar = new BindVar(bvNamespace.CreateNewBindVarName("V"), relationalUserDataFilter.UserProfileId, typeof(Guid));
BindVar bindVar = new BindVar(bvNamespace.CreateNewBindVarName("V"), relationalUserDataFilter.FilterValue, typeof(string));
resultParts.Add("(EXISTS(");
resultParts.Add("SELECT 1");
resultParts.Add(" FROM ");
resultParts.Add(UserProfileDataManagement_SubSchema.USER_MEDIA_ITEM_DATA_TABLE_NAME);
resultParts.Add(" WHERE ");
resultParts.Add(UserProfileDataManagement_SubSchema.USER_PROFILE_ID_COL_NAME);
resultParts.Add(" = @" + userIdVar.Name);
resultBindVars.Add(userIdVar);
resultParts.Add(" AND ");
resultParts.Add(UserProfileDataManagement_SubSchema.USER_DATA_KEY_COL_NAME);
resultParts.Add(" = '");
resultParts.Add(relationalUserDataFilter.UserDataKey);
resultParts.Add("' AND (");
resultParts.Add(UserProfileDataManagement_SubSchema.USER_DATA_VALUE_COL_NAME);
switch (relationalUserDataFilter.Operator)
{
case RelationalOperator.EQ:
resultParts.Add(" = ");
break;
case RelationalOperator.NEQ:
resultParts.Add(" <> ");
break;
case RelationalOperator.LT:
resultParts.Add(" < ");
break;
case RelationalOperator.LE:
resultParts.Add(" <= ");
break;
case RelationalOperator.GT:
resultParts.Add(" > ");
break;
case RelationalOperator.GE:
resultParts.Add(" >= ");
break;
default:
throw new NotImplementedException(string.Format(
"Relational user data filter operator '{0}' isn't supported by the media library", relationalUserDataFilter.Operator));
}
resultParts.Add("@" + bindVar.Name);
resultBindVars.Add(bindVar);
if (relationalUserDataFilter.IncludeEmpty)
{
resultParts.Add(" OR ");
resultParts.Add(UserProfileDataManagement_SubSchema.USER_DATA_VALUE_COL_NAME);
resultParts.Add(" IS NULL ");
}
resultParts.Add(") AND ");
resultParts.Add(MIA_Management.MIA_MEDIA_ITEM_ID_COL_NAME);
resultParts.Add("=");
resultParts.Add(outerMIIDJoinVariable);
resultParts.Add(")");
if (relationalUserDataFilter.IncludeEmpty)
{
resultParts.Add(" OR NOT EXISTS(");
resultParts.Add("SELECT 1");
resultParts.Add(" FROM ");
resultParts.Add(UserProfileDataManagement_SubSchema.USER_MEDIA_ITEM_DATA_TABLE_NAME);
resultParts.Add(" WHERE ");
resultParts.Add(UserProfileDataManagement_SubSchema.USER_PROFILE_ID_COL_NAME);
resultParts.Add(" = @" + userIdVar.Name);
resultParts.Add(" AND ");
resultParts.Add(UserProfileDataManagement_SubSchema.USER_DATA_KEY_COL_NAME);
resultParts.Add(" = '");
resultParts.Add(relationalUserDataFilter.UserDataKey);
resultParts.Add("'");
resultParts.Add(" AND ");
resultParts.Add(MIA_Management.MIA_MEDIA_ITEM_ID_COL_NAME);
resultParts.Add("=");
resultParts.Add(outerMIIDJoinVariable);
resultParts.Add(")");
}
resultParts.Add(")");
return;
}
IAttributeFilter attributeFilter = filter as IAttributeFilter;
if (attributeFilter != null)
{
MediaItemAspectMetadata.AttributeSpecification attributeType = attributeFilter.AttributeType;
if (attributeType.ParentMIAM is MultipleMediaItemAspectMetadata)
{
resultParts.Add(outerMIIDJoinVariable);
resultParts.Add(" IN(");
resultParts.Add("SELECT ");
resultParts.Add(MIA_Management.MIA_MEDIA_ITEM_ID_COL_NAME);
resultParts.Add(" FROM ");
resultParts.Add(miaManagement.GetMIATableName(attributeType.ParentMIAM));
resultParts.Add(" WHERE ");
BuildAttributeFilterExpression(attributeFilter, miaManagement.GetMIAAttributeColumnName(attributeType), bvNamespace, resultParts, resultBindVars);
resultParts.Add(")");
return;
}
// For attribute filters, we have to create different kinds of expressions, depending on the
// cardinality of the attribute to be filtered.
// For Inline and MTO attributes, we simply create
//
// QA [Operator] [Comparison-Value]
//
// for OTM attributes, we create
//
// INNER JOIN [OTM-Value-Table] V ON V.MEDIA_ITEM_ID=[Outer-Join-Variable-Placeholder]
// WHERE [...] and V.VALUE [Operator] [Comparison-Value])
//
// for MTM attributes, we create
//
// INNER JOIN [MTM-NM-Table] NM ON NM.MEDIA_ITEM_ID=[Outer-Join-Variable-Placeholder]
// INNER JOIN [MTM-Value-Table] V ON NM.ID = V.ID
// WHERE [...] AND V.VALUE [Operator] [Comparison-Value])
requiredMIATypes.Add(attributeType.ParentMIAM);
Cardinality cardinality = attributeType.Cardinality;
if (cardinality == Cardinality.Inline || cardinality == Cardinality.ManyToOne)
{
BuildAttributeFilterExpression(attributeFilter, new QueryAttribute(attributeType), bvNamespace,
resultParts, resultBindVars);
}
else if (cardinality == Cardinality.OneToMany)
{
string joinTable = miaManagement.GetMIACollectionAttributeTableName(attributeType);
string attrName;
if (!_innerJoinedTables.TryGetValue(joinTable, out attrName))
{
TableQueryData tqd = new TableQueryData(joinTable);
tableJoins.Add(new TableJoin("LEFT OUTER JOIN", tqd,
new RequestedAttribute(tqd, MIA_Management.MIA_MEDIA_ITEM_ID_COL_NAME), outerMIIDJoinVariable));
attrName = new RequestedAttribute(tqd, MIA_Management.COLL_ATTR_VALUE_COL_NAME).GetQualifiedName(ns);
_innerJoinedTables.Add(joinTable, attrName);
}
BuildAttributeFilterExpression(attributeFilter, attrName, bvNamespace, resultParts, resultBindVars);
}
else if (cardinality == Cardinality.ManyToMany)
{
string miaCollectionAttributeNMTableName = miaManagement.GetMIACollectionAttributeNMTableName(attributeType);
string attrName;
if (!_innerJoinedTables.TryGetValue(miaCollectionAttributeNMTableName, out attrName))
{
TableQueryData tqdMiaCollectionAttributeNMTable = new TableQueryData(miaCollectionAttributeNMTableName);
tableJoins.Add(new TableJoin("LEFT OUTER JOIN", tqdMiaCollectionAttributeNMTable,
new RequestedAttribute(tqdMiaCollectionAttributeNMTable, MIA_Management.MIA_MEDIA_ITEM_ID_COL_NAME), outerMIIDJoinVariable));
TableQueryData tqdMiaCollectionAttributeTable = new TableQueryData(miaManagement.GetMIACollectionAttributeTableName(attributeType));
tableJoins.Add(new TableJoin("LEFT OUTER JOIN", tqdMiaCollectionAttributeTable,
new RequestedAttribute(tqdMiaCollectionAttributeNMTable, MIA_Management.FOREIGN_COLL_ATTR_ID_COL_NAME),
new RequestedAttribute(tqdMiaCollectionAttributeTable, MIA_Management.FOREIGN_COLL_ATTR_ID_COL_NAME)));
attrName = tqdMiaCollectionAttributeTable.GetAlias(ns) + "." + MIA_Management.COLL_ATTR_VALUE_COL_NAME;
_innerJoinedTables.Add(miaCollectionAttributeNMTableName, attrName);
}
BuildAttributeFilterExpression(attributeFilter, attrName, bvNamespace, resultParts, resultBindVars);
}
return;
}
throw new InvalidDataException("Filter type '{0}' isn't supported by the media library", filter.GetType().Name);
}
protected int CompareAttributes(MediaItem x, MediaItemAspect aspectX, MediaItemAspectMetadata.AttributeSpecification attrX, MediaItem y, MediaItemAspect aspectY, MediaItemAspectMetadata.AttributeSpecification attrY)
{
string firstValueX = null;
string firstValueY = null;
if (attrX.IsCollectionAttribute)
{
IEnumerable <string> collectionX = aspectX.GetCollectionAttribute <string>(attrX);
if (collectionX != null)
{
List <string> valuesX = new List <string>(collectionX);
if (_preSortAttributes)
{
valuesX.Sort();
}
firstValueX = valuesX.FirstOrDefault();
}
}
else
{
IList <MultipleMediaItemAspect> aspectsX;
MultipleMediaItemAspectMetadata metadata = attrX.ParentMIAM as MultipleMediaItemAspectMetadata;
if (metadata != null && MediaItemAspect.TryGetAspects(x.Aspects, metadata, out aspectsX))
{
List <string> valuesX = new List <string>();
foreach (MultipleMediaItemAspect aspect in aspectsX)
{
if (!string.IsNullOrEmpty(aspect.GetAttributeValue <string>(attrX)))
{
valuesX.Add(aspect.GetAttributeValue <string>(attrX));
}
}
if (valuesX.Count > 0)
{
if (_preSortAttributes)
{
valuesX.Sort();
}
firstValueX = valuesX.FirstOrDefault();
}
}
}
if (attrY.IsCollectionAttribute)
{
IEnumerable <string> collectionY = aspectY.GetCollectionAttribute <string>(attrY);
if (collectionY != null)
{
List <string> valuesY = new List <string>(collectionY);
if (_preSortAttributes)
{
valuesY.Sort();
}
firstValueY = valuesY.FirstOrDefault();
}
}
else
{
IList <MultipleMediaItemAspect> aspectsY;
MultipleMediaItemAspectMetadata metadata = attrY.ParentMIAM as MultipleMediaItemAspectMetadata;
if (metadata != null && MediaItemAspect.TryGetAspects(y.Aspects, metadata, out aspectsY))
{
List <string> valuesY = new List <string>();
foreach (MultipleMediaItemAspect aspect in aspectsY)
{
if (!string.IsNullOrEmpty(aspect.GetAttributeValue <string>(attrY)))
{
valuesY.Add(aspect.GetAttributeValue <string>(attrY));
}
}
if (valuesY.Count > 0)
{
if (_preSortAttributes)
{
valuesY.Sort();
}
firstValueY = valuesY.FirstOrDefault();
}
}
}
return(ObjectUtils.Compare(firstValueX, firstValueY));
}
private void AddMultipleMIAResults(ISQLDatabase database, ITransaction transaction, MultipleMediaItemAspectMetadata miam,
IDictionary <MediaItemAspectMetadata.AttributeSpecification, QueryAttribute> attributes, MainQueryBuilder builder,
IDictionary <Guid, ICollection <MultipleMediaItemAspect> > multipleMiaValues)
{
if (miam.IsTransientAspect)
{
return;
}
using (IDbCommand command = transaction.CreateCommand())
{
string mediaItemIdAlias;
IDictionary <MediaItemAspectMetadata, string> miamAliases;
// Maps (selected and filtered) QueryAttributes to CompiledQueryAttributes in the SQL query
IDictionary <QueryAttribute, string> qa2a;
string statementStr;
IList <BindVar> bindVars;
builder.GenerateSqlStatement(out mediaItemIdAlias, out miamAliases, out qa2a, out statementStr, out bindVars);
command.CommandText = statementStr;
foreach (BindVar bindVar in bindVars)
{
database.AddParameter(command, bindVar.Name, bindVar.Value, bindVar.VariableType);
}
//logger.Debug("Get multiple MIAs for {0}", string.Join(",", ids));
using (IDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Guid itemId = database.ReadDBValue <Guid>(reader, reader.GetOrdinal(mediaItemIdAlias));
//logger.Debug("Read record for {0}", itemId);
MultipleMediaItemAspect mia = new MultipleMediaItemAspect(miam);
foreach (MediaItemAspectMetadata.AttributeSpecification attr in miam.AttributeSpecifications.Values)
{
if (attr.Cardinality == Cardinality.Inline)
{
QueryAttribute qa = attributes[attr];
string alias = qa2a[qa];
//logger.Debug("Reading multiple MIA attibute " + attr.AttributeName + " #" + index + " from column " + alias);
mia.SetAttribute(attr, database.ReadDBValue(attr.AttributeType, reader, reader.GetOrdinal(alias)));
}
}
if (builder is InverseRelationshipQueryBuilder)
{
/*
* Swap the ID / role <--> linked role / linked ID
* "A is a movie starting actor B"
* becomes
* "B is an actor starting in movie A"
*/
Guid id = itemId;
Guid role = mia.GetAttributeValue <Guid>(RelationshipAspect.ATTR_ROLE);
itemId = mia.GetAttributeValue <Guid>(RelationshipAspect.ATTR_LINKED_ID);
mia.SetAttribute(RelationshipAspect.ATTR_ROLE, mia.GetAttributeValue <Guid>(RelationshipAspect.ATTR_LINKED_ROLE));
mia.SetAttribute(RelationshipAspect.ATTR_LINKED_ROLE, role);
mia.SetAttribute(RelationshipAspect.ATTR_LINKED_ID, id);
}
ICollection <MultipleMediaItemAspect> values;
if (!multipleMiaValues.TryGetValue(itemId, out values))
{
values = new List <MultipleMediaItemAspect>();
multipleMiaValues[itemId] = values;
}
values.Add(mia);
}
}
}
}
public static IList <MultipleMediaItemAspect> GetAspects(this MediaItem mediaItem, MultipleMediaItemAspectMetadata aspect)
{
IList <MultipleMediaItemAspect> values = null;
if (!MediaItemAspect.TryGetAspects(mediaItem.Aspects, aspect, out values))
{
return(null);
}
return(values);
}