@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");
 }