Uses of Interface
org.jooq.Record7
Packages that use Record7
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of Record7 in org.jooq
Modifier and TypeMethodDescription<R extends Record7<?,?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>DerivedColumnList7.as(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnListto form a common table expression.<R extends Record7<?,?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>DerivedColumnList7.asMaterialized(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnListto form a common table expression.<R extends Record7<?,?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R>DerivedColumnList7.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, R extends Record7<T1, T2, T3, T4, T5, T6, T7>, U>
RecordMapper<R,U> Records.mapping(Function7<? super T1, ? super T2, ? super T3, ? super T4, ? super T5, ? super T6, ? super T7, ? extends U> function) Create aRecordMapperthat can map fromRecord7to a user type in a type safe way.Modifier and TypeMethodDescription<T1,T2, T3, T4, T5, T6, T7>
@NotNull Record7<T1,T2, T3, T4, T5, T6, T7> DSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Execute and return exactly one record for<T1,T2, T3, T4, T5, T6, T7>
@NotNull Record7<T1,T2, T3, T4, T5, T6, T7> Record.into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) 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>
@NotNull Record7<T1,T2, T3, T4, T5, T6, T7> DSLContext.newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) 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 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>
@NotNull CloseableResultQuery<Record7<T1,T2, T3, T4, T5, T6, T7>> CloseableResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) <T1,T2, T3, T4, T5, T6, T7>
@NotNull ResultQuery<Record7<T1,T2, T3, T4, T5, T6, T7>> ResultQuery.coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) 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) 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) Create a new emptyResult.<T1,T2, T3, T4, T5, T6, T7>
@NotNull DeleteResultStep<Record7<T1,T2, T3, T4, T5, T6, T7>> DeleteReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Configure theDELETEstatement to return a list of fields inR.<T1,T2, T3, T4, T5, T6, T7>
@NotNull InsertResultStep<Record7<T1,T2, T3, T4, T5, T6, T7>> InsertReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Configure theINSERTstatement to return a list of fields inR.<T1,T2, T3, T4, T5, T6, T7>
@NotNull UpdateResultStep<Record7<T1,T2, T3, T4, T5, T6, T7>> UpdateReturningStep.returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Configure theUPDATEstatement to return a list of fields inR.<T1,T2, T3, T4, T5, T6, T7>
@NotNull SelectSelectStep<Record7<T1,T2, T3, T4, T5, T6, T7>> DSLContext.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Create a new DSL select statement.<T1,T2, T3, T4, T5, T6, T7>
@NotNull SelectSelectStep<Record7<T1,T2, T3, T4, T5, T6, T7>> WithStep.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Create a new DSL select statement.<T1,T2, T3, T4, T5, T6, T7>
@NotNull SelectSelectStep<Record7<T1,T2, T3, T4, T5, T6, T7>> DSLContext.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Create a new DSL select statement.<T1,T2, T3, T4, T5, T6, T7>
@NotNull SelectSelectStep<Record7<T1,T2, T3, T4, T5, T6, T7>> WithStep.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) 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 ConditionCheck 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 ConditionRow7.betweenSymmetric(Record7<T1, T2, T3, T4, T5, T6, T7> minValue, Record7<T1, T2, T3, T4, T5, T6, T7> 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 ConditionCheck 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 ConditionRow7.notBetweenSymmetric(Record7<T1, T2, T3, T4, T5, T6, T7> minValue, Record7<T1, T2, T3, T4, T5, T6, T7> 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>
voidUpdateQuery.addValues(Row7<T1, T2, T3, T4, T5, T6, T7> row, Select<? extends Record7<T1, T2, T3, T4, T5, T6, T7>> select) Specify a multi-column set clause for theUPDATEstatement.@NotNull WithStepWithAsStep7.as(ResultQuery<? extends Record7<?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStepWithAsStep7.asMaterialized(ResultQuery<? extends Record7<?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStepWithAsStep7.asNotMaterialized(ResultQuery<? extends Record7<?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull ConditionRow7.compare(Comparator comparator, QuantifiedSelect<? extends Record7<T1, T2, T3, T4, T5, T6, T7>> 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 ConditionRow7.greaterOrEqual(QuantifiedSelect<? extends Record7<T1, T2, T3, T4, T5, T6, T7>> select) Compare this row value expression with a subselect for order.@NotNull ConditionCompare this row value expression with a subselect for order.@NotNull ConditionRow7.greaterThan(QuantifiedSelect<? extends Record7<T1, T2, T3, T4, T5, T6, T7>> select) Compare 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 ConditionRow7.lessOrEqual(QuantifiedSelect<? extends Record7<T1, T2, T3, T4, T5, T6, T7>> select) Compare 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>
@NotNull UpdateFromStep<R>UpdateSetFirstStep.set(Row7<T1, T2, T3, T4, T5, T6, T7> row, Select<? extends Record7<T1, T2, T3, T4, T5, T6, T7>> select) Specify a multi-column set clause for theUPDATEstatement.InsertValuesStep7.valuesOfRecords(Collection<? extends Record7<T1, T2, T3, T4, T5, T6, T7>> values) Add multiple rows of values to the insert statement. -
Uses of Record7 in org.jooq.impl
Methods in org.jooq.impl that return Record7Modifier and TypeMethodDescription<T1,T2, T3, T4, T5, T6, T7>
Record7<T1,T2, T3, T4, T5, T6, T7> DefaultDSLContext.fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) <T1,T2, T3, T4, T5, T6, T7>
Record7<T1,T2, T3, T4, T5, T6, T7> DefaultDSLContext.newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Methods in org.jooq.impl that return types with arguments of type Record7Modifier and TypeMethodDescriptionstatic <T1,T2, T3, T4, T5, T6, T7>
@NotNull ArrayAggOrderByStep<Result<Record7<T1,T2, T3, T4, T5, T6, T7>>> DSL.multisetAgg(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Get theMULTISET_AGGaggregate function to nest group contents.static <T1,T2, T3, T4, T5, T6, T7>
@NotNull ArrayAggOrderByStep<Result<Record7<T1,T2, T3, T4, T5, T6, T7>>> DSL.multisetAggDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Get theMULTISET_AGG(DISTINCT)aggregate 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) static <T1,T2, T3, T4, T5, T6, T7>
@NotNull RecordType<Record7<T1,T2, T3, T4, T5, T6, T7>> DSL.recordType(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Create aRecordTypeof degree7.Deprecated, for removal: This API element is subject to removal in a future version.- [#11812] - 3.15.0 - UseRow7as aSelectFielddirectly, instead.<T1,T2, T3, T4, T5, T6, T7>
SelectSelectStep<Record7<T1,T2, T3, T4, T5, T6, T7>> DefaultDSLContext.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) static <T1,T2, T3, T4, T5, T6, T7>
@NotNull SelectSelectStep<Record7<T1,T2, T3, T4, T5, T6, T7>> DSL.select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Create a new DSL subselect statement.<T1,T2, T3, T4, T5, T6, T7>
SelectSelectStep<Record7<T1,T2, T3, T4, T5, T6, T7>> DefaultDSLContext.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) static <T1,T2, T3, T4, T5, T6, T7>
@NotNull SelectSelectStep<Record7<T1,T2, T3, T4, T5, T6, T7>> DSL.selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4, SelectField<T5> field5, SelectField<T6> field6, SelectField<T7> field7) Create a new DSL subselect statement.Create aVALUES()expression of degree7.
DSLContext.mergeInto(Table)