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(), Does.Contain("[cube_name]='cubeName'".ToLower()));
Assert.That(commandText.Replace(" ", "").ToLower(), Does.Not.Contain("[measuregroup_name]=".ToLower()));
}
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_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(), Is.StringContaining("[cube_name]='cubeName'".ToLower()));
Assert.That(commandText.Replace(" ", "").ToLower(), Is.StringContaining("[measuregroup_name]='measureGroupName'".ToLower()));
Assert.That(commandText.Replace(" ", "").ToLower(), Is.StringContaining("[measure_caption]='measureName'".ToLower()));
}
