/*
* 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.jpql.clauses;
import java.util.ArrayList;
import java.util.List;
import javax.persistence.EntityManager;
import org.apache.openjpa.persistence.common.utils.AbstractTestCase;
import org.apache.openjpa.persistence.common.apps.Course;
import org.apache.openjpa.persistence.common.apps.ArtCourse;
import org.apache.openjpa.persistence.common.apps.Department;
import org.apache.openjpa.persistence.common.apps.Student;
public class TestEJBClauses extends AbstractTestCase {
public TestEJBClauses(String name) {
super(name, "jpqlclausescactusapp");
}
public void setUp() {
deleteAll(Course.class);
deleteAll(Student.class);
deleteAll(Department.class);
EntityManager em = currentEntityManager();
startTx(em);
String name = "";
List<Course> clist = new ArrayList<Course>();
List<Department> dlist = new ArrayList<Department>();
for (int i = 0; i < 5; i++) {
Course curr = new Course("Math " + i, i * 2, i);
Course acurr = new ArtCourse(i + 20, "English" + (2 * i));
Department durr = new Department("CompSci" + i, null, i + 2);
clist.add(curr);
clist.add(acurr);
dlist.add(durr);
}
Student stud = new Student("Jonathan", clist, dlist);
Student stud2 = new Student("Stam", null, dlist);
Student stud3 = new Student("John", clist, null);
Student stud4 = new Student("Bill", null, null);
em.persist(stud);
em.persist(stud2);
em.persist(stud3);
em.persist(stud4);
endTx(em);
endEm(em);
}
public void testFromClause1() {
EntityManager em = currentEntityManager();
String query = "SELECT o.name FROM Student o";
List result = em.createQuery(query)
.getResultList();
assertNotNull(result);
assertEquals(4, result.size());
endEm(em);
}
public void testFromClause2() {
EntityManager em = currentEntityManager();
String query = "SELECT NEW apps.ArtCourse(e.name)" +
"FROM Student e";
List result = em.createQuery(query).getResultList();
assertNotNull(result);
assertEquals(4, result.size());
endEm(em);
}
public void testFromClause3() {
EntityManager em = currentEntityManager();
String query = "SELECT o.name " +
"FROM Student o, Course c " +
"WHERE o.course IS NULL AND o.department IS NULL";
List ls = (List) em.createQuery(query)
.getResultList();
String uno = (String) ls.get(0);
assertNotNull(ls);
assertEquals(1, ls.size());
assertEquals("Bill", uno);
endEm(em);
}
public void testWhereClause1() {
EntityManager em = currentEntityManager();
String query = "SELECT distinct s.name " +
"FROM Student s, Course d " +
"WHERE d.courseId >= 4 AND s.department IS NOT NULL";
List ls = em.createQuery(query).getResultList();
assertNotNull(ls);
assertEquals(2, ls.size());
endEm(em);
}
public void testWhereClause2() {
EntityManager em = currentEntityManager();
String query = "SELECT distinct s.name " +
"FROM Student s " +
"WHERE" +
" Exists(SELECT c FROM s.course c WHERE c.name LIKE 'Math%')";
List ls = em.createQuery(query).getResultList();
assertNotNull(ls);
assertEquals(2, ls.size());
assertTrue(ls.contains("Jonathan"));
assertTrue(ls.contains("John"));
endEm(em);
}
public void testClauseRangeVar() {
EntityManager em = currentEntityManager();
String query = "SELECT DISTINCT s FROM Student s, Student s2 " +
"WHERE s.name = 'John' AND s2.name = 'Jonathan'";
List ls = em.createQuery(query).getResultList();
assertNotNull(ls);
assertEquals(1, ls.size());
Student ret = (Student) ls.get(0);
assertEquals("John", ret.getName());
endEm(em);
}
public void testClausePathExpr() {
EntityManager em = currentEntityManager();
String failure = "SELECT DISTINCT s " +
"FROM Student s WHERE" +
" s.department.name = 'CompSci1'";
// Changes related to OPENJPA-485 allows this query to pass.
// The query is not kosher as it does navigate through a
// collection-valued-path-expression (s.department.name) where
// department is a Collection.
// But we allow this because of the convenience of the query expression
List ls = em.createQuery(failure).getResultList();
assertFalse(ls.isEmpty());
endEm(em);
}
public void testClausePathExpr2() {
EntityManager em = currentEntityManager();
String success =
"SELECT DISTINCT d.name FROM Student AS s, IN(s.department) d ";
List ls2 = em.createQuery(success).getResultList();
assertNotNull(ls2);
assertEquals(5, ls2.size());
endEm(em);
}
public void testCollMemberDecl() {
EntityManager em = currentEntityManager();
String colldec = "SELECT DISTINCT s.name " +
"FROM Student s," +
" IN(s.department) d" +
" WHERE d.name = 'CompSci2'";
List ls = em.createQuery(colldec).getResultList();
assertNotNull(ls);
assertEquals(2, ls.size());
assertTrue(ls.contains("Jonathan"));
assertTrue(ls.contains("Stam"));
endEm(em);
}
/**
* GroupBy , OrderBy clause is tested by testejbqlfunction under
* functional directory.
*/
}