Java DefaultColumnFilter.includedColumnsTable方法代码示例

import org.dbunit.dataset.filter.DefaultColumnFilter; //导入方法依赖的package包/类
private void compareDbToDataSet(String filename) throws Exception
{
	
	IDataSet afterActualDataSet = getDbUnitconnection().createDataSet(); 
	IDataSet afterExpectedDataSet = loadDataSet(filename);
	
	
	ITableIterator iter = afterActualDataSet.iterator();
	while (iter.next()) {
		ITable actualTable = iter.getTable();
		ITable expectedTable = afterExpectedDataSet.getTable(actualTable.getTableMetaData().getTableName());
		Column[] expectedColumns = expectedTable.getTableMetaData().getColumns();
		//Expected table will be sorted by the columns present on expected file
		ITable sortedExpectedTable = new SortedTable(expectedTable, expectedColumns); 

		//Actual table will be sorted by the columns present on *expected* file.
		//It will be also filtered to only include tables present on expected file
		ITable filteredActualTable = DefaultColumnFilter.includedColumnsTable(actualTable, expectedColumns);
		ITable sortedFilteredActualTable = new SortedTable(filteredActualTable, expectedColumns);
		
	    Assertion.assertEquals(sortedExpectedTable, sortedFilteredActualTable); 
	}
}
 

import org.dbunit.dataset.filter.DefaultColumnFilter; //导入方法依赖的package包/类
/**
    * Asserts that the database is in a given state.
    * 
    * @param expectedState file name of dataset holding the expected state
    */
   @SuppressWarnings("deprecation")
protected void assertDatabaseState(String expectedState) throws Exception {
	// Fetch database data after executing your code
       IDataSet databaseDataSet = getConnection().createDataSet();
       IDataSet initialDataSet = new FlatXmlDataSet(new File(expectedState), false, true);
       
       // compare tables
       for (ITable table: initialDataSet.getTables()) {
       	ITable actualTable = databaseDataSet.getTable(table.getTableMetaData().getTableName());
       	ITable filteredTable = DefaultColumnFilter.includedColumnsTable(actualTable, 
                   table.getTableMetaData().getColumns());
       	Assertion.assertEquals(new SortedTable(table), new SortedTable(filteredTable));
       }
}
 

import org.dbunit.dataset.filter.DefaultColumnFilter; //导入方法依赖的package包/类
protected void assertTableEquals( Class peristentClass, String[] includedFields, IDataSet dataset ) throws Exception
{
    // Fetch database data after executing your code
    IDataSet databaseDataSet = getConnection().createDataSet();
    ITable actualTable = databaseDataSet.getTable( getTableName( peristentClass ) );
    ITable actualData = DefaultColumnFilter.includedColumnsTable( actualTable, getColumnNames( peristentClass, includedFields ) );

    // Load expected data from an XML dataset
    ITable expectedTable = dataset.getTable( getTableName( peristentClass ) );
    ITable expectedData = DefaultColumnFilter.includedColumnsTable( expectedTable, getColumnNames( peristentClass, includedFields ) );

    // Assert actual database table match expected table
    Assertion.assertEquals( expectedData, actualData );
}
 

import org.dbunit.dataset.filter.DefaultColumnFilter; //导入方法依赖的package包/类
protected void assertTableEquals(Class<?> peristentClass, String[] includedFields, IDataSet dataset) throws Exception {
    // Fetch database data after executing your code
    IDataSet databaseDataSet = getConnection().createDataSet();
    ITable actualTable = databaseDataSet.getTable(getTableName(peristentClass));
    ITable actualData =
        DefaultColumnFilter.includedColumnsTable(actualTable, getColumnNames(peristentClass, includedFields));

    // Load expected data from an XML dataset
    ITable expectedTable = dataset.getTable(getTableName(peristentClass));
    ITable expectedData =
        DefaultColumnFilter.includedColumnsTable(expectedTable, getColumnNames(peristentClass, includedFields));

    // Assert actual database table match expected table
    Assertion.assertEquals(expectedData, actualData);
}
 

import org.dbunit.dataset.filter.DefaultColumnFilter; //导入方法依赖的package包/类
/**
 * Convenience method for asserting equality between two tables, only considering the columns in the expected
 * dataset.
 * 
 * @param expected
 *            the expected dataset
 * @param actual
 *            the actual dataset
 * @throws DatabaseUnitException
 *             on DbUnit exceptions
 */
public void assertEquals(ITable expected, ITable actual) throws DatabaseUnitException {
    ITable actualFiltered = DefaultColumnFilter.includedColumnsTable(actual, expected.getTableMetaData().getColumns());
    Assertion.assertEquals(expected, actualFiltered);
}