Uses of Interface
org.jooq.Record2
-
Packages that use Record2 Package Description org.jooq Theorg.jooq
package contains jOOQ's public API.org.jooq.impl Theorg.jooq.impl
package contains jOOQ's implementation classes. -
-
Uses of Record2 in org.jooq
Methods in org.jooq with type parameters of type Record2 Modifier and Type Method Description <R extends Record2<?,?>>
CommonTableExpression<R>DerivedColumnList2. as(Select<R> select)
Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.Methods in org.jooq that return Record2 Modifier and Type Method Description <T1,T2>
Record2<T1,T2>DSLContext. fetchSingle(SelectField<T1> field1, SelectField<T2> field2)
Execute and return exactly one record for<T1,T2>
Record2<T1,T2>Record. into(Field<T1> field1, Field<T2> field2)
Copy this record into a new record holding only a subset of the previous fields.<T1,T2>
Record2<T1,T2>DSLContext. newRecord(Field<T1> field1, Field<T2> field2)
Create a new emptyRecord
.Record2<T1,T2>
Record2. value1(T1 value)
Set the first value.Record2<T1,T2>
Record2. value2(T2 value)
Set the second value.Record2<T1,T2>
Record2. values(T1 t1, T2 t2)
Set all values.Methods in org.jooq that return types with arguments of type Record2 Modifier and Type Method Description <T1,T2>
ResultQuery<Record2<T1,T2>>ResultQuery. coerce(Field<T1> field1, Field<T2> field2)
Coerce the result record type of this query to that of a set of fields.<T1,T2>
Result<Record2<T1,T2>>Result. into(Field<T1> field1, Field<T2> field2)
Copy all records from this result into a new result with new records holding only a subset of the previous fields.<T1,T2>
Result<Record2<T1,T2>>DSLContext. newResult(Field<T1> field1, Field<T2> field2)
Create a new emptyResult
.<T1,T2>
DeleteResultStep<Record2<T1,T2>>DeleteReturningStep. returningResult(SelectField<T1> field1, SelectField<T2> field2)
Configure theDELETE
statement to return a list of fields inR
.<T1,T2>
InsertResultStep<Record2<T1,T2>>InsertReturningStep. returningResult(SelectField<T1> field1, SelectField<T2> field2)
Configure theINSERT
statement to return a list of fields inR
.<T1,T2>
UpdateResultStep<Record2<T1,T2>>UpdateReturningStep. returningResult(SelectField<T1> field1, SelectField<T2> field2)
Configure theUPDATE
statement to return a list of fields inR
.<T1,T2>
SelectSelectStep<Record2<T1,T2>>DSLContext. select(SelectField<T1> field1, SelectField<T2> field2)
Create a new DSL select statement.<T1,T2>
SelectSelectStep<Record2<T1,T2>>WithStep. select(SelectField<T1> field1, SelectField<T2> field2)
Create a new DSL select statement.<T1,T2>
SelectSelectStep<Record2<T1,T2>>DSLContext. selectDistinct(SelectField<T1> field1, SelectField<T2> field2)
Create a new DSL select statement.<T1,T2>
SelectSelectStep<Record2<T1,T2>>WithStep. selectDistinct(SelectField<T1> field1, SelectField<T2> field2)
Create a new DSL select statement.Methods in org.jooq with parameters of type Record2 Modifier and Type Method Description Condition
BetweenAndStep2. and(Record2<T1,T2> maxValue)
Create a condition to check this field against some boundsBetweenAndStep2<T1,T2>
Row2. between(Record2<T1,T2> minValue)
Check if this row value expression is within a range of two records.Condition
Row2. between(Record2<T1,T2> minValue, Record2<T1,T2> maxValue)
Check if this row value expression is within a range of two records.BetweenAndStep2<T1,T2>
Row2. betweenSymmetric(Record2<T1,T2> minValue)
Check if this row value expression is within a symmetric range of two records.Condition
Row2. betweenSymmetric(Record2<T1,T2> minValue, Record2<T1,T2> maxValue)
Check if this row value expression is within a symmetric range of two records.Condition
Row2. compare(Comparator comparator, Record2<T1,T2> record)
Compare this row value expression with a record using a dynamic comparator.Condition
Row2. eq(Record2<T1,T2> record)
Compare this row value expression with a record for equality.Condition
Row2. equal(Record2<T1,T2> record)
Compare this row value expression with a record for equality.Condition
Row2. ge(Record2<T1,T2> record)
Compare this row value expression with a record for order.Condition
Row2. greaterOrEqual(Record2<T1,T2> record)
Compare this row value expression with a record for order.Condition
Row2. greaterThan(Record2<T1,T2> record)
Compare this row value expression with a record for order.Condition
Row2. gt(Record2<T1,T2> record)
Compare this row value expression with a record for order.Condition
Row2. in(Record2<T1,T2>... record)
Compare this row value expression with a set of records for equality.Condition
Row2. isDistinctFrom(Record2<T1,T2> record)
Compare this row value expression with another row value expression for distinctness.Condition
Row2. isNotDistinctFrom(Record2<T1,T2> record)
Compare this row value expression with another row value expression for distinctness.Condition
Row2. le(Record2<T1,T2> record)
Compare this row value expression with a record for order.Condition
Row2. lessOrEqual(Record2<T1,T2> record)
Compare this row value expression with a record for order.Condition
Row2. lessThan(Record2<T1,T2> record)
Compare this row value expression with a record for order.Condition
Row2. lt(Record2<T1,T2> record)
Compare this row value expression with a record for order.Condition
Row2. ne(Record2<T1,T2> record)
Compare this row value expression with a record for non-equality.BetweenAndStep2<T1,T2>
Row2. notBetween(Record2<T1,T2> minValue)
Check if this row value expression is within a range of two records.Condition
Row2. notBetween(Record2<T1,T2> minValue, Record2<T1,T2> maxValue)
Check if this row value expression is within a range of two records.BetweenAndStep2<T1,T2>
Row2. notBetweenSymmetric(Record2<T1,T2> minValue)
Check if this row value expression is not within a symmetric range of two records.Condition
Row2. notBetweenSymmetric(Record2<T1,T2> minValue, Record2<T1,T2> maxValue)
Check if this row value expression is not within a symmetric range of two records.Condition
Row2. notEqual(Record2<T1,T2> record)
Compare this row value expression with a record for non-equalityCondition
Row2. notIn(Record2<T1,T2>... record)
Compare this row value expression with a set of records for non-equality.Method parameters in org.jooq with type arguments of type Record2 Modifier and Type Method Description <T1,T2>
voidUpdateQuery. addValues(Row2<T1,T2> row, Select<? extends Record2<T1,T2>> select)
Specify a multi-column set clause for theUPDATE
statement.WithStep
WithAsStep2. as(Select<? extends Record2<?,?>> select)
Associate a subselect with a common table expression's table and column names.Condition
Row2. compare(Comparator comparator, QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect using a dynamic comparator.Condition
Row2. compare(Comparator comparator, Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect using a dynamic comparator.Condition
Row2. eq(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality.Condition
Row2. eq(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality.Condition
Row2. equal(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality.Condition
Row2. equal(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality.Condition
Row2. ge(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. ge(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. greaterOrEqual(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. greaterOrEqual(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. greaterThan(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. greaterThan(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. gt(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. gt(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. in(Result<? extends Record2<T1,T2>> result)
Compare this row value expression with a set of records for equality.Condition
Row2. in(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for equality.Condition
Row2. le(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. le(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. lessOrEqual(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. lessOrEqual(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. lessThan(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. lessThan(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. lt(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. lt(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for order.Condition
Row2. ne(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for non-equality.Condition
Row2. ne(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for non-equality.Condition
Row2. notEqual(QuantifiedSelect<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for non-equality.Condition
Row2. notEqual(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for non-equality.Condition
Row2. notIn(Result<? extends Record2<T1,T2>> result)
Compare this row value expression with a set of records for equality.Condition
Row2. notIn(Select<? extends Record2<T1,T2>> select)
Compare this row value expression with a subselect for non-equality.InsertOnDuplicateStep<R>
InsertValuesStep2. select(Select<? extends Record2<T1,T2>> select)
Use aSELECT
statement as the source of values for theINSERT
statementMerge<R>
MergeValuesStep2. select(Select<? extends Record2<T1,T2>> select)
Use aSELECT
statement as the source of values for theMERGE
statement<T1,T2>
UpdateFromStep<R>UpdateSetFirstStep. set(Row2<T1,T2> row, Select<? extends Record2<T1,T2>> select)
Specify a multi-column set clause for theUPDATE
statement. -
Uses of Record2 in org.jooq.impl
Methods in org.jooq.impl that return Record2 Modifier and Type Method Description <T1,T2>
Record2<T1,T2>DefaultDSLContext. fetchSingle(SelectField<T1> field1, SelectField<T2> field2)
<T1,T2>
Record2<T1,T2>DefaultDSLContext. newRecord(Field<T1> field1, Field<T2> field2)
Methods in org.jooq.impl that return types with arguments of type Record2 Modifier and Type Method Description <T1,T2>
Result<Record2<T1,T2>>DefaultDSLContext. newResult(Field<T1> field1, Field<T2> field2)
static <T1,T2>
RecordType<Record2<T1,T2>>DSL. recordType(Field<T1> field1, Field<T2> field2)
Create aRecordType
of degree2
.static <T1,T2>
Field<Record2<T1,T2>>DSL. rowField(Row2<T1,T2> row)
EXPERIMENTAL: Turn a row value expression of degree2
into aField
.<T1,T2>
SelectSelectStep<Record2<T1,T2>>DefaultDSLContext. select(SelectField<T1> field1, SelectField<T2> field2)
static <T1,T2>
SelectSelectStep<Record2<T1,T2>>DSL. select(SelectField<T1> field1, SelectField<T2> field2)
Create a new DSL subselect statement.<T1,T2>
SelectSelectStep<Record2<T1,T2>>DefaultDSLContext. selectDistinct(SelectField<T1> field1, SelectField<T2> field2)
static <T1,T2>
SelectSelectStep<Record2<T1,T2>>DSL. selectDistinct(SelectField<T1> field1, SelectField<T2> field2)
Create a new DSL subselect statement.static <T1,T2>
Table<Record2<T1,T2>>DSL. values(Row2<T1,T2>... rows)
Create aVALUES()
expression of degree2
.
-