Examples with BillingDetails org.jpwh.model.inheritance.tableperclass.BillingDetails used on opensource projects

Example 1 with BillingDetails

use of org.jpwh.model.inheritance.tableperclass.BillingDetails in project microservices by pwillhan.

the class Selection method executeQueries.

@Test
public void executeQueries() throws Exception {
    storeTestData();
    CriteriaBuilder cb = JPA.getEntityManagerFactory().getCriteriaBuilder();
    // or:
    // CriteriaBuilder cb = em.getCriteriaBuilder();
    UserTransaction tx = TM.getUserTransaction();
    try {
        tx.begin();
        EntityManager em = JPA.createEntityManager();
        {
            // This is not guaranteed to work in all JPA providers, criteria.select() should be used
            CriteriaQuery criteria = cb.createQuery(Item.class);
            criteria.from(Item.class);
            List<Item> result = em.createQuery(criteria).getResultList();
            assertEquals(result.size(), 3);
        }
        em.clear();
        {
            // Simplest
            CriteriaQuery criteria = cb.createQuery();
            Root<Item> i = criteria.from(Item.class);
            criteria.select(i);
            List<Item> result = em.createQuery(criteria).getResultList();
            assertEquals(result.size(), 3);
        }
        em.clear();
        {
            // Nested calls
            CriteriaQuery criteria = cb.createQuery();
            criteria.select(criteria.from(Item.class));
            TypedQuery<Item> q = em.createQuery(criteria);
            assertEquals(q.getResultList().size(), 3);
        }
        em.clear();
        {
            // Restrict type with metamodel
            CriteriaQuery criteria = cb.createQuery();
            EntityType entityType = getEntityType(em.getMetamodel(), "Item");
            criteria.select(criteria.from(entityType));
            Query q = em.createQuery(criteria);
            assertEquals(q.getResultList().size(), 3);
        }
        em.clear();
        {
            // Polymorphism restricted types
            CriteriaQuery criteria = cb.createQuery();
            criteria.select(criteria.from(BillingDetails.class));
            Query q = em.createQuery(criteria);
            assertEquals(q.getResultList().size(), 2);
        }
        em.clear();
        {
            CriteriaQuery criteria = cb.createQuery();
            criteria.select(criteria.from(CreditCard.class));
            Query q = em.createQuery(criteria);
            assertEquals(q.getResultList().size(), 1);
        }
        em.clear();
        {
            // Polymorphism restricted types
            CriteriaQuery criteria = cb.createQuery();
            Root<BillingDetails> bd = criteria.from(BillingDetails.class);
            criteria.select(bd).where(cb.equal(bd.type(), CreditCard.class));
            Query q = em.createQuery(criteria);
            assertEquals(q.getResultList().size(), 1);
        }
        em.clear();
        {
            // Polymorphism restricted types
            CriteriaQuery criteria = cb.createQuery();
            Root<BillingDetails> bd = criteria.from(BillingDetails.class);
            criteria.select(bd).where(cb.not(cb.equal(bd.type(), BankAccount.class)));
            Query q = em.createQuery(criteria);
            assertEquals(q.getResultList().size(), 1);
            assertTrue(q.getResultList().iterator().next() instanceof CreditCard);
        }
        em.clear();
        {
            // Polymorphism restricted types
            CriteriaQuery criteria = cb.createQuery();
            Root<BillingDetails> bd = criteria.from(BillingDetails.class);
            criteria.select(bd).where(bd.type().in(cb.parameter(List.class, "types")));
            Query q = em.createQuery(criteria);
            q.setParameter("types", Arrays.asList(CreditCard.class, BankAccount.class));
            assertEquals(q.getResultList().size(), 2);
        }
        tx.commit();
        em.close();
    } finally {
        TM.rollback();
    }
}