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