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