| /* |
| * Licensed to the Apache Software Foundation (ASF) under one |
| * or more contributor license agreements. See the NOTICE file |
| * distributed with this work for additional information |
| * regarding copyright ownership. The ASF licenses this file |
| * to you under the Apache License, Version 2.0 (the |
| * "License"); you may not use this file except in compliance |
| * with the License. You may obtain a copy of the License at |
| * |
| * http://www.apache.org/licenses/LICENSE-2.0 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| */ |
| package org.apache.openjpa.persistence.query; |
| |
| import java.util.List; |
| |
| import javax.persistence.EntityManager; |
| import javax.persistence.Query; |
| |
| import org.apache.openjpa.persistence.query.common.apps.Osoba; |
| import org.apache.openjpa.persistence.query.common.apps.Projekt; |
| import org.apache.openjpa.persistence.test.SingleEMFTestCase; |
| |
| /** |
| * Tests that managed, unmanaged or even transient Entity can be used as a |
| * query parameter. |
| * |
| * Originally raised as a JIRA Issue |
| * <A HREF="https://issues.apache.org/jira/browse/OPENJPA-187">OPENJPA-187</A> |
| * |
| * @author Pinaki Poddar |
| * |
| */ |
| public class TestNewEntityAsQueryParameter extends SingleEMFTestCase { |
| |
| public static final String ID_PROJEKT1 = "OpenJPA"; |
| public static final String ID_PROJEKT2 = "Tomcat"; |
| |
| public static final int MEMBER_COUNT_PROJEKT1 = 6; |
| public static final int MEMBER_COUNT_PROJEKT2 = 4; |
| public static final int MEMBER_COUNT_TOTAL = 8; |
| |
| public void setUp() throws Exception { |
| super.setUp(CLEAR_TABLES, Osoba.class, Projekt.class, |
| "openjpa.Log", "SQL=TRACE"); |
| createData(); |
| } |
| |
| private void createData() { |
| EntityManager em = emf.createEntityManager(); |
| em.getTransaction().begin(); |
| |
| Osoba[] osoby = new Osoba[MEMBER_COUNT_TOTAL]; |
| for (int i=0; i<MEMBER_COUNT_TOTAL; i++) { |
| osoby[i] = new Osoba("Osoba-"+(i+1), 20+i); |
| em.persist(osoby[i]); |
| } |
| |
| |
| Projekt projekt1 = new Projekt(ID_PROJEKT1); |
| Projekt projekt2 = new Projekt(ID_PROJEKT2); |
| em.persist(projekt1); |
| em.persist(projekt2); |
| |
| for (int i=0; i<MEMBER_COUNT_PROJEKT1; i++) |
| link(osoby[i], projekt1); |
| for (int i=0; i<MEMBER_COUNT_PROJEKT2; i++) |
| link(osoby[osoby.length-i-1], projekt2); |
| |
| em.getTransaction().commit(); |
| em.clear(); |
| } |
| |
| public void tearDown() throws Exception { |
| super.tearDown(); |
| } |
| |
| public void testQueryWithTransientInstanceAsParameter() { |
| Projekt projekt1 = new Projekt(ID_PROJEKT1); |
| Projekt projekt2 = new Projekt(ID_PROJEKT2); |
| |
| EntityManager em = emf.createEntityManager(); |
| queryWithParameter(em, projekt1, projekt2); |
| } |
| |
| public void testQueryWithUnmanagedPersistentInstanceAsParameter() { |
| EntityManager em = emf.createEntityManager(); |
| Projekt projekt1 = em.find(Projekt.class, ID_PROJEKT1); |
| Projekt projekt2 = em.find(Projekt.class, ID_PROJEKT2); |
| em.clear(); |
| assertFalse(em.contains(projekt1)); |
| assertFalse(em.contains(projekt2)); |
| |
| queryWithParameter(em, projekt1, projekt2); |
| } |
| |
| public void testQueryWithManagedPersistentInstanceAsParameter() { |
| EntityManager em = emf.createEntityManager(); |
| Projekt projekt1 = em.find(Projekt.class, ID_PROJEKT1); |
| Projekt projekt2 = em.find(Projekt.class, ID_PROJEKT2); |
| assertTrue(em.contains(projekt1)); |
| assertTrue(em.contains(projekt2)); |
| |
| queryWithParameter(em, projekt1, projekt2); |
| } |
| |
| void queryWithParameter(EntityManager em, Projekt projekt1, Projekt projekt2) { |
| String jpql = "SELECT DISTINCT o FROM Osoba o WHERE :projekt MEMBER OF o.projekty"; |
| em.getTransaction().begin(); |
| Query query = em.createQuery(jpql); |
| |
| query.setParameter("projekt", projekt1); |
| List<Osoba> osoby = query.getResultList(); |
| assertEquals(MEMBER_COUNT_PROJEKT1, osoby.size()); |
| |
| query.setParameter("projekt", projekt2); |
| osoby = query.getResultList(); |
| assertEquals(MEMBER_COUNT_PROJEKT2, osoby.size()); |
| em.getTransaction().rollback(); |
| } |
| |
| void link(Osoba o, Projekt p) { |
| o.addProjekty(p); |
| p.addOsoba(o); |
| } |
| |
| } |