/** * */ private void findByIdGTEAndAge() { String qry = "Select p.personName, p.age from PersonCassandra p where p.personId >= 1 and p.age = 10"; Query q = em.createQuery(qry); List<PersonCassandra> persons = q.getResultList(); Assert.assertNotNull(persons); Assert.assertEquals(1, persons.size()); for (PersonCassandra person : persons) { Assert.assertEquals(new Integer(10), person.getAge()); Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName()); } }
/** * */ private void findByIdLTEAndAge() { String qry = "Select p.personName, p.age from PersonCassandra p where p.personId <= 3 and p.age = 10"; Query q = em.createQuery(qry); List<PersonCassandra> persons = q.getResultList(); Assert.assertNotNull(persons); Assert.assertEquals(1, persons.size()); for (PersonCassandra person : persons) { Assert.assertEquals(new Integer(10), person.getAge()); Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName()); } }
/** * */ private void findByIdEQ() { String qry = "Select p.personName from PersonCassandra p where p.personId = 2"; Query q = em.createQuery(qry); List<PersonCassandra> persons = q.getResultList(); Assert.assertNotNull(persons); Assert.assertEquals(1, persons.size()); for (PersonCassandra person : persons) { Assert.assertNull(person.getAge()); Assert.assertEquals("2", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName()); } }
/** * */ private void findByIdAndAgeGTAndLT() { String qry = "Select p.personName from PersonCassandra p where p.personId = 1 and p.personName = vivek and p.age >=10 and p.age <= 20"; Query q = em.createQuery(qry); List<PersonCassandra> persons = q.getResultList(); Assert.assertNotNull(persons); Assert.assertEquals(1, persons.size()); int count = 0; for (PersonCassandra person : persons) { if (person.getPersonId().equals("1")) { Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; } } Assert.assertEquals(1, count); }
/** * */ private void findByIdAndAgeGT() { String qry = "Select p.personName, p.age from PersonCassandra p where p.personId = 1 and p.age > 5"; Query q = em.createQuery(qry); List<PersonCassandra> persons = q.getResultList(); Assert.assertNotNull(persons); Assert.assertEquals(1, persons.size()); for (PersonCassandra person : persons) { Assert.assertEquals(new Integer(10), person.getAge()); Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName()); Assert.assertEquals(10, person.getAge().intValue()); Assert.assertNull(person.getA()); } }
/** * */ private void findByIdAndAge() { String qry = "Select p.personName, p.age from PersonCassandra p where p.personId = 1 and p.age = 10"; Query q = em.createQuery(qry); List<PersonCassandra> persons = q.getResultList(); Assert.assertNotNull(persons); Assert.assertEquals(1, persons.size()); for (PersonCassandra person : persons) { Assert.assertEquals(new Integer(10), person.getAge()); Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName()); Assert.assertEquals(10, person.getAge().intValue()); Assert.assertNull(person.getA()); } }
Assert.assertNotNull(em.find(PersonCassandra.class, rows.get(i).getPersonId())); Assert.assertNull(em.find(PersonCassandra.class, rows.get(6).getPersonId()));
/** * */ private void findByIdGTAndLTE() { String qry = "Select p.personName from PersonCassandra p where p.personId > 1 and p.personId <= 2"; Query q = em.createQuery(qry); List<PersonCassandra> persons = q.getResultList(); Assert.assertNotNull(persons); Assert.assertEquals(2, persons.size()); int count = 0; for (PersonCassandra person : persons) { if (person.getPersonId().equals("2")) { Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; } else { Assert.assertEquals("1", person.getPersonId()); Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; } } Assert.assertEquals(2, count); }
for (PersonCassandra person : persons) if (person.getPersonId().equals("2")) count++; else if (person.getPersonId().equals("3")) Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName()); count++;
for (PersonCassandra person : persons) if (person.getPersonId().equals("2")) count++; else if (person.getPersonId().equals("3")) Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName()); count++;
for (PersonCassandra person : persons) if (person.getPersonId().equals("2")) count++; else if (person.getPersonId().equals("3")) Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName()); count++;
for (PersonCassandra person : persons) if (person.getPersonId().equals("2")) count++; else if (person.getPersonId().equals("3")) Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName()); count++;
for (PersonCassandra person : persons) if (person.getPersonId().equals("2")) count++; else if (person.getPersonId().equals("3")) Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName()); count++;
for (PersonCassandra person : persons) if (person.getPersonId().equals("2")) count++; else if (person.getPersonId().equals("3")) Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName()); count++;
for (PersonCassandra person : persons) if (person.getPersonId().equals("2")) count++; else if (person.getPersonId().equals("3")) Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName()); count++;
@Override public void run() { for (int j = 1; j <= 100; j++) { PersonCassandra foundObject = entityManager.find(PersonCassandra.class, "" + i * 1000); if (foundObject != null) { Assert.assertNotNull(foundObject.getPersonId()); Assert.assertEquals(10 + j - 1, foundObject.getAge().intValue()); Assert.assertEquals("vivek" + (j - 1), foundObject.getPersonName()); foundObject.setAge(10 + j); foundObject.setPersonName("vivek" + j); } else { foundObject = prepareData("" + i * 1000, 10 + j); foundObject.setPersonName("vivek" + j); } entityManager.persist(foundObject); } } }