Uses of Interface
org.jooq.Record2
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of Record2 in org.jooq
Modifier and TypeMethodDescription<R extends Record2<?,
?>>
@NotNull CommonTableExpression<R>DerivedColumnList2.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record2<?,
?>>
@NotNull CommonTableExpression<R>DerivedColumnList2.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record2<?,
?>>
@NotNull CommonTableExpression<R>DerivedColumnList2.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.Records.intoGroups()
Create a collector that can collectRecord2
resulting from a 2-columnResultQuery
into aMap
using the first column as key collecting values of the second column into a list of values.Records.intoMap()
Create a collector that can collectRecord2
resulting from a 2-columnResultQuery
into aMap
using the first column as key and the second column as value.static final <T1,
T2, R extends Record2<T1, T2>, U>
RecordMapper<R,U> Create aRecordMapper
that can map fromRecord2
to a user type in a type safe way.Modifier and TypeMethodDescription<T1,
T2> @NotNull Record2<T1, T2> DSLContext.fetchSingle
(SelectField<T1> field1, SelectField<T2> field2) Execute and return exactly one record for<T1,
T2> @NotNull Record2<T1, T2> Copy this record into a new record holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<T1,
T2> @NotNull Record2<T1, T2> Create a new emptyRecord
.Set the first value.Set the second 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> @NotNull CloseableResultQuery<Record2<T1, T2>> <T1,
T2> @NotNull ResultQuery<Record2<T1, T2>> Coerce the result record type of this query to that of a set of fields.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.Create a new emptyResult
.<T1,
T2> @NotNull DeleteResultStep<Record2<T1, T2>> DeleteReturningStep.returningResult
(SelectField<T1> field1, SelectField<T2> field2) Configure theDELETE
statement to return a list of fields inR
.<T1,
T2> @NotNull InsertResultStep<Record2<T1, T2>> InsertReturningStep.returningResult
(SelectField<T1> field1, SelectField<T2> field2) Configure theINSERT
statement to return a list of fields inR
.<T1,
T2> @NotNull UpdateResultStep<Record2<T1, T2>> UpdateReturningStep.returningResult
(SelectField<T1> field1, SelectField<T2> field2) Configure theUPDATE
statement to return a list of fields inR
.<T1,
T2> @NotNull SelectSelectStep<Record2<T1, T2>> DSLContext.select
(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL select statement.<T1,
T2> @NotNull SelectSelectStep<Record2<T1, T2>> WithStep.select
(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL select statement.<T1,
T2> @NotNull SelectSelectStep<Record2<T1, T2>> DSLContext.selectDistinct
(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL select statement.<T1,
T2> @NotNull SelectSelectStep<Record2<T1, T2>> WithStep.selectDistinct
(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL select statement.Modifier and TypeMethodDescription@NotNull Condition
Create a condition to check this field against some bounds@NotNull BetweenAndStep2<T1,
T2> Check 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.@NotNull BetweenAndStep2<T1,
T2> Row2.betweenSymmetric
(Record2<T1, T2> minValue) Check if this row value expression is within a symmetric range of two records.@NotNull Condition
Check if this row value expression is within a symmetric range of two records.@NotNull Condition
Row2.compare
(Comparator comparator, Record2<T1, T2> record) 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
Row2.greaterOrEqual
(Record2<T1, T2> record) Compare this row value expression with a record for order.@NotNull Condition
Row2.greaterThan
(Record2<T1, T2> record) 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
Row2.isDistinctFrom
(Record2<T1, T2> record) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row2.isNotDistinctFrom
(Record2<T1, T2> record) 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
Row2.lessOrEqual
(Record2<T1, T2> record) 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.@NotNull BetweenAndStep2<T1,
T2> Row2.notBetween
(Record2<T1, T2> minValue) Check 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.@NotNull BetweenAndStep2<T1,
T2> Row2.notBetweenSymmetric
(Record2<T1, T2> minValue) Check if this row value expression is not within a symmetric range of two records.@NotNull Condition
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.@NotNull InsertValuesStep2<R,
T1, T2> Add a single row of values to the insert statement.@NotNull InsertValuesStep2<R,
T1, T2> InsertValuesStep2.valuesOfRecords
(Record2<T1, T2>... values) Add multiple rows of values to the insert statement.Modifier and TypeMethodDescription<T1,
T2> void Specify a multi-column set clause for theUPDATE
statement.@NotNull WithStep
WithAsStep2.as
(ResultQuery<? extends Record2<?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep2.asMaterialized
(ResultQuery<? extends Record2<?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep2.asNotMaterialized
(ResultQuery<? extends Record2<?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull Condition
Row2.compare
(Comparator comparator, QuantifiedSelect<? extends Record2<T1, T2>> 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
Row2.eq
(QuantifiedSelect<? extends Record2<T1, T2>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Row2.equal
(QuantifiedSelect<? extends Record2<T1, T2>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.DSLContext.fetchGroups
(ResultQuery<? extends Record2<K, V>> query) Execute the query and return aMap
with the first column as the map key and the second column as the map values.<K,
V> @NotNull Map<K, V> DSLContext.fetchMap
(ResultQuery<? extends Record2<K, V>> query) Execute the query and return aMap
with the first column as the map key and the second column as the map value.@NotNull Condition
Row2.ge
(QuantifiedSelect<? extends Record2<T1, T2>> 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
Row2.greaterOrEqual
(QuantifiedSelect<? extends Record2<T1, T2>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row2.greaterOrEqual
(Select<? extends Record2<T1, T2>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row2.greaterThan
(QuantifiedSelect<? extends Record2<T1, T2>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row2.greaterThan
(Select<? extends Record2<T1, T2>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row2.gt
(QuantifiedSelect<? extends Record2<T1, T2>> 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 set of records for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.@NotNull Condition
Row2.isDistinctFrom
(Select<? extends Record2<T1, T2>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row2.isNotDistinctFrom
(Select<? extends Record2<T1, T2>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row2.le
(QuantifiedSelect<? extends Record2<T1, T2>> 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
Row2.lessOrEqual
(QuantifiedSelect<? extends Record2<T1, T2>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row2.lessOrEqual
(Select<? extends Record2<T1, T2>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row2.lessThan
(QuantifiedSelect<? extends Record2<T1, T2>> 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
Row2.lt
(QuantifiedSelect<? extends Record2<T1, T2>> 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
Row2.ne
(QuantifiedSelect<? extends Record2<T1, T2>> select) 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
Row2.notEqual
(QuantifiedSelect<? extends Record2<T1, T2>> select) 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> @NotNull UpdateFromStep<R> Specify a multi-column set clause for theUPDATE
statement.@NotNull InsertValuesStep2<R,
T1, T2> InsertValuesStep2.valuesOfRecords
(Collection<? extends Record2<T1, T2>> values) Add multiple rows of values to the insert statement. -
Uses of Record2 in org.jooq.impl
Modifier and TypeMethodDescription<T1,
T2> Record2<T1, T2> DefaultDSLContext.fetchSingle
(SelectField<T1> field1, SelectField<T2> field2) <T1,
T2> Record2<T1, T2> Modifier and TypeMethodDescriptionstatic <T1,
T2> @NotNull ArrayAggOrderByStep<Result<Record2<T1, T2>>> DSL.multisetAgg
(SelectField<T1> field1, SelectField<T2> field2) Get theMULTISET_AGG
aggregate function to nest group contents.static <T1,
T2> @NotNull ArrayAggOrderByStep<Result<Record2<T1, T2>>> DSL.multisetAggDistinct
(SelectField<T1> field1, SelectField<T2> field2) Get theMULTISET_AGG(DISTINCT)
aggregate function to nest group contents.static <T1,
T2> @NotNull RecordType<Record2<T1, T2>> DSL.recordType
(Field<T1> field1, Field<T2> field2) Create aRecordType
of degree2
.Deprecated, for removal: This API element is subject to removal in a future version.- [#11812] - 3.15.0 - UseRow2
as aSelectField
directly, instead.<T1,
T2> SelectSelectStep<Record2<T1, T2>> DefaultDSLContext.select
(SelectField<T1> field1, SelectField<T2> field2) static <T1,
T2> @NotNull SelectSelectStep<Record2<T1, T2>> DSL.select
(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL subselect statement.<T1,
T2> SelectSelectStep<Record2<T1, T2>> DefaultDSLContext.selectDistinct
(SelectField<T1> field1, SelectField<T2> field2) static <T1,
T2> @NotNull SelectSelectStep<Record2<T1, T2>> DSL.selectDistinct
(SelectField<T1> field1, SelectField<T2> field2) Create a new DSL subselect statement.Create aVALUES()
expression of degree2
.Modifier and TypeMethodDescriptionDefaultDSLContext.fetchGroups
(ResultQuery<? extends Record2<K, V>> query) <K,
V> Map<K, V> DefaultDSLContext.fetchMap
(ResultQuery<? extends Record2<K, V>> query)
DSLContext.mergeInto(Table)