Uses of Interface
org.jooq.Record9
-
Packages that use Record9 Package Description org.jooq This package contains jOOQ's public API.org.jooq.impl This package contains jOOQ's implementation classes. -
-
Uses of Record9 in org.jooq
Methods in org.jooq with type parameters of type Record9 Modifier and Type Method Description <R extends Record9<?,?,?,?,?,?,?,?,?>>
CommonTableExpression<R>DerivedColumnList9. as(Select<R> select)
Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.Methods in org.jooq that return Record9 Modifier and Type Method Description <T1,T2,T3,T4,T5,T6,T7,T8,T9>
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>
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.<T1,T2,T3,T4,T5,T6,T7,T8,T9>
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
.Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Record9. value1(T1 value)
Set the first value.Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Record9. value2(T2 value)
Set the second value.Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Record9. value3(T3 value)
Set the third value.Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Record9. value4(T4 value)
Set the fourth value.Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Record9. value5(T5 value)
Set the fifth value.Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Record9. value6(T6 value)
Set the sixth value.Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Record9. value7(T7 value)
Set the seventh value.Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Record9. value8(T8 value)
Set the eighth value.Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Record9. value9(T9 value)
Set the ninth value.Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Record9. values(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9)
Set all values.Methods in org.jooq that return types with arguments of type Record9 Modifier and Type Method Description <T1,T2,T3,T4,T5,T6,T7,T8,T9>
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.<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Result<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>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.<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Result<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>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>
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 theDELETE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9>
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 theINSERT
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9>
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 theUPDATE
statement to return a list of fields inR
.<T1,T2,T3,T4,T5,T6,T7,T8,T9>
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>
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>
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>
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.Methods in org.jooq with parameters of type Record9 Modifier and Type Method Description Condition
BetweenAndStep9. and(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> maxValue)
Create a condition to check this field against some boundsBetweenAndStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Row9. between(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> minValue)
Check if this row value expression is within a range of two records.Condition
Row9. 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.BetweenAndStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Row9. betweenSymmetric(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> minValue)
Check if this row value expression is within a symmetric range of two records.Condition
Row9. 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.Condition
Row9. compare(Comparator comparator, Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with a record using a dynamic comparator.Condition
Row9. eq(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with a record for equality.Condition
Row9. equal(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with a record for equality.Condition
Row9. ge(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with a record for order.Condition
Row9. greaterOrEqual(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with a record for order.Condition
Row9. greaterThan(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with a record for order.Condition
Row9. gt(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with a record for order.Condition
Row9. in(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>... record)
Compare this row value expression with a set of records for equality.Condition
Row9. isDistinctFrom(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with another row value expression for distinctness.Condition
Row9. isNotDistinctFrom(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with another row value expression for distinctness.Condition
Row9. le(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with a record for order.Condition
Row9. lessOrEqual(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with a record for order.Condition
Row9. lessThan(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with a record for order.Condition
Row9. lt(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with a record for order.Condition
Row9. ne(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with a record for non-equality.BetweenAndStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Row9. notBetween(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> minValue)
Check if this row value expression is within a range of two records.Condition
Row9. 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.BetweenAndStep9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
Row9. notBetweenSymmetric(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> minValue)
Check if this row value expression is not within a symmetric range of two records.Condition
Row9. 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.Condition
Row9. notEqual(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)
Compare this row value expression with a record for non-equalityCondition
Row9. notIn(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>... record)
Compare this row value expression with a set of records for non-equality.Method parameters in org.jooq with type arguments of type Record9 Modifier and Type Method Description <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 theUPDATE
statement.WithStep
WithAsStep9. as(Select<? extends Record9<?,?,?,?,?,?,?,?,?>> select)
Associate a subselect with a common table expression's table and column names.Condition
Row9. 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.Condition
Row9. compare(Comparator comparator, Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect using a dynamic comparator.Condition
Row9. eq(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for equality.Condition
Row9. eq(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for equality.Condition
Row9. equal(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for equality.Condition
Row9. equal(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for equality.Condition
Row9. ge(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. ge(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. greaterOrEqual(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. greaterOrEqual(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. greaterThan(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. greaterThan(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. gt(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. gt(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. in(Result<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> result)
Compare this row value expression with a set of records for equality.Condition
Row9. in(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for equality.Condition
Row9. le(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. le(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. lessOrEqual(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. lessOrEqual(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. lessThan(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. lessThan(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. lt(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. lt(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for order.Condition
Row9. ne(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for non-equality.Condition
Row9. ne(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for non-equality.Condition
Row9. notEqual(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for non-equality.Condition
Row9. notEqual(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for non-equality.Condition
Row9. notIn(Result<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> result)
Compare this row value expression with a set of records for equality.Condition
Row9. notIn(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Compare this row value expression with a subselect for non-equality.InsertOnDuplicateStep<R>
InsertValuesStep9. select(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Use aSELECT
statement as the source of values for theINSERT
statementMerge<R>
MergeValuesStep9. select(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)
Use aSELECT
statement as the source of values for theMERGE
statement<T1,T2,T3,T4,T5,T6,T7,T8,T9>
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 theUPDATE
statement. -
Uses of Record9 in org.jooq.impl
Methods in org.jooq.impl that return Record9 Modifier and Type Method Description <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 Record9 Modifier and Type Method Description <T1,T2,T3,T4,T5,T6,T7,T8,T9>
Result<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>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>
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 aRecordType
of degree9
.static <T1,T2,T3,T4,T5,T6,T7,T8,T9>
Field<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>DSL. rowField(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> row)
EXPERIMENTAL: Turn a row value expression of degree9
into aField
.<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>
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>
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.static <T1,T2,T3,T4,T5,T6,T7,T8,T9>
Table<Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>DSL. values(Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>... rows)
Create aVALUES()
expression of degree9
.
-