public void GetCommandText_CubeFilterAndMeasureGroupFilter_CorrectStatement()
{
var filters = new CaptionFilter[]
{
new CaptionFilter(Target.Perspectives, "cubeName")
, new CaptionFilter(Target.MeasureGroups, "measureGroupName")
};
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.StringContaining("[measuregroup_name]='measureGroupName'".ToLower()));
}
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);
}
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(), Is.Not.StringContaining("andand"));
}
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));
}
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, Is.Not.StringContaining("display").And.Not.StringContaining("folder"));
}
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"));
}
