use of org.datanucleus.samples.annotations.one_many.unidir_2.UserGroup in project tests by datanucleus.
the class RelationshipsTest method testOneToManyJoinTableIndexedList.
/**
* Test of 1-N JoinTable indexed list (JPA2).
*/
public void testOneToManyJoinTableIndexedList() {
EntityManagerFactory emf2 = getEMF(1, "JPATest", null);
try {
EntityManager em = emf2.createEntityManager();
EntityTransaction tx = em.getTransaction();
try {
tx.begin();
UserGroup grp = new UserGroup(1, "JDO Expert Group");
GroupMember member1 = new GroupMember(1, "Craig Russell");
GroupMember member2 = new GroupMember(2, "David Jordan");
List<GroupMember> members = new ArrayList<>();
members.add(member1);
members.add(member2);
grp.setMembers(members);
em.persist(grp);
tx.commit();
} catch (Exception e) {
e.printStackTrace();
fail("Exception thrown while creating UserGroup+GroupMembers");
} finally {
if (tx.isActive()) {
tx.rollback();
}
em.close();
}
// Check the contents of the datastore
em = emf2.createEntityManager();
tx = em.getTransaction();
try {
tx.begin();
List result = em.createQuery("SELECT Object(T) FROM " + UserGroup.class.getName() + " T").getResultList();
assertEquals(1, result.size());
UserGroup grp = (UserGroup) result.get(0);
Collection<GroupMember> members = grp.getMembers();
assertEquals("Number of GroupMembers in UserGroup is incorrect", 2, members.size());
Iterator<GroupMember> iter = members.iterator();
boolean hasMem1 = false;
boolean hasMem2 = false;
GroupMember mem1 = iter.next();
GroupMember mem2 = iter.next();
if (mem1.getName().equals("Craig Russell")) {
hasMem1 = true;
}
if (mem2.getName().equals("David Jordan")) {
hasMem2 = true;
}
assertTrue("First member of user group is not present (in right place)", hasMem1);
assertTrue("Second member of user group is not present (in right place)", hasMem2);
tx.rollback();
} catch (Exception e) {
e.printStackTrace();
fail("Exception thrown while retrieving UserGroup+GroupMembers");
} finally {
if (tx.isActive()) {
tx.rollback();
}
em.close();
}
} finally {
clean(emf2, UserGroup.class);
clean(emf2, GroupMember.class);
}
emf2.close();
}
use of org.datanucleus.samples.annotations.one_many.unidir_2.UserGroup in project tests by datanucleus.
the class JPQLQueryTest method testJoinMultipleFields.
/**
* Test for join across multiple fields in single join.
*/
public void testJoinMultipleFields() {
try {
EntityManager em = getEM();
EntityTransaction tx = em.getTransaction();
try {
tx.begin();
UserGroup grp = new UserGroup(101, "JPOX Users");
GroupMember member1 = new GroupMember(201, "Joe User");
MemberDetails memDets = new MemberDetails(301, "Joe", "User");
member1.setDetails(memDets);
grp.getMembers().add(member1);
em.persist(grp);
em.flush();
List result = em.createQuery("SELECT G FROM " + UserGroup.class.getName() + " G INNER JOIN G.members.details D").getResultList();
assertEquals(1, result.size());
tx.rollback();
} finally {
if (tx.isActive()) {
tx.rollback();
}
em.close();
}
} finally {
clean(UserGroup.class);
clean(GroupMember.class);
clean(MemberDetails.class);
}
}
use of org.datanucleus.samples.annotations.one_many.unidir_2.UserGroup in project tests by datanucleus.
the class JPQLQueryTest method testInnerJoinOneToManyUniFKOwner.
/**
* Test for Inner Join 1-N unidirectional FK relation from the owner side.
*/
public void testInnerJoinOneToManyUniFKOwner() {
try {
EntityManager em = getEM();
EntityTransaction tx = em.getTransaction();
try {
tx.begin();
UserGroup grp = new UserGroup(101, "JPOX Users");
GroupMember member1 = new GroupMember(201, "Joe User");
grp.getMembers().add(member1);
em.persist(grp);
em.flush();
List result = em.createQuery("SELECT G FROM " + UserGroup.class.getName() + " G INNER JOIN G.members M").getResultList();
assertEquals(1, result.size());
tx.rollback();
} finally {
if (tx.isActive()) {
tx.rollback();
}
em.close();
}
} finally {
clean(UserGroup.class);
clean(GroupMember.class);
}
}
use of org.datanucleus.samples.annotations.one_many.unidir_2.UserGroup in project tests by datanucleus.
the class AttachDetachReplicateTest method testReplicateApplicationIdentityWith1toN.
public void testReplicateApplicationIdentityWith1toN() {
PersistenceManagerFactory pmf1 = null;
PersistenceManagerFactory pmf2 = null;
try {
// Connect to "datastore1"
Properties props = new Properties();
props.setProperty(PropertyNames.PROPERTY_ATTACH_SAME_DATASTORE, "false");
props.setProperty(PropertyNames.PROPERTY_AUTOSTART_MECHANISM, "Classes");
props.setProperty(PropertyNames.PROPERTY_AUTOSTART_CLASSNAMES, "org.jpox.samples.one_many.unidir_2.GroupMember,org.jpox.samples.one_many.unidir_2.ExpertGroupMember," + "org.jpox.samples.one_many.unidir_2.UserGroup,org.jpox.samples.one_many.unidir_2.ModeratedUserGroup");
pmf1 = getPMF(1, props);
// Persist data to "datastore1"
PersistenceManager pm1 = pmf1.getPersistenceManager();
Transaction tx1 = pm1.currentTransaction();
Object holderId = null;
try {
tx1.begin();
ModeratedUserGroup holder = new ModeratedUserGroup(1, "HolderA", "First A");
List<GroupMember> elements = new ArrayList<GroupMember>();
elements.add(new ExpertGroupMember(25, "ElementB1", "First B"));
elements.add(new ExpertGroupMember(26, "ElementB2", "Second B"));
elements.add(new GroupMember(27, "ElementB3"));
elements.add(new GroupMember(28, "ElementB4"));
holder.setMembers(elements);
pm1.makePersistent(holder);
tx1.commit();
holderId = JDOHelper.getObjectId(holder);
} catch (Exception e) {
LOG.error("Exception thrown creating data in datastore 1", e);
e.printStackTrace();
return;
} finally {
if (tx1.isActive()) {
tx1.rollback();
}
pm1.close();
}
// Detach holder from "datastore1"
UserGroup detachedHolder = null;
pm1 = pmf1.getPersistenceManager();
tx1 = pm1.currentTransaction();
try {
pm1.getFetchPlan().setGroups(new String[] { FetchPlan.DEFAULT, FetchPlan.ALL });
pm1.getFetchPlan().setMaxFetchDepth(-1);
tx1.begin();
ModeratedUserGroup holder = (ModeratedUserGroup) pm1.getObjectById(holderId);
detachedHolder = (ModeratedUserGroup) pm1.detachCopy(holder);
tx1.commit();
} catch (Exception e) {
LOG.error("Exception thrown detaching data from datastore 1", e);
fail("Exception in detach with datastore 1 : " + e.getMessage());
} finally {
if (tx1.isActive()) {
tx1.rollback();
}
pm1.close();
}
// Connect to "datastore2"
pmf2 = getPMF(2, props);
// Attach data to "datastore2"
PersistenceManager pm2 = pmf2.getPersistenceManager();
Transaction tx2 = pm2.currentTransaction();
try {
tx2.begin();
pm2.makePersistent(detachedHolder);
tx2.commit();
} catch (Exception e) {
LOG.error("Exception thrown attaching data to datastore 2", e);
fail("Exception in attach with datastore 2 : " + e.getMessage());
} finally {
if (tx2.isActive()) {
tx2.rollback();
}
pm2.close();
}
} catch (Exception e) {
fail("Exception on attach to datastore 2 : " + e.getMessage());
} finally {
// Clean out our data
clean(ModeratedUserGroup.class);
clean(UserGroup.class);
clean(ExpertGroupMember.class);
clean(GroupMember.class);
}
}
use of org.datanucleus.samples.annotations.one_many.unidir_2.UserGroup in project tests by datanucleus.
the class JDOQLBasicTest method testQueryUnboundVariablesInheritance2.
public void testQueryUnboundVariablesInheritance2() {
try {
ModeratedUserGroup grp1 = new ModeratedUserGroup(1, "JDO Expert Group");
ModeratedUserGroup grp2 = new ModeratedUserGroup(1, "JPA Expert Group");
ModeratedUserGroup grp3 = new ModeratedUserGroup(1, "J2EE Expert Group");
ExpertGroupMember mem1 = new ExpertGroupMember(1, "Craig Russell");
ExpertGroupMember mem2 = new ExpertGroupMember(1, "Linda De Michiel");
ExpertGroupMember mem3 = new ExpertGroupMember(1, "Bill Shannon");
grp1.getMembers().add(mem1);
grp2.getMembers().add(mem2);
grp3.getMembers().add(mem2);
grp3.getMembers().add(mem3);
PersistenceManager pm = pmf.getPersistenceManager();
Transaction tx = pm.currentTransaction();
try {
tx.begin();
pm.makePersistent(grp1);
pm.makePersistent(grp2);
pm.makePersistent(grp3);
tx.commit();
tx.begin();
Query q = pm.newQuery(pm.getExtent(UserGroup.class, true));
Collection c = q.filter("this.members.contains(mem) && mem.name == \"Craig Russell\"").variables("ExpertGroupMember mem").imports("import org.jpox.samples.one_many.unidir_2.ExpertGroupMember").executeList();
assertEquals(1, c.size());
assertEquals(((UserGroup) c.iterator().next()).getName(), "JDO Expert Group");
tx.commit();
} finally {
if (tx.isActive()) {
tx.rollback();
}
pm.close();
}
} finally {
// Clean out our data
clean(ModeratedUserGroup.class);
clean(ExpertGroupMember.class);
}
}
Aggregations