Examples with Query com.haulmont.cuba.core.Query used on opensource projects

Example 41 with Query

use of com.haulmont.cuba.core.Query in project cuba by cuba-platform.

the class SoftDeleteTest method testQuery.

@Test
public void testQuery() {
    System.out.println("===================== BEGIN testQuery =====================");
    Transaction tx = cont.persistence().createTransaction();
    try {
        EntityManager em = cont.persistence().getEntityManager();
        Query query = em.createQuery("select r from sec$Role r where r.name = ?1");
        query.setParameter(1, "roleToBeDeleted");
        List<Role> list = query.getResultList();
        assertTrue(list.isEmpty());
        tx.commit();
    } finally {
        tx.end();
    }
    System.out.println("===================== END testQuery =====================");
}

Example 42 with Query

use of com.haulmont.cuba.core.Query in project cuba by cuba-platform.

the class SoftDeleteTest method testOneToMany_JoinFetchQuery.

@Test
public void testOneToMany_JoinFetchQuery() {
    System.out.println("===================== BEGIN testOneToMany_JoinFetchQuery =====================");
    Transaction tx = cont.persistence().createTransaction();
    try {
        EntityManager em = cont.persistence().getEntityManager();
        Query q = em.createQuery("select u from sec$User u join fetch u.userRoles where u.id = ?1");
        q.setParameter(1, userId);
        User user = (User) q.getSingleResult();
        List<UserRole> userRoles = user.getUserRoles();
        assertEquals(1, userRoles.size());
        for (UserRole ur : userRoles) {
            assertNotNull(ur.getRole());
        }
        tx.commit();
    } finally {
        tx.end();
    }
    System.out.println("===================== END testOneToMany_JoinFetchQuery =====================");
}