public TimeSeriesFiltersTest()
{
UIMap = CodedUITestHelpers.UIMap;
_dataset = CodedUITestHelpers.SampleDataset();
_filterDateFormat = "dd-MMM-yyyy";
_udfDateFormat = "yyyy-MM-dd";
}
public void MyTestInitialize()
{
List <object> testPre = CodedUITestHelpers.PrepareTest();
_excelApp = (ExcelApp.Application)testPre[0];
_worksheet = (ExcelApp.Worksheet)testPre[1];
}
public void MyTestInitialize()
{
CodedUITestHelpers.SetupCodedUITest();
CodedUITestHelpers.CompleteStep1(_dataset.DatabaseCode);
CodedUITestHelpers.CompleteStep2(_dataset, _dataset.Name);
CodedUITestHelpers.CompleteStep3(null);
ResetFilterOptions();
}
public void DatasetTestCases1()
{
_dataset = CodedUITestHelpers.FreeDataset();
var filters = CodedUITestHelpers.filtersAllHistRdiff();
var expectedUDF = "=QSERIES(\"WIKI/FMC\",,,,\"rdiff\")";
CodedUITestHelpers.CompleteStep1("WIKI");
CodedUITestHelpers.CompleteStep2(_dataset, _dataset.Name);
CodedUITestHelpers.CompleteStep3(null);
CodedUITestHelpers.CompleteStep4(filters);
CodedUITestHelpers.CompleteStep5(false);
UIMap.AssertCorrectUDFSignature(expectedUDF);
UIMap.ClickInsertButton();
}
public void SelectAddAllColumns()
{
CodedUITestHelpers.CompleteStep1(_dataset.DatabaseCode);
CodedUITestHelpers.CompleteStep2(_dataset, _dataset.Name);
var allAvailableColumns = UIMap.GetAllAvailableColumns();
var expectedUDFSignature = datasetUDF(_dataset.Code, allAvailableColumns);
UIMap.AssertNumberOfColumnsSelected(0);
UIMap.ClickAddAllColumnsButton();
UIMap.AssertNumberOfColumnsSelected(UIMap.CountAvailableColumns());
UIMap.AssertCorrectUDFSignature(expectedUDFSignature);
}
public void DatatableTestCases5()
{
_datatable = CodedUITestHelpers.PremiumDatatable();
_datatableColumns = CodedUITestHelpers.ActionTypeMtickerStatusDatatableColumns();
var filters = CodedUITestHelpers.filtersAllHistRdiff();
var expectedUDF = "=QTABLE(\"ZACKS/HDM\",{\"action_type\",\"m_ticker\",\"status\"})";
CodedUITestHelpers.CompleteStep1("ZFA");
CodedUITestHelpers.CompleteStep2(_datatable, null);
CodedUITestHelpers.CompleteStep3(_datatableColumns);
CodedUITestHelpers.CompleteStep4(filters, false);
CodedUITestHelpers.CompleteStep5(false);
UIMap.AssertCorrectUDFSignature(expectedUDF);
UIMap.ClickInsertButton();
}
private string datasetUDF(string datasetCode, List <DataColumn> columns = null)
{
if (columns == null || columns.Count == 0)
{
return($"=QSERIES(\"{datasetCode}\")");
}
else if (columns.Count == 1)
{
return($"=QSERIES(\"{datasetCode}/{columns.First().Code}\")");
}
else
{
var columnNames = columns.Select(column => $"{_dataset.Code}/{column.Name.ToUpper()}").ToList();
return($"=QSERIES({CodedUITestHelpers.convertListToUDFArray(columnNames)})");
}
}
public void SelectDatasetColumns()
{
CodedUITestHelpers.CompleteStep1(_dataset.DatabaseCode);
CodedUITestHelpers.CompleteStep2(_dataset, _dataset.Name);
var columns = CodedUITestHelpers.SampleDatasetColumns();
columns.ForEach(delegate(DataColumn column)
{
UIMap.SelectColumn(column);
UIMap.AssertColumnAddedToSelection(column);
});
UIMap.AssertNumberOfColumnsSelected(columns.Count);
UIMap.AssertCorrectUDFSignature(datasetUDF(_dataset.Code, columns));
}
private string datatableUDF(string datatableCode, List <DataColumn> columns = null)
{
if (columns == null || columns.Count == 0)
{
return($"=QTABLE(\"{datatableCode}\")");
}
else if (columns.Count == 1)
{
return($"=QTABLE(\"{datatableCode}\",\"{columns[0].Name}\")");
}
else
{
var columnNames = columns.Select(column => column.Name).ToList();
return($"=QTABLE(\"{datatableCode}\",{CodedUITestHelpers.convertListToUDFArray(columnNames)})");
}
}
public void DatasetTestCases4()
{
var browseOptions = CodedUITestHelpers.selectStockUsSfone();
_dataset = CodedUITestHelpers.PremiumDataset();
_datasetColumns = CodedUITestHelpers.DateValueColumns();
var filters = CodedUITestHelpers.filtersAllHistRdiff();
var expectedUDF = "=QSERIES({\"SF1/SYPR_CURRENTRATIO_MRQ/DATE\",\"SF1/SYPR_CURRENTRATIO_MRQ/VALUE\"},,,,\"rdiff\")";
CodedUITestHelpers.CompleteBrowseStep1(browseOptions);
CodedUITestHelpers.CompleteStep2(_dataset, _dataset.Name);
CodedUITestHelpers.CompleteStep3(_datasetColumns);
CodedUITestHelpers.CompleteStep4(filters);
CodedUITestHelpers.CompleteStep5(false);
UIMap.AssertCorrectUDFSignature(expectedUDF);
UIMap.ClickInsertButton();
}
public void DatasetTestCases2()
{
var browseOptions = CodedUITestHelpers.selectStockUsMfOne();
_dataset = CodedUITestHelpers.FreeDataset();
_datasetColumns = CodedUITestHelpers.DateOpenHighLowCloseExDividendDatasetColumns();
var filters = CodedUITestHelpers.filtersAllHistQuarterlyDiff();
var expectedUDF = "=QSERIES({\"WIKI/FMC/DATE\",\"WIKI/FMC/OPEN\",\"WIKI/FMC/HIGH\",\"WIKI/FMC/LOW\",\"WIKI/FMC/CLOSE\",\"WIKI/FMC/EX-DIVIDEND\"},,\"quarterly\",,\"diff\")";
CodedUITestHelpers.CompleteBrowseStep1(browseOptions);
CodedUITestHelpers.CompleteStep2(_dataset, _dataset.Name);
CodedUITestHelpers.CompleteStep3(_datasetColumns);
CodedUITestHelpers.CompleteStep4(filters);
CodedUITestHelpers.CompleteStep5(false);
UIMap.AssertCorrectUDFSignature(expectedUDF);
UIMap.ClickInsertButton();
}
public void SelectDatatableColumns()
{
CodedUITestHelpers.CompleteStep1("ZCP");
CodedUITestHelpers.CompleteStep2(_datatable);
var columns = CodedUITestHelpers.SampleDatatableColumns();
for (int n = 0; n < columns.Count; n++)
{
UIMap.SelectColumn(columns[n]);
UIMap.AssertColumnAddedToSelection(columns[n]);
UIMap.AssertCorrectUDFSignature(datatableUDF(_datatable.Code, columns.GetRange(0, n + 1)));
}
;
UIMap.AssertNumberOfColumnsSelected(columns.Count);
UIMap.AssertCorrectUDFSignature(datatableUDF(_datatable.Code, columns));
}
public void RemoveAllColumnsFromSelection()
{
CodedUITestHelpers.CompleteStep1(_dataset.DatabaseCode);
CodedUITestHelpers.CompleteStep2(_dataset, _dataset.Name);
var columns = CodedUITestHelpers.SampleDatasetColumns();
UIMap.AssertNumberOfColumnsSelected(0);
UIMap.AssertCorrectUDFSignature(datasetUDF(_dataset.Code));
for (int n = 0; n < columns.Count; n++)
{
UIMap.SelectColumn(columns[n]);
UIMap.AssertNumberOfColumnsSelected(n + 1);
UIMap.AssertCorrectUDFSignature(datasetUDF(_dataset.Code, columns.GetRange(0, n + 1)));
}
UIMap.ClickRemoveAllColumnsButton();
UIMap.AssertNumberOfColumnsSelected(0);
UIMap.AssertCorrectUDFSignature(datasetUDF(_dataset.Code));
}
public void DatatableTestCases6()
{
UIMap.OpenLoginPage();
UIMap.LoginWithApiKey();
_datatable = CodedUITestHelpers.PremiumDatatable();
_datatableColumns = CodedUITestHelpers.MtickerDatatableColumns();
var filters = CodedUITestHelpers.filtersAllHistRdiff();
var expectedUDF = "=QTABLE(\"ZACKS/HDM\",\"m_ticker\")";
CodedUITestHelpers.CompleteStep1("ZFA");
CodedUITestHelpers.CompleteStep2(_datatable, null);
CodedUITestHelpers.CompleteStep3(_datatableColumns);
UIMap.ClickNextButton();
CodedUITestHelpers.CompleteStep5(false);
UIMap.AssertCorrectUDFSignature(expectedUDF);
UIMap.ClickInsertButton();
System.Threading.Thread.Sleep(3000);
var actualCellHeader = _worksheet.Cells[1, 1].Value2;
UIMap.AssertCorrectCellValue(actualCellHeader, "M_TICKER");
var actualCellValue = _worksheet.Cells[2, 1].Value2;
var numberOfAttempt = 0;
while (numberOfAttempt <= 5)
{
if (actualCellValue != null)
{
UIMap.AssertCorrectCellValue(actualCellHeader, "M_TICKER");
break;
}
else
{
numberOfAttempt += 1;
System.Threading.Thread.Sleep(3000);
}
}
}
public ColumnSelectionTest()
{
UIMap = CodedUITestHelpers.UIMap;
_dataset = CodedUITestHelpers.SampleDataset();
_datatable = CodedUITestHelpers.SampleDatatable();
}
public void MyTestCleanup()
{
CodedUITestHelpers.CompleteCodedUITest();
}
public void MyTestInitialize()
{
CodedUITestHelpers.SetupCodedUITest();
}
