private void findByNameAndAgeGTAndLT() { EntityManager em; String query; Query q; List<StudentMongoCalendar> students; em = emf.createEntityManager(); query = "Select s From StudentMongoCalendar s where s.name = Kuldeep and s.age > " + getPartialValue(short.class) + " and s.age < " + getMaxValue(short.class); q = em.createQuery(query); students = q.getResultList(); Assert.assertNotNull(students); Assert.assertTrue(students.isEmpty()); em.close(); }
private void findByNameAndAGEBetween() { EntityManager em; String query; Query q; List<StudentMongoCalendar> students; em = emf.createEntityManager(); query = "Select s From StudentMongoCalendar s where s.name = Amresh and s.age between " + getPartialValue(short.class) + " and " + getMaxValue(short.class); q = em.createQuery(query); students = q.getResultList(); Assert.assertNotNull(students); Assert.assertTrue(students.isEmpty()); em.close(); }
private void findByNameAndAgeGTEQAndLTEQ() { EntityManager em; String query; Query q; List<StudentMongoCalendar> students; int count; em = emf.createEntityManager(); query = "Select s From StudentMongoCalendar s where s.name = Kuldeep and s.age >= " + getPartialValue(short.class) + " and s.age <= " + getMaxValue(short.class); q = em.createQuery(query); students = q.getResultList(); Assert.assertNotNull(students); Assert.assertEquals(1, students.size()); count = 0; for (StudentMongoCalendar student : students) { if (student.getId().equals(getMaxValue(Calendar.class))) { Assert.assertEquals(getMaxValue(short.class), student.getAge()); Assert.assertEquals("Kuldeep", student.getName()); count++; } } Assert.assertEquals(1, count); em.close(); }
private void findByNameAndAgeGTAndLTEQ() { EntityManager em; String query; Query q; List<StudentMongoCalendar> students; int count; em = emf.createEntityManager(); query = "Select s From StudentMongoCalendar s where s.name = Kuldeep and s.age > " + getPartialValue(short.class) + " and s.age <= " + getMaxValue(short.class); q = em.createQuery(query); students = q.getResultList(); Assert.assertNotNull(students); Assert.assertEquals(1, students.size()); count = 0; for (StudentMongoCalendar student : students) { Assert.assertEquals(getMaxValue(Calendar.class), student.getId()); Assert.assertEquals(getMaxValue(short.class), student.getAge()); Assert.assertEquals("Kuldeep", student.getName()); count++; } Assert.assertEquals(1, count); em.close(); }
em = emf.createEntityManager(); query = "Select s From StudentMongoCalendar s where s.name = Kuldeep and s.age > " + getPartialValue(short.class); q = em.createQuery(query); students = q.getResultList();
Assert.assertEquals(getPartialValue(short.class), student.getAge()); Assert.assertEquals(getMinValue(String.class), student.getName()); count++;