org.jooq.Row17 Maven / Gradle / Ivy
/**
* Copyright (c) 2009-2015, Data Geekery GmbH (http://www.datageekery.com)
* All rights reserved.
*
* 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;
// ...
import static org.jooq.SQLDialect.CUBRID;
// ...
import static org.jooq.SQLDialect.DERBY;
import static org.jooq.SQLDialect.FIREBIRD;
import static org.jooq.SQLDialect.H2;
// ...
import static org.jooq.SQLDialect.HSQLDB;
// ...
import static org.jooq.SQLDialect.MARIADB;
import static org.jooq.SQLDialect.MYSQL;
// ...
import static org.jooq.SQLDialect.POSTGRES;
// ...
// ...
import org.jooq.Comparator;
import org.jooq.impl.DSL;
import java.util.Collection;
import javax.annotation.Generated;
/**
* A model type for a row value expression with degree 17
.
*
* Note: Not all databases support row value expressions, but many row value
* expression operations can be emulated on all databases. See relevant row
* value expression method Javadocs for details.
*
* @author Lukas Eder
*/
@Generated("This class was generated using jOOQ-tools")
public interface Row17 extends Row {
// ------------------------------------------------------------------------
// Field accessors
// ------------------------------------------------------------------------
/**
* Get the first field.
*/
Field field1();
/**
* Get the second field.
*/
Field field2();
/**
* Get the third field.
*/
Field field3();
/**
* Get the fourth field.
*/
Field field4();
/**
* Get the fifth field.
*/
Field field5();
/**
* Get the sixth field.
*/
Field field6();
/**
* Get the seventh field.
*/
Field field7();
/**
* Get the eighth field.
*/
Field field8();
/**
* Get the ninth field.
*/
Field field9();
/**
* Get the tenth field.
*/
Field field10();
/**
* Get the eleventh field.
*/
Field field11();
/**
* Get the twelfth field.
*/
Field field12();
/**
* Get the thirteenth field.
*/
Field field13();
/**
* Get the fourteenth field.
*/
Field field14();
/**
* Get the fifteenth field.
*/
Field field15();
/**
* Get the sixteenth field.
*/
Field field16();
/**
* Get the seventeenth field.
*/
Field field17();
// ------------------------------------------------------------------------
// Generic comparison predicates
// ------------------------------------------------------------------------
/**
* Compare this row value expression with another row value expression
* using a dynamic comparator.
*
* See the explicit comparison methods for details. Note, not all
* {@link Comparator} types are supported
*
* @see #equal(Row17)
* @see #notEqual(Row17)
* @see #lessThan(Row17)
* @see #lessOrEqual(Row17)
* @see #greaterThan(Row17)
* @see #greaterOrEqual(Row17)
*/
@Support
Condition compare(Comparator comparator, Row17 row);
/**
* Compare this row value expression with a record
* using a dynamic comparator.
*
* See the explicit comparison methods for details. Note, not all
* {@link Comparator} types are supported
*
* @see #equal(Record17)
* @see #notEqual(Record17)
* @see #lessThan(Record17)
* @see #lessOrEqual(Record17)
* @see #greaterThan(Record17)
* @see #greaterOrEqual(Record17)
*/
@Support
Condition compare(Comparator comparator, Record17 record);
/**
* Compare this row value expression with another row value expression
* using a dynamic comparator.
*
* See the explicit comparison methods for details. Note, not all
* {@link Comparator} types are supported
*
* @see #equal(Row17)
* @see #notEqual(Row17)
* @see #lessThan(Row17)
* @see #lessOrEqual(Row17)
* @see #greaterThan(Row17)
* @see #greaterOrEqual(Row17)
*/
@Support
Condition compare(Comparator comparator, T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17);
/**
* Compare this row value expression with another row value expression
* using a dynamic comparator.
*
* See the explicit comparison methods for details. Note, not all
* {@link Comparator} types are supported
*
* @see #equal(Row17)
* @see #notEqual(Row17)
* @see #lessThan(Row17)
* @see #lessOrEqual(Row17)
* @see #greaterThan(Row17)
* @see #greaterOrEqual(Row17)
*/
@Support
Condition compare(Comparator comparator, Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17);
/**
* Compare this row value expression with a subselect
* using a dynamic comparator.
*
* See the explicit comparison methods for details. Note, not all
* {@link Comparator} types are supported
*
* @see #equal(Select)
* @see #notEqual(Select)
* @see #lessThan(Select)
* @see #lessOrEqual(Select)
* @see #greaterThan(Select)
* @see #greaterOrEqual(Select)
*/
@Support
Condition compare(Comparator comparator, Select extends Record17> select);
/**
* Compare this row value expression with a subselect
* using a dynamic comparator.
*
* See the explicit comparison methods for details. Note, not all
* {@link Comparator} types are supported
*
* @see #equal(Select)
* @see #notEqual(Select)
* @see #lessThan(Select)
* @see #lessOrEqual(Select)
* @see #greaterThan(Select)
* @see #greaterOrEqual(Select)
*/
@Support
Condition compare(Comparator comparator, QuantifiedSelect extends Record17> select);
// ------------------------------------------------------------------------
// Equal / Not equal comparison predicates
// ------------------------------------------------------------------------
/**
* Compare this row value expression with another row value expression for
* equality.
*
* Row equality comparison predicates can be emulated in those databases
* that do not support such predicates natively:
* (A, B) = (1, 2)
is equivalent to
* A = 1 AND B = 2
*/
@Support
Condition equal(Row17 row);
/**
* Compare this row value expression with a record for equality.
*
* @see #equal(Row17)
*/
@Support
Condition equal(Record17 record);
/**
* Compare this row value expression with another row value expression for
* equality.
*
* @see #equal(Row17)
*/
@Support
Condition equal(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17);
/**
* Compare this row value expression with another row value expression for
* equality.
*
* @see #equal(Row17)
*/
@Support
Condition equal(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17);
/**
* Compare this row value expression with a subselect for equality.
*
* @see #equal(Row17)
*/
@Support
Condition equal(Select extends Record17> select);
/**
* Compare this row value expression with a subselect for equality.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
Condition equal(QuantifiedSelect extends Record17> select);
/**
* Compare this row value expression with another row value expression for
* equality.
*
* @see #equal(Row17)
*/
@Support
Condition eq(Row17 row);
/**
* Compare this row value expression with a record for equality.
*
* @see #equal(Row17)
*/
@Support
Condition eq(Record17 record);
/**
* Compare this row value expression with another row value expression for
* equality.
*
* @see #equal(Row17)
*/
@Support
Condition eq(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17);
/**
* Compare this row value expression with another row value expression for
* equality.
*
* @see #equal(Row17)
*/
@Support
Condition eq(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17);
/**
* Compare this row value expression with a subselect for equality.
*
* @see #equal(Row17)
*/
@Support
Condition eq(Select extends Record17> select);
/**
* Compare this row value expression with a subselect for equality.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
Condition eq(QuantifiedSelect extends Record17> select);
/**
* Compare this row value expression with another row value expression for
* non-equality.
*
* Row non-equality comparison predicates can be emulated in those
* databases that do not support such predicates natively:
* (A, B) <> (1, 2)
is equivalent to
* NOT(A = 1 AND B = 2)
*/
@Support
Condition notEqual(Row17 row);
/**
* Compare this row value expression with a record for non-equality
*
* @see #notEqual(Row17)
*/
@Support
Condition notEqual(Record17 record);
/**
* Compare this row value expression with another row value expression for.
* non-equality
*
* @see #notEqual(Row17)
*/
@Support
Condition notEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17);
/**
* Compare this row value expression with another row value expression for
* non-equality.
*
* @see #notEqual(Row17)
*/
@Support
Condition notEqual(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17);
/**
* Compare this row value expression with a subselect for non-equality.
*
* @see #notEqual(Row17)
*/
@Support
Condition notEqual(Select extends Record17> select);
/**
* Compare this row value expression with a subselect for non-equality.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
Condition notEqual(QuantifiedSelect extends Record17> select);
/**
* Compare this row value expression with another row value expression for
* non-equality.
*
* @see #notEqual(Row17)
*/
@Support
Condition ne(Row17 row);
/**
* Compare this row value expression with a record for non-equality.
*
* @see #notEqual(Row17)
*/
@Support
Condition ne(Record17 record);
/**
* Compare this row value expression with another row value expression for
* non-equality.
*
* @see #notEqual(Row17)
*/
@Support
Condition ne(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17);
/**
* Compare this row value expression with another row value expression for
* non-equality.
*
* @see #notEqual(Row17)
*/
@Support
Condition ne(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17);
/**
* Compare this row value expression with a subselect for non-equality.
*
* @see #notEqual(Row17)
*/
@Support
Condition ne(Select extends Record17> select);
/**
* Compare this row value expression with a subselect for non-equality.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
Condition ne(QuantifiedSelect extends Record17> select);
// ------------------------------------------------------------------------
// Ordering comparison predicates
// ------------------------------------------------------------------------
/**
* Compare this row value expression with another row value expression for
* order.
*
* Row order comparison predicates can be emulated in those
* databases that do not support such predicates natively:
* (A, B, C) < (1, 2, 3)
is equivalent to
* A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3)
*/
@Support
Condition lessThan(Row17 row);
/**
* Compare this row value expression with a record for order.
*
* @see #lessThan(Row17)
*/
@Support
Condition lessThan(Record17 record);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessThan(Row17)
*/
@Support
Condition lessThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessThan(Row17)
*/
@Support
Condition lessThan(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17);
/**
* Compare this row value expression with a subselect for order.
*
* @see #lessThan(Row17)
*/
@Support
Condition lessThan(Select extends Record17> select);
/**
* Compare this row value expression with a subselect for order.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
Condition lessThan(QuantifiedSelect extends Record17> select);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessThan(Row17)
*/
@Support
Condition lt(Row17 row);
/**
* Compare this row value expression with a record for order.
*
* @see #lessThan(Row17)
*/
@Support
Condition lt(Record17 record);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessThan(Row17)
*/
@Support
Condition lt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessThan(Row17)
*/
@Support
Condition lt(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17);
/**
* Compare this row value expression with a subselect for order.
*
* @see #lessThan(Row17)
*/
@Support
Condition lt(Select extends Record17> select);
/**
* Compare this row value expression with a subselect for order.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
Condition lt(QuantifiedSelect extends Record17> select);
/**
* Compare this row value expression with another row value expression for
* order.
*
* Row order comparison predicates can be emulated in those
* databases that do not support such predicates natively:
* (A, B) <= (1, 2)
is equivalent to
* A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2)
*/
@Support
Condition lessOrEqual(Row17 row);
/**
* Compare this row value expression with a record for order.
*
* @see #lessOrEqual(Row17)
*/
@Support
Condition lessOrEqual(Record17 record);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessOrEqual(Row17)
*/
@Support
Condition lessOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessOrEqual(Row17)
*/
@Support
Condition lessOrEqual(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17);
/**
* Compare this row value expression with a subselect for order.
*
* @see #lessOrEqual(Row17)
*/
@Support
Condition lessOrEqual(Select extends Record17> select);
/**
* Compare this row value expression with a subselect for order.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
Condition lessOrEqual(QuantifiedSelect extends Record17> select);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessOrEqual(Row17)
*/
@Support
Condition le(Row17 row);
/**
* Compare this row value expression with a record for order.
*
* @see #lessOrEqual(Row17)
*/
@Support
Condition le(Record17 record);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessOrEqual(Row17)
*/
@Support
Condition le(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #lessOrEqual(Row17)
*/
@Support
Condition le(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17);
/**
* Compare this row value expression with a subselect for order.
*
* @see #lessOrEqual(Row17)
*/
@Support
Condition le(Select extends Record17> select);
/**
* Compare this row value expression with a subselect for order.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
Condition le(QuantifiedSelect extends Record17> select);
/**
* Compare this row value expression with another row value expression for
* order.
*
* Row order comparison predicates can be emulated in those
* databases that do not support such predicates natively:
* (A, B, C) > (1, 2, 3)
is equivalent to
* A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3)
*/
@Support
Condition greaterThan(Row17 row);
/**
* Compare this row value expression with a record for order.
*
* @see #greaterThan(Row17)
*/
@Support
Condition greaterThan(Record17 record);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterThan(Row17)
*/
@Support
Condition greaterThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterThan(Row17)
*/
@Support
Condition greaterThan(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field t11, Field t12, Field t13, Field t14, Field t15, Field t16, Field t17);
/**
* Compare this row value expression with a subselect for order.
*
* @see #greaterThan(Row17)
*/
@Support
Condition greaterThan(Select extends Record17> select);
/**
* Compare this row value expression with a subselect for order.
*
* @see DSL#all(Field)
* @see DSL#all(Select)
* @see DSL#all(Object...)
* @see DSL#any(Field)
* @see DSL#any(Select)
* @see DSL#any(Object...)
*/
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
Condition greaterThan(QuantifiedSelect extends Record17> select);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterThan(Row17)
*/
@Support
Condition gt(Row17 row);
/**
* Compare this row value expression with a record for order.
*
* @see #greaterThan(Row17)
*/
@Support
Condition gt(Record17 record);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterThan(Row17)
*/
@Support
Condition gt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16, T17 t17);
/**
* Compare this row value expression with another row value expression for
* order.
*
* @see #greaterThan(Row17)
*/
@Support
Condition gt(Field t1, Field t2, Field t3, Field t4, Field t5, Field t6, Field t7, Field t8, Field t9, Field t10, Field