protected override string Build(CaptionFilter filter) { if (filter.Target == DiscoveryTarget.Perspectives) { return(string.Format("[TABLE_SCHEMA]='{0}'", filter.Value)); } return(string.Empty); }
private IFilter BuildCaptionFilterForCaptionProperty(object src, DiscoveryTarget target) { var caption = GetPropertyValue(src, "Caption"); if (string.IsNullOrEmpty(caption)) { return(null); } var filter = new CaptionFilter(caption, target); return(filter); }
private IFilter BuildCaptionFilter(object src, string propertyName) { var caption = GetPropertyValue(src, propertyName); if (string.IsNullOrEmpty(caption)) { return(null); } var target = GetTargetForProperty(propertyName); var filter = new CaptionFilter(caption, target); return(filter); }
public void GetCommandText_CubeFilter_CorrectStatement() { var filters = new CaptionFilter[] { new CaptionFilter(Target.Perspectives, "cubeName") }; var builder = new MeasureDiscoveryCommandBuilder(); builder.Build(filters); var commandText = builder.GetCommandText(); Assert.That(commandText.Replace(" ", "").ToLower(), Is.StringContaining("[cube_name]='cubeName'".ToLower())); Assert.That(commandText.Replace(" ", "").ToLower(), Is.Not.StringContaining("[measuregroup_name]=".ToLower())); }
public void GetCommandText_CubeFilter_CorrectStatement() { var filters = new CaptionFilter[] { new CaptionFilter(Target.Perspectives, "cubeName") }; var builder = new DimensionDiscoveryCommandBuilder(); builder.Build(filters); var commandText = builder.GetCommandText(); Assert.That(commandText.Replace(" ", "").ToLower(), Does.Contain("[cube_name]='cubeName'".ToLower())); Assert.That(commandText.Replace(" ", "").ToLower(), Does.Not.Contain("[dimension_caption]=".ToLower())); }
public void GetCommandText_FiltersContainDisplayFolder_CommandFiltersDoesNotContainDoubleAnd() { var filters = new CaptionFilter[] { new CaptionFilter(Target.Perspectives, "my perspective") , new CaptionFilter(Target.DisplayFolders, "my display-folder") }; var builder = new SetDiscoveryCommandBuilder(); builder.Build(filters); var commandText = builder.GetCommandText(); Assert.That(commandText.Replace(" ", "").ToLower(), Does.Not.Contain("andand")); }
public void GetPostFilters_FiltersContainDisplayFolder_PostCommandFilterIsNotEmpty() { var filters = new CaptionFilter[] { new CaptionFilter(Target.Perspectives, "my perspective") , new CaptionFilter(Target.DisplayFolders, "my display-folder") }; var builder = new SetDiscoveryCommandBuilder(); builder.Build(filters); var postFilters = builder.GetPostFilters(); Assert.That(postFilters, Is.Not.Null.And.Not.Empty); }
protected override string Build(CaptionFilter filter) { var str = base.Build(filter); if (!String.IsNullOrEmpty(str)) { return(str); } if (filter.Target == DiscoveryTarget.Properties) { return(string.Format("[PROPERTY_CAPTION]='{0}'", filter.Value)); } return(string.Empty); }
protected override string Build(CaptionFilter filter) { var str = base.Build(filter); if (!String.IsNullOrEmpty(str)) { return(str); } if (filter.Target == DiscoveryTarget.Dimensions) { return(string.Format("[DIMENSION_UNIQUE_NAME]='[{0}]'", filter.Value)); } return(string.Empty); }
public void GetCommandText_FiltersContainDisplayFolder_DisplayFolderIsNotInCommandFilter() { var filters = new CaptionFilter[] { new CaptionFilter(Target.Perspectives, "my perspective") , new CaptionFilter(Target.DisplayFolders, "my display-folder") }; var builder = new SetDiscoveryCommandBuilder(); builder.Build(filters); var commandText = builder.GetCommandText().ToLower(); var filtersText = commandText.Substring(commandText.IndexOf(" from ")); Assert.That(filtersText, Does.Not.Contain("display").And.Not.Contain("folder")); }
protected override string Build(CaptionFilter filter) { var str = base.Build(filter); if (!String.IsNullOrEmpty(str)) { return(str); } if (filter.Target == DiscoveryTarget.MeasureGroups) { return(string.Format("[MEASUREGROUP_NAME]='{0}'", filter.Value)); } return(string.Empty); }
public void GetCommandText_FiltersContainDisplayFolder_DisplayFolderIsNotInCommandFilter() { var filters = new CaptionFilter[] { new CaptionFilter(Target.Perspectives, "my perspective") , new CaptionFilter(Target.Dimensions, "my dimension") , new CaptionFilter(Target.DisplayFolders, "my display-folder") , new CaptionFilter(Target.Hierarchies, "my hierarchy") }; var builder = new HierarchyDiscoveryCommandBuilder(); builder.Build(filters); var commandText = builder.GetCommandText(); Assert.That(commandText, Is.Not.StringContaining("Display").And.Not.StringContaining("Folder")); }
protected override string Build(CaptionFilter filter) { if (filter.Target == DiscoveryTarget.Perspectives) { return(string.Format("[CUBE_NAME]='{0}'", filter.Value)); } if (filter.Target == DiscoveryTarget.MeasureGroups) { return(string.Format("[MEASUREGROUP_NAME]='{0}'", filter.Value)); } if (filter.Target == DiscoveryTarget.Dimensions) { return(string.Format("[DIMENSION_UNIQUE_NAME]='[{0}]'", filter.Value)); } return(string.Empty); }
public void GetCommandText_CubeFilterMeasureGroupAndMeasureAndDisplayFolderFilter_CorrectPostFilter() { var filters = new CaptionFilter[] { new CaptionFilter(Target.Perspectives, "cubeName") , new CaptionFilter(Target.MeasureGroups, "measureGroupName") , new CaptionFilter(Target.Measures, "measureName") , new CaptionFilter(Target.DisplayFolders, "displayFolderName") }; var builder = new MeasureDiscoveryCommandBuilder(); builder.Build(filters); var postFilters = builder.GetPostFilters(); Assert.That(postFilters.Count(), Is.EqualTo(1)); }
protected override string Build(CaptionFilter filter) { var str = base.Build(filter); if (!String.IsNullOrEmpty(str)) { return(str); } if (filter.Target == DiscoveryTarget.Levels) { var dimFilter = FindFilter(DiscoveryTarget.Dimensions); var hieFilter = FindFilter(DiscoveryTarget.Hierarchies); return(string.Format("[LEVEL_UNIQUE_NAME]='[{0}].[{1}].[{2}]'", dimFilter.Value, hieFilter.Value, filter.Value)); } return(string.Empty); }
public void GetCommandText_CubeFilterMeasureGroupAndMeasureFilter_CorrectStatement() { var filters = new CaptionFilter[] { new CaptionFilter(Target.Perspectives, "cubeName") , new CaptionFilter(Target.MeasureGroups, "measureGroupName") , new CaptionFilter(Target.Measures, "measureName") }; var builder = new MeasureDiscoveryCommandBuilder(); builder.Build(filters); var commandText = builder.GetCommandText(); Assert.That(commandText.Replace(" ", "").ToLower(), Does.Contain("[cube_name]='cubeName'".ToLower())); Assert.That(commandText.Replace(" ", "").ToLower(), Does.Contain("[measuregroup_name]='measureGroupName'".ToLower())); Assert.That(commandText.Replace(" ", "").ToLower(), Does.Contain("[measure_caption]='measureName'".ToLower())); }
protected override string Build(CaptionFilter filter) { var str = base.Build(filter); if (!String.IsNullOrEmpty(str)) { return(str); } if (filter.Target == DiscoveryTarget.Measures) { return(string.Format("[MEASURE_UNIQUE_NAME]='[Measures].[{0}]'", filter.Value)); } if (filter.Target == DiscoveryTarget.DisplayFolders) { PostCommandFilters.Add(new DisplayFolderFilter(filter.Value)); } return(string.Empty); }
protected override string Build(CaptionFilter filter) { var str = base.Build(filter); if (!String.IsNullOrEmpty(str)) { return(str); } if (filter.Target == DiscoveryTarget.Hierarchies) { var dimFilter = FindFilter(DiscoveryTarget.Dimensions); return(string.Format("[HIERARCHY_UNIQUE_NAME]='[{0}].[{1}]'", dimFilter.Value, filter.Value)); } if (filter.Target == DiscoveryTarget.DisplayFolders) { PostCommandFilters.Add(new DisplayFolderFilter(filter.Value)); } return(string.Empty); }
protected abstract string Build(CaptionFilter filter);