@Test
public void testTableCreationAndPersist() throws SQLException, ClassNotFoundException {
Class.forName("org.h2.Driver");
String databaseUrl = "jdbc:h2:res\\test\\db\\ormLiteDb";
ConnectionSource cs = new JdbcConnectionSource(databaseUrl);
TableUtils.createTableIfNotExists(cs, Event.class);
TableUtils.clearTable(cs, Event.class);
int count = 10;
String namePrefix = "Testinimi";
Dao<Event, Integer> eventDao = DaoManager.createDao(cs, Event.class);
for (int i = 0; i < count; i++) {
Event event = new Event();
event.setTitle(namePrefix + i);
eventDao.create(event);
}
assertTrue(eventDao.countOf() == count);
for (Iterator<Event> it = eventDao.iterator(); it.hasNext(); ) {
Event event = it.next();
assertTrue(event.getTitle().startsWith(namePrefix));
}
;
cs.close();
}
