protected ColumnFilter createOrgUnitFilter(final OrganizationalUnit organizationalUnit) { return equalsTo(COLUMN_ORG, organizationalUnit.getName()); }
protected ColumnFilter createProjectFilter(WorkspaceProject project) { String repoAlias = project.getRepository().getAlias(); String projectName = project.getName(); String space = project.getOrganizationalUnit().getName(); return AND(equalsTo(COLUMN_REPO, repoAlias), equalsTo(COLUMN_PROJECT, projectName), equalsTo(COLUMN_ORG, space)); }
public FilterSettings createDefaultFilterSettingsPrototype(Long processInstanceId) { final FilterSettings filterSettings = createFilterSettings(PROCESS_INSTANCE_LOGS_DATASET, getSortByMap(), builder -> { builder.filter(equalsTo(COLUMN_LOG_PROCESS_INSTANCE_ID, processInstanceId)); } ); filterSettings.setTableDefaultSortColumnId(""); filterSettings.setKey(getDefaultFilterSettingsKey()); return filterSettings; }
@Test public void testViewInitialization() { DataSetFilter filter = new DataSetFilter(); ColumnFilter filter1 = FilterFactory.equalsTo("column1", "Test"); filter.addFilterColumn(filter1); DataSetFilterEditor filterEditor = new DataSetFilterEditor(filterView, beanManager, changedEvent); filterEditor.init(filter, metadata); assertEquals(filterView, filterEditor.view); verify(filterView).showNewFilterHome(); verify(filterView).addColumn("column1"); verify(filterView).addColumn("column2"); verify(filterView).addColumn("column3"); verify(filterView, times(filter.getColumnFilterList().size())).addColumnFilterEditor(any(ColumnFilterEditor.class)); }
@Test public void isFilteredByProcessIdTest() { final String processId = "testProc"; final DataSetFilter filter = new DataSetFilter(); filter.addFilterColumn(equalsTo(COLUMN_PROCESS_ID, processId)); final String filterProcessId = presenter.isFilteredByProcessId(Collections.<DataSetOp>singletonList(filter)); assertEquals(processId, filterProcessId); }
@Test public void isFilteredByProcessIdTest() { final String processId = "testProc"; final DataSetFilter filter = new DataSetFilter(); filter.addFilterColumn(equalsTo(COLUMN_PROCESS_ID, processId)); final String filterProcessId = presenter.isFilteredByProcessId(Collections.<DataSetOp>singletonList(filter)); assertEquals(processId, filterProcessId); }
@Test public void testFilterByStringWithPreProcessor() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(EXPENSE_REPORTS + "2") .filter(COLUMN_CITY, equalsTo("Barcelona")) .buildLookup()); //printDataSet(result); assertThat(result.getRowCount()).isEqualTo(0); }
@Test public void isFilteredByTaskNameTest() { final String taskName = "taskName"; final DataSetFilter filter = new DataSetFilter(); filter.addFilterColumn(equalsTo(COLUMN_NAME, taskName)); final String filterTaskName = getPresenter().isFilteredByTaskName(Collections.<DataSetOp>singletonList(filter)); assertEquals(taskName, filterTaskName); }
@Test public void testFilterByStringWithPreProcessor() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(EXPENSE_REPORTS + "2") .filter(COLUMN_CITY, equalsTo("Barcelona")) .buildLookup()); //printDataSet(result); assertThat(result.getRowCount()).isEqualTo(0); }
@Test public void testFilterEqualsByStringAnalyzed() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetFactory.newDataSetLookupBuilder() .dataset(EL_DATASET_UUID) .filter(ExpenseReportsData.COLUMN_EMPLOYEE, equalsTo(EL_EXAMPLE_EMP_NITA)) .sort(ExpenseReportsData.COLUMN_ID, SortOrder.ASCENDING) .buildLookup()); assertThat(result.getRowCount()).isEqualTo(4); assertDataSetValue(result, 0, 0, "9.00"); assertDataSetValue(result, 3, 0, "12.00"); }
@Test public void testFilterByString() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(EXPENSE_REPORTS) .filter(COLUMN_CITY, equalsTo("Barcelona")) .sort(COLUMN_ID, SortOrder.ASCENDING) .buildLookup()); //printDataSet(result); assertThat(result.getRowCount()).isEqualTo(6); assertDataSetValue(result, 0, 0, "1.00"); assertDataSetValue(result, 5, 0, "6.00"); }
@Test public void testDropTable() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(DataSetGroupTest.EXPENSE_REPORTS) .filter(COLUMN_EMPLOYEE, FilterFactory.equalsTo("David'; DROP TABLE 'EXPENSE_REPORTS; SELECT 'a' = 'a")) .buildLookup()); result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(DataSetGroupTest.EXPENSE_REPORTS) .buildLookup()); assertEquals(result.getRowCount(), 50); } }
@Test public void testDropTable() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(DataSetGroupTest.EXPENSE_REPORTS) .filter(COLUMN_EMPLOYEE, FilterFactory.equalsTo("David'; DROP TABLE 'EXPENSE_REPORTS; SELECT 'a' = 'a")) .buildLookup()); result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(DataSetGroupTest.EXPENSE_REPORTS) .buildLookup()); assertEquals(result.getRowCount(), 50); } }
@Test public void testAggregationAndFilterByNonAnalyzedField() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetFactory.newDataSetLookupBuilder() .dataset(EL_DATASET_UUID) .column(COUNT, "#items") .filter(ExpenseReportsData.COLUMN_DEPARTMENT, equalsTo(EL_EXAMPLE_DEPT_ENGINEERING)) .sort(ExpenseReportsData.COLUMN_ID, SortOrder.ASCENDING) .buildLookup()); assertThat(result.getRowCount()).isEqualTo(1); assertThat(result.getValueAt(0, 0)).isEqualTo(19d); }
@Test public void testORExpression() throws Exception { DataSet result = dataSetManager.lookupDataSet( DataSetLookupFactory.newDataSetLookupBuilder() .dataset(EXPENSE_REPORTS) .filter(COLUMN_AMOUNT, OR(NOT(greaterThan(100)), greaterThan(1000), equalsTo(COLUMN_ID, 1))) .sort(COLUMN_ID, SortOrder.ASCENDING) .buildLookup()); //printDataSet(result); assertThat(result.getRowCount()).isEqualTo(8); assertDataSetValue(result, 0, 0, "1.00"); assertDataSetValue(result, 1, 0, "2.00"); assertDataSetValue(result, 7, 0, "30.00"); }