| /******************************************************************************* |
| * Copyright (c) 2007 Oracle. |
| * All rights reserved. This program and the accompanying materials |
| * are made available under the terms of the Eclipse Public License v1.0 |
| * which accompanies this distribution, and is available at |
| * http://www.eclipse.org/legal/epl-v10.html |
| * |
| * Contributors: |
| * Oracle - initial API and implementation |
| *******************************************************************************/ |
| package org.eclipse.jpt.core.tests.internal.context.java; |
| |
| import java.util.Iterator; |
| import java.util.ListIterator; |
| import org.eclipse.jdt.core.IType; |
| import org.eclipse.jpt.core.context.Entity; |
| import org.eclipse.jpt.core.context.NamedNativeQuery; |
| import org.eclipse.jpt.core.context.QueryHint; |
| import org.eclipse.jpt.core.resource.java.JPA; |
| import org.eclipse.jpt.core.resource.java.JavaResourcePersistentType; |
| import org.eclipse.jpt.core.resource.java.NamedNativeQueryAnnotation; |
| import org.eclipse.jpt.core.tests.internal.context.ContextModelTestCase; |
| import org.eclipse.jpt.utility.internal.iterators.ArrayIterator; |
| |
| public class JavaNamedNativeQueryTests extends ContextModelTestCase |
| { |
| private static final String QUERY_NAME = "QUERY_NAME"; |
| private static final String QUERY_QUERY = "MY_QUERY"; |
| |
| private void createEntityAnnotation() throws Exception{ |
| this.createAnnotationAndMembers("Entity", "String name() default \"\";"); |
| } |
| |
| private void createNamedNativeQueryAnnotation() throws Exception { |
| createQueryHintAnnotation(); |
| this.createAnnotationAndMembers("NamedNativeQuery", |
| "String name();" + |
| "String query();" + |
| "QueryHint[] hints() default {};"); |
| } |
| |
| private void createQueryHintAnnotation() throws Exception { |
| this.createAnnotationAndMembers("QueryHint", |
| "String name();" + |
| "String value();"); |
| } |
| |
| private IType createTestEntityWithNamedNativeQuery() throws Exception { |
| createEntityAnnotation(); |
| createNamedNativeQueryAnnotation(); |
| |
| return this.createTestType(new DefaultAnnotationWriter() { |
| @Override |
| public Iterator<String> imports() { |
| return new ArrayIterator<String>(JPA.ENTITY, JPA.NAMED_NATIVE_QUERY); |
| } |
| @Override |
| public void appendTypeAnnotationTo(StringBuilder sb) { |
| sb.append("@Entity").append(CR); |
| sb.append("@NamedNativeQuery(name=\"" + QUERY_NAME + "\", query=\"" + QUERY_QUERY + "\")"); |
| } |
| }); |
| } |
| |
| |
| |
| public JavaNamedNativeQueryTests(String name) { |
| super(name); |
| } |
| |
| public void testUpdateName() throws Exception { |
| createTestEntityWithNamedNativeQuery(); |
| addXmlClassRef(FULLY_QUALIFIED_TYPE_NAME); |
| |
| Entity entity = javaEntity(); |
| NamedNativeQuery namedNativeQuery = entity.namedNativeQueries().next(); |
| |
| JavaResourcePersistentType typeResource = jpaProject().getJavaPersistentTypeResource(FULLY_QUALIFIED_TYPE_NAME); |
| NamedNativeQueryAnnotation javaNamedNativeQuery = (NamedNativeQueryAnnotation) typeResource.getAnnotation(NamedNativeQueryAnnotation.ANNOTATION_NAME); |
| |
| assertEquals(QUERY_NAME, javaNamedNativeQuery.getName()); |
| assertEquals(QUERY_NAME, namedNativeQuery.getName()); |
| |
| //set name to null in the resource model |
| javaNamedNativeQuery.setName(null); |
| assertNull(javaNamedNativeQuery.getName()); |
| assertNull(namedNativeQuery.getName()); |
| |
| //set name in the resource model, verify context model updated |
| javaNamedNativeQuery.setName("foo"); |
| assertEquals("foo", javaNamedNativeQuery.getName()); |
| assertEquals("foo", namedNativeQuery.getName()); |
| } |
| |
| public void testModifyName() throws Exception { |
| createTestEntityWithNamedNativeQuery(); |
| addXmlClassRef(FULLY_QUALIFIED_TYPE_NAME); |
| Entity entity = javaEntity(); |
| NamedNativeQuery namedNativeQuery = entity.namedNativeQueries().next(); |
| |
| JavaResourcePersistentType typeResource = jpaProject().getJavaPersistentTypeResource(FULLY_QUALIFIED_TYPE_NAME); |
| NamedNativeQueryAnnotation javaNamedNativeQuery = (NamedNativeQueryAnnotation) typeResource.getAnnotation(NamedNativeQueryAnnotation.ANNOTATION_NAME); |
| |
| assertEquals(QUERY_NAME, javaNamedNativeQuery.getName()); |
| assertEquals(QUERY_NAME, namedNativeQuery.getName()); |
| |
| //set name to null in the context model |
| namedNativeQuery.setName(null); |
| assertNull(javaNamedNativeQuery.getName()); |
| assertNull(namedNativeQuery.getName()); |
| |
| //set name in the context model, verify resource model updated |
| namedNativeQuery.setName("foo"); |
| assertEquals("foo", javaNamedNativeQuery.getName()); |
| assertEquals("foo", namedNativeQuery.getName()); |
| } |
| |
| public void testUpdateQuery() throws Exception { |
| createTestEntityWithNamedNativeQuery(); |
| addXmlClassRef(FULLY_QUALIFIED_TYPE_NAME); |
| |
| Entity entity = javaEntity(); |
| NamedNativeQuery namedNativeQuery = entity.namedNativeQueries().next(); |
| |
| JavaResourcePersistentType typeResource = jpaProject().getJavaPersistentTypeResource(FULLY_QUALIFIED_TYPE_NAME); |
| NamedNativeQueryAnnotation javaNamedNativeQuery = (NamedNativeQueryAnnotation) typeResource.getAnnotation(NamedNativeQueryAnnotation.ANNOTATION_NAME); |
| |
| assertEquals(QUERY_QUERY, javaNamedNativeQuery.getQuery()); |
| assertEquals(QUERY_QUERY, namedNativeQuery.getQuery()); |
| |
| //set name to null in the resource model |
| javaNamedNativeQuery.setQuery(null); |
| assertNull(javaNamedNativeQuery.getQuery()); |
| assertNull(namedNativeQuery.getQuery()); |
| |
| //set name in the resource model, verify context model updated |
| javaNamedNativeQuery.setQuery("foo"); |
| assertEquals("foo", javaNamedNativeQuery.getQuery()); |
| assertEquals("foo", namedNativeQuery.getQuery()); |
| } |
| |
| public void testModifyQuery() throws Exception { |
| createTestEntityWithNamedNativeQuery(); |
| addXmlClassRef(FULLY_QUALIFIED_TYPE_NAME); |
| Entity entity = javaEntity(); |
| NamedNativeQuery namedNativeQuery = entity.namedNativeQueries().next(); |
| |
| JavaResourcePersistentType typeResource = jpaProject().getJavaPersistentTypeResource(FULLY_QUALIFIED_TYPE_NAME); |
| NamedNativeQueryAnnotation javaNamedNativeQuery = (NamedNativeQueryAnnotation) typeResource.getAnnotation(NamedNativeQueryAnnotation.ANNOTATION_NAME); |
| |
| assertEquals(QUERY_QUERY, javaNamedNativeQuery.getQuery()); |
| assertEquals(QUERY_QUERY, namedNativeQuery.getQuery()); |
| |
| //set name to null in the context model |
| namedNativeQuery.setQuery(null); |
| assertNull(javaNamedNativeQuery.getQuery()); |
| assertNull(namedNativeQuery.getQuery()); |
| |
| //set name in the context model, verify resource model updated |
| namedNativeQuery.setQuery("foo"); |
| assertEquals("foo", javaNamedNativeQuery.getQuery()); |
| assertEquals("foo", namedNativeQuery.getQuery()); |
| } |
| |
| |
| public void testAddHint() throws Exception { |
| createTestEntityWithNamedNativeQuery(); |
| addXmlClassRef(FULLY_QUALIFIED_TYPE_NAME); |
| Entity entity = javaEntity(); |
| NamedNativeQuery namedNativeQuery = entity.namedNativeQueries().next(); |
| |
| JavaResourcePersistentType typeResource = jpaProject().getJavaPersistentTypeResource(FULLY_QUALIFIED_TYPE_NAME); |
| NamedNativeQueryAnnotation javaNamedNativeQuery = (NamedNativeQueryAnnotation) typeResource.getAnnotation(NamedNativeQueryAnnotation.ANNOTATION_NAME); |
| |
| |
| QueryHint queryHint = namedNativeQuery.addHint(0); |
| ormResource().save(null); |
| queryHint.setName("FOO"); |
| ormResource().save(null); |
| |
| assertEquals("FOO", javaNamedNativeQuery.hintAt(0).getName()); |
| |
| QueryHint queryHint2 = namedNativeQuery.addHint(0); |
| ormResource().save(null); |
| queryHint2.setName("BAR"); |
| ormResource().save(null); |
| |
| assertEquals("BAR", javaNamedNativeQuery.hintAt(0).getName()); |
| assertEquals("FOO", javaNamedNativeQuery.hintAt(1).getName()); |
| |
| QueryHint queryHint3 = namedNativeQuery.addHint(1); |
| ormResource().save(null); |
| queryHint3.setName("BAZ"); |
| ormResource().save(null); |
| |
| assertEquals("BAR", javaNamedNativeQuery.hintAt(0).getName()); |
| assertEquals("BAZ", javaNamedNativeQuery.hintAt(1).getName()); |
| assertEquals("FOO", javaNamedNativeQuery.hintAt(2).getName()); |
| |
| ListIterator<QueryHint> hints = namedNativeQuery.hints(); |
| assertEquals(queryHint2, hints.next()); |
| assertEquals(queryHint3, hints.next()); |
| assertEquals(queryHint, hints.next()); |
| |
| hints = namedNativeQuery.hints(); |
| assertEquals("BAR", hints.next().getName()); |
| assertEquals("BAZ", hints.next().getName()); |
| assertEquals("FOO", hints.next().getName()); |
| } |
| |
| public void testRemoveHint() throws Exception { |
| createTestEntityWithNamedNativeQuery(); |
| addXmlClassRef(FULLY_QUALIFIED_TYPE_NAME); |
| Entity entity = javaEntity(); |
| NamedNativeQuery namedNativeQuery = entity.namedNativeQueries().next(); |
| |
| JavaResourcePersistentType typeResource = jpaProject().getJavaPersistentTypeResource(FULLY_QUALIFIED_TYPE_NAME); |
| NamedNativeQueryAnnotation javaNamedNativeQuery = (NamedNativeQueryAnnotation) typeResource.getAnnotation(NamedNativeQueryAnnotation.ANNOTATION_NAME); |
| |
| namedNativeQuery.addHint(0).setName("FOO"); |
| namedNativeQuery.addHint(1).setName("BAR"); |
| namedNativeQuery.addHint(2).setName("BAZ"); |
| |
| assertEquals(3, javaNamedNativeQuery.hintsSize()); |
| |
| namedNativeQuery.removeHint(0); |
| assertEquals(2, javaNamedNativeQuery.hintsSize()); |
| assertEquals("BAR", javaNamedNativeQuery.hintAt(0).getName()); |
| assertEquals("BAZ", javaNamedNativeQuery.hintAt(1).getName()); |
| |
| namedNativeQuery.removeHint(0); |
| assertEquals(1, javaNamedNativeQuery.hintsSize()); |
| assertEquals("BAZ", javaNamedNativeQuery.hintAt(0).getName()); |
| |
| namedNativeQuery.removeHint(0); |
| assertEquals(0, javaNamedNativeQuery.hintsSize()); |
| } |
| |
| public void testMoveHint() throws Exception { |
| createTestEntityWithNamedNativeQuery(); |
| addXmlClassRef(FULLY_QUALIFIED_TYPE_NAME); |
| Entity entity = javaEntity(); |
| NamedNativeQuery namedNativeQuery = entity.namedNativeQueries().next(); |
| |
| JavaResourcePersistentType typeResource = jpaProject().getJavaPersistentTypeResource(FULLY_QUALIFIED_TYPE_NAME); |
| NamedNativeQueryAnnotation javaNamedNativeQuery = (NamedNativeQueryAnnotation) typeResource.getAnnotation(NamedNativeQueryAnnotation.ANNOTATION_NAME); |
| |
| namedNativeQuery.addHint(0).setName("FOO"); |
| namedNativeQuery.addHint(1).setName("BAR"); |
| namedNativeQuery.addHint(2).setName("BAZ"); |
| |
| assertEquals(3, javaNamedNativeQuery.hintsSize()); |
| |
| |
| namedNativeQuery.moveHint(2, 0); |
| ListIterator<QueryHint> hints = namedNativeQuery.hints(); |
| assertEquals("BAR", hints.next().getName()); |
| assertEquals("BAZ", hints.next().getName()); |
| assertEquals("FOO", hints.next().getName()); |
| |
| assertEquals("BAR", javaNamedNativeQuery.hintAt(0).getName()); |
| assertEquals("BAZ", javaNamedNativeQuery.hintAt(1).getName()); |
| assertEquals("FOO", javaNamedNativeQuery.hintAt(2).getName()); |
| |
| |
| namedNativeQuery.moveHint(0, 1); |
| hints = namedNativeQuery.hints(); |
| assertEquals("BAZ", hints.next().getName()); |
| assertEquals("BAR", hints.next().getName()); |
| assertEquals("FOO", hints.next().getName()); |
| |
| assertEquals("BAZ", javaNamedNativeQuery.hintAt(0).getName()); |
| assertEquals("BAR", javaNamedNativeQuery.hintAt(1).getName()); |
| assertEquals("FOO", javaNamedNativeQuery.hintAt(2).getName()); |
| } |
| |
| public void testUpdateHints() throws Exception { |
| createTestEntityWithNamedNativeQuery(); |
| addXmlClassRef(FULLY_QUALIFIED_TYPE_NAME); |
| Entity entity = javaEntity(); |
| NamedNativeQuery namedNativeQuery = entity.namedNativeQueries().next(); |
| |
| JavaResourcePersistentType typeResource = jpaProject().getJavaPersistentTypeResource(FULLY_QUALIFIED_TYPE_NAME); |
| NamedNativeQueryAnnotation javaNamedNativeQuery = (NamedNativeQueryAnnotation) typeResource.getAnnotation(NamedNativeQueryAnnotation.ANNOTATION_NAME); |
| |
| javaNamedNativeQuery.addHint(0); |
| javaNamedNativeQuery.addHint(1); |
| javaNamedNativeQuery.addHint(2); |
| |
| javaNamedNativeQuery.hintAt(0).setName("FOO"); |
| javaNamedNativeQuery.hintAt(1).setName("BAR"); |
| javaNamedNativeQuery.hintAt(2).setName("BAZ"); |
| |
| ListIterator<QueryHint> hints = namedNativeQuery.hints(); |
| assertEquals("FOO", hints.next().getName()); |
| assertEquals("BAR", hints.next().getName()); |
| assertEquals("BAZ", hints.next().getName()); |
| assertFalse(hints.hasNext()); |
| |
| javaNamedNativeQuery.moveHint(2, 0); |
| hints = namedNativeQuery.hints(); |
| assertEquals("BAR", hints.next().getName()); |
| assertEquals("BAZ", hints.next().getName()); |
| assertEquals("FOO", hints.next().getName()); |
| assertFalse(hints.hasNext()); |
| |
| javaNamedNativeQuery.moveHint(0, 1); |
| hints = namedNativeQuery.hints(); |
| assertEquals("BAZ", hints.next().getName()); |
| assertEquals("BAR", hints.next().getName()); |
| assertEquals("FOO", hints.next().getName()); |
| assertFalse(hints.hasNext()); |
| |
| javaNamedNativeQuery.removeHint(1); |
| hints = namedNativeQuery.hints(); |
| assertEquals("BAZ", hints.next().getName()); |
| assertEquals("FOO", hints.next().getName()); |
| assertFalse(hints.hasNext()); |
| |
| javaNamedNativeQuery.removeHint(1); |
| hints = namedNativeQuery.hints(); |
| assertEquals("BAZ", hints.next().getName()); |
| assertFalse(hints.hasNext()); |
| |
| javaNamedNativeQuery.removeHint(0); |
| assertFalse(namedNativeQuery.hints().hasNext()); |
| } |
| |
| public void testHintsSize() throws Exception { |
| createTestEntityWithNamedNativeQuery(); |
| addXmlClassRef(FULLY_QUALIFIED_TYPE_NAME); |
| Entity entity = javaEntity(); |
| |
| NamedNativeQuery namedNativeQuery = entity.namedNativeQueries().next(); |
| assertEquals(0, namedNativeQuery.hintsSize()); |
| |
| JavaResourcePersistentType typeResource = jpaProject().getJavaPersistentTypeResource(FULLY_QUALIFIED_TYPE_NAME); |
| NamedNativeQueryAnnotation javaNamedNativeQuery = (NamedNativeQueryAnnotation) typeResource.getAnnotation(NamedNativeQueryAnnotation.ANNOTATION_NAME); |
| |
| |
| javaNamedNativeQuery.addHint(0); |
| assertEquals(1, namedNativeQuery.hintsSize()); |
| |
| javaNamedNativeQuery.addHint(0); |
| assertEquals(2, namedNativeQuery.hintsSize()); |
| |
| javaNamedNativeQuery.removeHint(0); |
| javaNamedNativeQuery.removeHint(0); |
| assertEquals(0, namedNativeQuery.hintsSize()); |
| } |
| |
| public void testUpdateResultClass() throws Exception { |
| createTestEntityWithNamedNativeQuery(); |
| addXmlClassRef(FULLY_QUALIFIED_TYPE_NAME); |
| |
| Entity entity = javaEntity(); |
| NamedNativeQuery namedNativeQuery = entity.namedNativeQueries().next(); |
| |
| JavaResourcePersistentType typeResource = jpaProject().getJavaPersistentTypeResource(FULLY_QUALIFIED_TYPE_NAME); |
| NamedNativeQueryAnnotation javaNamedNativeQuery = (NamedNativeQueryAnnotation) typeResource.getAnnotation(NamedNativeQueryAnnotation.ANNOTATION_NAME); |
| |
| assertEquals(null, javaNamedNativeQuery.getResultClass()); |
| assertEquals(null, namedNativeQuery.getResultClass()); |
| |
| //set name in the resource model, verify context model updated |
| javaNamedNativeQuery.setResultClass("foo"); |
| assertEquals("foo", javaNamedNativeQuery.getResultClass()); |
| assertEquals("foo", namedNativeQuery.getResultClass()); |
| |
| //set name to null in the resource model |
| javaNamedNativeQuery.setResultClass(null); |
| assertNull(javaNamedNativeQuery.getResultClass()); |
| assertNull(namedNativeQuery.getResultClass()); |
| } |
| |
| public void testModifyResultClass() throws Exception { |
| createTestEntityWithNamedNativeQuery(); |
| addXmlClassRef(FULLY_QUALIFIED_TYPE_NAME); |
| Entity entity = javaEntity(); |
| NamedNativeQuery namedNativeQuery = entity.namedNativeQueries().next(); |
| |
| JavaResourcePersistentType typeResource = jpaProject().getJavaPersistentTypeResource(FULLY_QUALIFIED_TYPE_NAME); |
| NamedNativeQueryAnnotation javaNamedNativeQuery = (NamedNativeQueryAnnotation) typeResource.getAnnotation(NamedNativeQueryAnnotation.ANNOTATION_NAME); |
| |
| assertEquals(null, javaNamedNativeQuery.getResultClass()); |
| assertEquals(null, namedNativeQuery.getResultClass()); |
| |
| //set name in the context model, verify resource model updated |
| namedNativeQuery.setResultClass("foo"); |
| assertEquals("foo", javaNamedNativeQuery.getResultClass()); |
| assertEquals("foo", namedNativeQuery.getResultClass()); |
| |
| //set name to null in the context model |
| namedNativeQuery.setResultClass(null); |
| assertNull(javaNamedNativeQuery.getResultClass()); |
| assertNull(namedNativeQuery.getResultClass()); |
| } |
| |
| public void testUpdateResultSetMapping() throws Exception { |
| createTestEntityWithNamedNativeQuery(); |
| addXmlClassRef(FULLY_QUALIFIED_TYPE_NAME); |
| |
| Entity entity = javaEntity(); |
| NamedNativeQuery namedNativeQuery = entity.namedNativeQueries().next(); |
| |
| JavaResourcePersistentType typeResource = jpaProject().getJavaPersistentTypeResource(FULLY_QUALIFIED_TYPE_NAME); |
| NamedNativeQueryAnnotation javaNamedNativeQuery = (NamedNativeQueryAnnotation) typeResource.getAnnotation(NamedNativeQueryAnnotation.ANNOTATION_NAME); |
| |
| assertEquals(null, javaNamedNativeQuery.getResultSetMapping()); |
| assertEquals(null, namedNativeQuery.getResultSetMapping()); |
| |
| //set name in the resource model, verify context model updated |
| javaNamedNativeQuery.setResultSetMapping("foo"); |
| assertEquals("foo", javaNamedNativeQuery.getResultSetMapping()); |
| assertEquals("foo", namedNativeQuery.getResultSetMapping()); |
| |
| //set name to null in the resource model |
| javaNamedNativeQuery.setResultSetMapping(null); |
| assertNull(javaNamedNativeQuery.getResultSetMapping()); |
| assertNull(namedNativeQuery.getResultSetMapping()); |
| } |
| |
| public void testModifyResultSetMapping() throws Exception { |
| createTestEntityWithNamedNativeQuery(); |
| addXmlClassRef(FULLY_QUALIFIED_TYPE_NAME); |
| Entity entity = javaEntity(); |
| NamedNativeQuery namedNativeQuery = entity.namedNativeQueries().next(); |
| |
| JavaResourcePersistentType typeResource = jpaProject().getJavaPersistentTypeResource(FULLY_QUALIFIED_TYPE_NAME); |
| NamedNativeQueryAnnotation javaNamedNativeQuery = (NamedNativeQueryAnnotation) typeResource.getAnnotation(NamedNativeQueryAnnotation.ANNOTATION_NAME); |
| |
| assertEquals(null, javaNamedNativeQuery.getResultSetMapping()); |
| assertEquals(null, namedNativeQuery.getResultSetMapping()); |
| |
| //set name in the context model, verify resource model updated |
| namedNativeQuery.setResultSetMapping("foo"); |
| assertEquals("foo", javaNamedNativeQuery.getResultSetMapping()); |
| assertEquals("foo", namedNativeQuery.getResultSetMapping()); |
| |
| //set name to null in the context model |
| namedNativeQuery.setResultSetMapping(null); |
| assertNull(javaNamedNativeQuery.getResultSetMapping()); |
| assertNull(namedNativeQuery.getResultSetMapping()); |
| } |
| |
| } |