private void findByAgeAndNameGTAndLT() { EntityManager em; String query; Query q; List<StudentMongoInt> students; int count; em = emf.createEntityManager(); query = "Select s From StudentMongoInt s where s.age = " + getMinValue(short.class) + " and s.name > Amresh and s.name <= " + getMaxValue(String.class); q = em.createQuery(query); students = q.getResultList(); Assert.assertNotNull(students); Assert.assertEquals(1, students.size()); count = 0; for (StudentMongoInt student : students) { Assert.assertEquals(getMinValue(int.class), student.getId()); Assert.assertEquals(getMinValue(short.class), student.getAge()); Assert.assertEquals(getMinValue(String.class), student.getName()); count++; } Assert.assertEquals(1, count); em.close(); }
int count; em = emf.createEntityManager(); query = "Select s From StudentMongoInt s where s.name = Kuldeep and s.age >= " + getMinValue(short.class) + " and s.age <= " + getMaxValue(short.class); q = em.createQuery(query); Assert.assertEquals(getMinValue(int.class), student.getId()); Assert.assertEquals(getMinValue(short.class), student.getAge()); Assert.assertEquals(getMinValue(String.class), student.getName()); count++;
StudentMongoInt studentMin = em.find(StudentMongoInt.class, getMinValue(int.class)); Assert.assertNotNull(studentMin); Assert.assertEquals(getMinValue(short.class), studentMin.getAge()); Assert.assertEquals("Kuldeep", studentMin.getName()); em.remove(studentMin); em = emf.createEntityManager(); studentMin = em.find(StudentMongoInt.class, getMinValue(int.class)); Assert.assertNull(studentMin);
private void findByNameAndAgeGTAndLTEQ() { EntityManager em; String query; Query q; List<StudentMongoInt> students; int count; em = emf.createEntityManager(); query = "Select s From StudentMongoInt s where s.name = Kuldeep and s.age > " + getMinValue(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 (StudentMongoInt student : students) { Assert.assertEquals(getMaxValue(int.class), student.getId()); Assert.assertEquals(getMaxValue(short.class), student.getAge()); Assert.assertEquals("Kuldeep", student.getName()); count++; } Assert.assertEquals(1, count); em.close(); }
private void findByNameAndAgeWithOrClause() { EntityManager em; String query; Query q; List<StudentMongoInt> students; int count; em = emf.createEntityManager(); query = "Select s From StudentMongoInt s where s.name = Kuldeep and s.age > " + getMinValue(short.class); q = em.createQuery(query); students = q.getResultList(); Assert.assertNotNull(students); Assert.assertEquals(1, students.size()); count = 0; for (StudentMongoInt student : students) { Assert.assertEquals(getMaxValue(int.class), student.getId()); Assert.assertEquals(getMaxValue(short.class), student.getAge()); Assert.assertEquals("Kuldeep", student.getName()); count++; } Assert.assertEquals(1, count); em.close(); }
public void testFindById(boolean useSameEm) { EntityManager em = emf.createEntityManager(); StudentMongoInt studentMax = em.find(StudentMongoInt.class, getMaxValue(int.class)); Assert.assertNotNull(studentMax); Assert.assertEquals(getMaxValue(short.class), studentMax.getAge()); Assert.assertEquals(getMaxValue(String.class), studentMax.getName()); if (!useSameEm) { em.close(); em = emf.createEntityManager(); } StudentMongoInt studentMin = em.find(StudentMongoInt.class, getMinValue(int.class)); Assert.assertNotNull(studentMin); Assert.assertEquals(getMinValue(short.class), studentMin.getAge()); Assert.assertEquals(getMinValue(String.class), studentMin.getName()); if (!useSameEm) { em.close(); em = emf.createEntityManager(); } StudentMongoInt student = em.find(StudentMongoInt.class, getRandomValue(int.class)); Assert.assertNotNull(student); Assert.assertEquals(getRandomValue(short.class), student.getAge()); Assert.assertEquals(getRandomValue(String.class), student.getName()); em.close(); }
Assert.assertEquals(getMinValue(int.class), student.getId()); Assert.assertEquals(getMinValue(short.class), student.getAge()); Assert.assertEquals(getMinValue(String.class), student.getName()); count++;
private void findByNameAndAGEBetween() { EntityManager em; String query; Query q; List<StudentMongoInt> students; int count; em = emf.createEntityManager(); query = "Select s From StudentMongoInt s where s.name = Amresh and s.age between " + getMinValue(short.class) + " and " + getMaxValue(short.class); q = em.createQuery(query); students = q.getResultList(); Assert.assertNotNull(students); Assert.assertEquals(1, students.size()); count = 0; for (StudentMongoInt student : students) { Assert.assertEquals(getRandomValue(int.class), student.getId()); Assert.assertEquals(getRandomValue(short.class), student.getAge()); Assert.assertEquals(getRandomValue(String.class), student.getName()); count++; } Assert.assertEquals(1, count); em.close(); }
private void findByNameAndAgeGTAndLT() { EntityManager em; String query; Query q; List<StudentMongoInt> students; int count; em = emf.createEntityManager(); query = "Select s From StudentMongoInt s where s.name = Amresh and s.age > " + getMinValue(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 (StudentMongoInt student : students) { Assert.assertEquals(getRandomValue(int.class), student.getId()); Assert.assertEquals(getRandomValue(short.class), student.getAge()); Assert.assertEquals(getRandomValue(String.class), student.getName()); count++; } Assert.assertEquals(1, count); em.close(); }
count++; else if (student.getId() == ((Integer) getMinValue(int.class)).intValue()) Assert.assertEquals(getMinValue(short.class), student.getAge()); Assert.assertEquals(getMinValue(String.class), student.getName()); count++;
List<StudentMongoInt> students; em = emf.createEntityManager(); query = "Select s From StudentMongoInt s where s.id between " + getMinValue(int.class) + " and " + getMaxValue(int.class); q = em.createQuery(query); count++; else if (student.getId() == ((Integer) getMinValue(int.class)).intValue()) Assert.assertEquals(getMinValue(short.class), student.getAge()); Assert.assertEquals(getMinValue(String.class), student.getName()); count++;
public void testPersist(boolean useSameEm) { EntityManager em = emf.createEntityManager(); // Insert max value of int StudentMongoInt studentMax = new StudentMongoInt(); studentMax.setAge((Short) getMaxValue(short.class)); studentMax.setId((Integer) getMaxValue(int.class)); studentMax.setName((String) getMaxValue(String.class)); em.persist(studentMax); // Insert min value of int StudentMongoInt studentMin = new StudentMongoInt(); studentMin.setAge((Short) getMinValue(short.class)); studentMin.setId((Integer) getMinValue(int.class)); studentMin.setName((String) getMinValue(String.class)); em.persist(studentMin); // Insert random value of int StudentMongoInt student = new StudentMongoInt(); student.setAge((Short) getRandomValue(short.class)); student.setId((Integer) getRandomValue(int.class)); student.setName((String) getRandomValue(String.class)); em.persist(student); em.close(); }