/*
 * 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.shardingsphere.core.parsing.parser.context.condition;

import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.ToString;
import org.apache.shardingsphere.core.parsing.parser.clause.condition.NullCondition;

import java.util.ArrayList;
import java.util.List;

/**
 * Or conditions.
 *
 * @author maxiaoguang
 */
@NoArgsConstructor
@Getter
@ToString
public final class OrCondition {
    
    private final List<AndCondition> andConditions = new ArrayList<>();
    
    public OrCondition(final Condition condition) {
        add(condition);
    }
    
    /**
     * Add condition.
     *
     * @param condition condition
     */
    public void add(final Condition condition) {
        if (andConditions.isEmpty()) {
            andConditions.add(new AndCondition());
        }
        andConditions.get(0).getConditions().add(condition);
    }
    
    /**
     * Optimize or condition.
     *
     * @return or condition
     */
    public OrCondition optimize() {
        for (AndCondition each : andConditions) {
            if (each.getConditions().get(0) instanceof NullCondition) {
                OrCondition result = new OrCondition();
                result.add(new NullCondition());
                return result;
            }
        }
        return this;
    }
}

@@ -866,24 +866,112 @@
 condition;%0A%0A
+import com.google.common.base.Predicate;%0Aimport com.google.common.collect.Collections2;%0A
 import lombo
@@ -1151,16 +1151,74 @@
 ayList;%0A
+import java.util.Collection;%0Aimport java.util.LinkedList;%0A
 import j
@@ -2250,10 +2250,532 @@
 ;%0A    %7D%0A
+    %0A    public Collection%3CCondition%3E findConditions(final Column column) %7B%0A        Collection%3CCondition%3E result = new LinkedList%3C%3E();%0A        for (AndCondition each : andConditions) %7B%0A            result.addAll(Collections2.filter(each.getConditions(), new Predicate%3CCondition%3E() %7B%0A                %0A                @Override%0A                public boolean apply(final Condition input) %7B%0A                    return input.getColumn().equals(column);%0A                %7D%0A            %7D));%0A        %7D%0A        return result;%0A    %7D%0A
 %7D%0A

add findConditions()