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