@BeforeClass
public static void createDatabase() {
database = new DatabaseImpl();
database.url("jdbc:hsqldb:mem:.;sql.syntax_mys=true");
database.execute(
"CREATE TABLE auto_increment_id_entity (id INT AUTO_INCREMENT PRIMARY KEY, string_field VARCHAR(20), double_field DOUBLE, enum_field VARCHAR(10), date_time_field TIMESTAMP)");
repository = database.repository(AutoIncrementIdEntity.class);
}
@Before
public void truncateTable() {
database.execute("TRUNCATE TABLE auto_increment_id_entity");
}
@AfterClass
public static void cleanupDatabase() {
database.execute("DROP TABLE auto_increment_id_entity");
}