/*******************************************************************************
* Copyright (c) 2005, 2015 SAP. All rights reserved.
* This program and the accompanying materials are made available under the
* terms of the Eclipse Public License v1.0 and Eclipse Distribution License v. 1.0
* which accompanies this distribution.
* The Eclipse Public License is available at http://www.eclipse.org/legal/epl-v10.html
* and the Eclipse Distribution License is available at
* http://www.eclipse.org/org/documents/edl-v10.php.
*
* Contributors:
* SAP - initial API and implementation
******************************************************************************/
package org.eclipse.persistence.testing.tests.wdf.jpa1.relation;
import java.sql.Date;
import java.sql.SQLException;
import javax.persistence.EntityManager;
import javax.persistence.Query;
import org.eclipse.persistence.testing.framework.wdf.JPAEnvironment;
import org.eclipse.persistence.testing.models.wdf.jpa1.employee.Patent;
import org.eclipse.persistence.testing.models.wdf.jpa1.employee.PatentId;
import org.eclipse.persistence.testing.models.wdf.jpa1.employee.PatentReview;
import org.eclipse.persistence.testing.tests.wdf.jpa1.JPA1Base;
import org.junit.Test;
public class TestPatentReview extends JPA1Base {
@Test
public void testToOneRelationshipWithEmbddedKey() throws SQLException {
clearAllTables();
final JPAEnvironment env = getEnvironment();
final EntityManager em = env.getEntityManager();
try {
final String FUSSBALL = "Fussball";
env.beginTransaction(em);
PatentReview patentReview = new PatentReview();
Patent patent = new Patent(FUSSBALL, 1857, "das Fu\u00dfballspiel", Date.valueOf("1857-01-01"));
patentReview.setId(17);
patentReview.setPatent(patent);
patentReview.setReviewText("Review des Patents des Fu\u00dfballspiels");
em.persist(patent);
em.persist(patentReview);
env.commitTransactionAndClear(em);
Object found = em.find(PatentReview.class, Integer.valueOf(17));
verify(found != null, "nothing found");
verify(found instanceof PatentReview, "wrong instance: " + found.getClass().getName());
PatentReview review = (PatentReview) found;
verify(review.getPatent() != null, "patent is null");
Patent pat = review.getPatent();
PatentId id = pat.getId();
verify(FUSSBALL.equals(id.getName()), "patent has wrong name: " + id.getName());
verify(id.getYear() == 1857, "patent has wrong year: " + id.getYear());
} finally {
closeEntityManager(em);
}
}
@Test
public void testNoEnBlocLoading() throws SQLException {
clearAllTables();
final JPAEnvironment env = getEnvironment();
final EntityManager em = env.getEntityManager();
try {
env.beginTransaction(em);
final String PARSER = "SQL Parser";
PatentReview patentReview = new PatentReview();
Patent patent = new Patent(PARSER, 2002, "SQL Parser", Date.valueOf("2002-01-01"));
patentReview.setId(20);
patentReview.setPatent(patent);
patentReview.setReviewText("Review vom SQL Parser Patent");
em.persist(patent);
em.persist(patentReview);
final String SORTER = "Foreign Key Sorter";
patentReview = new PatentReview();
patent = new Patent(SORTER, 2008, "Foreign Key Sorter", Date.valueOf("2008-01-01"));
patentReview.setId(21);
patentReview.setPatent(patent);
patentReview.setReviewText("Review vom Foreign Key Sorter");
em.persist(patent);
em.persist(patentReview);
final String MONITOR = "JPA Monitor";
patentReview = new PatentReview();
patent = new Patent(MONITOR, 2007, "JPA Monitor", Date.valueOf("2007-01-01"));
patentReview.setId(22);
patentReview.setPatent(patent);
patentReview.setReviewText("Review vom JPA Monitor");
em.persist(patent);
em.persist(patentReview);
final String MANAGER = "Environment Manager";
patentReview = new PatentReview();
patent = new Patent(MANAGER, 2005, "Environment Manager", Date.valueOf("2005-01-01"));
patentReview.setId(23);
patentReview.setPatent(patent);
patentReview.setReviewText("Review vom Environment Manager");
em.persist(patent);
em.persist(patentReview);
env.commitTransactionAndClear(em);
env.beginTransaction(em);
Query query = em.createQuery("select r from PatentReview r");
query.getResultList();
} finally {
closeEntityManager(em);
}
}
@Test
public void testNativeQuery() throws SQLException {
clearAllTables();
final JPAEnvironment env = getEnvironment();
final EntityManager em = env.getEntityManager();
try {
final String FUSSBALL = "Fussball";
env.beginTransaction(em);
PatentReview patentReview = new PatentReview();
Patent patent = new Patent(FUSSBALL, 1857, "das Fu\u00dfballspiel", Date.valueOf("1857-01-01"));
patentReview.setId(18);
patentReview.setPatent(patent);
patentReview.setReviewText("Review des Patents des Fu\u00dfballspiels");
em.persist(patent);
em.persist(patentReview);
env.commitTransactionAndClear(em);
Query query = em
.createNativeQuery(
"select * from TMP_REVIEW join TMP_REVIEW_DETAILS on TMP_REVIEW.ID = TMP_REVIEW_DETAILS.REVIEW_ID where ID = 18",
PatentReview.class);
Object found = query.getSingleResult();
verify(found != null, "nothing found");
verify(found instanceof PatentReview, "wrong instance: " + found.getClass().getName());
PatentReview review = (PatentReview) found;
verify(review.getPatent() != null, "patent is null");
Patent pat = review.getPatent();
PatentId id = pat.getId();
verify(FUSSBALL.equals(id.getName()), "patent has wrong name: " + id.getName());
verify(id.getYear() == 1857, "patent has wrong year: " + id.getYear());
} finally {
closeEntityManager(em);
}
}
}