use of org.hibernate.envers.test.entities.manytomany.sametable.Child2Entity in project hibernate-orm by hibernate.
the class ValidityAuditStrategyRevEndTestCustomRevEnt method initData.
@Test
@Priority(10)
public void initData() {
EntityManager em = getEntityManager();
// We need first to modify the columns in the middle (join table) to
// allow null values. Hbm2ddl doesn't seem
// to allow this.
em.getTransaction().begin();
Session session = (Session) em.getDelegate();
session.createSQLQuery("DROP TABLE children").executeUpdate();
session.createSQLQuery("CREATE TABLE children ( parent_id " + getDialect().getTypeName(Types.INTEGER) + ", child1_id " + getDialect().getTypeName(Types.INTEGER) + getDialect().getNullColumnString() + ", child2_id " + getDialect().getTypeName(Types.INTEGER) + getDialect().getNullColumnString() + " )").executeUpdate();
session.createSQLQuery("DROP TABLE children_AUD").executeUpdate();
session.createSQLQuery("CREATE TABLE children_AUD ( REV " + getDialect().getTypeName(Types.INTEGER) + " NOT NULL" + ", REVEND " + getDialect().getTypeName(Types.INTEGER) + ", " + revendTimestampColumName + " " + getDialect().getTypeName(Types.TIMESTAMP) + ", REVTYPE " + getDialect().getTypeName(Types.TINYINT) + ", parent_id " + getDialect().getTypeName(Types.INTEGER) + ", child1_id " + getDialect().getTypeName(Types.INTEGER) + getDialect().getNullColumnString() + ", child2_id " + getDialect().getTypeName(Types.INTEGER) + getDialect().getNullColumnString() + " )").executeUpdate();
em.getTransaction().commit();
em.clear();
ParentEntity p1 = new ParentEntity("parent_1");
ParentEntity p2 = new ParentEntity("parent_2");
Child1Entity c1_1 = new Child1Entity("child1_1");
Child1Entity c1_2 = new Child1Entity("child1_2");
Child2Entity c2_1 = new Child2Entity("child2_1");
Child2Entity c2_2 = new Child2Entity("child2_2");
// Revision 1
em.getTransaction().begin();
em.persist(p1);
em.persist(p2);
em.persist(c1_1);
em.persist(c1_2);
em.persist(c2_1);
em.persist(c2_2);
em.getTransaction().commit();
em.clear();
// Revision 2 - (p1: c1_1, p2: c2_1)
em.getTransaction().begin();
p1 = em.find(ParentEntity.class, p1.getId());
p2 = em.find(ParentEntity.class, p2.getId());
c1_1 = em.find(Child1Entity.class, c1_1.getId());
c2_1 = em.find(Child2Entity.class, c2_1.getId());
p1.getChildren1().add(c1_1);
p2.getChildren2().add(c2_1);
em.getTransaction().commit();
em.clear();
// Revision 3 - (p1: c1_1, c1_2, c2_2, p2: c1_1, c2_1)
em.getTransaction().begin();
p1 = em.find(ParentEntity.class, p1.getId());
p2 = em.find(ParentEntity.class, p2.getId());
c1_1 = em.find(Child1Entity.class, c1_1.getId());
c1_2 = em.find(Child1Entity.class, c1_2.getId());
c2_2 = em.find(Child2Entity.class, c2_2.getId());
p1.getChildren1().add(c1_2);
p1.getChildren2().add(c2_2);
p2.getChildren1().add(c1_1);
em.getTransaction().commit();
em.clear();
// Revision 4 - (p1: c1_2, c2_2, p2: c1_1, c2_1, c2_2)
em.getTransaction().begin();
p1 = em.find(ParentEntity.class, p1.getId());
p2 = em.find(ParentEntity.class, p2.getId());
c1_1 = em.find(Child1Entity.class, c1_1.getId());
c2_2 = em.find(Child2Entity.class, c2_2.getId());
p1.getChildren1().remove(c1_1);
p2.getChildren2().add(c2_2);
em.getTransaction().commit();
em.clear();
// Revision 5 - (p1: c2_2, p2: c1_1, c2_1)
em.getTransaction().begin();
p1 = em.find(ParentEntity.class, p1.getId());
p2 = em.find(ParentEntity.class, p2.getId());
c1_2 = em.find(Child1Entity.class, c1_2.getId());
c2_2 = em.find(Child2Entity.class, c2_2.getId());
c2_2.getParents().remove(p2);
c1_2.getParents().remove(p1);
em.getTransaction().commit();
em.clear();
//
p1_id = p1.getId();
p2_id = p2.getId();
c1_1_id = c1_1.getId();
c1_2_id = c1_2.getId();
c2_1_id = c2_1.getId();
c2_2_id = c2_2.getId();
Set<Number> revisionNumbers = new HashSet<Number>();
revisionNumbers.addAll(Arrays.asList(1, 2, 3, 4, 5));
revisions = getAuditReader().findRevisions(CustomDateRevEntity.class, revisionNumbers);
assert revisions.size() == 5;
}
use of org.hibernate.envers.test.entities.manytomany.sametable.Child2Entity in project hibernate-orm by hibernate.
the class ValidityAuditStrategyRevEndTestCustomRevEnt method testHistoryOfParent1.
@Test
public void testHistoryOfParent1() {
Child1Entity c1_1 = getEntityManager().find(Child1Entity.class, c1_1_id);
Child1Entity c1_2 = getEntityManager().find(Child1Entity.class, c1_2_id);
Child2Entity c2_2 = getEntityManager().find(Child2Entity.class, c2_2_id);
ParentEntity rev1 = getAuditReader().find(ParentEntity.class, p1_id, 1);
ParentEntity rev2 = getAuditReader().find(ParentEntity.class, p1_id, 2);
ParentEntity rev3 = getAuditReader().find(ParentEntity.class, p1_id, 3);
ParentEntity rev4 = getAuditReader().find(ParentEntity.class, p1_id, 4);
ParentEntity rev5 = getAuditReader().find(ParentEntity.class, p1_id, 5);
assert TestTools.checkCollection(rev1.getChildren1());
assert TestTools.checkCollection(rev2.getChildren1(), c1_1);
assert TestTools.checkCollection(rev3.getChildren1(), c1_1, c1_2);
assert TestTools.checkCollection(rev4.getChildren1(), c1_2);
assert TestTools.checkCollection(rev5.getChildren1());
assert TestTools.checkCollection(rev1.getChildren2());
assert TestTools.checkCollection(rev2.getChildren2());
assert TestTools.checkCollection(rev3.getChildren2(), c2_2);
assert TestTools.checkCollection(rev4.getChildren2(), c2_2);
assert TestTools.checkCollection(rev5.getChildren2(), c2_2);
}
use of org.hibernate.envers.test.entities.manytomany.sametable.Child2Entity in project hibernate-orm by hibernate.
the class ValidityAuditStrategyRevEndTestCustomRevEnt method testHistoryOfChild2_1.
@Test
public void testHistoryOfChild2_1() {
ParentEntity p2 = getEntityManager().find(ParentEntity.class, p2_id);
Child2Entity rev1 = getAuditReader().find(Child2Entity.class, c2_1_id, 1);
Child2Entity rev2 = getAuditReader().find(Child2Entity.class, c2_1_id, 2);
Child2Entity rev3 = getAuditReader().find(Child2Entity.class, c2_1_id, 3);
Child2Entity rev4 = getAuditReader().find(Child2Entity.class, c2_1_id, 4);
Child2Entity rev5 = getAuditReader().find(Child2Entity.class, c2_1_id, 5);
assert TestTools.checkCollection(rev1.getParents());
assert TestTools.checkCollection(rev2.getParents(), p2);
assert TestTools.checkCollection(rev3.getParents(), p2);
assert TestTools.checkCollection(rev4.getParents(), p2);
assert TestTools.checkCollection(rev5.getParents(), p2);
}
use of org.hibernate.envers.test.entities.manytomany.sametable.Child2Entity in project hibernate-orm by hibernate.
the class ValidityAuditStrategyRevEndTestCustomRevEnt method testHistoryOfChild2_2.
@Test
public void testHistoryOfChild2_2() {
ParentEntity p1 = getEntityManager().find(ParentEntity.class, p1_id);
ParentEntity p2 = getEntityManager().find(ParentEntity.class, p2_id);
Child2Entity rev1 = getAuditReader().find(Child2Entity.class, c2_2_id, 1);
Child2Entity rev2 = getAuditReader().find(Child2Entity.class, c2_2_id, 2);
Child2Entity rev3 = getAuditReader().find(Child2Entity.class, c2_2_id, 3);
Child2Entity rev4 = getAuditReader().find(Child2Entity.class, c2_2_id, 4);
Child2Entity rev5 = getAuditReader().find(Child2Entity.class, c2_2_id, 5);
assert TestTools.checkCollection(rev1.getParents());
assert TestTools.checkCollection(rev2.getParents());
assert TestTools.checkCollection(rev3.getParents(), p1);
assert TestTools.checkCollection(rev4.getParents(), p1, p2);
assert TestTools.checkCollection(rev5.getParents(), p1);
}
use of org.hibernate.envers.test.entities.manytomany.sametable.Child2Entity in project hibernate-orm by hibernate.
the class ValidityAuditStrategyRevEndTsTest method initData.
@Test
@Priority(10)
public void initData() {
EntityManager em = getEntityManager();
// We need first to modify the columns in the middle (join table) to
// allow null values. Hbm2ddl doesn't seem
// to allow this.
em.getTransaction().begin();
Session session = (Session) em.getDelegate();
session.createSQLQuery("DROP TABLE children").executeUpdate();
session.createSQLQuery("CREATE TABLE children ( parent_id " + getDialect().getTypeName(Types.INTEGER) + ", child1_id " + getDialect().getTypeName(Types.INTEGER) + getDialect().getNullColumnString() + ", child2_id " + getDialect().getTypeName(Types.INTEGER) + getDialect().getNullColumnString() + " )").executeUpdate();
session.createSQLQuery("DROP TABLE children_AUD").executeUpdate();
session.createSQLQuery("CREATE TABLE children_AUD ( REV " + getDialect().getTypeName(Types.INTEGER) + " NOT NULL" + ", REVEND " + getDialect().getTypeName(Types.INTEGER) + ", " + revendTimestampColumName + " " + getDialect().getTypeName(Types.TIMESTAMP) + ", REVTYPE " + getDialect().getTypeName(Types.TINYINT) + ", parent_id " + getDialect().getTypeName(Types.INTEGER) + ", child1_id " + getDialect().getTypeName(Types.INTEGER) + getDialect().getNullColumnString() + ", child2_id " + getDialect().getTypeName(Types.INTEGER) + getDialect().getNullColumnString() + " )").executeUpdate();
em.getTransaction().commit();
em.clear();
ParentEntity p1 = new ParentEntity("parent_1");
ParentEntity p2 = new ParentEntity("parent_2");
Child1Entity c1_1 = new Child1Entity("child1_1");
Child1Entity c1_2 = new Child1Entity("child1_2");
Child2Entity c2_1 = new Child2Entity("child2_1");
Child2Entity c2_2 = new Child2Entity("child2_2");
// Revision 1
em.getTransaction().begin();
em.persist(p1);
em.persist(p2);
em.persist(c1_1);
em.persist(c1_2);
em.persist(c2_1);
em.persist(c2_2);
em.getTransaction().commit();
em.clear();
// Revision 2 - (p1: c1_1, p2: c2_1)
em.getTransaction().begin();
p1 = em.find(ParentEntity.class, p1.getId());
p2 = em.find(ParentEntity.class, p2.getId());
c1_1 = em.find(Child1Entity.class, c1_1.getId());
c2_1 = em.find(Child2Entity.class, c2_1.getId());
p1.getChildren1().add(c1_1);
p2.getChildren2().add(c2_1);
em.getTransaction().commit();
em.clear();
// Revision 3 - (p1: c1_1, c1_2, c2_2, p2: c1_1, c2_1)
em.getTransaction().begin();
p1 = em.find(ParentEntity.class, p1.getId());
p2 = em.find(ParentEntity.class, p2.getId());
c1_1 = em.find(Child1Entity.class, c1_1.getId());
c1_2 = em.find(Child1Entity.class, c1_2.getId());
c2_2 = em.find(Child2Entity.class, c2_2.getId());
p1.getChildren1().add(c1_2);
p1.getChildren2().add(c2_2);
p2.getChildren1().add(c1_1);
em.getTransaction().commit();
em.clear();
// Revision 4 - (p1: c1_2, c2_2, p2: c1_1, c2_1, c2_2)
em.getTransaction().begin();
p1 = em.find(ParentEntity.class, p1.getId());
p2 = em.find(ParentEntity.class, p2.getId());
c1_1 = em.find(Child1Entity.class, c1_1.getId());
c2_2 = em.find(Child2Entity.class, c2_2.getId());
p1.getChildren1().remove(c1_1);
p2.getChildren2().add(c2_2);
em.getTransaction().commit();
em.clear();
// Revision 5 - (p1: c2_2, p2: c1_1, c2_1)
em.getTransaction().begin();
p1 = em.find(ParentEntity.class, p1.getId());
p2 = em.find(ParentEntity.class, p2.getId());
c1_2 = em.find(Child1Entity.class, c1_2.getId());
c2_2 = em.find(Child2Entity.class, c2_2.getId());
c2_2.getParents().remove(p2);
c1_2.getParents().remove(p1);
em.getTransaction().commit();
em.clear();
//
p1_id = p1.getId();
p2_id = p2.getId();
c1_1_id = c1_1.getId();
c1_2_id = c1_2.getId();
c2_1_id = c2_1.getId();
c2_2_id = c2_2.getId();
Set<Number> revisionNumbers = new HashSet<Number>();
revisionNumbers.addAll(Arrays.asList(1, 2, 3, 4, 5));
revisions = getAuditReader().findRevisions(SequenceIdRevisionEntity.class, revisionNumbers);
assert revisions.size() == 5;
}
Aggregations