@Test
public void testDoubleDbOpen() throws Exception {
clearDatabases();
ConnectionSource cs =
new JdbcConnectionSource(
"jdbc:h2:file:" + DATABASE_DIR + "/" + DATABASE_NAME_PREFIX + ".1");
TableUtils.createTable(cs, Foo.class);
Dao<Foo, Integer> dao = Instances.getDaoManager().createDao(cs, Foo.class);
Foo foo1 = new Foo();
foo1.val = 12312;
assertEquals(1, dao.create(foo1));
Foo result = dao.queryForId(foo1.id);
assertNotNull(result);
assertEquals(foo1.val, result.val);
// ==================================
cs =
new JdbcConnectionSource(
"jdbc:h2:file:" + DATABASE_DIR + "/" + DATABASE_NAME_PREFIX + ".2");
Instances.getDaoManager().clearCache();
TableUtils.createTable(cs, Foo.class);
dao = Instances.getDaoManager().createDao(cs, Foo.class);
Foo foo2 = new Foo();
foo2.val = 12314;
assertEquals(1, dao.create(foo2));
result = dao.queryForId(foo2.id);
assertNotNull(result);
assertEquals(foo2.val, result.val);
}
@Test
public void dateEqualityTest() throws ParseException {
Book book = new Book();
book.setId(1);
book.setReciever("Mario");
book.setAmountSent(2);
SimpleDateFormat sdf = new SimpleDateFormat("dd/M/yyyy");
Date date = sdf.parse("24/11/2014");
book.setDateRecieved(date);
Dao<Integer, Book> dao = dbLite.getDao(Book.class);
long rowID = dao.create(book);
Assert.assertEquals(book.getId(), rowID);
Book book2 = new Book();
book2.setId(2);
book2.setReciever("Mario");
book2.setAmountSent(2);
book2.setDateRecieved(new Date());
long rowID2 = dao.create(book2);
Assert.assertEquals(book2.getId(), rowID2);
List<Book> books = dao.findAll(null, null, "dateRecieved > ?", date);
Assert.assertTrue(books.size() > 0);
}
/** @see Dao#create(Collection) */
public int create(Collection<T> datas) {
try {
return dao.create(datas);
} catch (SQLException e) {
logMessage(e, "create threw exception on: " + datas);
throw new RuntimeException(e);
}
}
@Test
public void createMethodGetterAndSetterTest() {
Book book = new Book();
book.setDateRecieved(new Date());
book.setRecieved(true);
book.setReciever("some");
Dao<Integer, Book> dao = dbLite.getDao(Book.class);
long id = dao.create(book);
Assert.assertTrue(id > 0);
}
@Test
public void createEntityWithStringPrimaryKeyTest() {
NoteStringKey note = new NoteStringKey();
note.id = 2;
note.body = "Body Text";
note.author = "John Doe";
Dao<String, NoteStringKey> dao = dbLite.getDao(NoteStringKey.class);
long id = dao.create(note);
Assert.assertTrue(id > 0);
}
@Test
public void createMethodTest() {
Note note = new Note();
note.id = 2;
note.body = "Body Text";
note.author = "John Doe";
Dao<Integer, Note> dao = dbLite.getDao(Note.class);
long id = dao.create(note);
Assert.assertTrue(id > 0);
}
@Test(expected = NoSuitablePrimaryKeySuppliedException.class)
public void primaryKeyAutoGenerationTest() {
Book book = new Book();
Dao<Long, Book> dao = dbLite.getDao(Book.class);
long id = dao.create(book);
Assert.assertTrue("pimary key not auto generated", id > 0);
book.setId(10);
id = dao.create(book);
Assert.assertTrue("primary key not created manually", id == 10);
// Test Non Numeric PrimaryKey
NonNumeric nonNumeric = new NonNumeric();
Dao<String, NonNumeric> dao2 = dbLite.getDao(NonNumeric.class);
id = dao2.create(nonNumeric); // should throw NoSuitablePrimaryKeySuppliedException
nonNumeric.setId("mdennis");
id = dao2.create(nonNumeric);
Assert.assertTrue("Entity with Non-Numeric primary key not stored", id > 0);
}
@Override
public void create() throws SQLException {
String createStatement =
String.format(
"create table %s(%s VARCHAR(8), %s VARCHAR(32), %s VARCHAR(32), %s VARCHAR(64), %s VARCHAR(32), %s DATE, primary key (%s) )",
tableName,
Fields.IDENTIFIER,
Fields.FIRSTNAME,
Fields.LASTNAME,
Fields.EMAILADDRESS,
Fields.GAMERTAG,
Fields.BIRTHDATE,
Fields.IDENTIFIER);
System.out.println(createStatement);
super.create(createStatement);
}
@Test
public void privateFieldsGetterAndSetterMethodTest() {
Book book = new Book();
book.setId(1);
book.setReciever("Mario");
book.setAmountSent(2);
book.setDateRecieved(new Date());
book.setRecieved(true);
Dao<Integer, Book> dao = dbLite.getDao(Book.class);
long rowID = dao.create(book);
Assert.assertEquals(book.getId(), rowID);
Book bookDB = dao.findById(book.getId());
Assert.assertEquals(book.getReciever(), bookDB.getReciever());
Assert.assertEquals(book.getAmountSent(), bookDB.getAmountSent());
Assert.assertEquals(book.isRecieved(), bookDB.isRecieved());
Assert.assertEquals(book.getDateRecieved(), bookDB.getDateRecieved());
}
@Test(expected = NullPointerException.class)
public void createMethodThrowsNullPointExceptionWhenNullValuePassed() {
Dao<Integer, Note> noteDao = dbLite.getDao(Note.class);
noteDao.create(null);
}
