/** * */ 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 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()); } }
/** * */ 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 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 findById() { PersonCassandra personHBase = findById(PersonCassandra.class, "1", em); Assert.assertNotNull(personHBase); Assert.assertEquals("vivek", personHBase.getPersonName()); Assert.assertEquals(new Integer(10), personHBase.getAge()); personHBase = findById(PersonCassandra.class, "2", em); Assert.assertNotNull(personHBase); Assert.assertEquals("vivek", personHBase.getPersonName()); Assert.assertEquals(new Integer(20), personHBase.getAge()); personHBase = findById(PersonCassandra.class, "3", em); Assert.assertNotNull(personHBase); Assert.assertEquals("vivek", personHBase.getPersonName()); Assert.assertEquals(new Integer(15), personHBase.getAge()); }
/** * */ 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); }
Assert.assertEquals(new Integer("20"), person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; Assert.assertEquals(new Integer("15"), person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; Assert.assertEquals(new Integer("10"), person.getAge()); Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName());
/** * */ 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); }
Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; Assert.assertNull(person.getAge()); Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName());
Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; Assert.assertNull(person.getAge()); Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName());
Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; Assert.assertNull(person.getAge()); Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName());
Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; Assert.assertNull(person.getAge()); Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName());
Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; Assert.assertNull(person.getAge()); Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName());
Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; Assert.assertNull(person.getAge()); Assert.assertEquals("vivek", person.getPersonName()); count++; Assert.assertNull(person.getAge()); Assert.assertEquals("1", person.getPersonId()); Assert.assertEquals("vivek", person.getPersonName());
@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); } } }
Assert.assertNotNull(p); Assert.assertEquals("'after merge'", p.getPersonName()); Assert.assertEquals(new Integer(10), p.getAge());