package org.unitils.dbmaintainer.locator;
import org.junit.AfterClass;
import org.junit.Assert;
import org.junit.BeforeClass;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.unitils.UnitilsJUnit4TestClassRunner;
import org.unitils.core.Unitils;
import org.unitils.database.DatabaseModule;
import org.unitils.database.SQLUnitils;
import org.unitils.dbunit.annotation.DataSet;
import org.unitils.dbunit.annotation.ExpectedDataSet;
/**
* Unit test for simple App.
* The test looks for xml files with the same name as the value of the {@link ResourceDataSet} on the classpath
* and gives the most recent.
* There are 2 files with the same name:
* <ul>
* <li>in the unitilsmodules</li>
* <li>in the TestAppResources module</li>
* </ul>
*
* @author tdr
*/
@RunWith(UnitilsJUnit4TestClassRunner.class)
@DataSet(value = "/org/unitils/testdata/exampleResourceData.xml")
public class ResourceLoadingClassTest {
@BeforeClass
public static void setUp() {
DatabaseModule databaseModule = Unitils.getInstance().getModulesRepository().getModuleOfType(DatabaseModule.class);
SQLUnitils.executeUpdate("CREATE TABLE dossier (id varchar(50), name varchar(50), Start_date date)", databaseModule.getWrapper("").getDataSource());
}
/*** */
@Test
@ExpectedDataSet("/org/unitils/testdata/exampleResourceData.xml")
public void testLoadingResource() {
//SqlAssert.assertCountSqlResult("select count(*) from dossier", 3L);
//SqlAssert.assertMultipleRowSqlResult("select * from dossier", new String[]{"DS-1", "TestAppResourcesBlack"}, new String[]{"DS-2", "n"}, new String[]{"DS-3", "decker"});
Assert.assertTrue(true);
}
@AfterClass
public static void afterClass() {
DatabaseModule databaseModule = Unitils.getInstance().getModulesRepository().getModuleOfType(DatabaseModule.class);
SQLUnitils.executeUpdate("drop table dossier",databaseModule.getWrapper("").getDataSource());
}
}