Uses of Interface
org.jooq.Record9
-
Packages that use Record9 Package Description org.jooq Theorg.jooqpackage contains jOOQ's public API.org.jooq.impl Theorg.jooq.implpackage 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 theDerivedColumnListto 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 theDELETEstatement 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 theINSERTstatement 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 theUPDATEstatement 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 ConditionBetweenAndStep9. 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.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.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.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.ConditionRow9. 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.ConditionRow9. eq(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)Compare this row value expression with a record for equality.ConditionRow9. equal(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)Compare this row value expression with a record for equality.ConditionRow9. ge(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)Compare this row value expression with a record for order.ConditionRow9. greaterOrEqual(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)Compare this row value expression with a record for order.ConditionRow9. greaterThan(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)Compare this row value expression with a record for order.ConditionRow9. gt(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)Compare this row value expression with a record for order.ConditionRow9. in(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>... record)Compare this row value expression with a set of records for equality.ConditionRow9. isDistinctFrom(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)Compare this row value expression with another row value expression for distinctness.ConditionRow9. isNotDistinctFrom(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)Compare this row value expression with another row value expression for distinctness.ConditionRow9. le(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)Compare this row value expression with a record for order.ConditionRow9. lessOrEqual(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)Compare this row value expression with a record for order.ConditionRow9. lessThan(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)Compare this row value expression with a record for order.ConditionRow9. lt(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)Compare this row value expression with a record for order.ConditionRow9. 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.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.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.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.ConditionRow9. notEqual(Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9> record)Compare this row value expression with a record for non-equalityConditionRow9. 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 theUPDATEstatement.WithStepWithAsStep9. as(Select<? extends Record9<?,?,?,?,?,?,?,?,?>> select)Associate a subselect with a common table expression's table and column names.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.ConditionRow9. 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.ConditionRow9. eq(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for equality.ConditionRow9. eq(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for equality.ConditionRow9. equal(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for equality.ConditionRow9. equal(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for equality.ConditionRow9. ge(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. ge(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. greaterOrEqual(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. greaterOrEqual(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. greaterThan(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. greaterThan(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. gt(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. gt(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. 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.ConditionRow9. in(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for equality.ConditionRow9. le(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. le(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. lessOrEqual(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. lessOrEqual(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. lessThan(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. lessThan(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. lt(QuantifiedSelect<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. lt(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Compare this row value expression with a subselect for order.ConditionRow9. 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.ConditionRow9. 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.ConditionRow9. 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.ConditionRow9. 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.ConditionRow9. 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.ConditionRow9. 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 aSELECTstatement as the source of values for theINSERTstatementMerge<R>MergeValuesStep9. select(Select<? extends Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select)Use aSELECTstatement as the source of values for theMERGEstatement<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 theUPDATEstatement. -
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 aRecordTypeof 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 degree9into 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.
-