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