/** * */ private void deleteNamed(boolean useSameEm) { String deleteQuery = "Delete From StudentBigDecimal s where s.name='Vivek'"; EntityManager em = emf.createEntityManager(); Query q = em.createQuery(deleteQuery); q.executeUpdate(); if (!useSameEm) { em.close(); em = emf.createEntityManager(); } StudentBigDecimal newStudent = em.find(StudentBigDecimal.class, getRandomValue(BigDecimal.class)); Assert.assertNull(newStudent); em.close(); }
/** * @return */ private void updateNamed(boolean useSameEm) { EntityManager em = emf.createEntityManager(); String updateQuery = "Update StudentBigDecimal s SET s.name='Vivek' where s.name='Amresh'"; Query q = em.createQuery(updateQuery); q.executeUpdate(); if (!useSameEm) { em.close(); em = emf.createEntityManager(); } StudentBigDecimal newStudent = em.find(StudentBigDecimal.class, getRandomValue(BigDecimal.class)); Assert.assertNotNull(newStudent); Assert.assertEquals(getRandomValue(short.class), newStudent.getAge()); Assert.assertEquals("Vivek", newStudent.getName()); em.close(); }
private void findByAge() { EntityManager em; String query; Query q; List<StudentBigDecimal> students; int count; em = emf.createEntityManager(); query = "Select s From StudentBigDecimal s where s.age = " + getRandomValue(short.class); q = em.createQuery(query); students = q.getResultList(); Assert.assertNotNull(students); Assert.assertEquals(1, students.size()); count = 0; for (StudentBigDecimal student : students) { Assert.assertEquals(((BigDecimal) getRandomValue(BigDecimal.class)).intValue(), student.getStudentId() .intValue()); Assert.assertEquals(getRandomValue(short.class), student.getAge()); Assert.assertEquals(getRandomValue(String.class), student.getName()); count++; } Assert.assertEquals(1, count); em.close(); }
private void findByNameAndAGEBetween() { EntityManager em; String query; Query q; List<StudentBigDecimal> students; int count; em = emf.createEntityManager(); query = "Select s From StudentBigDecimal 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 (StudentBigDecimal student : students) { Assert.assertEquals(((BigDecimal) getRandomValue(BigDecimal.class)).intValue(), student.getStudentId() .intValue()); 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<StudentBigDecimal> students; int count; em = emf.createEntityManager(); query = "Select s From StudentBigDecimal 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 (StudentBigDecimal student : students) { Assert.assertEquals(((BigDecimal) getRandomValue(BigDecimal.class)).intValue(), student.getStudentId() .intValue()); Assert.assertEquals(getRandomValue(short.class), student.getAge()); Assert.assertEquals(getRandomValue(String.class), student.getName()); count++; } Assert.assertEquals(1, count); em.close(); }
public void testFindById(boolean useSameEm) { EntityManager em = emf.createEntityManager(); StudentBigDecimal studentMax = em.find(StudentBigDecimal.class, getMaxValue(BigDecimal.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(); } StudentBigDecimal studentMin = em.find(StudentBigDecimal.class, getMinValue(BigDecimal.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(); } StudentBigDecimal student = em.find(StudentBigDecimal.class, getRandomValue(BigDecimal.class)); Assert.assertNotNull(student); Assert.assertEquals(getRandomValue(short.class), student.getAge()); Assert.assertEquals(getRandomValue(String.class), student.getName()); em.close(); }
Assert.assertEquals(((BigDecimal) getRandomValue(BigDecimal.class)).intValue(), student.getStudentId() .intValue()); Assert.assertEquals(getRandomValue(short.class), student.getAge()); Assert.assertEquals(getRandomValue(String.class), student.getName()); count++;
public void testPersist(boolean useSameEm) { EntityManager em = emf.createEntityManager(); // Insert max value of BigDecimal StudentBigDecimal studentMax = new StudentBigDecimal(); studentMax.setAge((Short) getMaxValue(short.class)); studentMax.setStudentId((BigDecimal) getMaxValue(BigDecimal.class)); studentMax.setName((String) getMaxValue(String.class)); em.persist(studentMax); // Insert min value of BigDecimal StudentBigDecimal studentMin = new StudentBigDecimal(); studentMin.setAge((Short) getMinValue(short.class)); studentMin.setStudentId((BigDecimal) getMinValue(BigDecimal.class)); studentMin.setName((String) getMinValue(String.class)); em.persist(studentMin); // Insert random value of BigDecimal StudentBigDecimal student = new StudentBigDecimal(); student.setAge((Short) getRandomValue(short.class)); student.setStudentId((BigDecimal) getRandomValue(BigDecimal.class)); student.setName((String) getRandomValue(String.class)); em.persist(student); em.close(); }