Uses of Interface
org.jooq.Record1
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of Record1 in org.jooq
Modifier and TypeMethodDescription<R extends Record1<?>>
@NotNull CommonTableExpression<R>DerivedColumnList1.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record1<?>>
@NotNull CommonTableExpression<R>DerivedColumnList1.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record1<?>>
@NotNull CommonTableExpression<R>DerivedColumnList1.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.DSLContext.fetchOptionalValue
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a single value.<T,
R extends Record1<T>>
TDSLContext.fetchValue
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a single value.DSLContext.fetchValues
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return all values for the only column.Records.intoArray
(E[] a) Create a collector that can collectRecord1
resulting from a single columnResultQuery
into an array of that column's type.Create a collector that can collectRecord
resulting from aResultQuery
into an array of a mapped type.Records.intoList()
Create a collector that can collectRecord1
resulting from a single columnResultQuery
into aList
of that column's type.Records.intoSet()
Create a collector that can collectRecord1
resulting from a single columnResultQuery
into aSet
of that column's type.static final <T1,
R extends Record1<T1>, U>
RecordMapper<R,U> Create aRecordMapper
that can map fromRecord1
to a user type in a type safe way.Modifier and TypeMethodDescription<T1> @NotNull Record1<T1>
DSLContext.fetchSingle
(SelectField<T1> field1) Execute and return exactly one record forThe inverse operation ofRecord.into(Field)
.<T1> @NotNull Record1<T1>
Copy this record into a new record holding only a subset of the previous fields, usingFields.field(Field)
for lookup.<T1> @NotNull Record1<T1>
Create a new emptyRecord
.Set the first 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> @NotNull CloseableResultQuery<Record1<T1>>
<T1> @NotNull ResultQuery<Record1<T1>>
Coerce the result record type of this query to that of a set of fields.@NotNull SelectForJSONStep<Record1<JSON>>
SelectForStep.forJSON()
Add a SQL Server-styleFOR JSON
clause.@NotNull SelectForJSONStep<Record1<JSONB>>
SelectForStep.forJSONB()
Add a SQL Server-styleFOR JSON
clause.@NotNull SelectForXMLStep<Record1<XML>>
SelectForStep.forXML()
Add a SQL Server-styleFOR XML
clause.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
.Sequence.nextvals
(int size) An expression to increment the sequence and get the next values.<T1> @NotNull DeleteResultStep<Record1<T1>>
DeleteReturningStep.returningResult
(SelectField<T1> field1) Configure theDELETE
statement to return a list of fields inR
.<T1> @NotNull InsertResultStep<Record1<T1>>
InsertReturningStep.returningResult
(SelectField<T1> field1) Configure theINSERT
statement to return a list of fields inR
.<T1> @NotNull UpdateResultStep<Record1<T1>>
UpdateReturningStep.returningResult
(SelectField<T1> field1) Configure theUPDATE
statement to return a list of fields inR
.<T1> @NotNull SelectSelectStep<Record1<T1>>
DSLContext.select
(SelectField<T1> field1) Create a new DSL select statement.<T1> @NotNull SelectSelectStep<Record1<T1>>
WithStep.select
(SelectField<T1> field1) Create a new DSL select statement.@NotNull SelectSelectStep<Record1<Integer>>
DSLContext.selectCount()
Create a new DSL select statement forCOUNT(*)
.@NotNull SelectSelectStep<Record1<Integer>>
WithStep.selectCount()
Create a new DSL select statement forCOUNT(*)
.<T1> @NotNull SelectSelectStep<Record1<T1>>
DSLContext.selectDistinct
(SelectField<T1> field1) Create a new DSL select statement.<T1> @NotNull SelectSelectStep<Record1<T1>>
WithStep.selectDistinct
(SelectField<T1> field1) Create a new DSL select statement.@NotNull SelectSelectStep<Record1<Integer>>
DSLContext.selectOne()
Create a new DSL select statement for a constant1
literal.@NotNull SelectSelectStep<Record1<Integer>>
WithStep.selectOne()
Create a new DSL select statement for a constant1
literal.@NotNull SelectSelectStep<Record1<Integer>>
DSLContext.selectZero()
Create a new DSL select statement for a constant0
literal.@NotNull SelectSelectStep<Record1<Integer>>
WithStep.selectZero()
Create a new DSL select statement for a constant0
literal.Modifier and TypeMethodDescription@NotNull Condition
Create a condition to check this field against some bounds@NotNull BetweenAndStep1<T1>
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 BetweenAndStep1<T1>
Row1.betweenSymmetric
(Record1<T1> minValue) Check if this row value expression is within a symmetric range of two records.@NotNull Condition
Row1.betweenSymmetric
(Record1<T1> minValue, Record1<T1> maxValue) Check if this row value expression is within a symmetric range of two records.@NotNull Condition
Row1.compare
(Comparator comparator, Record1<T1> 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
Row1.greaterOrEqual
(Record1<T1> record) Compare this row value expression with a record for order.@NotNull Condition
Row1.greaterThan
(Record1<T1> 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
Row1.isDistinctFrom
(Record1<T1> record) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Row1.isNotDistinctFrom
(Record1<T1> 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
Row1.lessOrEqual
(Record1<T1> 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 BetweenAndStep1<T1>
Row1.notBetween
(Record1<T1> minValue) Check if this row value expression is within a range of two records.@NotNull Condition
Row1.notBetween
(Record1<T1> minValue, Record1<T1> maxValue) Check if this row value expression is within a range of two records.@NotNull BetweenAndStep1<T1>
Row1.notBetweenSymmetric
(Record1<T1> minValue) Check if this row value expression is not within a symmetric range of two records.@NotNull Condition
Row1.notBetweenSymmetric
(Record1<T1> minValue, Record1<T1> 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.@NotNull InsertValuesStep1<R,
T1> Add a single row of values to the insert statement.@NotNull InsertValuesStep1<R,
T1> InsertValuesStep1.valuesOfRecords
(Record1<T1>... values) Add multiple rows of values to the insert statement.Modifier and TypeMethodDescription<T1> void
Specify a multi-column set clause for theUPDATE
statement.@NotNull WithStep
WithAsStep1.as
(ResultQuery<? extends Record1<?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep1.asMaterialized
(ResultQuery<? extends Record1<?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep1.asNotMaterialized
(ResultQuery<? extends Record1<?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull Condition
Field.compare
(Comparator comparator, QuantifiedSelect<? extends Record1<T>> query) Compare this field with a quantified subselect using a dynamic comparator.@NotNull Condition
Field.compare
(Comparator comparator, Select<? extends Record1<T>> query) Compare this field with a subselect using a dynamic comparator.@NotNull Condition
Row1.compare
(Comparator comparator, QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
Row1.compare
(Comparator comparator, Select<? extends Record1<T1>> select) Compare this row value expression with a subselect using a dynamic comparator.Add an else clause to the already constructed case statement@NotNull Condition
Field.eq
(QuantifiedSelect<? extends Record1<T>> query) this = [quantifier] (Select<?> …)
.@NotNull Condition
TheEQ
operator.@NotNull Condition
Row1.eq
(QuantifiedSelect<? extends Record1<T1>> 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
Field.equal
(QuantifiedSelect<? extends Record1<T>> query) this = [quantifier] (Select<?> …)
.@NotNull Condition
TheEQUAL
operator, an alias for theEQ
operator.@NotNull Condition
Row1.equal
(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for equality.@NotNull Condition
Compare this row value expression with a subselect for equality.<T> T
DSLContext.fetchValue
(Table<? extends Record1<T>> table) Fetch a single value from a single column table.<T> @NotNull List<T>
DSLContext.fetchValues
(Table<? extends Record1<T>> table) Fetch all values from a single column table.@NotNull Condition
Field.ge
(QuantifiedSelect<? extends Record1<T>> query) this >= [quantifier] (Select<?> …)
.@NotNull Condition
TheGE
operator.@NotNull Condition
Row1.ge
(QuantifiedSelect<? extends Record1<T1>> 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
Field.greaterOrEqual
(QuantifiedSelect<? extends Record1<T>> query) this >= [quantifier] (Select<?> …)
.@NotNull Condition
Field.greaterOrEqual
(Select<? extends Record1<T>> arg2) TheGREATER_OR_EQUAL
operator, an alias for theGE
operator.@NotNull Condition
Row1.greaterOrEqual
(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row1.greaterOrEqual
(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Field.greaterThan
(QuantifiedSelect<? extends Record1<T>> query) this > [quantifier] (Select<?> …)
.@NotNull Condition
Field.greaterThan
(Select<? extends Record1<T>> arg2) TheGREATER_THAN
operator, an alias for theGT
operator.@NotNull Condition
Row1.greaterThan
(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row1.greaterThan
(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Field.gt
(QuantifiedSelect<? extends Record1<T>> query) this > [quantifier] (Select<?> …)
.@NotNull Condition
TheGT
operator.@NotNull Condition
Row1.gt
(QuantifiedSelect<? extends Record1<T1>> 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
Create a condition to check this field against several values from a previous query.@NotNull Condition
TheIN
operator.@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
Field.isDistinctFrom
(Select<? extends Record1<T>> arg2) TheIS_DISTINCT_FROM
operator.@NotNull Condition
Row1.isDistinctFrom
(Select<? extends Record1<T1>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Field.isNotDistinctFrom
(Select<? extends Record1<T>> arg2) TheIS_NOT_DISTINCT_FROM
operator.@NotNull Condition
Row1.isNotDistinctFrom
(Select<? extends Record1<T1>> select) Compare this row value expression with another row value expression for distinctness.@NotNull Condition
Field.le
(QuantifiedSelect<? extends Record1<T>> query) this <= [quantifier] (Select<?> …)
.@NotNull Condition
TheLE
operator.@NotNull Condition
Row1.le
(QuantifiedSelect<? extends Record1<T1>> 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
Field.lessOrEqual
(QuantifiedSelect<? extends Record1<T>> query) this <= [quantifier] (Select<?> …)
.@NotNull Condition
Field.lessOrEqual
(Select<? extends Record1<T>> arg2) TheLESS_OR_EQUAL
operator, an alias for theLE
operator.@NotNull Condition
Row1.lessOrEqual
(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Row1.lessOrEqual
(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Field.lessThan
(QuantifiedSelect<? extends Record1<T>> query) this < [quantifier] (Select<?> …)
.@NotNull Condition
TheLESS_THAN
operator, an alias for theLT
operator.@NotNull Condition
Row1.lessThan
(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull Condition
Compare this row value expression with a subselect for order.@NotNull LikeEscapeStep
Field.like
(QuantifiedSelect<Record1<String>> query) Create a condition to pattern-check this field against a quantified select.@NotNull Condition
Field.lt
(QuantifiedSelect<? extends Record1<T>> query) this < [quantifier] (Select<?> …)
.@NotNull Condition
TheLT
operator.@NotNull Condition
Row1.lt
(QuantifiedSelect<? extends Record1<T1>> 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
Field.ne
(QuantifiedSelect<? extends Record1<T>> query) this != [quantifier] (Select<?> …)
.@NotNull Condition
TheNE
operator.@NotNull Condition
Row1.ne
(QuantifiedSelect<? extends Record1<T1>> 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
Field.notEqual
(QuantifiedSelect<? extends Record1<T>> query) this != [quantifier] (Select<?> …)
.@NotNull Condition
TheNOT_EQUAL
operator, an alias for theNE
operator.@NotNull Condition
Row1.notEqual
(QuantifiedSelect<? extends Record1<T1>> 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
Create a condition to check this field against several values from a previous query.@NotNull Condition
TheNOT_IN
operator.@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 LikeEscapeStep
Field.notLike
(QuantifiedSelect<Record1<String>> query) Create a condition to pattern-check this field against a quantified select.Add an else clause to the already constructed case statement@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
Initialise this declaration.<T> @NotNull InsertOnDuplicateSetMoreStep<R>
Set values forUPDATE
in theINSERT
statement'sON DUPLICATE KEY UPDATE
orON CONFLICT … DO UPDATE
clause.<T> @NotNull InsertSetMoreStep<R>
Set a value for a field in theINSERT
statement.<T> @NotNull InsertSetMoreStep<R>
Set a value for a field in theINSERT
statement.<T> @NotNull MergeMatchedSetMoreStep<R>
Set values forUPDATE
in theMERGE
statement'sWHEN MATCHED
clause.<T> @NotNull MergeNotMatchedSetMoreStep<R>
Set values forINSERT
in theMERGE
statement'sWHEN NOT MATCHED
clause.@NotNull Statement
Assign a value to this set of variables.<T1> @NotNull UpdateFromStep<R>
Specify a multi-column set clause for theUPDATE
statement.<T> @NotNull UpdateSetMoreStep<R>
Set a value for a field in theUPDATE
statement.@NotNull Statement
Assign a value to this variable.<T> @NotNull JSONEntry<T>
The JSON entry value.@NotNull InsertValuesStep1<R,
T1> InsertValuesStep1.valuesOfRecords
(Collection<? extends Record1<T1>> values) Add multiple rows of values to the insert statement.<T> @NotNull CaseConditionStep<T>
This construct can be used to create expressions of the type<T> @NotNull CaseConditionStep<T>
This construct can be used to create expressions of the type@NotNull CaseConditionStep<T>
Compare a condition to the already constructed case statement, return result if the condition holds true@NotNull CaseConditionStep<T>
Compare a condition to the already constructed case statement, return result if the condition holds true<T> @NotNull CaseWhenStep<V,
T> Compare a value to the already constructed case statement, return result if values are equal.<T> @NotNull CaseWhenStep<V,
T> Compare a value to the already constructed case statement, return result if values are equal. -
Uses of Record1 in org.jooq.impl
Modifier and TypeMethodDescriptionDefaultDSLContext.fetchOptionalValue
(ResultQuery<R> query) <T,
R extends Record1<T>>
TDefaultDSLContext.fetchValue
(ResultQuery<R> query) DefaultDSLContext.fetchValues
(ResultQuery<R> query) Modifier and TypeMethodDescription<T1> Record1<T1>
DefaultDSLContext.fetchSingle
(SelectField<T1> field1) <T1> Record1<T1>
Modifier and TypeMethodDescriptionQOM.ArrayQuery.$select()
static <T> @NotNull QuantifiedSelect<Record1<T>>
Create anALL
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>
Create anALL
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>
DSL.all
(T... array) Create anALL
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>
Create anANY
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>
Create anANY
quantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>
DSL.any
(T... array) Create anANY
quantified select to be used in quantified comparison predicate expressions.DSL.generateSeries
(int from, int to) A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries
(int from, int to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(int from, int to, Field<Integer> step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(int from, Field<Integer> to) A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries
(int from, Field<Integer> to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(int from, Field<Integer> to, Field<Integer> step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(Field<Integer> from, int to) A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries
(Field<Integer> from, int to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(Field<Integer> from, int to, Field<Integer> step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.DSL.generateSeries
(Field<Integer> from, Field<Integer> to) A table function generating a series of values fromfrom
toto
(inclusive).DSL.generateSeries
(Field<Integer> from, Field<Integer> to, int step) A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.A table function generating a series of values fromfrom
toto
(inclusive), increasing values bystep
.static <T1> @NotNull ArrayAggOrderByStep<Result<Record1<T1>>>
DSL.multisetAgg
(SelectField<T1> field1) Get theMULTISET_AGG
aggregate function to nest group contents.SequenceImpl.nextvals
(int size) static <T1> @NotNull RecordType<Record1<T1>>
DSL.recordType
(Field<T1> field1) Create aRecordType
of degree1
.Deprecated, for removal: This API element is subject to removal in a future version.- [#11812] - 3.15.0 - UseRow1
as aSelectField
directly, instead.<T1> SelectSelectStep<Record1<T1>>
DefaultDSLContext.select
(SelectField<T1> field1) static <T1> @NotNull SelectSelectStep<Record1<T1>>
DSL.select
(SelectField<T1> field1) Create a new DSL subselect statement.DefaultDSLContext.selectCount()
static @NotNull SelectSelectStep<Record1<Integer>>
DSL.selectCount()
Create a new DSL subselect statement forCOUNT(*)
.<T1> SelectSelectStep<Record1<T1>>
DefaultDSLContext.selectDistinct
(SelectField<T1> field1) static <T1> @NotNull SelectSelectStep<Record1<T1>>
DSL.selectDistinct
(SelectField<T1> field1) Create a new DSL subselect statement.DefaultDSLContext.selectOne()
static @NotNull SelectSelectStep<Record1<Integer>>
DSL.selectOne()
Create a new DSL subselect statement for a constant1
literal.DefaultDSLContext.selectZero()
static @NotNull SelectSelectStep<Record1<Integer>>
DSL.selectZero()
Create a new DSL subselect statement for a constant0
literal.Create aVALUES()
expression of degree1
.Modifier and TypeMethodDescriptionstatic <T> @NotNull Field<T[]>
The PostgreSQLarray(select)
function.<T> T
DefaultDSLContext.fetchValue
(Table<? extends Record1<T>> table) <T> List<T>
DefaultDSLContext.fetchValues
(Table<? extends Record1<T>> table) static <T> @NotNull Field<T>
Transform a subquery into a correlated subquery.static <T> @NotNull JSONEntry<T>
A constructor for JSON entries to be used withDSL.jsonObject(JSONEntry...)
.static <T> @NotNull JSONEntry<T>
A constructor for JSON entries to be used withDSL.jsonObject(JSONEntry...)
.static @NotNull JSONObjectNullStep<JSON>
DSL.jsonObject
(Field<String> key, Select<? extends Record1<?>> value) The JSON object constructor.static <T> @NotNull CaseConditionStep<T>
Initialise aCase
statement.static <T> @NotNull CaseConditionStep<T>
Initialise aCase
statement.
DSLContext.mergeInto(Table)