|
public GetProperty ( string longPath ) : |
||
| longPath | string | |
| return | ||
private void AnalyzeGroupByClause(QupidCollection collection, GroupByClause group)
{
if (group != null)
{
if (group.Property.IsAggregate)
{
_compiler.ErrorManager.AddError("Cannot 'group by' an aggregate property " + group.Property.Path);
return;
}
var shortName = collection.ConvertToShortPath(group.Property.Path);
if (shortName == null)
{
_compiler.ErrorManager.AddError("The 'group by' property (" + group.Property.Path + ") is invalid.");
return;
}
var dbProp = collection.GetProperty(group.Property.Path);
if (dbProp.Type == "DateTime")
{
_compiler.ErrorManager.AddWarning("You really want to group by a DateTime value? Really?");
}
group.Property.Alias = "_id";
group.Property.AnalyzedName = shortName;
group.AggregateByProperty = group.Property;
if (_query.SelectProperties.Properties.Count(pr => pr.IsAggregate) > 1)
{
Fail("You can only include one 'COUNT' or 'SUM' property in your 'select'");
return;
}
group.AggregationProperty = _query.SelectProperties.Properties.SingleOrDefault(pr => pr.IsAggregate);
if (group.AggregationProperty == null)
{
_compiler.ErrorManager.AddWarning("The aggregation property was not specified. Include a '.COUNT' or '.SUM' in your select clause");
}
else if (group.AggregationProperty.AggregateType != AggregateTypes.Count)
{
var aggShortName = collection.ConvertToShortPath(group.AggregationProperty.Path);
if (aggShortName == null)
{
Fail("The Sum property is invalid - please append '.SUM' to the end of a valid numeric property name (ex: Donations.TotalAmount.SUM).");
return;
}
group.AggregationProperty.AnalyzedName = aggShortName;
}
//get only the first segment of the index (because the groupby must match that part currently)
var indexFirstProperties = collection.Indices.Select(i => i.ShortProperties.First());
var usesIndex = indexFirstProperties.Contains(shortName);
if (!usesIndex && collection.NumberOfRows < _compiler.MaxCollectionSizeWithNoIndex)
{
_compiler.ErrorManager.AddWarning("Group by (" + group.Property.Path + ") doesn't use an index. Running with caution");
}
else if (!usesIndex)
{
Fail("Group by (" + group.Property.Path + ") doesn't use an index. Collection too large to allow");
}
}
}
private void AnalyzeWhereClause(QupidCollection collection, List<WhereClause> list)
{
if (list != null)
{
var indexFound = list.Count == 0; //if the list is empty - don't worry about indexes
foreach (var where in list)
{
var prop = where.Property;
if (!prop.Collection.Equals(collection.Name, StringComparison.OrdinalIgnoreCase))
{
Fail("The 'where' property (" + prop.Path + ") is invalid.");
return;
}
var shortName = collection.ConvertToShortPath(prop.Path);
if (shortName == null)
{
_compiler.ErrorManager.AddError("The 'where' property (" + prop.Path + ") is invalid.");
return;
}
prop.AnalyzedName = shortName;
var dbProp = collection.GetProperty(prop.Path);
if (dbProp.Type == "DateTime")
{
where.AnalyzedValue = "new Date(" + where.LiteralValue + ")";
}
else if (dbProp.Type == "Boolean")
{
where.AnalyzedValue = (where.LiteralValue.ToString().Equals("1")) ? "true" : "false";
}
else if (dbProp.Type == "BsonObjectId")
{
where.AnalyzedValue = "ObjectId(" + where.LiteralValue + ")";
}
else
{
where.AnalyzedValue = where.LiteralValue.ToString();
}
// index checking
var usesIndex = collection.Indices.Select(i => i.ShortProperties.First()).Contains(shortName);
if (usesIndex)
{
indexFound = true;
}
}
//find the where clause(s) that don't use an index
if (!indexFound)
{
var smallCollection = collection.NumberOfRows < _compiler.MaxCollectionSizeWithNoIndex;
foreach (var where in list)
{
var shortName = collection.ConvertToShortPath(where.Property.Path);
if (shortName == null)
{
Fail("The 'where' property (" + where.Property.Path + ") is invalid.");
return;
}
var usesIndex = collection.Indices.Select(i => i.ShortProperties.First()).Contains(shortName);
if (!usesIndex && smallCollection)
{
_compiler.ErrorManager.AddWarning("Where clause (" + where.Property.Path + ") doesn't use an index. Proceed with caution");
}
else if (!usesIndex)
{
_compiler.ErrorManager.AddError("Where clause (" + where.Property.Path +
") doesn't use an index. Collection too large to run un-indexed");
}
}
}
}
}
