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