Examples with AuditReader org.hibernate.envers.AuditReader used on opensource projects

Example 36 with AuditReader

use of org.hibernate.envers.AuditReader in project hibernate-orm by hibernate.

the class SetHashcodeChangeTest method testAuthorLastRevision.

@Test
public void testAuthorLastRevision() {
    // tests that Author has 3 books, Book1, Book2, and Book3.
    // where Book1 and Book2 were removed and re-added with the addition of Book3.
    EntityManager entityManager = getEntityManager();
    try {
        final AuditReader reader = getAuditReader();
        final List<Number> revisions = reader.getRevisions(Author.class, authorId);
        final Number lastRevision = revisions.get(revisions.size() - 1);
        final Author author = (Author) reader.createQuery().forEntitiesAtRevision(Author.class, lastRevision).getSingleResult();
        assertNotNull(author);
        assertEquals(3, author.getBooks().size());
    } catch (Exception e) {
        if (entityManager.getTransaction().isActive()) {
            entityManager.getTransaction().rollback();
        }
    } finally {
        entityManager.close();
    }
}

Example 37 with AuditReader

use of org.hibernate.envers.AuditReader in project hibernate-orm by hibernate.

the class AssociationToOneInnerJoinQueryTest method testComparisonOfTwoPropertiesFromDifferentEntities.

@Test
public void testComparisonOfTwoPropertiesFromDifferentEntities() {
    AuditReader auditReader = getAuditReader();
    // the car where the owner age is equal to the owner address number.
    Car result = (Car) auditReader.createQuery().forEntitiesAtRevision(Car.class, 1).traverseRelation("owner", JoinType.INNER, "p").traverseRelation("address", JoinType.INNER, "a").up().up().add(AuditEntity.property("p", "age").eqProperty("a", "number")).getSingleResult();
    assertEquals("Unexpected car returned", toyota.getId(), result.getId());
}

Example 38 with AuditReader

use of org.hibernate.envers.AuditReader in project hibernate-orm by hibernate.

the class AssociationToOneInnerJoinQueryTest method testAssociationQueryWithProjection.

@Test
public void testAssociationQueryWithProjection() {
    AuditReader auditReader = getAuditReader();
    List<Integer> list1 = auditReader.createQuery().forEntitiesAtRevision(Car.class, 2).traverseRelation("owner", JoinType.INNER).addProjection(AuditEntity.property("age")).addOrder(AuditEntity.property("age").asc()).getResultList();
    assertEquals("Unexpected number of results", 3, list1.size());
    assertEquals("Unexpected age at index 0", Integer.valueOf(20), list1.get(0));
    assertEquals("Unexpected age at index 0", Integer.valueOf(30), list1.get(1));
    assertEquals("Unexpected age at index 0", Integer.valueOf(40), list1.get(2));
    List<Address> list2 = auditReader.createQuery().forEntitiesAtRevision(Car.class, 2).traverseRelation("owner", JoinType.INNER).addOrder(AuditEntity.property("age").asc()).traverseRelation("address", JoinType.INNER).addProjection(AuditEntity.selectEntity(false)).getResultList();
    assertEquals("Unexpected number of results", 3, list2.size());
    assertEquals("Unexpected address at index 0", address1.getId(), list2.get(0).getId());
    assertEquals("Unexpected address at index 1", address1.getId(), list2.get(1).getId());
    assertEquals("Unexpected address at index 2", address2.getId(), list2.get(2).getId());
    List<Address> list3 = auditReader.createQuery().forEntitiesAtRevision(Car.class, 2).traverseRelation("owner", JoinType.INNER).traverseRelation("address", JoinType.INNER).addProjection(AuditEntity.selectEntity(true)).addOrder(AuditEntity.property("number").asc()).getResultList();
    assertEquals("Unexpected number of results", 2, list3.size());
    assertEquals("Unexpected address at index 0", address1.getId(), list3.get(0).getId());
    assertEquals("Unexpected address at index 1", address2.getId(), list3.get(1).getId());
    List<Object[]> list4 = auditReader.createQuery().forEntitiesAtRevision(Car.class, 2).traverseRelation("owner", JoinType.INNER).addOrder(AuditEntity.property("age").asc()).addProjection(AuditEntity.selectEntity(false)).traverseRelation("address", JoinType.INNER).addProjection(AuditEntity.property("number")).getResultList();
    assertEquals("Unexpected number of results", 3, list4.size());
    final Object[] index0 = list4.get(0);
    assertEquals("Unexpected owner at index 0", vwOwner.getId(), ((Person) index0[0]).getId());
    assertEquals("Unexpected number at index 0", Integer.valueOf(5), index0[1]);
    final Object[] index1 = list4.get(1);
    assertEquals("Unexpected owner at index 1", fordOwner.getId(), ((Person) index1[0]).getId());
    assertEquals("Unexpected number at index 1", Integer.valueOf(5), index1[1]);
    final Object[] index2 = list4.get(2);
    assertEquals("Unexpected owner at index 2", toyotaOwner.getId(), ((Person) index2[0]).getId());
    assertEquals("Unexpected number at index 2", Integer.valueOf(30), index2[1]);
}

Example 39 with AuditReader

use of org.hibernate.envers.AuditReader in project hibernate-orm by hibernate.

the class AssociationToOneInnerJoinQueryTest method testAssociationQueryWithOrdering.

@Test
public void testAssociationQueryWithOrdering() {
    AuditReader auditReader = getAuditReader();
    List<Car> cars1 = auditReader.createQuery().forEntitiesAtRevision(Car.class, 1).traverseRelation("owner", JoinType.INNER).traverseRelation("address", JoinType.INNER).addOrder(AuditEntity.property("number").asc()).up().addOrder(AuditEntity.property("age").desc()).getResultList();
    assertEquals("Unexpected number of results", 3, cars1.size());
    assertEquals("Unexpected car at index 0", ford.getId(), cars1.get(0).getId());
    assertEquals("Unexpected car at index 1", vw.getId(), cars1.get(1).getId());
    assertEquals("Unexpected car at index 2", toyota.getId(), cars1.get(2).getId());
    List<Car> cars2 = auditReader.createQuery().forEntitiesAtRevision(Car.class, 1).traverseRelation("owner", JoinType.INNER).traverseRelation("address", JoinType.INNER).addOrder(AuditEntity.property("number").asc()).up().addOrder(AuditEntity.property("age").asc()).getResultList();
    assertEquals("Unexpected number of results", 3, cars2.size());
    assertEquals("Unexpected car at index 0", vw.getId(), cars2.get(0).getId());
    assertEquals("Unexpected car at index 1", ford.getId(), cars2.get(1).getId());
    assertEquals("Unexpected car at index 2", toyota.getId(), cars2.get(2).getId());
}

Example 40 with AuditReader

use of org.hibernate.envers.AuditReader in project hibernate-orm by hibernate.

the class AssociationToOneInnerJoinQueryTest method testAssociationQuery.

@Test
public void testAssociationQuery() {
    final AuditReader auditReader = getAuditReader();
    final Car result1 = (Car) auditReader.createQuery().forEntitiesAtRevision(Car.class, 1).traverseRelation("owner", JoinType.INNER).add(AuditEntity.property("name").like("Ford%")).getSingleResult();
    assertEquals("Unexpected single car at revision 1", ford.getId(), result1.getId());
    Car result2 = (Car) auditReader.createQuery().forEntitiesAtRevision(Car.class, 1).traverseRelation("owner", JoinType.INNER).traverseRelation("address", JoinType.INNER).add(AuditEntity.property("number").eq(30)).getSingleResult();
    assertEquals("Unexpected single car at revision 1", toyota.getId(), result2.getId());
    List<Car> resultList1 = auditReader.createQuery().forEntitiesAtRevision(Car.class, 1).traverseRelation("owner", JoinType.INNER).add(AuditEntity.property("age").ge(30)).add(AuditEntity.property("age").lt(40)).up().addOrder(AuditEntity.property("make").asc()).getResultList();
    assertEquals("Unexpected number of cars for query in revision 1", 2, resultList1.size());
    assertEquals("Unexpected car at index 0 in revision 1", ford.getId(), resultList1.get(0).getId());
    assertEquals("Unexpected car at index 1 in revision 2", toyota.getId(), resultList1.get(1).getId());
    Car result3 = (Car) auditReader.createQuery().forEntitiesAtRevision(Car.class, 2).traverseRelation("owner", JoinType.INNER).add(AuditEntity.property("age").ge(30)).add(AuditEntity.property("age").lt(40)).up().addOrder(AuditEntity.property("make").asc()).getSingleResult();
    assertEquals("Unexpected car at revision 2", ford.getId(), result3.getId());
}