@Test public void findAllWithWhereClauseTest() { Date date = new Date(); @SuppressWarnings("deprecation") Date laterDate = new Date(date.getYear() + 1, 2, 4); ContentValues values = new ContentValues(); values.put("id", 1); values.put("body", "text"); values.put("date", date.getTime()); long id = db.insert("Note", null, values); Assert.assertTrue("Note instance not created", id > 0); values = new ContentValues(); values.put("id", 2); values.put("body", "text"); values.put("date", laterDate.getTime()); id = db.insert("Note", null, values); Assert.assertTrue("Note instance not created", id > 0); Dao<Integer, Note> dao = dbLite.getDao(Note.class); List<Note> notes = dao.findAll(null, null, "id=? AND body=?", "1", "text"); Assert.assertTrue("Empty List<Note> Returned", !notes.isEmpty()); Assert.assertEquals(1, notes.get(0).id); notes = dao.findAll(null, null, "date >= ?", date); Assert.assertTrue("Empty List<Note> Returned", !notes.isEmpty()); Assert.assertEquals(2, notes.size()); }
@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); }
@Test public void findAllMethodInstancesAddedToListTest() { ContentValues values = new ContentValues(); values.put("id", 1); values.put("body", "text"); long id = db.insert("Note", null, values); Assert.assertTrue(id > 0); Dao<Integer, Note> dao = dbLite.getDao(Note.class); List<Note> notes = dao.findAll(); Assert.assertTrue(notes.size() > 0); }
@Test public void findAllOrderByTest() { ContentValues values = new ContentValues(); values.put("id", 11); values.put("body", "text"); values.put("date", new Date().getTime()); long id = db.insert("Note", null, values); Assert.assertTrue("Note instance not created", id > 0); values.put("id", 15); values.put("date", new Date().getTime()); long id2 = db.insert("Note", null, values); Assert.assertTrue("Note instance not created", id > 0); Dao<Integer, Note> dao = dbLite.getDao(Note.class); List<Note> notes = dao.findAll("date", OrderByType.ASC, null); Assert.assertTrue("Empty List<Note> Returned", !notes.isEmpty()); Assert.assertEquals(id, notes.get(0).id); Assert.assertEquals(id2, notes.get(1).id); }
@Test public void findAllMethodFieldsPopulatedWithDataTest() { Dao<Integer, Note> dao = dbLite.getDao(Note.class); ContentValues values = new ContentValues(); values.put("id", 4); values.put("body", "text"); values.put("author", "john doe"); values.put("date", new Date().toString()); values.put("sent", true); long id = db.insert("Note", null, values); Assert.assertTrue(id > 0); List<Note> notes = dao.findAll(); for (Note note : notes) { Assert.assertNotNull(note.author); Assert.assertNotNull(note.date); Assert.assertNotNull(note.body); Assert.assertTrue(note.id > 0); Assert.assertTrue(note.sent); } }