Uses of Interface
org.jooq.Record6
-
Packages that use Record6 Package Description org.jooq This package contains jOOQ's public API.org.jooq.impl This package contains jOOQ's implementation classes. -
-
Uses of Record6 in org.jooq
Methods in org.jooq with type parameters of type Record6 Modifier and Type Method Description <R extends Record6<?,?,?,?,?,?>>
@NotNull CommonTableExpression<R>DerivedColumnList6. as(Select<R> select)
Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record6<?,?,?,?,?,?>>
@NotNull CommonTableExpression<R>DerivedColumnList6. asMaterialized(Select<R> select)
Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record6<?,?,?,?,?,?>>
@NotNull CommonTableExpression<R>DerivedColumnList6. asNotMaterialized(Select<R> select)
Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.Methods in org.jooq that return Record6 Modifier and Type Method Description <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
.@NotNull Record6<T1,T2,T3,T4,T5,T6>
Record6. value1(T1 value)
Set the first value.@NotNull Record6<T1,T2,T3,T4,T5,T6>
Record6. value2(T2 value)
Set the second value.@NotNull Record6<T1,T2,T3,T4,T5,T6>
Record6. value3(T3 value)
Set the third value.@NotNull Record6<T1,T2,T3,T4,T5,T6>
Record6. value4(T4 value)
Set the fourth value.@NotNull Record6<T1,T2,T3,T4,T5,T6>
Record6. value5(T5 value)
Set the fifth value.@NotNull Record6<T1,T2,T3,T4,T5,T6>
Record6. value6(T6 value)
Set the sixth value.@NotNull Record6<T1,T2,T3,T4,T5,T6>
Record6. values(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6)
Set all values.<T> @NotNull Record6<T1,T2,T3,T4,T5,T6>
Record6. with(Field<T> field, T value)
Set a value into this record.<T,U>
@NotNull Record6<T1,T2,T3,T4,T5,T6>Record6. with(Field<T> field, U value, Converter<? extends T,? super U> converter)
Set a value into this record.Methods in org.jooq that return types with arguments of type Record6 Modifier and Type Method Description <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.<T1,T2,T3,T4,T5,T6>
@NotNull Result<Record6<T1,T2,T3,T4,T5,T6>>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.<T1,T2,T3,T4,T5,T6>
@NotNull Result<Record6<T1,T2,T3,T4,T5,T6>>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.Methods in org.jooq with parameters of type Record6 Modifier and Type Method Description @NotNull Condition
BetweenAndStep6. and(Record6<T1,T2,T3,T4,T5,T6> maxValue)
Create a condition to check this field against some bounds@NotNull BetweenAndStep6<T1,T2,T3,T4,T5,T6>
Row6. between(Record6<T1,T2,T3,T4,T5,T6> minValue)
Check if this row value expression is within a range of two records.@NotNull Condition
Row6. between(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.@NotNull BetweenAndStep6<T1,T2,T3,T4,T5,T6>
Row6. betweenSymmetric(Record6<T1,T2,T3,T4,T5,T6> minValue)
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
Row6. compare(Comparator comparator, Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record using a dynamic comparator.@NotNull Condition
Row6. eq(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for equality.@NotNull Condition
Row6. equal(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for equality.@NotNull Condition
Row6. ge(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order.@NotNull Condition
Row6. greaterOrEqual(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order.@NotNull Condition
Row6. greaterThan(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order.@NotNull Condition
Row6. gt(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order.@NotNull Condition
Row6. in(Record6<T1,T2,T3,T4,T5,T6>... record)
Compare this row value expression with a set of records for equality.@NotNull Condition
Row6. isDistinctFrom(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row6. isNotDistinctFrom(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row6. le(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order.@NotNull Condition
Row6. lessOrEqual(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order.@NotNull Condition
Row6. lessThan(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order.@NotNull Condition
Row6. lt(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for order.@NotNull Condition
Row6. ne(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for non-equality.@NotNull BetweenAndStep6<T1,T2,T3,T4,T5,T6>
Row6. notBetween(Record6<T1,T2,T3,T4,T5,T6> minValue)
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.@NotNull BetweenAndStep6<T1,T2,T3,T4,T5,T6>
Row6. notBetweenSymmetric(Record6<T1,T2,T3,T4,T5,T6> minValue)
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
Row6. notEqual(Record6<T1,T2,T3,T4,T5,T6> record)
Compare this row value expression with a record for non-equality@NotNull Condition
Row6. notIn(Record6<T1,T2,T3,T4,T5,T6>... record)
Compare this row value expression with a set of records for non-equality.Method parameters in org.jooq with type arguments of type Record6 Modifier and Type Method Description <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(Select<? extends Record6<?,?,?,?,?,?>> select)
Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep6. asMaterialized(Select<? extends Record6<?,?,?,?,?,?>> select)
Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep6. asNotMaterialized(Select<? extends Record6<?,?,?,?,?,?>> select)
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
Row6. compare(Comparator comparator, Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row6. eq(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
Row6. eq(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
Row6. equal(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
Row6. equal(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
Row6. ge(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
Row6. ge(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
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
Row6. greaterOrEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
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
Row6. greaterThan(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
Row6. gt(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
Row6. gt(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
Row6. in(Result<? extends Record6<T1,T2,T3,T4,T5,T6>> result)
Compare this row value expression with a set of records for equality.@NotNull Condition
Row6. in(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
Row6. isDistinctFrom(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row6. isNotDistinctFrom(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row6. le(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
Row6. le(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
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
Row6. lessOrEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
Row6. lessThan(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
Row6. lessThan(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
Row6. lt(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
Row6. lt(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
Row6. ne(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row6. ne(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row6. notEqual(QuantifiedSelect<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row6. notEqual(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for non-equality.@NotNull Condition
Row6. notIn(Result<? extends Record6<T1,T2,T3,T4,T5,T6>> result)
Compare this row value expression with a set of records for equality.@NotNull Condition
Row6. notIn(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Compare this row value expression with a subselect for non-equality.@NotNull InsertOnDuplicateStep<R>
InsertValuesStep6. select(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Use aSELECT
statement as the source of values for theINSERT
statement@NotNull Merge<R>
MergeValuesStep6. select(Select<? extends Record6<T1,T2,T3,T4,T5,T6>> select)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<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. -
Uses of Record6 in org.jooq.impl
Methods in org.jooq.impl that return Record6 Modifier and Type Method Description <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)
Methods in org.jooq.impl that return types with arguments of type Record6 Modifier and Type Method Description <T1,T2,T3,T4,T5,T6>
Result<Record6<T1,T2,T3,T4,T5,T6>>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
.static <T1,T2,T3,T4,T5,T6>
@NotNull Field<Record6<T1,T2,T3,T4,T5,T6>>DSL. rowField(Row6<T1,T2,T3,T4,T5,T6> row)
EXPERIMENTAL: Turn a row value expression of degree6
into aField
.<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.static <T1,T2,T3,T4,T5,T6>
@NotNull Table<Record6<T1,T2,T3,T4,T5,T6>>DSL. values(Row6<T1,T2,T3,T4,T5,T6>... rows)
Create aVALUES()
expression of degree6
.
-