private <E extends Object> String getPersonName(E e, Object result) { return ((Person) result).getPersonName(); } }
/** * Test order by ascending. */ private void testOrderByAscending() { String queryString = "Select p.personName from Person p order by p.age ASC"; Query query = em.createQuery(queryString); List resultList = query.getResultList(); Assert.assertEquals(4, resultList.size()); Assert.assertEquals("pragalbh", ((Person) resultList.get(0)).getPersonName()); Assert.assertEquals("dev", ((Person) resultList.get(1)).getPersonName()); Assert.assertEquals("karthik", ((Person) resultList.get(2)).getPersonName()); Assert.assertEquals("amit", ((Person) resultList.get(3)).getPersonName()); }
/** * Test order by asc where clause. */ private void testOrderByASCWhereClause() { String queryString = "Select p.personName from Person p where p.salary > 350.0 order by p.age ASC"; Query query = em.createQuery(queryString); List resultList = query.getResultList(); Assert.assertEquals(3, resultList.size()); Assert.assertEquals("pragalbh", ((Person) resultList.get(0)).getPersonName()); Assert.assertEquals("dev", ((Person) resultList.get(1)).getPersonName()); Assert.assertEquals("karthik", ((Person) resultList.get(2)).getPersonName()); }
/** * Test order by desc with string. */ private void testOrderByDescWithString() { String queryString = "Select p.personName from Person p order by p.personName DESC"; Query query = em.createQuery(queryString); List resultList = query.getResultList(); Assert.assertEquals(4, resultList.size()); Assert.assertEquals("pragalbh", ((Person) resultList.get(0)).getPersonName()); Assert.assertEquals("karthik", ((Person) resultList.get(1)).getPersonName()); Assert.assertEquals("dev", ((Person) resultList.get(2)).getPersonName()); Assert.assertEquals("amit", ((Person) resultList.get(3)).getPersonName()); }
/** * Test having with entity. */ private void testHavingWithEntity() { String queryString = "Select p from Person p where p.age < 40 group by p.age having max(p.salary) > 600"; Query query = em.createQuery(queryString); List resultList = query.getResultList(); Assert.assertEquals(1, resultList.size()); Person person = (Person) (resultList.get(0)); Assert.assertEquals("7", person.getPersonId()); Assert.assertEquals("KPM", person.getPersonName()); Assert.assertEquals(30, person.getAge().intValue()); Assert.assertEquals(700.0, person.getSalary()); }
/** * Test group by with entity. */ private void testGroupByWithEntity() { String queryString = "Select p from Person p where p.age < 20 group by p.age"; Query query = em.createQuery(queryString); List resultList = query.getResultList(); Assert.assertEquals(1, resultList.size()); Person person = (Person) (resultList.get(0)); Assert.assertEquals("5", person.getPersonId()); Assert.assertEquals("AK", person.getPersonName()); Assert.assertEquals(10, person.getAge().intValue()); Assert.assertEquals(500.0, person.getSalary()); }
/** * Test order by asc multiple fields. */ private void testOrderByASCMultipleFields() { String queryString = "Select p.personName, p.age, p.salary from Person p where p.salary <> 300.0 order by p.age ASC"; Query query = em.createQuery(queryString); List resultList = query.getResultList(); Assert.assertEquals(3, resultList.size()); Assert.assertEquals("pragalbh", (((Person) resultList.get(0)).getPersonName())); Assert.assertEquals(20, ((Person) resultList.get(0)).getAge().intValue()); Assert.assertEquals(700.0, ((Person) resultList.get(0)).getSalary()); Assert.assertEquals("dev", ((Person) resultList.get(1)).getPersonName()); Assert.assertEquals(40, ((Person) resultList.get(1)).getAge().intValue()); Assert.assertEquals(400.0, ((Person) resultList.get(1)).getSalary()); Assert.assertEquals("karthik", ((Person) resultList.get(2)).getPersonName()); Assert.assertEquals(50, ((Person) resultList.get(2)).getAge().intValue()); Assert.assertEquals(500.0, ((Person) resultList.get(2)).getSalary()); }
@Test public void testDeletion() throws Exception { Object p1 = prepareData("1", 10); Object p2 = prepareData("2", 20); Object p3 = prepareData("3", 15); em.persist(p1); em.persist(p2); em.persist(p3); Person p = findById(Person.class, "1", em); Assert.assertNotNull(p); Assert.assertEquals("vivek", p.getPersonName()); em.remove(p); em.clear(); TypedQuery<Person> query = em.createQuery("Select p from Person p", Person.class); List<Person> results = query.getResultList(); Assert.assertNotNull(query); Assert.assertNotNull(results); }
/** * Assert person. * * @param actual * the actual * @param person * the person */ private void assertPerson(Object actual, Person person) { Person actualPerson = (Person) actual; Assert.assertEquals(actualPerson.getPersonId(), person.getPersonId()); Assert.assertEquals(actualPerson.getPersonName(), person.getPersonName()); Assert.assertEquals(actualPerson.getAge().intValue(), person.getAge().intValue()); Assert.assertEquals(actualPerson.getSalary(), person.getSalary()); Assert.assertEquals(actualPerson.getDay(), person.getDay()); }
Assert.assertEquals("merged", finalFound.getPersonName());
@Test public void testCommit() { em.getTransaction().begin(); Object p1 = prepareData("1", 10); Object p2 = prepareData("2", 20); Object p3 = prepareData("3", 15); em.persist(p1); em.persist(p2); em.persist(p3); // on commit. em.getTransaction().commit(); Person p = findById(Person.class, "1", em); Assert.assertNotNull(p); em.getTransaction().begin(); ((Person) p2).setPersonName("rollback"); em.merge(p2); // roll back, should roll back person name for p2! em.getTransaction().rollback(); p = findById(Person.class, "1", em); Assert.assertNotNull(p); p = findById(Person.class, "2", em); Assert.assertNotNull(p); Assert.assertEquals("vivek", p.getPersonName()); Assert.assertNotSame("rollback", p.getPersonName()); }
@Test public void testUpdation() throws Exception { Object p1 = prepareData("1", 10); Object p2 = prepareData("2", 20); Object p3 = prepareData("3", 15); em.persist(p1); em.persist(p2); em.persist(p3); em.clear(); Person p = findById(Person.class, "1", em); Assert.assertNotNull(p); Assert.assertEquals("vivek", p.getPersonName()); // modify record. p.setPersonName("newvivek"); em.merge(p); assertUpdation(em, "Person", Person.class, "vivek", "newvivek", "personName"); }
@Test public void testOnUpdate() { Person p1 = new Person(); p1.setPersonName("vivek"); p1.setAge(32); p1.setDay(Day.TUESDAY); p1.setPersonId("p1"); p1.setSalary(6000.345); em.persist(p1); em.clear(); Person p = em.find(Person.class, "p1"); Assert.assertNotNull(p); Assert.assertEquals("vivek", p.getPersonName()); p.setAge(12); p.setPersonName("newvivek"); em.merge(p); em.clear(); Query findQuery = em.createQuery("Select p from Person p WHERE p.personName = vivek"); List<Person> allPersons = findQuery.getResultList(); Assert.assertEquals(0, allPersons.size()); findQuery = em.createQuery("Select p from Person p WHERE p.personName = newvivek"); allPersons = findQuery.getResultList(); Assert.assertEquals(new Integer(12), allPersons.get(0).getAge()); em.remove(em.find(Person.class, "p1")); }
Person p = findById(Person.class, "1", em); Assert.assertNotNull(p); Assert.assertEquals("vivek", p.getPersonName()); Assert.assertEquals(Day.THURSDAY, p.getDay());
Assert.assertEquals("vivek", p.getPersonName());
for (Course c : courseArray) { print += c.getCourseName() + "\n"; for (Person p : c.personArray){ print += p.getPersonName()+ "\n"; } }