public void queryMedicalHistory4() {
EntityManager em = emf.createEntityManager();
Map medicals = new HashMap();
long ssn = 0;
EntityTransaction tran = em.getTransaction();
tran.begin();
String jpql = "select m from MedicalHistory2 m";
Query q = em.createQuery(jpql);
List<MedicalHistory2> ms = q.getResultList();
for (MedicalHistory2 m : ms) {
ssn = m.getId();
}
tran.commit();
em.close();
em = emf.createEntityManager();
tran = em.getTransaction();
tran.begin();
jpql = "select m from MedicalHistory2 m where m.patient.ssn = " + ssn;
q = em.createQuery(jpql);
ms = q.getResultList();
for (MedicalHistory2 m : ms) {
assertMedicalHistory2(m);
}
tran.commit();
em.close();
findObj4(ssn);
}
public Person2 createPerson2(EntityManager em, int id) {
Person2 p = new Person2();
p.setName("p_" + id);
MedicalHistory2 m = createMedicalHistory2(em, mId2++);
m.setPatient(p); // automatically set the id
p.setMedical(m);
em.persist(m);
medicals2.put(m.getName(), m);
em.persist(p);
persons2.put(p.getName(), p);
return p;
}
public void assertMedicalHistory2(MedicalHistory2 m) {
String name = m.getName();
MedicalHistory2 m0 = medicals2.get(name);
MedicalHistory2 m1 = m.getPatient().getMedical();
assertEquals(m1, m);
}
public MedicalHistory2 createMedicalHistory2(EntityManager em, int id) {
MedicalHistory2 m = new MedicalHistory2();
m.setName("medical_" + id);
return m;
}
