/*
 * Licensed 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.
 *
 * Other licenses:
 * -----------------------------------------------------------------------------
 * Commercial licenses for this work are available. These replace the above
 * ASL 2.0 and offer limited warranties, support, maintenance, and commercial
 * database integrations.
 *
 * For more information, please visit: http://www.jooq.org/licenses
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 */
package org.jooq.impl;

import static java.lang.Boolean.TRUE;
// ...
import static org.jooq.impl.DSL.select;
import static org.jooq.impl.DSL.table;
import static org.jooq.impl.DSL.val;
import static org.jooq.impl.Tools.visitSubquery;

import org.jooq.Configuration;
import org.jooq.Context;
import org.jooq.Field;
import org.jooq.Param;
import org.jooq.QuantifiedSelect;
import org.jooq.QueryPart;
import org.jooq.Record;
import org.jooq.Record1;
import org.jooq.Select;
import org.jooq.impl.Tools.BooleanDataKey;

Author:
Lukas Eder/**
 * @author Lukas Eder
 */
final class QuantifiedSelectImpl<R extends Record> extends AbstractQueryPart implements QuantifiedSelect<R> {

    
Generated UID
/**
     * Generated UID
     */
    private static final long       serialVersionUID = -1224570388944748450L;

    final Quantifier                quantifier;
    final Select<R>                 query;
    final Field<? extends Object[]> array;
    final Field<?>[]                values;

    QuantifiedSelectImpl(Quantifier quantifier, Select<R> query) {
        this.quantifier = quantifier;
        this.query = query;
        this.array = null;
        this.values = null;
    }

    QuantifiedSelectImpl(Quantifier quantifier, Field<? extends Object[]> array) {
        this.quantifier = quantifier;
        this.query = null;
        this.array = array;
        this.values = null;
    }

    QuantifiedSelectImpl(Quantifier quantifier, Field<?>... values) {
        this.quantifier = quantifier;
        this.query = null;
        this.array = null;
        this.values = values;
    }

    @Override
    public final void accept(Context<?> ctx) {
        boolean extraParentheses = false ;

        ctx.visit(quantifier.toKeyword());
        ctx.sql(extraParentheses ? " ((" : " (");
        visitSubquery(ctx, delegate(ctx.configuration()));
        ctx.sql(extraParentheses ? "))" : ")");
    }

    @SuppressWarnings({ "rawtypes", "unchecked" })
    private final QueryPart delegate(Configuration ctx) {
        if (query != null) {
            return query;
        }
        else if (values != null) {
            Select<Record1<?>> select = null;
            for (Field value : values)
                if (select == null)
                    select = select(value);
                else
                    select = select.unionAll(select(value));

            return select;
        }
        else {
            switch (ctx.family()) {

                // [#869] Postgres supports this syntax natively




                case POSTGRES: {
                    return array;
                }

                // [#869] H2 and HSQLDB can emulate this syntax by unnesting
                // the array in a subselect
                case H2:
                case HSQLDB:
                    return create(ctx).select().from(table(array));

                // [#1048] All other dialects emulate unnesting of arrays using
                // UNION ALL-connected subselects
                default: {

                    // The Informix database has an interesting bug when quantified comparison predicates
                    // use nested derived tables with UNION ALL
                    if (array instanceof Param) {
                        Object[] values0 = ((Param<? extends Object[]>) array).getValue();

                        Select<Record1<Object>> select = null;
                        for (Object value : values0)
                            if (select == null)
                                select = select(val(value));
                            else
                                select = select.unionAll(select(val(value)));

                        return select;
                    }
                    else {
                        return select().from(table(array));
                    }
                }
            }
        }
    }
}