Uses of Interface
org.jooq.Record9
Packages that use Record9
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of Record9 in org.jooq
Modifier and TypeMethodDescription<R extends Record9<?,?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>DerivedColumnList9.as(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnListto form a common table expression.<R extends Record9<?,?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>DerivedColumnList9.asMaterialized(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnListto form a common table expression.<R extends Record9<?,?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>DerivedColumnList9.asNotMaterialized(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnListto form a common table expression.static final <T1,T2, T3, T4, T5, T6, T7, T8, T9, R extends Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>, U>
RecordMapper<R,U> Records.mapping(Function9<? super T1, ? super T2, ? super T3, ? super T4, ? super T5, ? super T6, ? super T7, ? super T8, ? super T9, ? extends U> function) Create aRecordMapperthat can map fromRecord9to a user type in a type safe way.Modifier and TypeMethodDescription<T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Execute and return exactly one record for<T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9> Record.into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Copy this record into a new record holding only a subset of the previous fields, usingFields.field(Field)for lookup.<T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9> DSLContext.newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Create a new emptyRecord.Set the first value.Set the second value.Set the third value.Set the fourth value.Set the fifth value.Set the sixth value.Set the seventh value.Set the eighth value.Set the ninth 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, T3, T4, T5, T6, T7, T8, T9>
@NotNull CloseableResultQuery<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> CloseableResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) <T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull ResultQuery<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Coerce the result record type of this query to that of a set of fields.Result.into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) 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.DSLContext.newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Create a new emptyResult.<T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull DeleteResultStep<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> DeleteReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Configure theDELETEstatement to return a list of fields inR.<T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull InsertResultStep<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> InsertReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Configure theINSERTstatement to return a list of fields inR.<T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull UpdateResultStep<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> UpdateReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Configure theUPDATEstatement to return a list of fields inR.<T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull SelectSelectStep<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> DSLContext.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Create a new DSL select statement.<T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull SelectSelectStep<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> WithStep.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Create a new DSL select statement.<T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull SelectSelectStep<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> DSLContext.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Create a new DSL select statement.<T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull SelectSelectStep<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> WithStep.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Create a new DSL select statement.Modifier and TypeMethodDescription@NotNull ConditionCreate a condition to check this field against some boundsCheck if this row value expression is within a range of two records.@NotNull ConditionRow9.between(Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9> minValue, Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9> maxValue) Check if this row value expression is within a range of two records.Check if this row value expression is within a symmetric range of two records.@NotNull ConditionRow9.betweenSymmetric(Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9> minValue, Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9> maxValue) Check if this row value expression is within a symmetric range of two records.@NotNull ConditionCompare 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 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 order.@NotNull ConditionCompare this row value expression with a set of records for equality.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@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 order.@NotNull ConditionCompare this row value expression with a record for order.@NotNull ConditionCompare this row value expression with a record for non-equality.Check if this row value expression is within a range of two records.@NotNull ConditionRow9.notBetween(Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9> minValue, Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9> maxValue) Check if this row value expression is within a range of two records.Check if this row value expression is not within a symmetric range of two records.@NotNull ConditionRow9.notBetweenSymmetric(Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9> minValue, Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9> 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.Add a single row of values to the insert statement.Add multiple rows of values to the insert statement.Modifier and TypeMethodDescription<T1,T2, T3, T4, T5, T6, T7, T8, T9>
voidUpdateQuery.addValues(Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> row, Select<? extends Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> select) Specify a multi-column set clause for theUPDATEstatement.@NotNull WithStepWithAsStep9.as(ResultQuery<? extends Record9<?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStepWithAsStep9.asMaterialized(ResultQuery<? extends Record9<?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStepWithAsStep9.asNotMaterialized(ResultQuery<? extends Record9<?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull ConditionRow9.compare(Comparator comparator, QuantifiedSelect<? extends Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> select) Compare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionCompare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for equality.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@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 ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with another row value expression for distinctness.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@NotNull ConditionCompare this row value expression with a subselect for non-equality.@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 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 StatementAssign a value to this set of variables.<T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull UpdateFromStep<R>UpdateSetFirstStep.set(Row9<T1, T2, T3, T4, T5, T6, T7, T8, T9> row, Select<? extends Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> select) Specify a multi-column set clause for theUPDATEstatement.Add multiple rows of values to the insert statement. -
Uses of Record9 in org.jooq.impl
Methods in org.jooq.impl that return Record9Modifier and TypeMethodDescription<T1,T2, T3, T4, T5, T6, T7, T8, T9>
Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9> DefaultDSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) <T1,T2, T3, T4, T5, T6, T7, T8, T9>
Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9> DefaultDSLContext.newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Methods in org.jooq.impl that return types with arguments of type Record9Modifier and TypeMethodDescriptionstatic <T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull ArrayAggOrderByStep<Result<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>>> DSL.multisetAgg(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Get theMULTISET_AGGaggregate function to nest group contents.DefaultDSLContext.newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) static <T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull RecordType<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> DSL.recordType(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Create aRecordTypeof degree9.Deprecated, for removal: This API element is subject to removal in a future version.- [#11812] - 3.15.0 - UseRow9as aSelectFielddirectly, instead.<T1,T2, T3, T4, T5, T6, T7, T8, T9>
SelectSelectStep<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> DefaultDSLContext.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) static <T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull SelectSelectStep<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> DSL.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Create a new DSL subselect statement.<T1,T2, T3, T4, T5, T6, T7, T8, T9>
SelectSelectStep<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> DefaultDSLContext.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) static <T1,T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull SelectSelectStep<Record9<T1,T2, T3, T4, T5, T6, T7, T8, T9>> DSL.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7, SelectField<T8> field8, SelectField<T9> field9) Create a new DSL subselect statement.Create aVALUES()expression of degree9.
DSLContext.mergeInto(Table)