TestDatabaseConfig

CSVDataSetLoader.java

package com.github.apz.sample.mapper;
import org.dbunit.dataset.IDataSet;
import org.dbunit.dataset.csv.CsvDataSet;
import org.springframework.core.io.Resource;
import com.github.springtestdbunit.dataset.AbstractDataSetLoader;
public class CSVDataSetLoader extends AbstractDataSetLoader {
  @Override
  protected IDataSet createDataSet(Resource resource) throws Exception {
    return new CsvDataSet(resource.getFile());
  }
}

TestDatabaseConfig.java

package com.github.apz.sample.mapper;
import javax.sql.DataSource;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import com.github.springtestdbunit.bean.DatabaseDataSourceConnectionFactoryBean;
@Configuration
public class TestDatabaseConfig {
  @Bean(name = "dbUnitDatabaseConnection")
  public DatabaseDataSourceConnectionFactoryBean dbUnitDatabaseConnection(DataSource dataSource) {
    DatabaseDataSourceConnectionFactoryBean connectionFactory = new DatabaseDataSourceConnectionFactoryBean();
    connectionFactory.setDataSource(dataSource);
    return connectionFactory;
  }
}