Uses of Interface
org.jooq.Record4
-
Packages that use Record4 Package Description org.jooq This package contains jOOQ's public API.org.jooq.impl This package contains jOOQ's implementation classes. -
-
Uses of Record4 in org.jooq
Methods in org.jooq with type parameters of type Record4 Modifier and Type Method Description <R extends Record4<?,?,?,?>>
@NotNull CommonTableExpression<R>DerivedColumnList4. as(Select<R> select)Specify a subselect to refer to by theDerivedColumnListto form a common table expression.<R extends Record4<?,?,?,?>>
@NotNull CommonTableExpression<R>DerivedColumnList4. asMaterialized(Select<R> select)Specify a materialized subselect to refer to by theDerivedColumnListto form a common table expression.<R extends Record4<?,?,?,?>>
@NotNull CommonTableExpression<R>DerivedColumnList4. asNotMaterialized(Select<R> select)Specify a non-materialized subselect to refer to by theDerivedColumnListto form a common table expression.Methods in org.jooq that return Record4 Modifier and Type Method Description <T1,T2,T3,T4>
@NotNull Record4<T1,T2,T3,T4>DSLContext. fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)Execute and return exactly one record for<T1,T2,T3,T4>
@NotNull Record4<T1,T2,T3,T4>Record. into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)Copy this record into a new record holding only a subset of the previous fields.<T1,T2,T3,T4>
@NotNull Record4<T1,T2,T3,T4>DSLContext. newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)Create a new emptyRecord.@NotNull Record4<T1,T2,T3,T4>Record4. value1(T1 value)Set the first value.@NotNull Record4<T1,T2,T3,T4>Record4. value2(T2 value)Set the second value.@NotNull Record4<T1,T2,T3,T4>Record4. value3(T3 value)Set the third value.@NotNull Record4<T1,T2,T3,T4>Record4. value4(T4 value)Set the fourth value.@NotNull Record4<T1,T2,T3,T4>Record4. values(T1 t1, T2 t2, T3 t3, T4 t4)Set all values.<T> @NotNull Record4<T1,T2,T3,T4>Record4. with(Field<T> field, T value)Set a value into this record.<T,U>
@NotNull Record4<T1,T2,T3,T4>Record4. with(Field<T> field, U value, Converter<? extends T,? super U> converter)Set a value into this record.Methods in org.jooq that return types with arguments of type Record4 Modifier and Type Method Description <T1,T2,T3,T4>
@NotNull ResultQuery<Record4<T1,T2,T3,T4>>ResultQuery. coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)Coerce the result record type of this query to that of a set of fields.<T1,T2,T3,T4>
@NotNull Result<Record4<T1,T2,T3,T4>>Result. into(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)Copy all records from this result into a new result with new records holding only a subset of the previous fields.<T1,T2,T3,T4>
@NotNull Result<Record4<T1,T2,T3,T4>>DSLContext. newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)Create a new emptyResult.<T1,T2,T3,T4>
@NotNull DeleteResultStep<Record4<T1,T2,T3,T4>>DeleteReturningStep. returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)Configure theDELETEstatement to return a list of fields inR.<T1,T2,T3,T4>
@NotNull InsertResultStep<Record4<T1,T2,T3,T4>>InsertReturningStep. returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)Configure theINSERTstatement to return a list of fields inR.<T1,T2,T3,T4>
@NotNull UpdateResultStep<Record4<T1,T2,T3,T4>>UpdateReturningStep. returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)Configure theUPDATEstatement to return a list of fields inR.<T1,T2,T3,T4>
@NotNull SelectSelectStep<Record4<T1,T2,T3,T4>>DSLContext. select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)Create a new DSL select statement.<T1,T2,T3,T4>
@NotNull SelectSelectStep<Record4<T1,T2,T3,T4>>WithStep. select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)Create a new DSL select statement.<T1,T2,T3,T4>
@NotNull SelectSelectStep<Record4<T1,T2,T3,T4>>DSLContext. selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)Create a new DSL select statement.<T1,T2,T3,T4>
@NotNull SelectSelectStep<Record4<T1,T2,T3,T4>>WithStep. selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)Create a new DSL select statement.Methods in org.jooq with parameters of type Record4 Modifier and Type Method Description @NotNull ConditionBetweenAndStep4. and(Record4<T1,T2,T3,T4> maxValue)Create a condition to check this field against some bounds@NotNull BetweenAndStep4<T1,T2,T3,T4>Row4. between(Record4<T1,T2,T3,T4> minValue)Check if this row value expression is within a range of two records.@NotNull ConditionRow4. between(Record4<T1,T2,T3,T4> minValue, Record4<T1,T2,T3,T4> maxValue)Check if this row value expression is within a range of two records.@NotNull BetweenAndStep4<T1,T2,T3,T4>Row4. betweenSymmetric(Record4<T1,T2,T3,T4> minValue)Check if this row value expression is within a symmetric range of two records.@NotNull ConditionRow4. betweenSymmetric(Record4<T1,T2,T3,T4> minValue, Record4<T1,T2,T3,T4> maxValue)Check if this row value expression is within a symmetric range of two records.@NotNull ConditionRow4. compare(Comparator comparator, Record4<T1,T2,T3,T4> record)Compare this row value expression with a record using a dynamic comparator.@NotNull ConditionRow4. eq(Record4<T1,T2,T3,T4> record)Compare this row value expression with a record for equality.@NotNull ConditionRow4. equal(Record4<T1,T2,T3,T4> record)Compare this row value expression with a record for equality.@NotNull ConditionRow4. ge(Record4<T1,T2,T3,T4> record)Compare this row value expression with a record for order.@NotNull ConditionRow4. greaterOrEqual(Record4<T1,T2,T3,T4> record)Compare this row value expression with a record for order.@NotNull ConditionRow4. greaterThan(Record4<T1,T2,T3,T4> record)Compare this row value expression with a record for order.@NotNull ConditionRow4. gt(Record4<T1,T2,T3,T4> record)Compare this row value expression with a record for order.@NotNull ConditionRow4. in(Record4<T1,T2,T3,T4>... record)Compare this row value expression with a set of records for equality.@NotNull ConditionRow4. isDistinctFrom(Record4<T1,T2,T3,T4> record)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRow4. isNotDistinctFrom(Record4<T1,T2,T3,T4> record)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRow4. le(Record4<T1,T2,T3,T4> record)Compare this row value expression with a record for order.@NotNull ConditionRow4. lessOrEqual(Record4<T1,T2,T3,T4> record)Compare this row value expression with a record for order.@NotNull ConditionRow4. lessThan(Record4<T1,T2,T3,T4> record)Compare this row value expression with a record for order.@NotNull ConditionRow4. lt(Record4<T1,T2,T3,T4> record)Compare this row value expression with a record for order.@NotNull ConditionRow4. ne(Record4<T1,T2,T3,T4> record)Compare this row value expression with a record for non-equality.@NotNull BetweenAndStep4<T1,T2,T3,T4>Row4. notBetween(Record4<T1,T2,T3,T4> minValue)Check if this row value expression is within a range of two records.@NotNull ConditionRow4. notBetween(Record4<T1,T2,T3,T4> minValue, Record4<T1,T2,T3,T4> maxValue)Check if this row value expression is within a range of two records.@NotNull BetweenAndStep4<T1,T2,T3,T4>Row4. notBetweenSymmetric(Record4<T1,T2,T3,T4> minValue)Check if this row value expression is not within a symmetric range of two records.@NotNull ConditionRow4. notBetweenSymmetric(Record4<T1,T2,T3,T4> minValue, Record4<T1,T2,T3,T4> maxValue)Check if this row value expression is not within a symmetric range of two records.@NotNull ConditionRow4. notEqual(Record4<T1,T2,T3,T4> record)Compare this row value expression with a record for non-equality@NotNull ConditionRow4. notIn(Record4<T1,T2,T3,T4>... record)Compare this row value expression with a set of records for non-equality.Method parameters in org.jooq with type arguments of type Record4 Modifier and Type Method Description <T1,T2,T3,T4>
voidUpdateQuery. addValues(Row4<T1,T2,T3,T4> row, Select<? extends Record4<T1,T2,T3,T4>> select)Specify a multi-column set clause for theUPDATEstatement.@NotNull WithStepWithAsStep4. as(Select<? extends Record4<?,?,?,?>> select)Associate a subselect with a common table expression's table and column names.@NotNull WithStepWithAsStep4. asMaterialized(Select<? extends Record4<?,?,?,?>> select)Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStepWithAsStep4. asNotMaterialized(Select<? extends Record4<?,?,?,?>> select)Associate a non-materialized subselect with a common table expression's table and column names.@NotNull ConditionRow4. compare(Comparator comparator, QuantifiedSelect<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionRow4. compare(Comparator comparator, Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect using a dynamic comparator.@NotNull ConditionRow4. eq(QuantifiedSelect<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for equality.@NotNull ConditionRow4. eq(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for equality.@NotNull ConditionRow4. equal(QuantifiedSelect<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for equality.@NotNull ConditionRow4. equal(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for equality.@NotNull ConditionRow4. ge(QuantifiedSelect<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. ge(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. greaterOrEqual(QuantifiedSelect<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. greaterOrEqual(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. greaterThan(QuantifiedSelect<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. greaterThan(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. gt(QuantifiedSelect<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. gt(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. in(Result<? extends Record4<T1,T2,T3,T4>> result)Compare this row value expression with a set of records for equality.@NotNull ConditionRow4. in(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for equality.@NotNull ConditionRow4. isDistinctFrom(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRow4. isNotDistinctFrom(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with another row value expression for distinctness.@NotNull ConditionRow4. le(QuantifiedSelect<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. le(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. lessOrEqual(QuantifiedSelect<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. lessOrEqual(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. lessThan(QuantifiedSelect<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. lessThan(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. lt(QuantifiedSelect<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. lt(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for order.@NotNull ConditionRow4. ne(QuantifiedSelect<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for non-equality.@NotNull ConditionRow4. ne(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for non-equality.@NotNull ConditionRow4. notEqual(QuantifiedSelect<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for non-equality.@NotNull ConditionRow4. notEqual(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for non-equality.@NotNull ConditionRow4. notIn(Result<? extends Record4<T1,T2,T3,T4>> result)Compare this row value expression with a set of records for equality.@NotNull ConditionRow4. notIn(Select<? extends Record4<T1,T2,T3,T4>> select)Compare this row value expression with a subselect for non-equality.@NotNull InsertOnDuplicateStep<R>InsertValuesStep4. select(Select<? extends Record4<T1,T2,T3,T4>> select)Use aSELECTstatement as the source of values for theINSERTstatement@NotNull Merge<R>MergeValuesStep4. select(Select<? extends Record4<T1,T2,T3,T4>> select)Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)<T1,T2,T3,T4>
@NotNull UpdateFromStep<R>UpdateSetFirstStep. set(Row4<T1,T2,T3,T4> row, Select<? extends Record4<T1,T2,T3,T4>> select)Specify a multi-column set clause for theUPDATEstatement. -
Uses of Record4 in org.jooq.impl
Methods in org.jooq.impl that return Record4 Modifier and Type Method Description <T1,T2,T3,T4>
Record4<T1,T2,T3,T4>DefaultDSLContext. fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)<T1,T2,T3,T4>
Record4<T1,T2,T3,T4>DefaultDSLContext. newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)Methods in org.jooq.impl that return types with arguments of type Record4 Modifier and Type Method Description <T1,T2,T3,T4>
Result<Record4<T1,T2,T3,T4>>DefaultDSLContext. newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)static <T1,T2,T3,T4>
@NotNull RecordType<Record4<T1,T2,T3,T4>>DSL. recordType(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)Create aRecordTypeof degree4.static <T1,T2,T3,T4>
@NotNull Field<Record4<T1,T2,T3,T4>>DSL. rowField(Row4<T1,T2,T3,T4> row)EXPERIMENTAL: Turn a row value expression of degree4into aField.<T1,T2,T3,T4>
SelectSelectStep<Record4<T1,T2,T3,T4>>DefaultDSLContext. select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)static <T1,T2,T3,T4>
@NotNull SelectSelectStep<Record4<T1,T2,T3,T4>>DSL. select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)Create a new DSL subselect statement.<T1,T2,T3,T4>
SelectSelectStep<Record4<T1,T2,T3,T4>>DefaultDSLContext. selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)static <T1,T2,T3,T4>
@NotNull SelectSelectStep<Record4<T1,T2,T3,T4>>DSL. selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3, SelectField<T4> field4)Create a new DSL subselect statement.static <T1,T2,T3,T4>
@NotNull Table<Record4<T1,T2,T3,T4>>DSL. values(Row4<T1,T2,T3,T4>... rows)Create aVALUES()expression of degree4.
-