release13.07/framework/sql/src/org/ofbiz/sql/test/ConditionsTest.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.ofbiz.sql.test;

import java.util.Collections;
import java.util.List;

import org.ofbiz.sql.BetweenCondition;
import org.ofbiz.sql.BooleanCondition;
import org.ofbiz.sql.Condition;
import org.ofbiz.sql.ConditionList;
import org.ofbiz.sql.Joiner;
import org.ofbiz.sql.ListCondition;
import org.ofbiz.sql.NumberValue;
import org.ofbiz.sql.Value;

import org.ofbiz.base.lang.SourceMonitored;
import org.ofbiz.base.test.GenericTestCaseBase;

@SourceMonitored
public class ConditionsTest extends GenericTestCaseBase {
    private static final NumberValue<Long> l1 = NumberValue.valueOf(1);
    private static final NumberValue<Long> l2 = NumberValue.valueOf(5);
    private static final NumberValue<Long> l3 = NumberValue.valueOf(10);

    public ConditionsTest(String name) {
        super(name);
    }

    private static <C extends Condition> void basicTest(String label, Class<C> clz, C c, String s, C o, boolean matches) {
        assertEquals(label + ":toString", s, c.toString());
        assertNotEquals(label + ":not-equals-this", c, ConditionsTest.class);
        if (o != null) {
            if (matches) {
                assertEquals(label + ":equals", o, c);
            } else {
                assertNotEquals(label + ":not-equals", o, c);
            }
        }
        ConditionVisitorRecorder visitor = new ConditionVisitorRecorder();
        c.accept(visitor);
        c.accept(visitor);
        assertEquals(label + ":visited", 2, visitor.counts.remove(clz).intValue());
        assertTrue(label + ":nothing-else-visited", visitor.counts.isEmpty());
    }

    private static void betweenConditionTest(String label, BetweenCondition c, Value left, Value r1, Value r2, String s, BetweenCondition o, boolean matches) {
        assertEquals(label + ":left", left, c.getLeft());
        assertEquals(label + ":r1", r1, c.getR1());
        assertEquals(label + ":r2", r2, c.getR2());
        basicTest(label, BetweenCondition.class, c, s, o, matches);
    }

    public void testBetweenCondition() {
        BetweenCondition c1 = new BetweenCondition(l1, l2, l3);
        betweenConditionTest("c1", c1, l1, l2, l3, "1 BETWEEN 5 AND 10", null, false);
        BetweenCondition c2 = new BetweenCondition(l3, l1, l2);
        betweenConditionTest("c2", c2, l3, l1, l2, "10 BETWEEN 1 AND 5", c1, false);
        BetweenCondition c3 = new BetweenCondition(l1, l2, l3);
        betweenConditionTest("c3", c3, l1, l2, l3, "1 BETWEEN 5 AND 10", c1, true);
        BetweenCondition c4 = new BetweenCondition(l1, l3, l2);
        betweenConditionTest("c4", c4, l1, l3, l2, "1 BETWEEN 10 AND 5", c1, false);
        BetweenCondition c5 = new BetweenCondition(l1, l2, l1);
        betweenConditionTest("c5", c5, l1, l2, l1, "1 BETWEEN 5 AND 1", c1, false);
    }

    private static void booleanConditionTest(String label, BooleanCondition c, Value left, String op, Value right, String s, BooleanCondition o, boolean matches) {
        assertEquals(label + ":left", left, c.getLeft());
        assertEquals(label + ":op", op, c.getOp());
        assertEquals(label + ":right", right, c.getRight());
        basicTest(label, BooleanCondition.class, c, s, o, matches);
    }

    public void testBooleanCondition() {
        BooleanCondition c1 = new BooleanCondition(l1, "=", l2);
        booleanConditionTest("c1", c1, l1, "=", l2, "1 = 5", null, false);
        BooleanCondition c2 = new BooleanCondition(l1, "=", l3);
        booleanConditionTest("c2", c2, l1, "=", l3, "1 = 10", c1, false);
        BooleanCondition c3 = new BooleanCondition(l1, "<", l2);
        booleanConditionTest("c3", c3, l1, "<", l2, "1 < 5", c1, false);
        BooleanCondition c4 = new BooleanCondition(l2, ">", l3);
        booleanConditionTest("c4", c4, l2, ">", l3, "5 > 10", c1, false);
        BooleanCondition c5 = new BooleanCondition(l1, "=", l2);
        booleanConditionTest("c5", c5, l1, "=", l2, "1 = 5", c1, true);
    }

    private static void conditionListTest(String label, ConditionList c, Joiner joiner, List<? extends Condition> conditions, String s, ConditionList o, boolean matches) {
        assertEquals(label + ":joiner", joiner, c.getJoiner());
        basicTest(label, ConditionList.class, c, s, o, matches);
        BooleanCondition b = new BooleanCondition(l1, "=", l3);
        c.add(b);
        assertEqualsIterable(label + ":iterable", conditions, Collections.<Condition>emptyList(), false, c, list(b), true);
    }

    public void testConditionList() {
        BooleanCondition b1 = new BooleanCondition(l1, "=", l2);
        BooleanCondition b2 = new BooleanCondition(l2, "=", l3);
        ConditionList c1 = new ConditionList(Joiner.AND, GenericTestCaseBase.<Condition>list(b1));
        conditionListTest("c1", c1, Joiner.AND, list(b1), "( 1 = 5 )", null, false);
        ConditionList c2 = new ConditionList(Joiner.AND, GenericTestCaseBase.<Condition>list(b1, b2));
        conditionListTest("c2", c2, Joiner.AND, list(b1, b2), "( 1 = 5 AND 5 = 10 )", c1, false);
        ConditionList c3 = new ConditionList(Joiner.OR, GenericTestCaseBase.<Condition>list(b2, b1));
        conditionListTest("c3", c3, Joiner.OR, list(b2, b1), "( 5 = 10 OR 1 = 5 )", c1, false);
        ConditionList c4 = new ConditionList(Joiner.AND, GenericTestCaseBase.<Condition>list(b1));
        conditionListTest("c4", c4, Joiner.AND, list(b1), "( 1 = 5 )", c1, true);
    }

    private static void listConditionTest(String label, ListCondition c, Value left, String op, List<? extends Value> values, String s, ListCondition o, boolean matches) {
        assertEquals(label + ":left", left, c.getLeft());
        assertEquals(label + ":op", op, c.getOp());
        assertEquals(label + ":right", values, c.getValues());
        basicTest(label, ListCondition.class, c, s, o, matches);
    }

    @SuppressWarnings("unchecked")
    public void testListCondition() {
        ListCondition c1 = new ListCondition(l1, "IN", GenericTestCaseBase.<Value>list(l2));
        listConditionTest("c1", c1, l1, "in", list(l2), "1 in (5)", null, false);
        ListCondition c2 = new ListCondition(l1, "NOT IN", GenericTestCaseBase.<Value>list(l2));
        listConditionTest("c2", c2, l1, "not in", list(l2), "1 not in (5)", c1, false);
        ListCondition c3 = new ListCondition(l2, "IN", GenericTestCaseBase.<Value>list(l3));
        listConditionTest("c3", c3, l2, "in", list(l3), "5 in (10)", c1, false);
        ListCondition c4 = new ListCondition(l1, "IN", GenericTestCaseBase.<Value>list(l2, l3));
        listConditionTest("c4", c4, l1, "in", list(l2, l3), "1 in (5, 10)", c1, false);
        ListCondition c5 = new ListCondition(l1, "IN", GenericTestCaseBase.<Value>list(l2));
        listConditionTest("c5", c5, l1, "in", list(l2), "1 in (5)", c1, true);
    }

    public static class ConditionVisitorRecorder extends Recorder<Class<? extends Condition>> implements Condition.Visitor {
        public void visit(BetweenCondition condition) {
            record(BetweenCondition.class);
        }

        public void visit(BooleanCondition condition) {
            record(BooleanCondition.class);
        }

        public void visit(ConditionList condition) {
            record(ConditionList.class);
        }

        public void visit(ListCondition condition) {
            record(ListCondition.class);
        }
    }
}