Uses of Interface
org.jooq.Record1
Packages that use 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 theDerivedColumnListto form a common table expression.<R extends Record1<?>>
@NotNull CommonTableExpression<R>DerivedColumnList1.asMaterialized(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnListto 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 theDerivedColumnListto form a common table expression.DSLContext.fetchOptionalValue(ResultQuery<R> query) Execute aResultQueryin the context of thisDSLContextand return a single value.<T,R extends Record1<T>>
TDSLContext.fetchValue(ResultQuery<R> query) Execute aResultQueryin the context of thisDSLContextand return a single value.DSLContext.fetchValues(ResultQuery<R> query) Execute aResultQueryin the context of thisDSLContextand return all values for the only column.Records.intoArray(E[] a) Create a collector that can collectRecord1resulting from a single columnResultQueryinto an array of that column's type.Create a collector that can collectRecordresulting from aResultQueryinto an array of a mapped type.Records.intoList()Create a collector that can collectRecord1resulting from a single columnResultQueryinto aListof that column's type.Records.intoSet()Create a collector that can collectRecord1resulting from a single columnResultQueryinto aSetof that column's type.static final <T1,R extends Record1<T1>, U>
RecordMapper<R,U> Create aRecordMapperthat can map fromRecord1to 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 JSONclause.@NotNull SelectForJSONStep<Record1<JSONB>>SelectForStep.forJSONB()Add a SQL Server-styleFOR JSONclause.@NotNull SelectForXMLStep<Record1<XML>>SelectForStep.forXML()Add a SQL Server-styleFOR XMLclause.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 theDELETEstatement to return a list of fields inR.<T1> @NotNull InsertResultStep<Record1<T1>>InsertReturningStep.returningResult(SelectField<T1> field1) Configure theINSERTstatement to return a list of fields inR.<T1> @NotNull UpdateResultStep<Record1<T1>>UpdateReturningStep.returningResult(SelectField<T1> field1) Configure theUPDATEstatement 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 constant1literal.@NotNull SelectSelectStep<Record1<Integer>>WithStep.selectOne()Create a new DSL select statement for a constant1literal.@NotNull SelectSelectStep<Record1<Integer>>DSLContext.selectZero()Create a new DSL select statement for a constant0literal.@NotNull SelectSelectStep<Record1<Integer>>WithStep.selectZero()Create a new DSL select statement for a constant0literal.Modifier and TypeMethodDescription@NotNull ConditionCreate 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 ConditionCheck 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 ConditionRow1.betweenSymmetric(Record1<T1> minValue, Record1<T1> maxValue) Check if this row value expression is within a symmetric range of two records.@NotNull ConditionRow1.compare(Comparator comparator, Record1<T1> record) Compare this row value expression with a record using a dynamic comparator.@NotNull ConditionCompare this row value expression with a record for equality.@NotNull ConditionCompare this row value expression with a record for equality.@NotNull ConditionCompare this row value expression with a record for order.@NotNull ConditionRow1.greaterOrEqual(Record1<T1> record) Compare this row value expression with a record for order.@NotNull ConditionRow1.greaterThan(Record1<T1> record) Compare this row value expression with a record for order.@NotNull ConditionCompare this row value expression with a record for order.@NotNull ConditionCompare this row value expression with a set of records for equality.@NotNull ConditionRow1.isDistinctFrom(Record1<T1> record) Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRow1.isNotDistinctFrom(Record1<T1> record) Compare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with a record for order.@NotNull ConditionRow1.lessOrEqual(Record1<T1> record) Compare this row value expression with a record for order.@NotNull ConditionCompare this row value expression with a record for order.@NotNull ConditionCompare this row value expression with a record for order.@NotNull ConditionCompare 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 ConditionRow1.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 ConditionRow1.notBetweenSymmetric(Record1<T1> minValue, Record1<T1> maxValue) Check if this row value expression is not within a symmetric range of two records.@NotNull ConditionCompare this row value expression with a record for non-equality@NotNull ConditionCompare this row value expression with a set of records for non-equality.@NotNull StatementAssign 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> voidSpecify a multi-column set clause for theUPDATEstatement.@NotNull WithStepWithAsStep1.as(ResultQuery<? extends Record1<?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStepWithAsStep1.asMaterialized(ResultQuery<? extends Record1<?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStepWithAsStep1.asNotMaterialized(ResultQuery<? extends Record1<?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull ConditionField.compare(Comparator comparator, QuantifiedSelect<? extends Record1<T>> query) Compare this field with a quantified subselect using a dynamic comparator.@NotNull ConditionField.compare(Comparator comparator, Select<? extends Record1<T>> query) Compare this field with a subselect using a dynamic comparator.@NotNull ConditionRow1.compare(Comparator comparator, QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionRow1.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 ConditionField.eq(QuantifiedSelect<? extends Record1<T>> query) this = [quantifier] (Select<?> …).@NotNull ConditionTheEQoperator.@NotNull ConditionRow1.eq(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionField.equal(QuantifiedSelect<? extends Record1<T>> query) this = [quantifier] (Select<?> …).@NotNull ConditionTheEQUALoperator, an alias for theEQoperator.@NotNull ConditionRow1.equal(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.<T> TDSLContext.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 ConditionField.ge(QuantifiedSelect<? extends Record1<T>> query) this >= [quantifier] (Select<?> …).@NotNull ConditionTheGEoperator.@NotNull ConditionRow1.ge(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionField.greaterOrEqual(QuantifiedSelect<? extends Record1<T>> query) this >= [quantifier] (Select<?> …).@NotNull ConditionField.greaterOrEqual(Select<? extends Record1<T>> arg2) TheGREATER_OR_EQUALoperator, an alias for theGEoperator.@NotNull ConditionRow1.greaterOrEqual(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull ConditionRow1.greaterOrEqual(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull ConditionField.greaterThan(QuantifiedSelect<? extends Record1<T>> query) this > [quantifier] (Select<?> …).@NotNull ConditionField.greaterThan(Select<? extends Record1<T>> arg2) TheGREATER_THANoperator, an alias for theGToperator.@NotNull ConditionRow1.greaterThan(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull ConditionRow1.greaterThan(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull ConditionField.gt(QuantifiedSelect<? extends Record1<T>> query) this > [quantifier] (Select<?> …).@NotNull ConditionTheGToperator.@NotNull ConditionRow1.gt(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCreate a condition to check this field against several values from a previous query.@NotNull ConditionTheINoperator.@NotNull ConditionCompare this row value expression with a set of records for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionField.isDistinctFrom(Select<? extends Record1<T>> arg2) TheIS_DISTINCT_FROMoperator.@NotNull ConditionRow1.isDistinctFrom(Select<? extends Record1<T1>> select) Compare this row value expression with another row value expression for distinctness.@NotNull ConditionField.isNotDistinctFrom(Select<? extends Record1<T>> arg2) TheIS_NOT_DISTINCT_FROMoperator.@NotNull ConditionRow1.isNotDistinctFrom(Select<? extends Record1<T1>> select) Compare this row value expression with another row value expression for distinctness.@NotNull ConditionField.le(QuantifiedSelect<? extends Record1<T>> query) this <= [quantifier] (Select<?> …).@NotNull ConditionTheLEoperator.@NotNull ConditionRow1.le(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionField.lessOrEqual(QuantifiedSelect<? extends Record1<T>> query) this <= [quantifier] (Select<?> …).@NotNull ConditionField.lessOrEqual(Select<? extends Record1<T>> arg2) TheLESS_OR_EQUALoperator, an alias for theLEoperator.@NotNull ConditionRow1.lessOrEqual(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull ConditionRow1.lessOrEqual(Select<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull ConditionField.lessThan(QuantifiedSelect<? extends Record1<T>> query) this < [quantifier] (Select<?> …).@NotNull ConditionTheLESS_THANoperator, an alias for theLToperator.@NotNull ConditionRow1.lessThan(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull LikeEscapeStepField.like(QuantifiedSelect<Record1<String>> query) Create a condition to pattern-check this field against a quantified select.@NotNull ConditionField.lt(QuantifiedSelect<? extends Record1<T>> query) this < [quantifier] (Select<?> …).@NotNull ConditionTheLToperator.@NotNull ConditionRow1.lt(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionField.ne(QuantifiedSelect<? extends Record1<T>> query) this != [quantifier] (Select<?> …).@NotNull ConditionTheNEoperator.@NotNull ConditionRow1.ne(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionField.notEqual(QuantifiedSelect<? extends Record1<T>> query) this != [quantifier] (Select<?> …).@NotNull ConditionTheNOT_EQUALoperator, an alias for theNEoperator.@NotNull ConditionRow1.notEqual(QuantifiedSelect<? extends Record1<T1>> select) Compare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCreate a condition to check this field against several values from a previous query.@NotNull ConditionTheNOT_INoperator.@NotNull ConditionCompare this row value expression with a set of records for equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull LikeEscapeStepField.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 aSELECTstatement as the source of values for theINSERTstatementDeprecated, for removal: This API element is subject to removal in a future version.@NotNull StatementInitialise this declaration.<T> @NotNull InsertOnDuplicateSetMoreStep<R>Set values forUPDATEin theINSERTstatement'sON DUPLICATE KEY UPDATEorON CONFLICT … DO UPDATEclause.<T> @NotNull InsertSetMoreStep<R>Set a value for a field in theINSERTstatement.<T> @NotNull InsertSetMoreStep<R>Set a value for a field in theINSERTstatement.<T> @NotNull MergeMatchedSetMoreStep<R>Set values forUPDATEin theMERGEstatement'sWHEN MATCHEDclause.<T> @NotNull MergeNotMatchedSetMoreStep<R>Set values forINSERTin theMERGEstatement'sWHEN NOT MATCHEDclause.@NotNull StatementAssign a value to this set of variables.<T1> @NotNull UpdateFromStep<R>Specify a multi-column set clause for theUPDATEstatement.<T> @NotNull UpdateSetMoreStep<R>Set a value for a field in theUPDATEstatement.@NotNull StatementAssign 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
Methods in org.jooq.impl with type parameters of type Record1Modifier and TypeMethodDescriptionDefaultDSLContext.fetchOptionalValue(ResultQuery<R> query) <T,R extends Record1<T>>
TDefaultDSLContext.fetchValue(ResultQuery<R> query) DefaultDSLContext.fetchValues(ResultQuery<R> query) Methods in org.jooq.impl that return Record1Modifier and TypeMethodDescription<T1> Record1<T1>DefaultDSLContext.fetchSingle(SelectField<T1> field1) <T1> Record1<T1>Methods in org.jooq.impl that return types with arguments of type Record1Modifier and TypeMethodDescriptionQOM.ArrayQuery.$select()static <T> @NotNull QuantifiedSelect<Record1<T>>Create anALLquantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>Create anALLquantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>DSL.all(T... array) Create anALLquantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>Create anANYquantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>Create anANYquantified select to be used in quantified comparison predicate expressions.static <T> @NotNull QuantifiedSelect<Record1<T>>DSL.any(T... array) Create anANYquantified select to be used in quantified comparison predicate expressions.DSL.generateSeries(int from, int to) A table function generating a series of values fromfromtoto(inclusive).DSL.generateSeries(int from, int to, int step) A table function generating a series of values fromfromtoto(inclusive), increasing values bystep.DSL.generateSeries(int from, int to, Field<Integer> step) A table function generating a series of values fromfromtoto(inclusive), increasing values bystep.DSL.generateSeries(int from, Field<Integer> to) A table function generating a series of values fromfromtoto(inclusive).DSL.generateSeries(int from, Field<Integer> to, int step) A table function generating a series of values fromfromtoto(inclusive), increasing values bystep.DSL.generateSeries(int from, Field<Integer> to, Field<Integer> step) A table function generating a series of values fromfromtoto(inclusive), increasing values bystep.DSL.generateSeries(Field<Integer> from, int to) A table function generating a series of values fromfromtoto(inclusive).DSL.generateSeries(Field<Integer> from, int to, int step) A table function generating a series of values fromfromtoto(inclusive), increasing values bystep.DSL.generateSeries(Field<Integer> from, int to, Field<Integer> step) A table function generating a series of values fromfromtoto(inclusive), increasing values bystep.DSL.generateSeries(Field<Integer> from, Field<Integer> to) A table function generating a series of values fromfromtoto(inclusive).DSL.generateSeries(Field<Integer> from, Field<Integer> to, int step) A table function generating a series of values fromfromtoto(inclusive), increasing values bystep.A table function generating a series of values fromfromtoto(inclusive), increasing values bystep.static <T1> @NotNull ArrayAggOrderByStep<Result<Record1<T1>>>DSL.multisetAgg(SelectField<T1> field1) Get theMULTISET_AGGaggregate function to nest group contents.SequenceImpl.nextvals(int size) static <T1> @NotNull RecordType<Record1<T1>>DSL.recordType(Field<T1> field1) Create aRecordTypeof degree1.Deprecated, for removal: This API element is subject to removal in a future version.- [#11812] - 3.15.0 - UseRow1as aSelectFielddirectly, 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 constant1literal.DefaultDSLContext.selectZero()static @NotNull SelectSelectStep<Record1<Integer>>DSL.selectZero()Create a new DSL subselect statement for a constant0literal.Create aVALUES()expression of degree1.Method parameters in org.jooq.impl with type arguments of type Record1Modifier and TypeMethodDescriptionstatic <T> @NotNull Field<T[]>The PostgreSQLarray(select)function.<T> TDefaultDSLContext.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 aCasestatement.static <T> @NotNull CaseConditionStep<T>Initialise aCasestatement.
DSLContext.mergeInto(Table)