openjpa-persistence-jdbc/src/test/java/org/apache/openjpa/persistence/criteria/TestCQL.java

/*
 * 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.criteria;

import javax.persistence.criteria.Predicate;
import javax.persistence.criteria.Root;

/**
 * Test logical predicates precedence is preserved and rendered correctly in CQL.
 *
 * @author Pinaki Poddar
 *
 */
public class TestCQL extends CriteriaTest {
    public void testLogicalPrecedence() {
        OpenJPACriteriaQuery<Person> q = cb.createQuery(Person.class);
        Root<Person> p = q.from(Person.class);
        q.select(p);
        Predicate a = cb.equal(p.get(Person_.name), "A");
        Predicate b = cb.equal(p.get(Person_.name), "B");
        Predicate c = cb.equal(p.get(Person_.name), "C");
        Predicate d = cb.equal(p.get(Person_.name), "D");

        // (a OR b) AND (c or D)
        q.where(cb.or(a,b), cb.or(c,d));

        String jpql = "";
        // The strings are compared for exact match so be careful about spaces and such...
        jpql = "SELECT p FROM Person p WHERE ((p.name = 'A' OR p.name = 'B') AND (p.name = 'C' OR p.name = 'D'))";
        assertEquivalence(q, jpql);
        assertEquals(jpql, q.toCQL());

        // (a OR b or C) AND D
        q.where(cb.or(a,b,c), d);
        jpql = "SELECT p FROM Person p WHERE ((p.name = 'A' OR p.name = 'B' OR p.name = 'C') AND p.name = 'D')";
        assertEquivalence(q, jpql);
        assertEquals(jpql, q.toCQL());

        // a AND (b OR c) AND d
        q.where(a, cb.or(b,c), d);
        jpql = "SELECT p FROM Person p WHERE (p.name = 'A' AND (p.name = 'B' OR p.name = 'C') AND p.name = 'D')";
        assertEquivalence(q, jpql);
        assertEquals(jpql, q.toCQL());

        // a OR (b AND (c OR d))
        q.where(cb.or(a, cb.and(b, cb.or(c,d))));
        jpql = "SELECT p FROM Person p WHERE (p.name = 'A' OR (p.name = 'B' AND (p.name = 'C' OR p.name = 'D')))";
        assertEquivalence(q, jpql);
        assertEquals(jpql, q.toCQL());

        // NOT (a OR b)
        q.where(cb.or(a, b).not());
        jpql = "SELECT p FROM Person p WHERE NOT (p.name = 'A' OR p.name = 'B')";
        assertEquivalence(q, jpql);
        assertEquals(jpql, q.toCQL());

        // NOT a
        q.where(cb.and(a).not());
        jpql = "SELECT p FROM Person p WHERE NOT p.name = 'A'";
        assertEquivalence(q, jpql);
        assertEquals(jpql, q.toCQL());

        // NOT a OR NOT b
        q.where(cb.or(cb.not(a), cb.not(b)));
        jpql = "SELECT p FROM Person p WHERE (p.name <> 'A' OR p.name <> 'B')";
        assertEquivalence(q, jpql);
        assertEquals(jpql, q.toCQL());
    }
}