Uses of Interface
org.jooq.Record6
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of Record6 in org.jooq
Modifier and TypeMethodDescription<R extends Record6<?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>DerivedColumnList6.as(ResultQuery<R> query)
Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record6<?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>DerivedColumnList6.asMaterialized(ResultQuery<R> query)
Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record6<?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>DerivedColumnList6.asNotMaterialized(ResultQuery<R> query)
Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.static <T1, T2, T3, T4, T5, T6, R extends Record6<T1, T2, T3, T4, T5, T6>, U>
RecordMapper<R,U>Records.mapping(Function6<? super T1,? super T2,? super T3,? super T4,? super T5,? super T6,? extends U> function)
Create aRecordMapper
that can map fromRecord6
to a user type in a type safe way.Modifier and TypeMethodDescription<T1, T2, T3, T4, T5, T6>
@NotNull Record6<T1,T2,T3,T4,T5,T6>DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Execute and return exactly one record for<T1, T2, T3, T4, T5, T6>
@NotNull Record6<T1,T2,T3,T4,T5,T6>Record.into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Copy this record into a new record holding only a subset of the previous fields.<T1, T2, T3, T4, T5, T6>
@NotNull Record6<T1,T2,T3,T4,T5,T6>DSLContext.newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
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 all values.Set a value into this record.Set a value into this record.Modifier and TypeMethodDescription<T1, T2, T3, T4, T5, T6>
@NotNull ResultQuery<Record6<T1,T2,T3,T4,T5,T6>>ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
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)
Copy all records from this result into a new result with new records holding only a subset of the previous fields.DSLContext.newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Create a new emptyResult
.<T1, T2, T3, T4, T5, T6>
@NotNull DeleteResultStep<Record6<T1,T2,T3,T4,T5,T6>>DeleteReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Configure theDELETE
statement to return a list of fields inR
.<T1, T2, T3, T4, T5, T6>
@NotNull InsertResultStep<Record6<T1,T2,T3,T4,T5,T6>>InsertReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Configure theINSERT
statement to return a list of fields inR
.<T1, T2, T3, T4, T5, T6>
@NotNull UpdateResultStep<Record6<T1,T2,T3,T4,T5,T6>>UpdateReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Configure theUPDATE
statement to return a list of fields inR
.<T1, T2, T3, T4, T5, T6>
@NotNull SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>DSLContext.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Create a new DSL select statement.<T1, T2, T3, T4, T5, T6>
@NotNull SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>WithStep.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Create a new DSL select statement.<T1, T2, T3, T4, T5, T6>
@NotNull SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>DSLContext.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Create a new DSL select statement.<T1, T2, T3, T4, T5, T6>
@NotNull SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>WithStep.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
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
Row6.betweenSymmetric(Record6<T1,T2,T3,T4,T5,T6> minValue, Record6<T1,T2,T3,T4,T5,T6> 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
Row6.notBetween(Record6<T1,T2,T3,T4,T5,T6> minValue, Record6<T1,T2,T3,T4,T5,T6> 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
Row6.notBetweenSymmetric(Record6<T1,T2,T3,T4,T5,T6> minValue, Record6<T1,T2,T3,T4,T5,T6> 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>
voidUpdateQuery.addValues(Row6<T1,T2,T3,T4,T5,T6> row, Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Specify a multi-column set clause for theUPDATE
statement.@NotNull WithStep
WithAsStep6.as(ResultQuery<? extends Record6<?,?,?,?,?,?>> query)
Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep6.asMaterialized(ResultQuery<? extends Record6<?,?,?,?,?,?>> query)
Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep6.asNotMaterialized(ResultQuery<? extends Record6<?,?,?,?,?,?>> query)
Associate a non-materialized subselect with a common table expression's table and column names.@NotNull Condition
Row6.compare(Comparator comparator, QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> 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
Row6.greaterOrEqual(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull Condition
Row6.greaterThan(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
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
Row6.lessOrEqual(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
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>
@NotNull UpdateFromStep<R>UpdateSetFirstStep.set(Row6<T1,T2,T3,T4,T5,T6> row, Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Specify a multi-column set clause for theUPDATE
statement.InsertValuesStep6.valuesOfRecords(Collection<? extends Record6<T1,T2,T3,T4,T5,T6>> values)
Add multiple rows of values to the insert statement. -
Uses of Record6 in org.jooq.impl
Modifier and TypeMethodDescription<T1, T2, T3, T4, T5, T6>
Record6<T1,T2,T3,T4,T5,T6>DefaultDSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
<T1, T2, T3, T4, T5, T6>
Record6<T1,T2,T3,T4,T5,T6>DefaultDSLContext.newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Modifier and TypeMethodDescriptionstatic <T1, T2, T3, T4, T5, T6>
@NotNull ArrayAggOrderByStep<Result<Record6<T1,T2,T3,T4,T5,T6>>>DSL.multisetAgg(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Get theMULTISET_AGG
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)
static <T1, T2, T3, T4, T5, T6>
@NotNull RecordType<Record6<T1,T2,T3,T4,T5,T6>>DSL.recordType(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Create aRecordType
of degree6
.Deprecated, for removal: This API element is subject to removal in a future version.- [#11812] - 3.15.0 - UseRow6
as aSelectField
directly, instead.<T1, T2, T3, T4, T5, T6>
SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>DefaultDSLContext.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
static <T1, T2, T3, T4, T5, T6>
@NotNull SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>DSL.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Create a new DSL subselect statement.<T1, T2, T3, T4, T5, T6>
SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>DefaultDSLContext.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
static <T1, T2, T3, T4, T5, T6>
@NotNull SelectSelectStep<Record6<T1,T2,T3,T4,T5,T6>>DSL.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6)
Create a new DSL subselect statement.Create aVALUES()
expression of degree6
.
DSLContext.mergeInto(Table)