protected static void printResult(ITable resultTable) throws DataSetException { StringBuilder sb = new StringBuilder(); int columnCount = resultTable.getTableMetaData().getColumns().length; String[] columns = new String[columnCount]; for (int i = 0; i < columnCount; i++) { sb.append(resultTable.getTableMetaData().getColumns()[i].getColumnName()); sb.append("-"); sb.append(resultTable.getTableMetaData().getColumns()[i].getDataType()); sb.append("\t"); columns[i] = resultTable.getTableMetaData().getColumns()[i].getColumnName(); } sb.append("\n"); for (int i = 0; i < resultTable.getRowCount(); i++) { for (int j = 0; j < columns.length; j++) { sb.append(resultTable.getValue(i, columns[j])); sb.append("\t"); } sb.append("\n"); } System.out.println(sb.toString()); }
protected ITable executeDynamicQuery(IDatabaseConnection dbConn, String queryName, String sql, List<String> parameters, boolean needSort) throws Exception { // change join type to match current setting sql = changeJoinType(sql, joinType); PreparedStatement prepStat = dbConn.getConnection().prepareStatement(sql); for (int j = 1; j <= parameters.size(); ++j) { prepStat.setString(j, parameters.get(j - 1).trim()); } ITable queryTable = dbConn.createTable(resultTableName + queryName, prepStat); String[] columnNames = new String[queryTable.getTableMetaData().getColumns().length]; for (int i = 0; i < columnNames.length; i++) { columnNames[i] = queryTable.getTableMetaData().getColumns()[i].getColumnName(); } if (needSort) { queryTable = new SortedTable(queryTable, columnNames); } // printResult(queryTable); return queryTable; }
protected ITable executeQuery(IDatabaseConnection dbConn, String queryName, String sql, boolean needSort) throws Exception { // change join type to match current setting sql = changeJoinType(sql, joinType); ITable queryTable = dbConn.createQueryTable(resultTableName + queryName, sql); String[] columnNames = new String[queryTable.getTableMetaData().getColumns().length]; for (int i = 0; i < columnNames.length; i++) { columnNames[i] = queryTable.getTableMetaData().getColumns()[i].getColumnName(); } if (needSort) { queryTable = new SortedTable(queryTable, columnNames); } // printResult(queryTable); return queryTable; }
public void assertEquals(ITable expectedTable, ITable actualTable, List<IColumnFilter> columnFilters) throws DatabaseUnitException { Set<String> ignoredColumns = getColumnsToIgnore(expectedTable.getTableMetaData(), actualTable.getTableMetaData(), columnFilters); Assertion.assertEqualsIgnoreCols(expectedTable, actualTable, ignoredColumns.toArray(new String[ignoredColumns.size()])); }
public void assertEquals(ITable expectedTable, ITable actualTable, List<IColumnFilter> columnFilters) throws DatabaseUnitException { Set<String> ignoredColumns = getColumnsToIgnore(expectedTable.getTableMetaData(), actualTable.getTableMetaData(), columnFilters); Assertion.assertEqualsIgnoreCols(expectedTable, actualTable, ignoredColumns.toArray(new String[ignoredColumns.size()])); }
/** * Gets the primary key column names for the given DbUnit table. * * @param dbUnitTable The DbUnit table, not null * @return The pk column names, empty if none found */ protected List<String> getPrimaryKeyColumnNames(ITable dbUnitTable) throws DataSetException { List<String> result = new ArrayList<String>(); for (org.dbunit.dataset.Column column : dbUnitTable.getTableMetaData().getPrimaryKeys()) { result.add(column.getColumnName()); } return result; }
public static List<String> extractColumnsNotSpecifiedInExpectedDataSet(final ITable expectedTableState, final ITable currentTableState) throws DataSetException { final Set<String> allColumns = new HashSet<String>(extractColumnNames(currentTableState.getTableMetaData().getColumns())); final Set<String> expectedColumnNames = new HashSet<String>(extractColumnNames(expectedTableState.getTableMetaData().getColumns())); return extractNonExistingColumns(allColumns, expectedColumnNames); }
public static List<String> extractColumnsNotSpecifiedInExpectedDataSet(final ITable expectedTableState, final ITable currentTableState) throws DataSetException { final Set<String> allColumns = new HashSet<String>(extractColumnNames(currentTableState.getTableMetaData().getColumns())); final Set<String> expectedColumnNames = new HashSet<String>(extractColumnNames(expectedTableState.getTableMetaData().getColumns())); return extractNonExistingColumns(allColumns, expectedColumnNames); }
private static ITable filterTable(ITable table, IColumnFilter filter) throws DataSetException { FilteredTableMetaData metaData = new FilteredTableMetaData(table.getTableMetaData(), filter); return new CompositeTable(metaData, table); } }
public static List<String> extractColumnsNotSpecifiedInExpectedDataSet(final ITable expectedTableState, final ITable currentTableState) throws DataSetException { final Set<String> allColumns = new HashSet<String>(extractColumnNames(currentTableState.getTableMetaData().getColumns())); final Set<String> expectedColumnNames = new HashSet<String>(extractColumnNames(expectedTableState.getTableMetaData().getColumns())); return extractNonExistingColumns(allColumns, expectedColumnNames); }
@Override public String[] getTableNames() throws DataSetException { ITable[] tables = getTables(); String[] tableNames = new String[tables.length]; for (int i = 0; i < tables.length; i++) { tableNames[i] = tables[i].getTableMetaData().getTableName(); } return tableNames; }
public static List<String> extractColumnsNotSpecifiedInExpectedDataSet(final ITable expectedTableState, final ITable currentTableState) throws DataSetException { final Set<String> allColumns = new HashSet<String>(extractColumnNames(currentTableState.getTableMetaData().getColumns())); final Set<String> expectedColumnNames = new HashSet<String>(extractColumnNames(expectedTableState.getTableMetaData().getColumns())); return extractNonExistingColumns(allColumns, expectedColumnNames); }
private ITable filter(final ITable table, final String[] columnsToFilter) throws DataSetException { ITable filteredTable = DefaultColumnFilter.excludedColumnsTable(table, Columns.findColumnsByName(columnsToFilter, table.getTableMetaData())); return applyCustomFilters(filteredTable); }
@Override public void assertEquals(ITable expectedSortedTable, ITable actualSortedTable, List<IColumnFilter> columnFilters) throws DatabaseUnitException { Column[] expectedColumns = expectedSortedTable.getTableMetaData().getColumns(); expectedSortedTable = new SortedTable(expectedSortedTable, expectedColumns); actualSortedTable = new SortedTable(actualSortedTable, expectedColumns); super.assertEquals(expectedSortedTable, actualSortedTable, columnFilters); }
public ITableMetaData getTableMetaData() { ITableMetaData meta = delegate.getTableMetaData(); try { return new DefaultTableMetaData(tableName, meta.getColumns(), meta.getPrimaryKeys()); } catch (DataSetException e) { throw new QtafException("Don't get the meta info from " + meta, e); } }
@Override public void assertEquals(ITable expectedSortedTable, ITable actualSortedTable, List<IColumnFilter> columnFilters) throws DatabaseUnitException { Column[] expectedColumns = expectedSortedTable.getTableMetaData().getColumns(); expectedSortedTable = new SortedTable(expectedSortedTable, expectedColumns); actualSortedTable = new SortedTable(actualSortedTable, expectedColumns); super.assertEquals(expectedSortedTable, actualSortedTable, columnFilters); }
private void collectErrors(AssertionErrorCollector errorCollector, List<Difference> diffs) { for (Difference diff : diffs) { final String tableName = diff.getActualTable().getTableMetaData().getTableName(); errorCollector.collect( new AssertionError(String.format(DIFF_ERROR, tableName, diff.getRowIndex(), diff.getColumnName(), diff.getExpectedValue(), diff.getActualValue()))); } }
private void collectErrors(AssertionErrorCollector errorCollector, List<Difference> diffs) { for (Difference diff : diffs) { final String tableName = diff.getActualTable().getTableMetaData().getTableName(); errorCollector.collect( new AssertionError(String.format(DIFF_ERROR, tableName, diff.getRowIndex(), diff.getColumnName(), diff.getExpectedValue(), diff.getActualValue()))); } }
private void collectErrors(AssertionErrorCollector errorCollector, List<Difference> diffs) { for (Difference diff : diffs) { final String tableName = diff.getActualTable().getTableMetaData().getTableName(); errorCollector.collect(String.format(DIFF_ERROR, tableName, diff.getRowIndex(), diff.getColumnName(), diff.getExpectedValue(), diff.getActualValue())); } }
private void collectErrors(AssertionErrorCollector errorCollector, List<Difference> diffs) { for (Difference diff : diffs) { final String tableName = diff.getActualTable().getTableMetaData().getTableName(); errorCollector.collect(String.format(DIFF_ERROR, tableName, diff.getRowIndex(), diff.getColumnName(), diff.getExpectedValue(), diff.getActualValue())); } }