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