@SuppressWarnings("unchecked") public TablePage getTablePage(TablePageQueryImpl tablePageQuery, int firstResult, int maxResults) { TablePage tablePage = new TablePage(); @SuppressWarnings("rawtypes") List tableData = getDbSqlSession().getSqlSession() .selectList("selectTableData", tablePageQuery, new RowBounds(firstResult, maxResults)); tablePage.setTableName(tablePageQuery.getTableName()); tablePage.setTotal(getTableCount(tablePageQuery.getTableName())); tablePage.setRows(tableData); tablePage.setFirstResult(firstResult); return tablePage; }
public void testGetTablePage() { String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); List<String> taskIds = generateDummyTasks(20); TablePage tablePage = managementService.createTablePageQuery() .tableName(tablePrefix + "ACT_RU_TASK") .listPage(0, 5); assertEquals(0, tablePage.getFirstResult()); assertEquals(5, tablePage.getSize()); assertEquals(5, tablePage.getRows().size()); assertEquals(20, tablePage.getTotal()); tablePage = managementService.createTablePageQuery() .tableName(tablePrefix + "ACT_RU_TASK") .listPage(14, 10); assertEquals(14, tablePage.getFirstResult()); assertEquals(6, tablePage.getSize()); assertEquals(6, tablePage.getRows().size()); assertEquals(20, tablePage.getTotal()); taskService.deleteTasks(taskIds, true); }
public void testGetSortedTablePage() { String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); List<String> taskIds = generateDummyTasks(15); // With an ascending sort TablePage tablePage = managementService.createTablePageQuery() .tableName(tablePrefix + "ACT_RU_TASK") .orderAsc("NAME_") .listPage(1, 7); String[] expectedTaskNames = new String[]{"B", "C", "D", "E", "F", "G", "H"}; verifyTaskNames(expectedTaskNames, tablePage.getRows()); // With a descending sort tablePage = managementService.createTablePageQuery() .tableName(tablePrefix + "ACT_RU_TASK") .orderDesc("NAME_") .listPage(6, 8); expectedTaskNames = new String[]{"I", "H", "G", "F", "E", "D", "C", "B"}; verifyTaskNames(expectedTaskNames, tablePage.getRows()); taskService.deleteTasks(taskIds, true); }
public void testGetTablePage() { String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); List<String> taskIds = generateDummyTasks(20); TablePage tablePage = managementService.createTablePageQuery() .tableName(tablePrefix + "ACT_RU_TASK") .listPage(0, 5); assertEquals(0, tablePage.getFirstResult()); assertEquals(5, tablePage.getSize()); assertEquals(5, tablePage.getRows().size()); assertEquals(20, tablePage.getTotal()); tablePage = managementService.createTablePageQuery() .tableName(tablePrefix + "ACT_RU_TASK") .listPage(14, 10); assertEquals(14, tablePage.getFirstResult()); assertEquals(6, tablePage.getSize()); assertEquals(6, tablePage.getRows().size()); assertEquals(20, tablePage.getTotal()); taskService.deleteTasks(taskIds, true); }
public void testGetSortedTablePage() { String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); List<String> taskIds = generateDummyTasks(15); // With an ascending sort TablePage tablePage = managementService.createTablePageQuery() .tableName(tablePrefix + "ACT_RU_TASK") .orderAsc("NAME_") .listPage(1, 7); String[] expectedTaskNames = new String[]{"B", "C", "D", "E", "F", "G", "H"}; verifyTaskNames(expectedTaskNames, tablePage.getRows()); // With a descending sort tablePage = managementService.createTablePageQuery() .tableName(tablePrefix + "ACT_RU_TASK") .orderDesc("NAME_") .listPage(6, 8); expectedTaskNames = new String[]{"I", "H", "G", "F", "E", "D", "C", "B"}; verifyTaskNames(expectedTaskNames, tablePage.getRows()); taskService.deleteTasks(taskIds, true); }
@SuppressWarnings("unchecked") public TablePage getTablePage(TablePageQueryImpl tablePageQuery, int firstResult, int maxResults) { TablePage tablePage = new TablePage(); @SuppressWarnings("rawtypes") List tableData = getDbSqlSession().getSqlSession() .selectList("selectTableData", tablePageQuery, new RowBounds(firstResult, maxResults)); tablePage.setTableName(tablePageQuery.getTableName()); tablePage.setTotal(getTableCount(tablePageQuery.getTableName())); tablePage.setRows(tableData); tablePage.setFirstResult(firstResult); return tablePage; }
@SuppressWarnings("unchecked") public TablePage getTablePage(TablePageQueryImpl tablePageQuery, int firstResult, int maxResults) { TablePage tablePage = new TablePage(); @SuppressWarnings("rawtypes") List tableData = getDbSqlSession().getSqlSession() .selectList("selectTableData", tablePageQuery, new RowBounds(firstResult, maxResults)); tablePage.setTableName(tablePageQuery.getTableName()); tablePage.setTotal(getTableCount(tablePageQuery.getTableName())); tablePage.setRows(tableData); tablePage.setFirstResult(firstResult); return tablePage; }