Uses of Interface
org.jooq.Record3
-
Packages that use Record3 Package Description org.jooq Theorg.jooqpackage contains jOOQ's public API.org.jooq.impl Theorg.jooq.implpackage contains jOOQ's implementation classes. -
-
Uses of Record3 in org.jooq
Methods in org.jooq with type parameters of type Record3 Modifier and Type Method Description <R extends Record3<?,?,?>>
CommonTableExpression<R>DerivedColumnList3. as(Select<R> select)Specify a subselect to refer to by theDerivedColumnListto form a common table expression.Methods in org.jooq that return Record3 Modifier and Type Method Description <T1,T2,T3>
Record3<T1,T2,T3>DSLContext. fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)Execute and return exactly one record for<T1,T2,T3>
Record3<T1,T2,T3>Record. into(Field<T1> field1, Field<T2> field2, Field<T3> field3)Copy this record into a new record holding only a subset of the previous fields.<T1,T2,T3>
Record3<T1,T2,T3>DSLContext. newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3)Create a new emptyRecord.Record3<T1,T2,T3>Record3. value1(T1 value)Set the first value.Record3<T1,T2,T3>Record3. value2(T2 value)Set the second value.Record3<T1,T2,T3>Record3. value3(T3 value)Set the third value.Record3<T1,T2,T3>Record3. values(T1 t1, T2 t2, T3 t3)Set all values.Methods in org.jooq that return types with arguments of type Record3 Modifier and Type Method Description <T1,T2,T3>
ResultQuery<Record3<T1,T2,T3>>ResultQuery. coerce(Field<T1> field1, Field<T2> field2, Field<T3> field3)Coerce the result record type of this query to that of a set of fields.<T1,T2,T3>
Result<Record3<T1,T2,T3>>Result. into(Field<T1> field1, Field<T2> field2, Field<T3> field3)Copy all records from this result into a new result with new records holding only a subset of the previous fields.<T1,T2,T3>
Result<Record3<T1,T2,T3>>DSLContext. newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3)Create a new emptyResult.<T1,T2,T3>
DeleteResultStep<Record3<T1,T2,T3>>DeleteReturningStep. returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)Configure theDELETEstatement to return a list of fields inR.<T1,T2,T3>
InsertResultStep<Record3<T1,T2,T3>>InsertReturningStep. returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)Configure theINSERTstatement to return a list of fields inR.<T1,T2,T3>
UpdateResultStep<Record3<T1,T2,T3>>UpdateReturningStep. returningResult(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)Configure theUPDATEstatement to return a list of fields inR.<T1,T2,T3>
SelectSelectStep<Record3<T1,T2,T3>>DSLContext. select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)Create a new DSL select statement.<T1,T2,T3>
SelectSelectStep<Record3<T1,T2,T3>>WithStep. select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)Create a new DSL select statement.<T1,T2,T3>
SelectSelectStep<Record3<T1,T2,T3>>DSLContext. selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)Create a new DSL select statement.<T1,T2,T3>
SelectSelectStep<Record3<T1,T2,T3>>WithStep. selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)Create a new DSL select statement.Methods in org.jooq with parameters of type Record3 Modifier and Type Method Description ConditionBetweenAndStep3. and(Record3<T1,T2,T3> maxValue)Create a condition to check this field against some boundsBetweenAndStep3<T1,T2,T3>Row3. between(Record3<T1,T2,T3> minValue)Check if this row value expression is within a range of two records.ConditionRow3. between(Record3<T1,T2,T3> minValue, Record3<T1,T2,T3> maxValue)Check if this row value expression is within a range of two records.BetweenAndStep3<T1,T2,T3>Row3. betweenSymmetric(Record3<T1,T2,T3> minValue)Check if this row value expression is within a symmetric range of two records.ConditionRow3. betweenSymmetric(Record3<T1,T2,T3> minValue, Record3<T1,T2,T3> maxValue)Check if this row value expression is within a symmetric range of two records.ConditionRow3. compare(Comparator comparator, Record3<T1,T2,T3> record)Compare this row value expression with a record using a dynamic comparator.ConditionRow3. eq(Record3<T1,T2,T3> record)Compare this row value expression with a record for equality.ConditionRow3. equal(Record3<T1,T2,T3> record)Compare this row value expression with a record for equality.ConditionRow3. ge(Record3<T1,T2,T3> record)Compare this row value expression with a record for order.ConditionRow3. greaterOrEqual(Record3<T1,T2,T3> record)Compare this row value expression with a record for order.ConditionRow3. greaterThan(Record3<T1,T2,T3> record)Compare this row value expression with a record for order.ConditionRow3. gt(Record3<T1,T2,T3> record)Compare this row value expression with a record for order.ConditionRow3. in(Record3<T1,T2,T3>... record)Compare this row value expression with a set of records for equality.ConditionRow3. isDistinctFrom(Record3<T1,T2,T3> record)Compare this row value expression with another row value expression for distinctness.ConditionRow3. isNotDistinctFrom(Record3<T1,T2,T3> record)Compare this row value expression with another row value expression for distinctness.ConditionRow3. le(Record3<T1,T2,T3> record)Compare this row value expression with a record for order.ConditionRow3. lessOrEqual(Record3<T1,T2,T3> record)Compare this row value expression with a record for order.ConditionRow3. lessThan(Record3<T1,T2,T3> record)Compare this row value expression with a record for order.ConditionRow3. lt(Record3<T1,T2,T3> record)Compare this row value expression with a record for order.ConditionRow3. ne(Record3<T1,T2,T3> record)Compare this row value expression with a record for non-equality.BetweenAndStep3<T1,T2,T3>Row3. notBetween(Record3<T1,T2,T3> minValue)Check if this row value expression is within a range of two records.ConditionRow3. notBetween(Record3<T1,T2,T3> minValue, Record3<T1,T2,T3> maxValue)Check if this row value expression is within a range of two records.BetweenAndStep3<T1,T2,T3>Row3. notBetweenSymmetric(Record3<T1,T2,T3> minValue)Check if this row value expression is not within a symmetric range of two records.ConditionRow3. notBetweenSymmetric(Record3<T1,T2,T3> minValue, Record3<T1,T2,T3> maxValue)Check if this row value expression is not within a symmetric range of two records.ConditionRow3. notEqual(Record3<T1,T2,T3> record)Compare this row value expression with a record for non-equalityConditionRow3. notIn(Record3<T1,T2,T3>... record)Compare this row value expression with a set of records for non-equality.Method parameters in org.jooq with type arguments of type Record3 Modifier and Type Method Description <T1,T2,T3>
voidUpdateQuery. addValues(Row3<T1,T2,T3> row, Select<? extends Record3<T1,T2,T3>> select)Specify a multi-column set clause for theUPDATEstatement.WithStepWithAsStep3. as(Select<? extends Record3<?,?,?>> select)Associate a subselect with a common table expression's table and column names.ConditionRow3. compare(Comparator comparator, QuantifiedSelect<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect using a dynamic comparator.ConditionRow3. compare(Comparator comparator, Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect using a dynamic comparator.ConditionRow3. eq(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for equality.ConditionRow3. eq(Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for equality.ConditionRow3. equal(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for equality.ConditionRow3. equal(Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for equality.ConditionRow3. ge(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. ge(Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. greaterOrEqual(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. greaterOrEqual(Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. greaterThan(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. greaterThan(Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. gt(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. gt(Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. in(Result<? extends Record3<T1,T2,T3>> result)Compare this row value expression with a set of records for equality.ConditionRow3. in(Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for equality.ConditionRow3. le(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. le(Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. lessOrEqual(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. lessOrEqual(Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. lessThan(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. lessThan(Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. lt(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. lt(Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for order.ConditionRow3. ne(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for non-equality.ConditionRow3. ne(Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for non-equality.ConditionRow3. notEqual(QuantifiedSelect<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for non-equality.ConditionRow3. notEqual(Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for non-equality.ConditionRow3. notIn(Result<? extends Record3<T1,T2,T3>> result)Compare this row value expression with a set of records for equality.ConditionRow3. notIn(Select<? extends Record3<T1,T2,T3>> select)Compare this row value expression with a subselect for non-equality.InsertOnDuplicateStep<R>InsertValuesStep3. select(Select<? extends Record3<T1,T2,T3>> select)Use aSELECTstatement as the source of values for theINSERTstatementMerge<R>MergeValuesStep3. select(Select<? extends Record3<T1,T2,T3>> select)Use aSELECTstatement as the source of values for theMERGEstatement<T1,T2,T3>
UpdateFromStep<R>UpdateSetFirstStep. set(Row3<T1,T2,T3> row, Select<? extends Record3<T1,T2,T3>> select)Specify a multi-column set clause for theUPDATEstatement. -
Uses of Record3 in org.jooq.impl
Methods in org.jooq.impl that return Record3 Modifier and Type Method Description <T1,T2,T3>
Record3<T1,T2,T3>DefaultDSLContext. fetchSingle(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)<T1,T2,T3>
Record3<T1,T2,T3>DefaultDSLContext. newRecord(Field<T1> field1, Field<T2> field2, Field<T3> field3)Methods in org.jooq.impl that return types with arguments of type Record3 Modifier and Type Method Description <T1,T2,T3>
Result<Record3<T1,T2,T3>>DefaultDSLContext. newResult(Field<T1> field1, Field<T2> field2, Field<T3> field3)static <T1,T2,T3>
RecordType<Record3<T1,T2,T3>>DSL. recordType(Field<T1> field1, Field<T2> field2, Field<T3> field3)Create aRecordTypeof degree3.static <T1,T2,T3>
Field<Record3<T1,T2,T3>>DSL. rowField(Row3<T1,T2,T3> row)EXPERIMENTAL: Turn a row value expression of degree3into aField.<T1,T2,T3>
SelectSelectStep<Record3<T1,T2,T3>>DefaultDSLContext. select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)static <T1,T2,T3>
SelectSelectStep<Record3<T1,T2,T3>>DSL. select(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)Create a new DSL subselect statement.<T1,T2,T3>
SelectSelectStep<Record3<T1,T2,T3>>DefaultDSLContext. selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)static <T1,T2,T3>
SelectSelectStep<Record3<T1,T2,T3>>DSL. selectDistinct(SelectField<T1> field1, SelectField<T2> field2, SelectField<T3> field3)Create a new DSL subselect statement.static <T1,T2,T3>
Table<Record3<T1,T2,T3>>DSL. values(Row3<T1,T2,T3>... rows)Create aVALUES()expression of degree3.
-