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 <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.<T1> @NotNull Record1<T1>
Create a new emptyRecord
.Set the first value.Set all values.Set a value into this record.Set a value into this record.Modifier and TypeMethodDescription<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.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
this = (Select<?> ...)
.@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
this = (Select<?> ...)
.@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
this >= (Select<?> ...)
.@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>> query)
this >= (Select<?> ...)
.@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>> query)
this > (Select<?> ...)
.@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
this > (Select<?> ...)
.@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
Create a condition to check this field against a subquery.@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>> select)
Create a condition to check if this field isDISTINCT
from another field.@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>> select)
Create a condition to check if this field isNOT DISTINCT
from another field.@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
this <= (Select<?> ...)
.@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>> query)
this <= (Select<?> ...)
.@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
this < (Select<?> ...)
.@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
this < (Select<?> ...)
.@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
this != (Select<?> ...)
.@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
this != (Select<?> ...)
.@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
Create a condition to check this field against a subquery.@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 ...
<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 TypeMethodDescriptionstatic <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)