JarCastingDbUnit SQL
SQL dataset support for DbUnit and spring-test-dbunit extension for Spring test.
Description
Are equivalents:
-
SQL dataset:
insert into profile (id, key) values ('1st', 'first'); insert into user (id, email, profile_id) values (1, 'first@domain.org', '1st');
-
XML dataset:
<dataset> <profile id="1st" key="first"> <user id="1" email="first@domain.org" profile_id="1st"> </dataset>
Dependencies
To use SQL support, add this dependency to your pom.xml:
<dependency>
<groupId>fr.pinguet62</groupId>
<artifactId>dbunit-sql</artifactId>
<version>...</version>
</dependency>
It's necessary to add DbUnit and/or spring-test-dbunit dependencies, because this project use provided scope.
Usage
DbUnit (native)
From Getting Started:
// [...]
import fr.pinguet62.dbunit.sql.ext.SqlDataSet;
public class SqlTest extends DBTestCase {
// [...]
@Override
protected IDataSet getDataSet() throws Exception {
return new SqlDataSet(getClass().getResourceAsStream("/dataset.sql"));
// return new SqlDataSet(getClass().getResourceAsStream("insert into profile (id, key) values ('1st', 'first');"));
}
}
spring-test-dbunit (extension)
// [...]
import fr.pinguet62.dbunit.sql.springtest.SqlDataSetLoader;
// [...]
@TestExecutionListeners({ /*...,*/ TransactionDbUnitTestExecutionListener.class })
@DbUnitConfiguration(dataSetLoader = SqlDataSetLoader.class)
@DatabaseSetup("/dataset.sql")
public class SqlTest {
// [...]
}