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"); } } } } }