All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.jooq.impl.RowImpl2 Maven / Gradle / Ivy

There is a newer version: 3.19.15
Show newest version
/*
 * 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
 *
 *  https://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
 * Apache-2.0 license and offer limited warranties, support, maintenance, and
 * commercial database integrations.
 *
 * For more information, please visit: https://www.jooq.org/legal/licensing
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 */
package org.jooq.impl;

import static org.jooq.impl.DSL.row;

import java.util.Arrays;
import java.util.Collection;

import org.jooq.BetweenAndStep2;
import org.jooq.Comparator;
import org.jooq.Condition;
import org.jooq.DataType;
import org.jooq.Field;
import org.jooq.Function2;
import org.jooq.QuantifiedSelect;
import org.jooq.Record;
import org.jooq.Record2;
import org.jooq.Records;
import org.jooq.Result;
import org.jooq.Row;
import org.jooq.Row2;
import org.jooq.Select;
import org.jooq.SelectField;
import org.jooq.Statement;

import org.jetbrains.annotations.NotNull;

/**
 * @author Lukas Eder
 */
@SuppressWarnings({ "rawtypes", "unchecked" })
final class RowImpl2
extends
    AbstractRow>
implements
    Row2 {

    RowImpl2(SelectField field1, SelectField field2) {
        super(field1, field2);
    }

    RowImpl2(FieldsImpl fields) {
        super((FieldsImpl) fields);
    }

    // ------------------------------------------------------------------------
    // Mapping convenience methods
    // ------------------------------------------------------------------------

    @Override
    public final  SelectField mapping(Function2 function) {
        return convertFrom(r -> r == null ? null : function.apply(r.value1(), r.value2()));
    }

    @Override
    public final  SelectField mapping(Class uType, Function2 function) {
        return convertFrom(uType, r -> r == null ? null : function.apply(r.value1(), r.value2()));
    }

    // ------------------------------------------------------------------------
    // XXX: Row accessor API
    // ------------------------------------------------------------------------

    @Override
    public final Field field1() {
        return (@NotNull Field) fields.field(0);
    }

    @Override
    public final Field field2() {
        return (@NotNull Field) fields.field(1);
    }

    // ------------------------------------------------------------------------
    // Generic comparison predicates
    // ------------------------------------------------------------------------

    @Override
    public final Condition compare(Comparator comparator, Row2 row) {
        return compare(this, comparator, row);
    }

    @Override
    public final Condition compare(Comparator comparator, Record2 record) {
        return compare(this, comparator, record.valuesRow());
    }

    @Override
    public final Condition compare(Comparator comparator, T1 t1, T2 t2) {
        return compare(comparator, row(Tools.field(t1, (DataType) dataType(0)), Tools.field(t2, (DataType) dataType(1))));
    }

    @Override
    public final Condition compare(Comparator comparator, Field t1, Field t2) {
        return compare(comparator, row(Tools.nullSafe(t1, dataType(0)), Tools.nullSafe(t2, dataType(1))));
    }

    @Override
    public final Condition compare(Comparator comparator, Select> select) {
        return new RowSubqueryCondition(this, select, comparator);
    }

    @Override
    public final Condition compare(Comparator comparator, QuantifiedSelect> select) {
        return new RowSubqueryCondition(this, select, comparator);
    }

    // ------------------------------------------------------------------------
    // Equal / Not equal comparison predicates
    // ------------------------------------------------------------------------

    @Override
    public final Condition equal(Row2 row) {
        return compare(Comparator.EQUALS, row);
    }

    @Override
    public final Condition equal(Record2 record) {
        return compare(Comparator.EQUALS, record);
    }

    @Override
    public final Condition equal(T1 t1, T2 t2) {
        return compare(Comparator.EQUALS, t1, t2);
    }

    @Override
    public final Condition equal(Field t1, Field t2) {
        return compare(Comparator.EQUALS, t1, t2);
    }

    @Override
    public final Condition eq(Row2 row) {
        return equal(row);
    }

    @Override
    public final Condition eq(Record2 record) {
        return equal(record);
    }

    @Override
    public final Condition eq(T1 t1, T2 t2) {
        return equal(t1, t2);
    }

    @Override
    public final Condition eq(Field t1, Field t2) {
        return equal(t1, t2);
    }

    @Override
    public final Condition notEqual(Row2 row) {
        return compare(Comparator.NOT_EQUALS, row);
    }

    @Override
    public final Condition notEqual(Record2 record) {
        return compare(Comparator.NOT_EQUALS, record);
    }

    @Override
    public final Condition notEqual(T1 t1, T2 t2) {
        return compare(Comparator.NOT_EQUALS, t1, t2);
    }

    @Override
    public final Condition notEqual(Field t1, Field t2) {
        return compare(Comparator.NOT_EQUALS, t1, t2);
    }

    @Override
    public final Condition ne(Row2 row) {
        return notEqual(row);
    }

    @Override
    public final Condition ne(Record2 record) {
        return notEqual(record);
    }

    @Override
    public final Condition ne(T1 t1, T2 t2) {
        return notEqual(t1, t2);
    }

    @Override
    public final Condition ne(Field t1, Field t2) {
        return notEqual(t1, t2);
    }

    // ------------------------------------------------------------------------
    // Ordering comparison predicates
    // ------------------------------------------------------------------------

    @Override
    public final Condition lessThan(Row2 row) {
        return compare(Comparator.LESS, row);
    }

    @Override
    public final Condition lessThan(Record2 record) {
        return compare(Comparator.LESS, record);
    }

    @Override
    public final Condition lessThan(T1 t1, T2 t2) {
        return compare(Comparator.LESS, t1, t2);
    }

    @Override
    public final Condition lessThan(Field t1, Field t2) {
        return compare(Comparator.LESS, t1, t2);
    }

    @Override
    public final Condition lt(Row2 row) {
        return lessThan(row);
    }

    @Override
    public final Condition lt(Record2 record) {
        return lessThan(record);
    }

    @Override
    public final Condition lt(T1 t1, T2 t2) {
        return lessThan(t1, t2);
    }

    @Override
    public final Condition lt(Field t1, Field t2) {
        return lessThan(t1, t2);
    }

    @Override
    public final Condition lessOrEqual(Row2 row) {
        return compare(Comparator.LESS_OR_EQUAL, row);
    }

    @Override
    public final Condition lessOrEqual(Record2 record) {
        return compare(Comparator.LESS_OR_EQUAL, record);
    }

    @Override
    public final Condition lessOrEqual(T1 t1, T2 t2) {
        return compare(Comparator.LESS_OR_EQUAL, t1, t2);
    }

    @Override
    public final Condition lessOrEqual(Field t1, Field t2) {
        return compare(Comparator.LESS_OR_EQUAL, t1, t2);
    }

    @Override
    public final Condition le(Row2 row) {
        return lessOrEqual(row);
    }

    @Override
    public final Condition le(Record2 record) {
        return lessOrEqual(record);
    }

    @Override
    public final Condition le(T1 t1, T2 t2) {
        return lessOrEqual(t1, t2);
    }

    @Override
    public final Condition le(Field t1, Field t2) {
        return lessOrEqual(t1, t2);
    }

    @Override
    public final Condition greaterThan(Row2 row) {
        return compare(Comparator.GREATER, row);
    }

    @Override
    public final Condition greaterThan(Record2 record) {
        return compare(Comparator.GREATER, record);
    }

    @Override
    public final Condition greaterThan(T1 t1, T2 t2) {
        return compare(Comparator.GREATER, t1, t2);
    }

    @Override
    public final Condition greaterThan(Field t1, Field t2) {
        return compare(Comparator.GREATER, t1, t2);
    }

    @Override
    public final Condition gt(Row2 row) {
        return greaterThan(row);
    }

    @Override
    public final Condition gt(Record2 record) {
        return greaterThan(record);
    }

    @Override
    public final Condition gt(T1 t1, T2 t2) {
        return greaterThan(t1, t2);
    }

    @Override
    public final Condition gt(Field t1, Field t2) {
        return greaterThan(t1, t2);
    }

    @Override
    public final Condition greaterOrEqual(Row2 row) {
        return compare(Comparator.GREATER_OR_EQUAL, row);
    }

    @Override
    public final Condition greaterOrEqual(Record2 record) {
        return compare(Comparator.GREATER_OR_EQUAL, record);
    }

    @Override
    public final Condition greaterOrEqual(T1 t1, T2 t2) {
        return compare(Comparator.GREATER_OR_EQUAL, t1, t2);
    }

    @Override
    public final Condition greaterOrEqual(Field t1, Field t2) {
        return compare(Comparator.GREATER_OR_EQUAL, t1, t2);
    }

    @Override
    public final Condition ge(Row2 row) {
        return greaterOrEqual(row);
    }

    @Override
    public final Condition ge(Record2 record) {
        return greaterOrEqual(record);
    }

    @Override
    public final Condition ge(T1 t1, T2 t2) {
        return greaterOrEqual(t1, t2);
    }

    @Override
    public final Condition ge(Field t1, Field t2) {
        return greaterOrEqual(t1, t2);
    }

    // ------------------------------------------------------------------------
    // [NOT] BETWEEN predicates
    // ------------------------------------------------------------------------

    @Override
    public final BetweenAndStep2 between(T1 t1, T2 t2) {
        return between(row(Tools.field(t1, (DataType) dataType(0)), Tools.field(t2, (DataType) dataType(1))));
    }

    @Override
    public final BetweenAndStep2 between(Field t1, Field t2) {
        return between(row(t1, t2));
    }

    @Override
    public final BetweenAndStep2 between(Row2 row) {
        return new RowBetweenCondition<>(this, row, false, false);
    }

    @Override
    public final BetweenAndStep2 between(Record2 record) {
        return between(record.valuesRow());
    }

    @Override
    public final Condition between(Row2 minValue, Row2 maxValue) {
        return between(minValue).and(maxValue);
    }

    @Override
    public final Condition between(Record2 minValue, Record2 maxValue) {
        return between(minValue).and(maxValue);
    }

    @Override
    public final BetweenAndStep2 betweenSymmetric(T1 t1, T2 t2) {
        return betweenSymmetric(row(Tools.field(t1, (DataType) dataType(0)), Tools.field(t2, (DataType) dataType(1))));
    }

    @Override
    public final BetweenAndStep2 betweenSymmetric(Field t1, Field t2) {
        return betweenSymmetric(row(t1, t2));
    }

    @Override
    public final BetweenAndStep2 betweenSymmetric(Row2 row) {
        return new RowBetweenCondition<>(this, row, false, true);
    }

    @Override
    public final BetweenAndStep2 betweenSymmetric(Record2 record) {
        return betweenSymmetric(record.valuesRow());
    }

    @Override
    public final Condition betweenSymmetric(Row2 minValue, Row2 maxValue) {
        return betweenSymmetric(minValue).and(maxValue);
    }

    @Override
    public final Condition betweenSymmetric(Record2 minValue, Record2 maxValue) {
        return betweenSymmetric(minValue).and(maxValue);
    }

    @Override
    public final BetweenAndStep2 notBetween(T1 t1, T2 t2) {
        return notBetween(row(Tools.field(t1, (DataType) dataType(0)), Tools.field(t2, (DataType) dataType(1))));
    }

    @Override
    public final BetweenAndStep2 notBetween(Field t1, Field t2) {
        return notBetween(row(t1, t2));
    }

    @Override
    public final BetweenAndStep2 notBetween(Row2 row) {
        return new RowBetweenCondition<>(this, row, true, false);
    }

    @Override
    public final BetweenAndStep2 notBetween(Record2 record) {
        return notBetween(record.valuesRow());
    }

    @Override
    public final Condition notBetween(Row2 minValue, Row2 maxValue) {
        return notBetween(minValue).and(maxValue);
    }

    @Override
    public final Condition notBetween(Record2 minValue, Record2 maxValue) {
        return notBetween(minValue).and(maxValue);
    }

    @Override
    public final BetweenAndStep2 notBetweenSymmetric(T1 t1, T2 t2) {
        return notBetweenSymmetric(row(Tools.field(t1, (DataType) dataType(0)), Tools.field(t2, (DataType) dataType(1))));
    }

    @Override
    public final BetweenAndStep2 notBetweenSymmetric(Field t1, Field t2) {
        return notBetweenSymmetric(row(t1, t2));
    }

    @Override
    public final BetweenAndStep2 notBetweenSymmetric(Row2 row) {
        return new RowBetweenCondition<>(this, row, true, true);
    }

    @Override
    public final BetweenAndStep2 notBetweenSymmetric(Record2 record) {
        return notBetweenSymmetric(record.valuesRow());
    }

    @Override
    public final Condition notBetweenSymmetric(Row2 minValue, Row2 maxValue) {
        return notBetweenSymmetric(minValue).and(maxValue);
    }

    @Override
    public final Condition notBetweenSymmetric(Record2 minValue, Record2 maxValue) {
        return notBetweenSymmetric(minValue).and(maxValue);
    }

    // ------------------------------------------------------------------------
    // [NOT] DISTINCT predicates
    // ------------------------------------------------------------------------

    @Override
    public final Condition isNotDistinctFrom(Row2 row) {
        return new RowIsDistinctFrom(this, row, true);
    }

    @Override
    public final Condition isNotDistinctFrom(Record2 record) {
        return isNotDistinctFrom(record.valuesRow());
    }

    @Override
    public final Condition isNotDistinctFrom(T1 t1, T2 t2) {
        return isNotDistinctFrom(Tools.field(t1, (DataType) dataType(0)), Tools.field(t2, (DataType) dataType(1)));
    }

    @Override
    public final Condition isNotDistinctFrom(Field t1, Field t2) {
        return isNotDistinctFrom(row(t1, t2));
    }

    @Override
    public final Condition isNotDistinctFrom(Select> select) {
        return new RowIsDistinctFrom(this, select, true);
    }

    @Override
    public final Condition isDistinctFrom(Row2 row) {
        return new RowIsDistinctFrom(this, row, false);
    }

    @Override
    public final Condition isDistinctFrom(Record2 record) {
        return isDistinctFrom(record.valuesRow());
    }

    @Override
    public final Condition isDistinctFrom(T1 t1, T2 t2) {
        return isDistinctFrom(Tools.field(t1, (DataType) dataType(0)), Tools.field(t2, (DataType) dataType(1)));
    }

    @Override
    public final Condition isDistinctFrom(Field t1, Field t2) {
        return isDistinctFrom(row(t1, t2));
    }

    @Override
    public final Condition isDistinctFrom(Select> select) {
        return new RowIsDistinctFrom(this, select, false);
    }

    // ------------------------------------------------------------------------
    // [NOT] IN predicates
    // ------------------------------------------------------------------------

    @Override
    public final Condition in(Row2... rows) {
        return in(Arrays.asList(rows));
    }

    @Override
    public final Condition in(Record2... records) {
        QueryPartList rows = new QueryPartList<>();

        for (Record record : records)
            rows.add(record.valuesRow());

        return new RowInCondition(this, rows, false);
    }

    @Override
    public final Condition notIn(Row2... rows) {
        return notIn(Arrays.asList(rows));
    }

    @Override
    public final Condition notIn(Record2... records) {
        QueryPartList rows = new QueryPartList<>();

        for (Record record : records)
            rows.add(record.valuesRow());

        return new RowInCondition(this, rows, true);
    }

    @Override
    public final Condition in(Collection> rows) {
        return new RowInCondition(this, new QueryPartList(rows), false);
    }

    @Override
    public final Condition in(Result> result) {
        return new RowInCondition(this, new QueryPartList(Tools.rows(result)), false);
    }

    @Override
    public final Condition notIn(Collection> rows) {
        return new RowInCondition(this, new QueryPartList(rows), true);
    }

    @Override
    public final Condition notIn(Result> result) {
        return new RowInCondition(this, new QueryPartList(Tools.rows(result)), true);
    }

    // ------------------------------------------------------------------------
    // Predicates involving subqueries
    // ------------------------------------------------------------------------

    @Override
    public final Condition equal(Select> select) {
        return compare(Comparator.EQUALS, select);
    }

    @Override
    public final Condition equal(QuantifiedSelect> select) {
        return compare(Comparator.EQUALS, select);
    }

    @Override
    public final Condition eq(Select> select) {
        return equal(select);
    }

    @Override
    public final Condition eq(QuantifiedSelect> select) {
        return equal(select);
    }

    @Override
    public final Condition notEqual(Select> select) {
        return compare(Comparator.NOT_EQUALS, select);
    }

    @Override
    public final Condition notEqual(QuantifiedSelect> select) {
        return compare(Comparator.NOT_EQUALS, select);
    }

    @Override
    public final Condition ne(Select> select) {
        return notEqual(select);
    }

    @Override
    public final Condition ne(QuantifiedSelect> select) {
        return notEqual(select);
    }

    @Override
    public final Condition greaterThan(Select> select) {
        return compare(Comparator.GREATER, select);
    }

    @Override
    public final Condition greaterThan(QuantifiedSelect> select) {
        return compare(Comparator.GREATER, select);
    }

    @Override
    public final Condition gt(Select> select) {
        return greaterThan(select);
    }

    @Override
    public final Condition gt(QuantifiedSelect> select) {
        return greaterThan(select);
    }

    @Override
    public final Condition greaterOrEqual(Select> select) {
        return compare(Comparator.GREATER_OR_EQUAL, select);
    }

    @Override
    public final Condition greaterOrEqual(QuantifiedSelect> select) {
        return compare(Comparator.GREATER_OR_EQUAL, select);
    }

    @Override
    public final Condition ge(Select> select) {
        return greaterOrEqual(select);
    }

    @Override
    public final Condition ge(QuantifiedSelect> select) {
        return greaterOrEqual(select);
    }

    @Override
    public final Condition lessThan(Select> select) {
        return compare(Comparator.LESS, select);
    }

    @Override
    public final Condition lessThan(QuantifiedSelect> select) {
        return compare(Comparator.LESS, select);
    }

    @Override
    public final Condition lt(Select> select) {
        return lessThan(select);
    }

    @Override
    public final Condition lt(QuantifiedSelect> select) {
        return lessThan(select);
    }

    @Override
    public final Condition lessOrEqual(Select> select) {
        return compare(Comparator.LESS_OR_EQUAL, select);
    }

    @Override
    public final Condition lessOrEqual(QuantifiedSelect> select) {
        return compare(Comparator.LESS_OR_EQUAL, select);
    }

    @Override
    public final Condition le(Select> select) {
        return lessOrEqual(select);
    }

    @Override
    public final Condition le(QuantifiedSelect> select) {
        return lessOrEqual(select);
    }

    @Override
    public final Condition in(Select> select) {
        return compare(Comparator.IN, select);
    }

    @Override
    public final Condition notIn(Select> select) {
        return compare(Comparator.NOT_IN, select);
    }

    // ------------------------------------------------------------------------
    // XXX: Row2 API
    // ------------------------------------------------------------------------

    @Override
    public final Condition overlaps(T1 t1, T2 t2) {
        return overlaps(row(t1, t2));
    }

    @Override
    public final Condition overlaps(Field t1, Field t2) {
        return overlaps(row(t1, t2));
    }

    @Override
    public final Condition overlaps(Row2 row) {
        return new RowOverlaps<>(this, row);
    }

































}