Uses of Interface
org.jooq.Record8
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of Record8 in org.jooq
Modifier and TypeMethodDescription<R extends Record8<?,
?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList8.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record8<?,
?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList8.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record8<?,
?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList8.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.static final <T1,
T2, T3, T4, T5, T6, T7, T8, R extends Record8<T1, T2, T3, T4, T5, T6, T7, T8>, U>
RecordMapper<R, U> Records.mapping
(Function8<? super T1, ? super T2, ? super T3, ? super T4, ? super T5, ? super T6, ? super T7, ? super T8, ? extends U> function) Create aRecordMapper
that can map fromRecord8
to a user type in a type safe way.Modifier and TypeMethodDescription<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull Record8<T1, T2, T3, T4, T5, T6, T7, T8> DSLContext.fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Execute and return exactly one record for<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull Record8<T1, T2, T3, T4, T5, T6, T7, T8> Record.into
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Copy this record into a new record holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull Record8<T1, T2, T3, T4, T5, T6, T7, T8> DSLContext.newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create a new emptyRecord
.Set the first value.Set the second value.Set the third value.Set the fourth value.Set the fifth value.Set the sixth value.Set the seventh value.Set the eighth value.Set all values.Set a value into this record, usingFields.field(Field)
for lookup.Set a value into this record, usingFields.field(Field)
for lookup.Modifier and TypeMethodDescription<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull CloseableResultQuery<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> CloseableResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) <T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull ResultQuery<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Coerce the result record type of this query to that of a set of fields.Result.into
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Copy all records from this result into a new result with new records holding only a subset of the previous fields, usingFields.field(Field)
for lookup.DSLContext.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create a new emptyResult
.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull DeleteResultStep<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> DeleteReturningStep.returningResult
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Configure theDELETE
statement to return a list of fields inR
.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull InsertResultStep<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> InsertReturningStep.returningResult
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Configure theINSERT
statement to return a list of fields inR
.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull UpdateResultStep<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> UpdateReturningStep.returningResult
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Configure theUPDATE
statement to return a list of fields inR
.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull SelectSelectStep<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> DSLContext.select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull SelectSelectStep<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> WithStep.select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull SelectSelectStep<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> DSLContext.selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Create a new DSL select statement.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull SelectSelectStep<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> WithStep.selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Create a new DSL select statement.Modifier and TypeMethodDescription@NotNull Condition
Create a condition to check this field against some boundsCheck if this row value expression is within a range of two records.@NotNull Condition
Check if this row value expression is within a range of two records.Check if this row value expression is within a symmetric range of two records.@NotNull Condition
Row8.betweenSymmetric
(Record8<T1, T2, T3, T4, T5, T6, T7, T8> minValue, Record8<T1, T2, T3, T4, T5, T6, T7, T8> maxValue) Check if this row value expression is within a symmetric range of two records.@NotNull Condition
Compare this row value expression with a record using a dynamic comparator.@NotNull Condition
Compare this row value expression with a record for equality.@NotNull Condition
Compare this row value expression with a record for equality.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with a record for order.@NotNull Condition
Compare this row value expression with a record for non-equality.Check if this row value expression is within a range of two records.@NotNull Condition
Row8.notBetween
(Record8<T1, T2, T3, T4, T5, T6, T7, T8> minValue, Record8<T1, T2, T3, T4, T5, T6, T7, T8> maxValue) Check if this row value expression is within a range of two records.Check if this row value expression is not within a symmetric range of two records.@NotNull Condition
Row8.notBetweenSymmetric
(Record8<T1, T2, T3, T4, T5, T6, T7, T8> minValue, Record8<T1, T2, T3, T4, T5, T6, T7, T8> maxValue) Check if this row value expression is not within a symmetric range of two records.@NotNull Condition
Compare this row value expression with a record for non-equality@NotNull Condition
Compare this row value expression with a set of records for non-equality.@NotNull Statement
Assign a value to this set of variables.Add a single row of values to the insert statement.Add multiple rows of values to the insert statement.Modifier and TypeMethodDescription<T1,
T2, T3, T4, T5, T6, T7, T8>
voidUpdateQuery.addValues
(Row8<T1, T2, T3, T4, T5, T6, T7, T8> row, Select<? extends Record8<T1, T2, T3, T4, T5, T6, T7, T8>> select) Specify a multi-column set clause for theUPDATE
statement.@NotNull WithStep
WithAsStep8.as
(ResultQuery<? extends Record8<?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep8.asMaterialized
(ResultQuery<? extends Record8<?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep8.asNotMaterialized
(ResultQuery<? extends Record8<?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull Condition
Row8.compare
(Comparator comparator, QuantifiedSelect<? extends Record8<T1, T2, T3, T4, T5, T6, T7, T8>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Compare this row value expression with a set of records for equality.@NotNull Condition
Compare this row value expression with a subselect for non-equality.@NotNull InsertOnDuplicateStep
<R> Use aSELECT
statement as the source of values for theINSERT
statementDeprecated, for removal: This API element is subject to removal in a future version.@NotNull Statement
Assign a value to this set of variables.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull UpdateFromStep<R> UpdateSetFirstStep.set
(Row8<T1, T2, T3, T4, T5, T6, T7, T8> row, Select<? extends Record8<T1, T2, T3, T4, T5, T6, T7, T8>> select) Specify a multi-column set clause for theUPDATE
statement.Add multiple rows of values to the insert statement. -
Uses of Record8 in org.jooq.impl
Modifier and TypeMethodDescription<T1,
T2, T3, T4, T5, T6, T7, T8>
Record8<T1, T2, T3, T4, T5, T6, T7, T8> DefaultDSLContext.fetchSingle
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) <T1,
T2, T3, T4, T5, T6, T7, T8>
Record8<T1, T2, T3, T4, T5, T6, T7, T8> DefaultDSLContext.newRecord
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Modifier and TypeMethodDescriptionstatic <T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull ArrayAggOrderByStep<Result<Record8<T1, T2, T3, T4, T5, T6, T7, T8>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull ArrayAggOrderByStep<Result<Record8<T1, T2, T3, T4, T5, T6, T7, T8>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.DefaultDSLContext.newResult
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) static <T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull RecordType<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> DSL.recordType
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Create aRecordType
of degree8
.Deprecated, for removal: This API element is subject to removal in a future version.- [#11812] - 3.15.0 - UseRow8
as aSelectField
directly, instead.<T1,
T2, T3, T4, T5, T6, T7, T8>
SelectSelectStep<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> DefaultDSLContext.select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) static <T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull SelectSelectStep<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> DSL.select
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Create a new DSL subselect statement.<T1,
T2, T3, T4, T5, T6, T7, T8>
SelectSelectStep<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> DefaultDSLContext.selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) static <T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull SelectSelectStep<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> DSL.selectDistinct
(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8) Create a new DSL subselect statement.Create aVALUES()
expression of degree8
.
DSLContext.mergeInto(Table)