Uses of Interface
org.jooq.Record
-
Packages that use Record Package Description org.jooq Theorg.jooq
package contains jOOQ's public API.org.jooq.impl Theorg.jooq.impl
package contains jOOQ's implementation classes.org.jooq.tools.jdbc Theorg.jooq.tools.jdbc
package contains compatibility classes to bridge between JDBC 4.0 and JDBC 4.1.org.jooq.util.aurorapostgres Theorg.jooq.util.ase
package contains classes related to theSQLDialect.AURORA_POSTGRES
dialect.org.jooq.util.h2 Theorg.jooq.util.ase
package contains classes related to theSQLDialect.H2
dialect.org.jooq.util.hsqldb Theorg.jooq.util.ase
package contains classes related to theSQLDialect.HSQLDB
dialect.org.jooq.util.oracle Theorg.jooq.util.ase
package contains classes related to theSQLDialect.ORACLE
dialect.org.jooq.util.postgres Theorg.jooq.util.ase
package contains classes related to theSQLDialect.POSTGRES
dialect.org.jooq.util.redshift Theorg.jooq.util.ase
package contains classes related to theSQLDialect.REDSHIFT
dialect.org.jooq.util.vertica -
-
Uses of Record in org.jooq
Classes in org.jooq with type parameters of type Record Modifier and Type Interface Description interface
Check<R extends Record>
A check constraint.interface
CommonTableExpression<R extends Record>
A common table expression.interface
CreateTableAsStep<R extends Record>
AQuery
that can create tables.interface
CreateViewAsStep<R extends Record>
AQuery
that can create views.interface
Cursor<R extends Record>
Cursors allow for lazy, sequential access to an underlying JDBCResultSet
.interface
Delete<R extends Record>
ADELETE
statement.interface
DeleteConditionStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteFinalStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteLimitStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteOrderByStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteQuery<R extends Record>
ADELETE
statement (model API).interface
DeleteResultStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteReturningStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteUsingStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteWhereStep<R extends Record>
This type is used for theDelete
's DSL API.interface
ForeignKey<R extends Record,O extends Record>
AForeignKey
is an object referencing aUniqueKey
.interface
ForeignKey<R extends Record,O extends Record>
AForeignKey
is an object referencing aUniqueKey
.interface
FutureResult<R extends Record>
Deprecated.- 3.2.0 - [#2581] - This type will be removed in jOOQ 4.0interface
Identity<R extends Record,T>
AnIdentity
is an object representing anIDENTITY
column as understood by the SQL:2003 standard.interface
Insert<R extends Record>
AnINSERT
statement.interface
InsertFinalStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnConflictConditionStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnConflictDoUpdateStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnConflictWhereStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnDuplicateSetMoreStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnDuplicateSetStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnDuplicateStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertQuery<R extends Record>
AnINSERT
statement (model API).interface
InsertResultStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertReturningStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertSetMoreStep<R extends Record>
This type is used for theInsert
's alternative DSL API.interface
InsertSetStep<R extends Record>
This type is used for theInsert
's alternative DSL API.interface
InsertValuesStep1<R extends Record,T1>
This type is used for theInsert
's DSL API.interface
InsertValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
This type is used for theInsert
's DSL API.interface
InsertValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
This type is used for theInsert
's DSL API.interface
InsertValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
This type is used for theInsert
's DSL API.interface
InsertValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
This type is used for theInsert
's DSL API.interface
InsertValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
This type is used for theInsert
's DSL API.interface
InsertValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
This type is used for theInsert
's DSL API.interface
InsertValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
This type is used for theInsert
's DSL API.interface
InsertValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
This type is used for theInsert
's DSL API.interface
InsertValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
This type is used for theInsert
's DSL API.interface
InsertValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
This type is used for theInsert
's DSL API.interface
InsertValuesStep2<R extends Record,T1,T2>
This type is used for theInsert
's DSL API.interface
InsertValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
This type is used for theInsert
's DSL API.interface
InsertValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
This type is used for theInsert
's DSL API.interface
InsertValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
This type is used for theInsert
's DSL API.interface
InsertValuesStep3<R extends Record,T1,T2,T3>
This type is used for theInsert
's DSL API.interface
InsertValuesStep4<R extends Record,T1,T2,T3,T4>
This type is used for theInsert
's DSL API.interface
InsertValuesStep5<R extends Record,T1,T2,T3,T4,T5>
This type is used for theInsert
's DSL API.interface
InsertValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>
This type is used for theInsert
's DSL API.interface
InsertValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
This type is used for theInsert
's DSL API.interface
InsertValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
This type is used for theInsert
's DSL API.interface
InsertValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
This type is used for theInsert
's DSL API.interface
InsertValuesStepN<R extends Record>
This type is used for theInsert
's DSL API.interface
Key<R extends Record>
AKey
is an object representing aUNIQUE KEY
, aPRIMARY KEY
, or aFOREIGN KEY
.interface
Loader<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderCSVOptionsStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderCSVStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderJSONOptionsStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderJSONStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderListenerStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderLoadStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderOptionsStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderRowsStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderSourceStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
LoaderXMLStep<R extends Record>
TheLoader
API is used for configuring data loads.interface
Merge<R extends Record>
AMERGE
statement.interface
MergeFinalStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeKeyStep1<R extends Record,T1>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep2<R extends Record,T1,T2>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep3<R extends Record,T1,T2,T3>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep4<R extends Record,T1,T2,T3,T4>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep5<R extends Record,T1,T2,T3,T4,T5>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep6<R extends Record,T1,T2,T3,T4,T5,T6>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeKeyStepN<R extends Record>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeMatchedDeleteStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedSetMoreStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedSetStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedWhereStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedSetMoreStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedSetStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep1<R extends Record,T1>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep2<R extends Record,T1,T2>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep3<R extends Record,T1,T2,T3>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep4<R extends Record,T1,T2,T3,T4>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep5<R extends Record,T1,T2,T3,T4,T5>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedValuesStepN<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedWhereStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeOnConditionStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeOnStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeUsingStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeValuesStep1<R extends Record,T1>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep2<R extends Record,T1,T2>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep3<R extends Record,T1,T2,T3>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep4<R extends Record,T1,T2,T3,T4>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep5<R extends Record,T1,T2,T3,T4,T5>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
MergeValuesStepN<R extends Record>
This type is used for the H2-specific variant of theMerge
's DSL API.interface
QuantifiedSelect<R extends Record>
A quantified select for use in quantified comparison predicates.interface
RecordHandler<R extends Record>
ARecordHandler
is a handler that can receiveRecord
objects, when fetching data from the database.interface
RecordMapper<R extends Record,E>
ARecordMapper
is a mapper that can receiveRecord
objects, when fetching data from the database, transforming them into a custom type<E>
.interface
RecordType<R extends Record>
interface
RecordUnmapper<E,R extends Record>
ARecordUnmapper
is a mapper that can receive user objects and convert them back toRecord
.interface
Result<R extends Record>
A wrapper for database results returned bySelectQuery
interface
ResultQuery<R extends Record>
A query that can return results.interface
Select<R extends Record>
ASELECT
statement.interface
SelectConditionStep<R extends Record>
interface
SelectConnectByAfterStartWithConditionStep<R extends Record>
interface
SelectConnectByAfterStartWithStep<R extends Record>
interface
SelectConnectByConditionStep<R extends Record>
interface
SelectConnectByStep<R extends Record>
interface
SelectDistinctOnStep<R extends Record>
interface
SelectFinalStep<R extends Record>
interface
SelectForUpdateOfStep<R extends Record>
interface
SelectForUpdateStep<R extends Record>
interface
SelectForUpdateWaitStep<R extends Record>
interface
SelectFromStep<R extends Record>
interface
SelectGroupByStep<R extends Record>
interface
SelectHavingConditionStep<R extends Record>
interface
SelectHavingStep<R extends Record>
interface
SelectIntoStep<R extends Record>
interface
SelectJoinPartitionByStep<R extends Record>
interface
SelectJoinStep<R extends Record>
interface
SelectLimitAfterOffsetStep<R extends Record>
interface
SelectLimitPercentAfterOffsetStep<R extends Record>
interface
SelectLimitPercentStep<R extends Record>
interface
SelectLimitStep<R extends Record>
interface
SelectOffsetStep<R extends Record>
interface
SelectOnConditionStep<R extends Record>
interface
SelectOnStep<R extends Record>
interface
SelectOptionalOnStep<R extends Record>
interface
SelectOptionStep<R extends Record>
interface
SelectOrderByStep<R extends Record>
interface
SelectQualifyConditionStep<R extends Record>
interface
SelectQualifyStep<R extends Record>
interface
SelectQuery<R extends Record>
ASELECT
statement (model API).interface
SelectSeekLimitStep<R extends Record>
interface
SelectSeekStep1<R extends Record,T1>
interface
SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
interface
SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
interface
SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
interface
SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
interface
SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
interface
SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
interface
SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
interface
SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
interface
SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
interface
SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
interface
SelectSeekStep2<R extends Record,T1,T2>
interface
SelectSeekStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
interface
SelectSeekStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
interface
SelectSeekStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
interface
SelectSeekStep3<R extends Record,T1,T2,T3>
interface
SelectSeekStep4<R extends Record,T1,T2,T3,T4>
interface
SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5>
interface
SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6>
interface
SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
interface
SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
interface
SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
interface
SelectSeekStepN<R extends Record>
interface
SelectSelectStep<R extends Record>
interface
SelectStartWithStep<R extends Record>
interface
SelectUnionStep<R extends Record>
interface
SelectWhereStep<R extends Record>
interface
SelectWindowStep<R extends Record>
interface
SelectWithTiesAfterOffsetStep<R extends Record>
interface
SelectWithTiesStep<R extends Record>
interface
StoreQuery<R extends Record>
A query storing objects to the database.interface
Table<R extends Record>
A table.interface
TableField<R extends Record,T>
A field contained in a table.interface
TableLike<R extends Record>
An object that can behave like a table (a table-like object).interface
TableOnConditionStep<R extends Record>
An intermediate (optional) type for the construction of aJOIN
clause, where the join criteria is added using anON
clause (with aCondition
.interface
TableOnStep<R extends Record>
interface
TableOptionalOnStep<R extends Record>
interface
TableOuterJoinStep<R extends Record>
An intermediate type for the construction of a partitionedSQLDialect.ORACLE
OUTER JOIN
clause.interface
TablePartitionByStep<R extends Record>
An intermediate type for the construction of a partitionedSQLDialect.ORACLE
OUTER JOIN
clause.interface
Truncate<R extends Record>
ATRUNCATE
statement.interface
TruncateCascadeStep<R extends Record>
AQuery
that can truncate a table in the database.interface
TruncateFinalStep<R extends Record>
AQuery
that can truncate a table in the database.interface
TruncateIdentityStep<R extends Record>
AQuery
that can truncate a table in the database.interface
UniqueKey<R extends Record>
AUniqueKey
is an object representing aUNIQUE KEY
or aPRIMARY KEY
.interface
Update<R extends Record>
AnUPDATE
statement.interface
UpdateConditionStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateFinalStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateFromStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateLimitStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateOrderByStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateQuery<R extends Record>
AnUPDATE
statement (model API).interface
UpdateResultStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateReturningStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateSetFirstStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateSetMoreStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateSetStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateWhereStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
VersionsBetweenAndStep<R extends Record,T>
This type is used for the OracleVERSIONS
clause DSL API, providing access to the flashback versions query clauses.Subinterfaces of Record in org.jooq Modifier and Type Interface Description interface
EmbeddableRecord<R extends EmbeddableRecord<R>>
A record originating from a single tableinterface
Record1<T1>
A model type for a records with degree1
interface
Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
A model type for a records with degree10
interface
Record11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
A model type for a records with degree11
interface
Record12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
A model type for a records with degree12
interface
Record13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
A model type for a records with degree13
interface
Record14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
A model type for a records with degree14
interface
Record15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
A model type for a records with degree15
interface
Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
A model type for a records with degree16
interface
Record17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
A model type for a records with degree17
interface
Record18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
A model type for a records with degree18
interface
Record19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
A model type for a records with degree19
interface
Record2<T1,T2>
A model type for a records with degree2
interface
Record20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
A model type for a records with degree20
interface
Record21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
A model type for a records with degree21
interface
Record22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
A model type for a records with degree22
interface
Record3<T1,T2,T3>
A model type for a records with degree3
interface
Record4<T1,T2,T3,T4>
A model type for a records with degree4
interface
Record5<T1,T2,T3,T4,T5>
A model type for a records with degree5
interface
Record6<T1,T2,T3,T4,T5,T6>
A model type for a records with degree6
interface
Record7<T1,T2,T3,T4,T5,T6,T7>
A model type for a records with degree7
interface
Record8<T1,T2,T3,T4,T5,T6,T7,T8>
A model type for a records with degree8
interface
Record9<T1,T2,T3,T4,T5,T6,T7,T8,T9>
A model type for a records with degree9
interface
TableRecord<R extends TableRecord<R>>
A record originating from a single tableinterface
UDTRecord<R extends UDTRecord<R>>
An object holding data of a UDTinterface
UpdatableRecord<R extends UpdatableRecord<R>>
A common interface for records that can be stored back to the database again.Methods in org.jooq with type parameters of type Record Modifier and Type Method Description <R extends Record>
CommonTableExpression<R>DerivedColumnList. as(Select<R> select)
Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record>
CommonTableExpression<R>Name. as(Select<R> select)
Specify a subselect to refer to by theName
to form a common table expression.<X extends Record>
ResultQuery<X>ResultQuery. coerce(Table<X> table)
Coerce the result record type of this query to that of a table.<R extends Record>
DeleteUsingStep<R>DSLContext. delete(Table<R> table)
Create a new DSL delete statement.<R extends Record>
DeleteUsingStep<R>WithStep. delete(Table<R> table)
Create a new DSL delete statement.<R extends Record>
DeleteUsingStep<R>DSLContext. deleteFrom(Table<R> table)
Create a new DSL delete statement.<R extends Record>
DeleteQuery<R>DSLContext. deleteQuery(Table<R> table)
Create a newDeleteQuery
<R extends Record>
Result<R>DSLContext. fetch(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return results.<R extends Record>
Result<R>DSLContext. fetch(Table<R> table)
Execute and return all records for<R extends Record>
Result<R>DSLContext. fetch(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records for<R extends Record>
Result<R>DSLContext. fetch(Table<R> table, Condition condition)
Execute and return all records for<R extends Record>
Result<R>DSLContext. fetch(Table<R> table, Condition... conditions)
Execute and return all records for<R extends Record>
RDSLContext. fetchAny(Table<R> table)
Execute and return zero or one record for<R extends Record>
RDSLContext. fetchAny(Table<R> table, Collection<? extends Condition> conditions)
Execute and return zero or one record for<R extends Record>
RDSLContext. fetchAny(Table<R> table, Condition condition)
Execute and return zero or one record for<R extends Record>
RDSLContext. fetchAny(Table<R> table, Condition... conditions)
Execute and return zero or one record for<Z extends Record>
ZResultQuery. fetchAnyInto(Table<Z> table)
Map resulting records onto a custom record.<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, ResultQuery<R> query)
Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table, Condition condition)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table, Condition... conditions)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(ResultQuery<R> query)
Fetch results in a newCompletionStage
.<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table, Collection<? extends Condition> condition)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table, Condition condition)
Execute and return all records asynchronously for<R extends Record>
CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table, Condition... condition)
Execute and return all records asynchronously for<S extends Record>
Map<S,Result<R>>ResultQuery. fetchGroups(Table<S> table)
Execute the query and return aMap
with the result grouped by the given table.<E,S extends Record>
Map<S,List<E>>ResultQuery. fetchGroups(Table<S> table, Class<? extends E> type)
Execute the query and return aMap
with results grouped by the given table and mapped into the given entity type.<E,S extends Record>
Map<S,List<E>>ResultQuery. fetchGroups(Table<S> table, RecordMapper<? super R,E> mapper)
Execute the query and return aMap
with results grouped by the given table and mapped by the given mapper.<S extends Record,T extends Record>
Map<S,Result<T>>ResultQuery. fetchGroups(Table<S> keyTable, Table<T> valueTable)
Execute the query and return aMap
with the result grouped by the given table.<S extends Record,T extends Record>
Map<S,Result<T>>ResultQuery. fetchGroups(Table<S> keyTable, Table<T> valueTable)
Execute the query and return aMap
with the result grouped by the given table.<Z extends Record>
Result<Z>Cursor. fetchInto(Table<Z> table)
Map resulting records onto a custom record.<Z extends Record>
Result<Z>ResultQuery. fetchInto(Table<Z> table)
Map resulting records onto a custom record.<R extends Record>
Cursor<R>DSLContext. fetchLazy(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a cursor.<R extends Record>
Cursor<R>DSLContext. fetchLazy(Table<R> table)
Execute and return all records lazily for<R extends Record>
Cursor<R>DSLContext. fetchLazy(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records lazily for<R extends Record>
Cursor<R>DSLContext. fetchLazy(Table<R> table, Condition condition)
Execute and return all records lazily for<R extends Record>
Cursor<R>DSLContext. fetchLazy(Table<R> table, Condition... conditions)
Execute and return all records lazily for<R extends Record>
ResultsDSLContext. fetchMany(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a cursor.<S extends Record>
Map<S,R>ResultQuery. fetchMap(Table<S> table)
Execute the query and return aMap
with table as a map key and the corresponding record as value.<E,S extends Record>
Map<S,E>ResultQuery. fetchMap(Table<S> table, Class<? extends E> type)
Execute the query and return aMap
with results grouped by the given table and mapped into the given entity type.<E,S extends Record>
Map<S,E>ResultQuery. fetchMap(Table<S> table, RecordMapper<? super R,E> mapper)
Execute the query and return aMap
with results grouped by the given table and mapped by the given mapper.<S extends Record,T extends Record>
Map<S,T>ResultQuery. fetchMap(Table<S> keyTable, Table<T> valueTable)
Execute the query and return aMap
with table as a map key and the corresponding record as value.<S extends Record,T extends Record>
Map<S,T>ResultQuery. fetchMap(Table<S> keyTable, Table<T> valueTable)
Execute the query and return aMap
with table as a map key and the corresponding record as value.<Z extends Record>
ZCursor. fetchNextInto(Table<Z> table)
Map the next resulting record onto a custom record.<Z extends Record>
Optional<Z>Cursor. fetchNextOptionalInto(Table<Z> table)
Map the next resulting record onto a custom record.<R extends Record>
RDSLContext. fetchOne(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a record.<R extends Record>
RDSLContext. fetchOne(Table<R> table)
Execute and return zero or one record for<R extends Record>
RDSLContext. fetchOne(Table<R> table, Collection<? extends Condition> conditions)
Execute and return zero or one record for<R extends Record>
RDSLContext. fetchOne(Table<R> table, Condition condition)
Execute and return zero or one record for<R extends Record>
RDSLContext. fetchOne(Table<R> table, Condition... conditions)
Execute and return zero or one record for<Z extends Record>
ZCursor. fetchOneInto(Table<Z> table)
Deprecated.- 3.10 - [#6363] - UseCursor.fetchNextInto(Table)
instead.<Z extends Record>
ZResultQuery. fetchOneInto(Table<Z> table)
Map resulting records onto a custom record.<R extends Record>
Optional<R>DSLContext. fetchOptional(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a record.<R extends Record>
Optional<R>DSLContext. fetchOptional(Table<R> table)
Execute and return zero or one record for<R extends Record>
Optional<R>DSLContext. fetchOptional(Table<R> table, Collection<? extends Condition> conditions)
Execute and return zero or one record for<R extends Record>
Optional<R>DSLContext. fetchOptional(Table<R> table, Condition condition)
Execute and return zero or one record for<R extends Record>
Optional<R>DSLContext. fetchOptional(Table<R> table, Condition... conditions)
Execute and return zero or one record for<Z extends Record>
Optional<Z>Cursor. fetchOptionalInto(Table<Z> table)
Deprecated.- 3.10 - [#6363] - UseCursor.fetchNextOptionalInto(Table)
instead.<Z extends Record>
Optional<Z>ResultQuery. fetchOptionalInto(Table<Z> table)
Map resulting records onto a custom record.<R extends Record>
RDSLContext. fetchSingle(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a record.<R extends Record>
RDSLContext. fetchSingle(Table<R> table)
Execute and return exactly one record for<R extends Record>
RDSLContext. fetchSingle(Table<R> table, Collection<? extends Condition> conditions)
Execute and return exactly one record for<R extends Record>
RDSLContext. fetchSingle(Table<R> table, Condition condition)
Execute and return exactly one record for<R extends Record>
RDSLContext. fetchSingle(Table<R> table, Condition... conditions)
Execute and return exactly one record for<Z extends Record>
ZResultQuery. fetchSingleInto(Table<Z> table)
Map resulting records onto a custom record.<R extends Record>
Stream<R>DSLContext. fetchStream(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a stream.<R extends Record>
Stream<R>DSLContext. fetchStream(Table<R> table)
Execute and return all records lazily for<R extends Record>
Stream<R>DSLContext. fetchStream(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records lazily for<R extends Record>
Stream<R>DSLContext. fetchStream(Table<R> table, Condition condition)
Execute and return all records lazily for<R extends Record>
Stream<R>DSLContext. fetchStream(Table<R> table, Condition... conditions)
Execute and return all records lazily for<Z extends Record>
Stream<Z>ResultQuery. fetchStreamInto(Table<Z> table)
Stream this query, mapping records into a custom record.<O extends Record>
List<ForeignKey<O,R>>Table. getReferencesFrom(Table<O> other)
Get a list ofFOREIGN KEY
's of a specific table, referencing a this table.<O extends Record>
List<ForeignKey<R,O>>Table. getReferencesTo(Table<O> other)
Get a list ofFOREIGN KEY
's of this table, referencing a specific table.<R extends Record>
InsertSetStep<R>DSLContext. insertInto(Table<R> into)
Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R>DSLContext. insertInto(Table<R> into, Collection<? extends Field<?>> fields)
Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R>DSLContext. insertInto(Table<R> into, Field<?>... fields)
Create a new DSL insert statement.<R extends Record,T1>
InsertValuesStep1<R,T1>DSLContext. insertInto(Table<R> into, Field<T1> field1)
Create a new DSL insert statement.<R extends Record,T1,T2>
InsertValuesStep2<R,T1,T2>DSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)
Create a new DSL insert statement.<R extends Record,T1,T2,T3>
InsertValuesStep3<R,T1,T2,T3>DSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4>
InsertValuesStep4<R,T1,T2,T3,T4>DSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5>
InsertValuesStep5<R,T1,T2,T3,T4,T5>DSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6>
InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>DSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7>
InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>DSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>DSLContext. insertInto(Table<R> 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>DSLContext. insertInto(Table<R> 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>DSLContext. insertInto(Table<R> 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, Field<T10> field10)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>DSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>DSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>DSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>DSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>DSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>DSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>DSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>DSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>DSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>DSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>DSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>DSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)
Create a new DSL insert statement.<R extends Record>
InsertSetStep<R>WithStep. insertInto(Table<R> into)
Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R>WithStep. insertInto(Table<R> into, Collection<? extends Field<?>> fields)
Create a new DSL insert statement.<R extends Record>
InsertValuesStepN<R>WithStep. insertInto(Table<R> into, Field<?>... fields)
Create a new DSL insert statement.<R extends Record,T1>
InsertValuesStep1<R,T1>WithStep. insertInto(Table<R> into, Field<T1> field1)
Create a new DSL insert statement.<R extends Record,T1,T2>
InsertValuesStep2<R,T1,T2>WithStep. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)
Create a new DSL insert statement.<R extends Record,T1,T2,T3>
InsertValuesStep3<R,T1,T2,T3>WithStep. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4>
InsertValuesStep4<R,T1,T2,T3,T4>WithStep. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5>
InsertValuesStep5<R,T1,T2,T3,T4,T5>WithStep. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6>
InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>WithStep. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7>
InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>WithStep. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>WithStep. insertInto(Table<R> 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>WithStep. insertInto(Table<R> 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)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>WithStep. insertInto(Table<R> 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, Field<T10> field10)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>WithStep. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>WithStep. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>WithStep. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>WithStep. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>WithStep. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>WithStep. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>WithStep. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>WithStep. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>WithStep. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>WithStep. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>WithStep. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)
Create a new DSL insert statement.<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>WithStep. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)
Create a new DSL insert statement.<R extends Record>
InsertQuery<R>DSLContext. insertQuery(Table<R> into)
Create a newInsertQuery
<R extends Record>
RRecord. into(Table<R> table)
Map resulting records onto a custom record type.<Z extends Record>
Result<Z>Result. into(Table<Z> table)
Map resulting records onto a custom record.<S extends Record>
Map<S,Result<R>>Result. intoGroups(Table<S> table)
Return aMap
with the result grouped by the given key table.<E,S extends Record>
Map<S,List<E>>Result. intoGroups(Table<S> table, Class<? extends E> type)
Return aMap
with results grouped by the given key table and mapped into the given entity type.<E,S extends Record>
Map<S,List<E>>Result. intoGroups(Table<S> table, RecordMapper<? super R,E> mapper)
Return aMap
with results grouped by the given key table and mapped into the given entity type.<S extends Record,T extends Record>
Map<S,Result<T>>Result. intoGroups(Table<S> keyTable, Table<T> valueTable)
Return aMap
with the result grouped by the given key table.<S extends Record,T extends Record>
Map<S,Result<T>>Result. intoGroups(Table<S> keyTable, Table<T> valueTable)
Return aMap
with the result grouped by the given key table.<S extends Record>
Map<S,R>Result. intoMap(Table<S> table)
Return aMap
with the given key table as a map key and the corresponding record as value.<E,S extends Record>
Map<S,E>Result. intoMap(Table<S> table, Class<? extends E> type)
Return aMap
with results grouped by the given key table and mapped into the given entity type.<E,S extends Record>
Map<S,E>Result. intoMap(Table<S> table, RecordMapper<? super R,E> mapper)
Return aMap
with results grouped by the given key table and mapped by the given mapper.<S extends Record,T extends Record>
Map<S,T>Result. intoMap(Table<S> keyTable, Table<T> valueTable)
Return aMap
with the given key table as a map key and the corresponding record as value.<S extends Record,T extends Record>
Map<S,T>Result. intoMap(Table<S> keyTable, Table<T> valueTable)
Return aMap
with the given key table as a map key and the corresponding record as value.<R extends Record>
LoaderOptionsStep<R>DSLContext. loadInto(Table<R> table)
Create a newLoader
object to load data from a CSV or XML source.<R extends Record>
Table<R>DSLContext. map(Table<R> table)
Map a table to another one.<R extends Record>
Table<R>SchemaMapping. map(Table<R> table)
Deprecated.Apply mapping to a given table<R extends Record>
MergeUsingStep<R>DSLContext. mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.<R extends Record>
MergeKeyStepN<R>DSLContext. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax).<R extends Record>
MergeKeyStepN<R>DSLContext. mergeInto(Table<R> table, Field<?>... fields)
<R extends Record,T1>
MergeKeyStep1<R,T1>DSLContext. mergeInto(Table<R> table, Field<T1> field1)
<R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)
<R extends Record,T1,T2,T3>
MergeKeyStep3<R,T1,T2,T3>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
<R extends Record,T1,T2,T3,T4>
MergeKeyStep4<R,T1,T2,T3,T4>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
<R extends Record,T1,T2,T3,T4,T5>
MergeKeyStep5<R,T1,T2,T3,T4,T5>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
<R extends Record,T1,T2,T3,T4,T5,T6>
MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
<R extends Record,T1,T2,T3,T4,T5,T6,T7>
MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>DSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>DSLContext. mergeInto(Table<R> table, 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, Field<T10> field10)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>DSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>DSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>DSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>DSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>DSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>DSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>DSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>DSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>DSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>DSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>DSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>DSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)
<R extends Record>
MergeUsingStep<R>WithStep. mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.<R extends Record>
MergeKeyStepN<R>WithStep. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax).<R extends Record>
MergeKeyStepN<R>WithStep. mergeInto(Table<R> table, Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1>
MergeKeyStep1<R,T1>WithStep. mergeInto(Table<R> table, Field<T1> field1)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3>
MergeKeyStep3<R,T1,T2,T3>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4>
MergeKeyStep4<R,T1,T2,T3,T4>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5>
MergeKeyStep5<R,T1,T2,T3,T4,T5>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6>
MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7>
MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>WithStep. mergeInto(Table<R> table, 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 DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>WithStep. mergeInto(Table<R> table, 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, Field<T10> field10)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>WithStep. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>WithStep. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>WithStep. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>WithStep. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>WithStep. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>WithStep. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>WithStep. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>WithStep. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>WithStep. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>WithStep. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>WithStep. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>WithStep. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)
Create a new DSL merge statement (H2-specific syntax).<R extends Record>
RDSLContext. newRecord(Table<R> table)
Create a newRecord
that can be inserted into the corresponding table.<R extends Record>
RDSLContext. newRecord(Table<R> table, Object source)
Create a new pre-filledRecord
that can be inserted into the corresponding table.<R extends Record>
Result<R>DSLContext. newResult(Table<R> table)
Create a new emptyResult
.<R extends Record,E>
RecordMapper<R,E>RecordMapperProvider. provide(RecordType<R> recordType, Class<? extends E> type)
Provide aRecordMapper
instance.<E,R extends Record>
RecordUnmapper<E,R>RecordUnmapperProvider. provide(Class<? extends E> type, RecordType<R> recordType)
Provide aRecordUnmapper
instance.<R extends Record>
SelectWhereStep<R>DSLContext. selectFrom(Table<R> table)
Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
SelectWhereStep<R>WithStep. selectFrom(Table<R> table)
Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
SelectQuery<R>DSLContext. selectQuery(TableLike<R> table)
Create a newSelectQuery
<R extends Record>
TruncateIdentityStep<R>DSLContext. truncate(Table<R> table)
Create a new DSL truncate statement.<R extends Record>
TruncateIdentityStep<R>DSLContext. truncateTable(Table<R> table)
Create a new DSL truncate statement.<R extends Record>
UpdateSetFirstStep<R>DSLContext. update(Table<R> table)
Create a new DSL update statement.<R extends Record>
UpdateSetFirstStep<R>WithStep. update(Table<R> table)
Create a new DSL update statement.<R extends Record>
UpdateQuery<R>DSLContext. updateQuery(Table<R> table)
Create a newUpdateQuery
Methods in org.jooq that return Record Modifier and Type Method Description Record[]
RecordContext. batchRecords()
TheRecord
(s) that are being manipulated in batch mode.R[]
ResultQuery. fetchArray()
Execute the query and return the generated result as an array of records.Record
DSLContext. fetchOne(String sql)
Execute a new query holding plain SQL.Record
DSLContext. fetchOne(String sql, Object... bindings)
Execute a new query holding plain SQL.Record
DSLContext. fetchOne(String sql, QueryPart... parts)
Execute a new query holding plain SQL.Record
DSLContext. fetchOne(ResultSet rs)
Record
DSLContext. fetchOne(ResultSet rs, Class<?>... types)
Record
DSLContext. fetchOne(ResultSet rs, DataType<?>... types)
Record
DSLContext. fetchOne(ResultSet rs, Field<?>... fields)
Record
DSLContext. fetchOne(SQL sql)
Execute a new query holding plain SQL.Record
DSLContext. fetchSingle(String sql)
Execute a new query holding plain SQL.Record
DSLContext. fetchSingle(String sql, Object... bindings)
Execute a new query holding plain SQL.Record
DSLContext. fetchSingle(String sql, QueryPart... parts)
Execute a new query holding plain SQL.Record
DSLContext. fetchSingle(ResultSet rs)
Record
DSLContext. fetchSingle(ResultSet rs, Class<?>... types)
Record
DSLContext. fetchSingle(ResultSet rs, DataType<?>... types)
Record
DSLContext. fetchSingle(ResultSet rs, Field<?>... fields)
Record
DSLContext. fetchSingle(Collection<? extends SelectField<?>> fields)
Execute and return exactly one record forRecord
DSLContext. fetchSingle(SelectField<?>... fields)
Execute and return exactly one record forRecord
DSLContext. fetchSingle(SQL sql)
Execute a new query holding plain SQL.Record
Record. into(Field<?>... fields)
Copy this record into a new record holding only a subset of the previous fields.Record
UpdatableRecord. key()
A Record copy holding values for theTable.getPrimaryKey()
.Record
DSLContext. newRecord(Collection<? extends Field<?>> fields)
Create a new emptyRecord
.Record
DSLContext. newRecord(Field<?>... fields)
Create a new emptyRecord
.Record
Record. original()
Get this record containing the original values as fetched from the database.Record
ExecuteContext. record()
The last record that was fetched from the result set, ornull
if no record has been fetched.Record
RecordContext. record()
TheRecord
that is being manipulated.<T> Record
Record. with(Field<T> field, T value)
Set a value into this record.<T,U>
RecordRecord. 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 Record Modifier and Type Method Description ResultQuery<Record>
ResultQuery. coerce(Collection<? extends Field<?>> fields)
Coerce the result record type of this query to that of a set of fields.ResultQuery<Record>
ResultQuery. coerce(Field<?>... fields)
Coerce the result record type of this query to that of a set of fields.CreateViewAsStep<Record>
DSLContext. createOrReplaceView(String view, String... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createOrReplaceView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createOrReplaceView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Name view, Name... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Table<?> view, Field<?>... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createView(String view, String... fields)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createView(Name view, Name... fields)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createView(Table<?> view, Field<?>... fields)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(String view, String... fields)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Name view, Name... fields)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Create a new DSLCREATE VIEW
statement.CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Table<?> view, Field<?>... fields)
Create a new DSLCREATE VIEW
statement.Table<Record>
Table. crossApply(String sql)
CROSS APPLY
a table to this table.Table<Record>
Table. crossApply(String sql, Object... bindings)
CROSS APPLY
a table to this table.Table<Record>
Table. crossApply(String sql, QueryPart... parts)
CROSS APPLY
a table to this table.Table<Record>
Table. crossApply(Name name)
CROSS APPLY
a table to this table.Table<Record>
Table. crossApply(SQL sql)
CROSS APPLY
a table to this table.Table<Record>
Table. crossApply(TableLike<?> table)
CROSS APPLY
a table to this table.Table<Record>
Table. crossJoin(String sql)
CROSS JOIN
a table to this table.Table<Record>
Table. crossJoin(String sql, Object... bindings)
CROSS JOIN
a table to this table.Table<Record>
Table. crossJoin(String sql, QueryPart... parts)
CROSS JOIN
a table to this table.Table<Record>
Table. crossJoin(Name name)
CROSS JOIN
a table to this table.Table<Record>
Table. crossJoin(SQL sql)
CROSS JOIN
a table to this table.Table<Record>
Table. crossJoin(TableLike<?> table)
CROSS JOIN
a table to this table.Result<Record>
DSLContext. fetch(String sql)
Execute a new query holding plain SQL.Result<Record>
DSLContext. fetch(String sql, Object... bindings)
Execute a new query holding plain SQL.Result<Record>
DSLContext. fetch(String sql, QueryPart... parts)
Execute a new query holding plain SQL.Result<Record>
DSLContext. fetch(ResultSet rs)
Result<Record>
DSLContext. fetch(ResultSet rs, Class<?>... types)
Result<Record>
DSLContext. fetch(ResultSet rs, DataType<?>... types)
Result<Record>
DSLContext. fetch(ResultSet rs, Field<?>... fields)
Result<Record>
DSLContext. fetch(SQL sql)
Execute a new query holding plain SQL.CompletionStage<Result<Record>>
DSLContext. fetchAsync(String sql)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
DSLContext. fetchAsync(String sql, Object... bindings)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
DSLContext. fetchAsync(String sql, QueryPart... parts)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
DSLContext. fetchAsync(ResultSet rs)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
DSLContext. fetchAsync(ResultSet rs, Class<?>... types)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
DSLContext. fetchAsync(ResultSet rs, DataType<?>... types)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
DSLContext. fetchAsync(ResultSet rs, Field<?>... fields)
Fetch results in a newCompletionStage
.CompletionStage<Result<Record>>
DSLContext. fetchAsync(Executor executor, String sql)
Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.CompletionStage<Result<Record>>
DSLContext. fetchAsync(Executor executor, String sql, Object... bindings)
Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.CompletionStage<Result<Record>>
DSLContext. fetchAsync(Executor executor, String sql, QueryPart... parts)
Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.CompletionStage<Result<Record>>
DSLContext. fetchAsync(Executor executor, ResultSet rs)
Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.CompletionStage<Result<Record>>
DSLContext. fetchAsync(Executor executor, ResultSet rs, Class<?>... types)
Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.CompletionStage<Result<Record>>
DSLContext. fetchAsync(Executor executor, ResultSet rs, DataType<?>... types)
Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.CompletionStage<Result<Record>>
DSLContext. fetchAsync(Executor executor, ResultSet rs, Field<?>... fields)
Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.CompletionStage<Result<Record>>
DSLContext. fetchAsync(Executor executor, SQL sql)
Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.CompletionStage<Result<Record>>
DSLContext. fetchAsync(SQL sql)
Fetch results in a newCompletionStage
.Result<Record>
DSLContext. fetchFromCSV(String string)
Fetch all data from a CSV string.Result<Record>
DSLContext. fetchFromCSV(String string, boolean header)
Fetch all data from a CSV string.Result<Record>
DSLContext. fetchFromCSV(String string, boolean header, char delimiter)
Fetch all data from a CSV string.Result<Record>
DSLContext. fetchFromCSV(String string, char delimiter)
Fetch all data from a CSV string.Result<Record>
DSLContext. fetchFromHTML(String string)
Convert an HTML table into a jOOQResult
.Result<Record>
DSLContext. fetchFromJSON(String string)
Fetch all data from a JSON string.Result<Record>
DSLContext. fetchFromStringData(String[]... data)
Fetch all data from a list of strings.Result<Record>
DSLContext. fetchFromStringData(List<String[]> data)
Fetch all data from a list of strings.Result<Record>
DSLContext. fetchFromStringData(List<String[]> data, boolean header)
Fetch all data from a list of strings.Result<Record>
DSLContext. fetchFromTXT(String string)
Fetch all data from a formatted string.Result<Record>
DSLContext. fetchFromTXT(String string, String nullLiteral)
Fetch all data from a formatted string.Result<Record>
DSLContext. fetchFromXML(String string)
Fetch all data from an XML string.Map<Record,Result<R>>
ResultQuery. fetchGroups(int[] keyFieldIndexes)
Execute the query and return aMap
with the result grouped by the given keys.Map<Record,Result<Record>>
ResultQuery. fetchGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)
Execute the query and return aMap
with the result grouped by the given keys.Map<Record,Result<Record>>
ResultQuery. fetchGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)
Execute the query and return aMap
with the result grouped by the given keys.<E> Map<Record,List<E>>
ResultQuery. fetchGroups(int[] keyFieldIndexes, Class<? extends E> type)
Execute the query and return aMap
with results grouped by the given keys and mapped into the given entity type.<E> Map<Record,List<E>>
ResultQuery. fetchGroups(int[] keyFieldIndexes, RecordMapper<? super R,E> mapper)
Execute the query and return aMap
with results grouped by the given keys and mapped by the given mapper.Map<Record,Result<R>>
ResultQuery. fetchGroups(String[] keyFieldNames)
Execute the query and return aMap
with the result grouped by the given keys.<E> Map<Record,List<E>>
ResultQuery. fetchGroups(String[] keyFieldNames, Class<? extends E> type)
Execute the query and return aMap
with results grouped by the given keys and mapped into the given entity type.Map<Record,Result<Record>>
ResultQuery. fetchGroups(String[] keyFieldNames, String[] valueFieldNames)
Execute the query and return aMap
with the result grouped by the given keys.Map<Record,Result<Record>>
ResultQuery. fetchGroups(String[] keyFieldNames, String[] valueFieldNames)
Execute the query and return aMap
with the result grouped by the given keys.<E> Map<Record,List<E>>
ResultQuery. fetchGroups(String[] keyFieldNames, RecordMapper<? super R,E> mapper)
Execute the query and return aMap
with results grouped by the given keys and mapped by the given mapper.Map<Record,Result<R>>
ResultQuery. fetchGroups(Field<?>[] keys)
Execute the query and return aMap
with the result grouped by the given keys.<E> Map<Record,List<E>>
ResultQuery. fetchGroups(Field<?>[] keys, Class<? extends E> type)
Execute the query and return aMap
with results grouped by the given keys and mapped into the given entity type.Map<Record,Result<Record>>
ResultQuery. fetchGroups(Field<?>[] keys, Field<?>[] values)
Execute the query and return aMap
with the result grouped by the given keys.Map<Record,Result<Record>>
ResultQuery. fetchGroups(Field<?>[] keys, Field<?>[] values)
Execute the query and return aMap
with the result grouped by the given keys.<E> Map<Record,List<E>>
ResultQuery. fetchGroups(Field<?>[] keys, RecordMapper<? super R,E> mapper)
Execute the query and return aMap
with results grouped by the given keys and mapped by the given mapper.Map<Record,Result<R>>
ResultQuery. fetchGroups(Name[] keyFieldNames)
Execute the query and return aMap
with the result grouped by the given keys.<E> Map<Record,List<E>>
ResultQuery. fetchGroups(Name[] keyFieldNames, Class<? extends E> type)
Execute the query and return aMap
with results grouped by the given keys and mapped into the given entity type.Map<Record,Result<Record>>
ResultQuery. fetchGroups(Name[] keyFieldNames, Name[] valueFieldNames)
Execute the query and return aMap
with the result grouped by the given keys.Map<Record,Result<Record>>
ResultQuery. fetchGroups(Name[] keyFieldNames, Name[] valueFieldNames)
Execute the query and return aMap
with the result grouped by the given keys.<E> Map<Record,List<E>>
ResultQuery. fetchGroups(Name[] keyFieldNames, RecordMapper<? super R,E> mapper)
Execute the query and return aMap
with results grouped by the given keys and mapped by the given mapper.Cursor<Record>
DSLContext. fetchLazy(String sql)
Execute a new query holding plain SQL and "lazily" return the generated result.Cursor<Record>
DSLContext. fetchLazy(String sql, Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated result.Cursor<Record>
DSLContext. fetchLazy(String sql, QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated result.Cursor<Record>
DSLContext. fetchLazy(ResultSet rs)
Cursor<Record>
DSLContext. fetchLazy(ResultSet rs, Class<?>... types)
Cursor<Record>
DSLContext. fetchLazy(ResultSet rs, DataType<?>... types)
Cursor<Record>
DSLContext. fetchLazy(ResultSet rs, Field<?>... fields)
Cursor<Record>
DSLContext. fetchLazy(SQL sql)
Execute a new query holding plain SQL and "lazily" return the generated result.Map<Record,R>
ResultQuery. fetchMap(int[] keyFieldIndexes)
Execute the query and return aMap
with keys as a map key and the corresponding record as value.Map<Record,Record>
ResultQuery. fetchMap(int[] keyFieldIndexes, int[] valueFieldIndexes)
Execute the query and return aMap
with keys as a map key and the corresponding record as value.Map<Record,Record>
ResultQuery. fetchMap(int[] keyFieldIndexes, int[] valueFieldIndexes)
Execute the query and return aMap
with keys as a map key and the corresponding record as value.Map<Record,R>
ResultQuery. fetchMap(String[] keyFieldNames)
Execute the query and return aMap
with keys as a map key and the corresponding record as value.Map<Record,Record>
ResultQuery. fetchMap(String[] keyFieldNames, String[] valueFieldNames)
Execute the query and return aMap
with keys as a map key and the corresponding record as value.Map<Record,Record>
ResultQuery. fetchMap(String[] keyFieldNames, String[] valueFieldNames)
Execute the query and return aMap
with keys as a map key and the corresponding record as value.Map<Record,R>
ResultQuery. fetchMap(Field<?>[] keys)
Execute the query and return aMap
with keys as a map key and the corresponding record as value.Map<Record,Record>
ResultQuery. fetchMap(Field<?>[] keys, Field<?>[] values)
Execute the query and return aMap
with keys as a map key and the corresponding record as value.Map<Record,Record>
ResultQuery. fetchMap(Field<?>[] keys, Field<?>[] values)
Execute the query and return aMap
with keys as a map key and the corresponding record as value.Map<Record,R>
ResultQuery. fetchMap(Name[] keyFieldNames)
Execute the query and return aMap
with keys as a map key and the corresponding record as value.Map<Record,Record>
ResultQuery. fetchMap(Name[] keyFieldNames, Name[] valueFieldNames)
Execute the query and return aMap
with keys as a map key and the corresponding record as value.Map<Record,Record>
ResultQuery. fetchMap(Name[] keyFieldNames, Name[] valueFieldNames)
Execute the query and return aMap
with keys as a map key and the corresponding record as value.Optional<Record>
DSLContext. fetchOptional(String sql)
Execute a new query holding plain SQL.Optional<Record>
DSLContext. fetchOptional(String sql, Object... bindings)
Execute a new query holding plain SQL.Optional<Record>
DSLContext. fetchOptional(String sql, QueryPart... parts)
Execute a new query holding plain SQL.Optional<Record>
DSLContext. fetchOptional(ResultSet rs)
Optional<Record>
DSLContext. fetchOptional(ResultSet rs, Class<?>... types)
Optional<Record>
DSLContext. fetchOptional(ResultSet rs, DataType<?>... types)
Optional<Record>
DSLContext. fetchOptional(ResultSet rs, Field<?>... fields)
Optional<Record>
DSLContext. fetchOptional(SQL sql)
Execute a new query holding plain SQL.Stream<Record>
DSLContext. fetchStream(String sql)
Execute a new query holding plain SQL and "lazily" return the generated result.Stream<Record>
DSLContext. fetchStream(String sql, Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated result.Stream<Record>
DSLContext. fetchStream(String sql, QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated result.Stream<Record>
DSLContext. fetchStream(ResultSet rs)
Stream<Record>
DSLContext. fetchStream(ResultSet rs, Class<?>... types)
Stream<Record>
DSLContext. fetchStream(ResultSet rs, DataType<?>... types)
Stream<Record>
DSLContext. fetchStream(ResultSet rs, Field<?>... fields)
Stream<Record>
DSLContext. fetchStream(SQL sql)
Execute a new query holding plain SQL and "lazily" return the generated result.TableOnStep<Record>
Table. fullJoin(String sql)
FULL OUTER JOIN
a table to this table.TableOnStep<Record>
Table. fullJoin(String sql, Object... bindings)
FULL OUTER JOIN
a table to this table.TableOnStep<Record>
Table. fullJoin(String sql, QueryPart... parts)
FULL OUTER JOIN
a table to this table.TableOnStep<Record>
Table. fullJoin(Name name)
FULL OUTER JOIN
a table to this table.TableOnStep<Record>
Table. fullJoin(SQL sql)
FULL OUTER JOIN
a table to this table.TableOnStep<Record>
Table. fullJoin(TableLike<?> table)
FULL OUTER JOIN
a table to this table.TableOnStep<Record>
Table. fullOuterJoin(String sql)
FULL OUTER JOIN
a table to this table.TableOnStep<Record>
Table. fullOuterJoin(String sql, Object... bindings)
FULL OUTER JOIN
a table to this table.TableOnStep<Record>
Table. fullOuterJoin(String sql, QueryPart... parts)
FULL OUTER JOIN
a table to this table.TableOnStep<Record>
Table. fullOuterJoin(Name name)
FULL OUTER JOIN
a table to this table.TableOnStep<Record>
Table. fullOuterJoin(SQL sql)
FULL OUTER JOIN
a table to this table.TableOnStep<Record>
Table. fullOuterJoin(TableLike<?> table)
FULL OUTER JOIN
a table to this table.Table<Record>
PivotInStep. in(Collection<? extends Field<T>> fields)
Specify the acceptable values for pivotingTable<Record>
PivotInStep. in(Field<?>... fields)
Specify the acceptable values for pivotingTable<Record>
PivotInStep. in(T... values)
Specify the acceptable values for pivotingTableOnStep<Record>
Table. innerJoin(String sql)
INNER JOIN
a table to this table.TableOnStep<Record>
Table. innerJoin(String sql, Object... bindings)
INNER JOIN
a table to this table.TableOnStep<Record>
Table. innerJoin(String sql, QueryPart... parts)
INNER JOIN
a table to this table.TableOnStep<Record>
Table. innerJoin(Name name)
INNER JOIN
a table to this table.TableOnStep<Record>
Table. innerJoin(SQL sql)
INNER JOIN
a table to this table.TableOnStep<Record>
Table. innerJoin(TableLike<?> table)
INNER JOIN
a table to this table.Result<Record>
Result. into(Field<?>... fields)
Copy all records from this result into a new result with new records holding only a subset of the previous fields.SelectFromStep<Record>
SelectIntoStep. into(Table<?> table)
Add anINTO
clause to theSELECT
statement.Map<Record,Result<R>>
Result. intoGroups(int[] keyFieldIndexes)
Return aMap
with the result grouped by the given keys.Map<Record,Result<Record>>
Result. intoGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)
Return aMap
with the result grouped by the given keys.Map<Record,Result<Record>>
Result. intoGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)
Return aMap
with the result grouped by the given keys.<E> Map<Record,List<E>>
Result. intoGroups(int[] keyFieldIndexes, Class<? extends E> type)
Return aMap
with results grouped by the given keys and mapped into the given entity type.<E> Map<Record,List<E>>
Result. intoGroups(int[] keyFieldIndexes, RecordMapper<? super R,E> mapper)
Return aMap
with results grouped by the given keys and mapped into the given entity type.Map<Record,Result<R>>
Result. intoGroups(String[] keyFieldNames)
Return aMap
with the result grouped by the given keys.<E> Map<Record,List<E>>
Result. intoGroups(String[] keyFieldNames, Class<? extends E> type)
Return aMap
with results grouped by the given keys and mapped into the given entity type.Map<Record,Result<Record>>
Result. intoGroups(String[] keyFieldNames, String[] valueFieldNames)
Return aMap
with the result grouped by the given keys.Map<Record,Result<Record>>
Result. intoGroups(String[] keyFieldNames, String[] valueFieldNames)
Return aMap
with the result grouped by the given keys.<E> Map<Record,List<E>>
Result. intoGroups(String[] keyFieldNames, RecordMapper<? super R,E> mapper)
Return aMap
with results grouped by the given keys and mapped into the given entity type.Map<Record,Result<R>>
Result. intoGroups(Field<?>[] keys)
Return aMap
with the result grouped by the given keys.<E> Map<Record,List<E>>
Result. intoGroups(Field<?>[] keys, Class<? extends E> type)
Return aMap
with results grouped by the given keys and mapped into the given entity type.Map<Record,Result<Record>>
Result. intoGroups(Field<?>[] keys, Field<?>[] values)
Return aMap
with the result grouped by the given keys.Map<Record,Result<Record>>
Result. intoGroups(Field<?>[] keys, Field<?>[] values)
Return aMap
with the result grouped by the given keys.<E> Map<Record,List<E>>
Result. intoGroups(Field<?>[] keys, RecordMapper<? super R,E> mapper)
Return aMap
with results grouped by the given keys and mapped into the given entity type.Map<Record,Result<R>>
Result. intoGroups(Name[] keyFieldNames)
Return aMap
with the result grouped by the given keys.<E> Map<Record,List<E>>
Result. intoGroups(Name[] keyFieldNames, Class<? extends E> type)
Return aMap
with results grouped by the given keys and mapped into the given entity type.Map<Record,Result<Record>>
Result. intoGroups(Name[] keyFieldNames, Name[] valueFieldNames)
Return aMap
with the result grouped by the given keys.Map<Record,Result<Record>>
Result. intoGroups(Name[] keyFieldNames, Name[] valueFieldNames)
Return aMap
with the result grouped by the given keys.<E> Map<Record,List<E>>
Result. intoGroups(Name[] keyFieldNames, RecordMapper<? super R,E> mapper)
Return aMap
with results grouped by the given keys and mapped into the given entity type.Map<Record,R>
Result. intoMap(int[] keyFieldIndexes)
Return aMap
with the given keys as a map key and the corresponding record as value.Map<Record,Record>
Result. intoMap(int[] keyFieldIndexes, int[] valueFieldIndexes)
Return aMap
with the given keys as a map key and the corresponding record as value.Map<Record,Record>
Result. intoMap(int[] keyFieldIndexes, int[] valueFieldIndexes)
Return aMap
with the given keys as a map key and the corresponding record as value.Map<Record,R>
Result. intoMap(String[] keyFieldNames)
Return aMap
with the given keys as a map key and the corresponding record as value.Map<Record,Record>
Result. intoMap(String[] keyFieldNames, String[] valueFieldNames)
Return aMap
with the given keys as a map key and the corresponding record as value.Map<Record,Record>
Result. intoMap(String[] keyFieldNames, String[] valueFieldNames)
Return aMap
with the given keys as a map key and the corresponding record as value.Map<Record,R>
Result. intoMap(Field<?>[] keys)
Return aMap
with the given keys as a map key and the corresponding record as value.Map<Record,Record>
Result. intoMap(Field<?>[] keys, Field<?>[] values)
Return aMap
with the given keys as a map key and the corresponding record as value.Map<Record,Record>
Result. intoMap(Field<?>[] keys, Field<?>[] values)
Return aMap
with the given keys as a map key and the corresponding record as value.Map<Record,R>
Result. intoMap(Name[] keyFieldNames)
Return aMap
with the given keys as a map key and the corresponding record as value.Map<Record,Record>
Result. intoMap(Name[] keyFieldNames, Name[] valueFieldNames)
Return aMap
with the given keys as a map key and the corresponding record as value.Map<Record,Record>
Result. intoMap(Name[] keyFieldNames, Name[] valueFieldNames)
Return aMap
with the given keys as a map key and the corresponding record as value.TableOnStep<Record>
Table. join(String sql)
INNER JOIN
a table to this table.TableOnStep<Record>
Table. join(String sql, Object... bindings)
INNER JOIN
a table to this table.TableOnStep<Record>
Table. join(String sql, QueryPart... parts)
INNER JOIN
a table to this table.TableOnStep<Record>
Table. join(Name name)
INNER JOIN
a table to this table.TableOnStep<Record>
Table. join(SQL sql)
INNER JOIN
a table to this table.TableOnStep<Record>
Table. join(TableLike<?> table)
INNER JOIN
a table to this table.TableOptionalOnStep<Record>
Table. join(TableLike<?> table, JoinType type)
Join a table to this table using aJoinType
TableOnStep<Record>
TableOuterJoinStep. join(TableLike<?> table, JoinType type)
Join a table to this table using aJoinType
.TablePartitionByStep<Record>
Table. leftJoin(String sql)
LEFT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. leftJoin(String sql, Object... bindings)
LEFT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. leftJoin(String sql, QueryPart... parts)
LEFT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. leftJoin(Name name)
LEFT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. leftJoin(SQL sql)
LEFT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. leftJoin(TableLike<?> table)
LEFT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. leftJoin(String sql)
LEFT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. leftJoin(String sql, Object... bindings)
LEFT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. leftJoin(String sql, QueryPart... parts)
LEFT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. leftJoin(Name name)
LEFT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. leftJoin(SQL sql)
LEFT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. leftJoin(TableLike<?> table)
LEFT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. leftOuterJoin(String sql)
LEFT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. leftOuterJoin(String sql, Object... bindings)
LEFT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. leftOuterJoin(String sql, QueryPart... parts)
LEFT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. leftOuterJoin(Name name)
LEFT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. leftOuterJoin(SQL sql)
LEFT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. leftOuterJoin(TableLike<?> table)
LEFT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. leftOuterJoin(String sql)
LEFT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. leftOuterJoin(String sql, Object... bindings)
LEFT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. leftOuterJoin(String sql, QueryPart... parts)
LEFT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. leftOuterJoin(Name name)
LEFT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. leftOuterJoin(SQL sql)
LEFT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. leftOuterJoin(TableLike<?> table)
LEFT OUTER JOIN
a table to this table.Table<Record>
Table. naturalFullOuterJoin(String sql)
NATURAL FULL OUTER JOIN
a table to this table.Table<Record>
Table. naturalFullOuterJoin(String sql, Object... bindings)
NATURAL FULL OUTER JOIN
a table to this table.Table<Record>
Table. naturalFullOuterJoin(String sql, QueryPart... parts)
NATURAL FULL OUTER JOIN
a table to this table.Table<Record>
Table. naturalFullOuterJoin(Name name)
NATURAL FULL OUTER JOIN
a table to this table.Table<Record>
Table. naturalFullOuterJoin(SQL sql)
NATURAL FULL OUTER JOIN
a table to this table.Table<Record>
Table. naturalFullOuterJoin(TableLike<?> table)
NATURAL FULL OUTER JOIN
a table to this table.Table<Record>
Table. naturalJoin(String sql)
NATURAL JOIN
a table to this table.Table<Record>
Table. naturalJoin(String sql, Object... bindings)
NATURAL JOIN
a table to this table.Table<Record>
Table. naturalJoin(String sql, QueryPart... parts)
NATURAL JOIN
a table to this table.Table<Record>
Table. naturalJoin(Name name)
NATURAL JOIN
a table to this table.Table<Record>
Table. naturalJoin(SQL sql)
NATURAL JOIN
a table to this table.Table<Record>
Table. naturalJoin(TableLike<?> table)
NATURAL JOIN
a table to this table.Table<Record>
Table. naturalLeftOuterJoin(String sql)
NATURAL LEFT OUTER JOIN
a table to this table.Table<Record>
Table. naturalLeftOuterJoin(String sql, Object... bindings)
NATURAL LEFT OUTER JOIN
a table to this table.Table<Record>
Table. naturalLeftOuterJoin(String sql, QueryPart... parts)
NATURAL LEFT OUTER JOIN
a table to this table.Table<Record>
Table. naturalLeftOuterJoin(Name name)
NATURAL LEFT OUTER JOIN
a table to this table.Table<Record>
Table. naturalLeftOuterJoin(SQL sql)
NATURAL LEFT OUTER JOIN
a table to this table.Table<Record>
Table. naturalLeftOuterJoin(TableLike<?> table)
NATURAL LEFT OUTER JOIN
a table to this table.Table<Record>
Table. naturalRightOuterJoin(String sql)
NATURAL RIGHT OUTER JOIN
a table to this table.Table<Record>
Table. naturalRightOuterJoin(String sql, Object... bindings)
NATURAL RIGHT OUTER JOIN
a table to this table.Table<Record>
Table. naturalRightOuterJoin(String sql, QueryPart... parts)
NATURAL RIGHT OUTER JOIN
a table to this table.Table<Record>
Table. naturalRightOuterJoin(Name name)
NATURAL RIGHT OUTER JOIN
a table to this table.Table<Record>
Table. naturalRightOuterJoin(SQL sql)
NATURAL RIGHT OUTER JOIN
a table to this table.Table<Record>
Table. naturalRightOuterJoin(TableLike<?> table)
NATURAL RIGHT OUTER JOIN
a table to this table.Result<Record>
DSLContext. newResult(Collection<? extends Field<?>> fields)
Create a new emptyRecord
.Result<Record>
DSLContext. newResult(Field<?>... fields)
Create a new emptyRecord
.Table<Record>
Table. outerApply(String sql)
OUTER APPLY
a table to this table.Table<Record>
Table. outerApply(String sql, Object... bindings)
OUTER APPLY
a table to this table.Table<Record>
Table. outerApply(String sql, QueryPart... parts)
OUTER APPLY
a table to this table.Table<Record>
Table. outerApply(Name name)
OUTER APPLY
a table to this table.Table<Record>
Table. outerApply(SQL sql)
OUTER APPLY
a table to this table.Table<Record>
Table. outerApply(TableLike<?> table)
OUTER APPLY
a table to this table.TableOuterJoinStep<Record>
Table. partitionBy(Collection<? extends Field<?>> fields)
Add aPARTITION BY
clause to the left hand side of theOUTER JOIN
keywordsTableOuterJoinStep<Record>
Table. partitionBy(Field<?>... fields)
Add aPARTITION BY
clause to the left hand side of theOUTER JOIN
keywordsResult<Record>
ResultOrRows. result()
The result ornull
if there was no result.ResultQuery<Record>
DSLContext. resultQuery(String sql)
Create a new query holding plain SQL.ResultQuery<Record>
DSLContext. resultQuery(String sql, Object... bindings)
Create a new query holding plain SQL.ResultQuery<Record>
DSLContext. resultQuery(String sql, QueryPart... parts)
Create a new query holding plain SQL.ResultQuery<Record>
DSLContext. resultQuery(SQL sql)
Create a new query holding plain SQL.Table<Record>
DivideByReturningStep. returning(Collection<? extends Field<?>> fields)
Specify the fields that you want the division to return from the dividendTable<Record>
DivideByReturningStep. returning(Field<?>... fields)
Specify the fields that you want the division to return from the dividendDeleteResultStep<Record>
DeleteReturningStep. returningResult(Collection<? extends SelectFieldOrAsterisk> fields)
Configure theDELETE
statement to return a list of fields inR
.DeleteResultStep<Record>
DeleteReturningStep. returningResult(SelectFieldOrAsterisk... fields)
Configure theDELETE
statement to return a list of fields inR
.InsertResultStep<Record>
InsertReturningStep. returningResult(Collection<? extends SelectFieldOrAsterisk> fields)
Configure theINSERT
statement to return a list of fields inR
.InsertResultStep<Record>
InsertReturningStep. returningResult(SelectFieldOrAsterisk... fields)
Configure theINSERT
statement to return a list of fields inR
.UpdateResultStep<Record>
UpdateReturningStep. returningResult(Collection<? extends SelectFieldOrAsterisk> fields)
Configure theUPDATE
statement to return a list of fields inR
.UpdateResultStep<Record>
UpdateReturningStep. returningResult(SelectFieldOrAsterisk... fields)
Configure theUPDATE
statement to return a list of fields inR
.TablePartitionByStep<Record>
Table. rightJoin(String sql)
RIGHT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. rightJoin(String sql, Object... bindings)
RIGHT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. rightJoin(String sql, QueryPart... parts)
RIGHT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. rightJoin(Name name)
RIGHT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. rightJoin(SQL sql)
RIGHT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. rightJoin(TableLike<?> table)
RIGHT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. rightJoin(String sql)
RIGHT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. rightJoin(String sql, Object... bindings)
RIGHT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. rightJoin(String sql, QueryPart... parts)
RIGHT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. rightJoin(Name name)
RIGHT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. rightJoin(SQL sql)
RIGHT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. rightJoin(TableLike<?> table)
RIGHT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. rightOuterJoin(String sql)
RIGHT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. rightOuterJoin(String sql, Object... bindings)
RIGHT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. rightOuterJoin(String sql, QueryPart... parts)
RIGHT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. rightOuterJoin(Name name)
RIGHT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. rightOuterJoin(SQL sql)
RIGHT OUTER JOIN
a table to this table.TablePartitionByStep<Record>
Table. rightOuterJoin(TableLike<?> table)
RIGHT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. rightOuterJoin(String sql)
RIGHT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. rightOuterJoin(String sql, Object... bindings)
RIGHT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. rightOuterJoin(String sql, QueryPart... parts)
RIGHT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. rightOuterJoin(Name name)
RIGHT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. rightOuterJoin(SQL sql)
RIGHT OUTER JOIN
a table to this table.TableOnStep<Record>
TableOuterJoinStep. rightOuterJoin(TableLike<?> table)
RIGHT OUTER JOIN
a table to this table.SelectSelectStep<Record>
DSLContext. select(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.SelectSelectStep<Record>
DSLContext. select(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.SelectSelectStep<Record>
SelectSelectStep. select(Collection<? extends SelectFieldOrAsterisk> fields)
Add additional fields to theSELECT
clause of this querySelectSelectStep<Record>
SelectSelectStep. select(SelectFieldOrAsterisk... fields)
Add additional fields to theSELECT
clause of this querySelectSelectStep<Record>
WithStep. select(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.SelectSelectStep<Record>
WithStep. select(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.SelectSelectStep<Record>
DSLContext. selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.SelectSelectStep<Record>
DSLContext. selectDistinct(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.SelectSelectStep<Record>
WithStep. selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.SelectSelectStep<Record>
WithStep. selectDistinct(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.SelectWhereStep<Record>
DSLContext. selectFrom(String sql)
Create a new DSL select statement, projecting*
.SelectWhereStep<Record>
DSLContext. selectFrom(String sql, Object... bindings)
Create a new DSL select statement, projecting*
.SelectWhereStep<Record>
DSLContext. selectFrom(String sql, QueryPart... parts)
Create a new DSL select statement, projecting*
.SelectWhereStep<Record>
DSLContext. selectFrom(Name table)
Create a new DSL select statement, projecting*
.SelectWhereStep<Record>
DSLContext. selectFrom(SQL sql)
Create a new DSL select statement, projecting*
.SelectWhereStep<Record>
WithStep. selectFrom(String sql)
Create a new DSL select statement, projecting*
.SelectWhereStep<Record>
WithStep. selectFrom(String sql, Object... bindings)
Create a new DSL select statement, projecting*
.SelectWhereStep<Record>
WithStep. selectFrom(String sql, QueryPart... parts)
Create a new DSL select statement, projecting*
.SelectWhereStep<Record>
WithStep. selectFrom(Name table)
Create a new DSL select statement, projecting*
.SelectWhereStep<Record>
WithStep. selectFrom(SQL sql)
Create a new DSL select statement, projecting*
.SelectQuery<Record>
DSLContext. selectQuery()
Create a newSelectQuery
TableOnStep<Record>
Table. straightJoin(String sql)
STRAIGHT_JOIN
a table to this table.TableOnStep<Record>
Table. straightJoin(String sql, Object... bindings)
STRAIGHT_JOIN
a table to this table.TableOnStep<Record>
Table. straightJoin(String sql, QueryPart... parts)
STRAIGHT_JOIN
a table to this table.TableOnStep<Record>
Table. straightJoin(Name name)
STRAIGHT_JOIN
a table to this table.TableOnStep<Record>
Table. straightJoin(SQL sql)
STRAIGHT_JOIN
a table to this table.TableOnStep<Record>
Table. straightJoin(TableLike<?> table)
STRAIGHT_JOIN
a table to this table.TruncateIdentityStep<Record>
DSLContext. truncate(String table)
Create a new DSL truncate statement.TruncateIdentityStep<Record>
DSLContext. truncate(Name table)
Create a new DSL truncate statement.TruncateIdentityStep<Record>
DSLContext. truncateTable(String table)
Create a new DSL truncate statement.TruncateIdentityStep<Record>
DSLContext. truncateTable(Name table)
Create a new DSL truncate statement.Table<Record>
TableOnStep. using(Collection<? extends Field<?>> fields)
Join a table with theUSING(column [, column...])
syntax.Table<Record>
TableOnStep. using(Field<?>... fields)
Join a table with theUSING(column [, column...])
syntax.Methods in org.jooq with parameters of type Record Modifier and Type Method Description Condition
BetweenAndStepN. and(Record maxValue)
Create a condition to check this field against some boundsBetweenAndStepN
RowN. between(Record minValue)
Check if this row value expression is within a range of two records.Condition
RowN. between(Record minValue, Record maxValue)
Check if this row value expression is within a range of two records.BetweenAndStepN
RowN. betweenSymmetric(Record minValue)
Check if this row value expression is within a symmetric range of two records.Condition
RowN. betweenSymmetric(Record minValue, Record maxValue)
Check if this row value expression is within a symmetric range of two records.boolean
Field. changed(Record record)
The inverse operation ofchanged(Field)
.Condition
RowN. compare(Comparator comparator, Record record)
Compare this row value expression with a record using a dynamic comparator.int
Record. compareTo(Record record)
Compares thisRecord
with anotherRecord
according to their natural ordering.Condition
RowN. eq(Record record)
Compare this row value expression with a record for equality.Condition
RowN. equal(Record record)
Compare this row value expression with a record for equality.Result<R>
ForeignKey. fetchChildren(O... records)
Fetch child records of a given set of records through this foreign keyResult<O>
ForeignKey. fetchParents(R... records)
Fetch parent records of a given set of record through this foreign keyField<T>
Field. field(Record record)
The inverse operation offield(Field)
.Record1<T>
Field. from(Record record)
The inverse operation ofinto(Field)
.R
Table. from(Record record)
The inverse operation ofinto(Table)
.Condition
RowN. ge(Record record)
Compare this row value expression with a record for order.T
Field. get(Record record)
The inverse operation ofget(Field)
.T
Field. getValue(Record record)
The inverse operation ofgetValue(Field)
.Condition
RowN. greaterOrEqual(Record record)
Compare this row value expression with a record for order.Condition
RowN. greaterThan(Record record)
Compare this row value expression with a record for order.Condition
RowN. gt(Record record)
Compare this row value expression with a record for order.Condition
RowN. in(Record... record)
Compare this row value expression with a set of records for equality.Condition
RowN. isDistinctFrom(Record record)
Compare this row value expression with another row value expression for distinctness.Condition
RowN. isNotDistinctFrom(Record record)
Compare this row value expression with another row value expression for distinctness.Condition
RowN. le(Record record)
Compare this row value expression with a record for order.Condition
RowN. lessOrEqual(Record record)
Compare this row value expression with a record for order.Condition
RowN. lessThan(Record record)
Compare this row value expression with a record for order.LoaderRowsStep<R>
LoaderSourceStep. loadRecords(Record... records)
Load in-memory data.Condition
RowN. lt(Record record)
Compare this row value expression with a record for order.Condition
RowN. ne(Record record)
Compare this row value expression with a record for non-equality.BetweenAndStepN
RowN. notBetween(Record minValue)
Check if this row value expression is within a range of two records.Condition
RowN. notBetween(Record minValue, Record maxValue)
Check if this row value expression is within a range of two records.BetweenAndStepN
RowN. notBetweenSymmetric(Record minValue)
Check if this row value expression is not within a symmetric range of two records.Condition
RowN. notBetweenSymmetric(Record minValue, Record maxValue)
Check if this row value expression is not within a symmetric range of two records.Condition
RowN. notEqual(Record record)
Compare this row value expression with a record for non-equalityCondition
RowN. notIn(Record... record)
Compare this row value expression with a set of records for non-equality.T
Field. original(Record record)
The inverse operation oforiginal(Field)
.void
ExecuteContext. record(Record record)
Calling this has no effect.void
Field. reset(Record record)
The inverse operation ofreset(Field)
.InsertOnDuplicateSetMoreStep<R>
InsertOnDuplicateSetStep. set(Record record)
Set multiple values forUPDATE
in theINSERT
statement'sON DUPLICATE KEY UPDATE
orON CONFLICT ...
InsertSetMoreStep<R>
InsertSetMoreStep. set(Record record)
Set values in theINSERT
statement.InsertSetMoreStep<R>
InsertSetStep. set(Record record)
Set values in theINSERT
statement.MergeMatchedSetMoreStep<R>
MergeMatchedSetStep. set(Record record)
Set multiple values forUPDATE
in theMERGE
statement'sWHEN MATCHED
clause.MergeNotMatchedSetMoreStep<R>
MergeNotMatchedSetStep. set(Record record)
Set multiple values forINSERT
in theMERGE
statement'sWHEN NOT MATCHED
clause.UpdateSetMoreStep<R>
UpdateSetStep. set(Record record)
Set a value for a field in theUPDATE
statement.Method parameters in org.jooq with type arguments of type Record Modifier and Type Method Description Condition
RowN. compare(Comparator comparator, QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect using a dynamic comparator.Condition
RowN. compare(Comparator comparator, Select<? extends Record> select)
Compare this row value expression with a subselect using a dynamic comparator.Condition
RowN. eq(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for equality.Condition
RowN. eq(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.Condition
RowN. equal(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for equality.Condition
RowN. equal(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.Condition
RowN. ge(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
RowN. ge(Select<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
RowN. greaterOrEqual(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
RowN. greaterOrEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
RowN. greaterThan(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
RowN. greaterThan(Select<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
RowN. gt(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
RowN. gt(Select<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
RowN. in(Result<? extends Record> result)
Compare this row value expression with a set of records for equality.Condition
RowN. in(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.Condition
RowN. le(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
RowN. le(Select<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
RowN. lessOrEqual(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
RowN. lessOrEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
RowN. lessThan(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
RowN. lessThan(Select<? extends Record> select)
Compare this row value expression with a subselect for order.LoaderRowsStep<R>
LoaderSourceStep. loadRecords(Iterable<? extends Record> records)
Load in-memory data.LoaderRowsStep<R>
LoaderSourceStep. loadRecords(Iterator<? extends Record> records)
Load in-memory data.LoaderRowsStep<R>
LoaderSourceStep. loadRecords(Stream<? extends Record> records)
Load in-memory data.Condition
RowN. lt(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.Condition
RowN. lt(Select<? extends Record> select)
Compare this row value expression with a subselect for order.<E> E
Record. map(RecordMapper<Record,E> mapper)
Map this record into a custom mapper callback.Condition
RowN. ne(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for non-equality.Condition
RowN. ne(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.Condition
RowN. notEqual(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for non-equality.Condition
RowN. notEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.Condition
RowN. notIn(Result<? extends Record> result)
Compare this row value expression with a set of records for equality.Condition
RowN. notIn(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality. -
Uses of Record in org.jooq.impl
Classes in org.jooq.impl with type parameters of type Record Modifier and Type Class Description class
DefaultRecordMapper<R extends Record,E>
This is the default implementation forRecordMapper
types.class
DefaultRecordUnmapper<E,R extends Record>
A default implementation for unmapping a custom type to aRecord
.class
TableImpl<R extends Record>
A common base type for tablesClasses in org.jooq.impl that implement Record Modifier and Type Class Description class
CustomRecord<R extends TableRecord<R>>
A base class for customTableRecord
implementations in client code.class
EmbeddableRecordImpl<R extends EmbeddableRecord<R>>
A record implementation for a record originating from a single tableclass
TableRecordImpl<R extends TableRecord<R>>
A record implementation for a record originating from a single tableclass
UDTRecordImpl<R extends UDTRecord<R>>
A record implementation for a record originating from a single UDTclass
UpdatableRecordImpl<R extends UpdatableRecord<R>>
A record implementation for a record holding a primary keyFields in org.jooq.impl with type parameters of type Record Modifier and Type Field Description static DataType<Record>
SQLDataType. RECORD
TheTypes.STRUCT
type.static DataType<Result<Record>>
SQLDataType. RESULT
TheResultSet
type.Methods in org.jooq.impl with type parameters of type Record Modifier and Type Method Description static <R extends Record>
QuantifiedSelect<R>DSL. all(Select<R> select)
Create anALL
quantified select to be used in quantified comparison predicate expressions.static <R extends Record>
QuantifiedSelect<R>DSL. any(Select<R> select)
Create anANY
quantified select to be used in quantified comparison predicate expressions.static <R extends Record>
Check<R>Internal. createCheck(Table<R> table, Name name, String condition)
Factory method for check constraints.static <R extends Record>
Check<R>Internal. createCheck(Table<R> table, Name name, String condition, boolean enforced)
Factory method for check constraints.static <R extends Record,T extends Record>
TableField<R,T>Internal. createEmbeddable(Name name, Class<T> recordType, Table<R> table, TableField<R,?>... fields)
Factory method for embeddable types.static <R extends Record,T extends Record>
TableField<R,T>Internal. createEmbeddable(Name name, Class<T> recordType, Table<R> table, TableField<R,?>... fields)
Factory method for embeddable types.static <R extends Record,U extends Record>
ForeignKey<R,U>AbstractKeys. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record,U extends Record>
ForeignKey<R,U>AbstractKeys. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record,U extends Record>
ForeignKey<R,U>AbstractKeys. createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record,U extends Record>
ForeignKey<R,U>AbstractKeys. createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record,U extends Record>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)
Factory method for foreign keys.static <R extends Record,U extends Record>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)
Factory method for foreign keys.static <R extends Record,U extends Record>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)
Factory method for foreign keys.static <R extends Record,U extends Record>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)
Factory method for foreign keys.static <R extends Record,U extends Record>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields)
Factory method for foreign keys.static <R extends Record,U extends Record>
ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields)
Factory method for foreign keys.static <R extends Record,T>
Identity<R,T>AbstractKeys. createIdentity(Table<R> table, TableField<R,T> field)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record,T>
Identity<R,T>Internal. createIdentity(Table<R> table, TableField<R,T> field)
Factory method for identities.static <R extends Record>
UniqueKey<R>AbstractKeys. createUniqueKey(Table<R> table, String name, TableField<R,?>... fields)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record>
UniqueKey<R>AbstractKeys. createUniqueKey(Table<R> table, TableField<R,?>... fields)
Deprecated.- [#6875] [#7158] - 3.11.0 - Please re-generate your codestatic <R extends Record>
UniqueKey<R>Internal. createUniqueKey(Table<R> table, String name, TableField<R,?>... fields)
Factory method for unique keys.static <R extends Record>
UniqueKey<R>Internal. createUniqueKey(Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)
Factory method for unique keys.static <R extends Record>
UniqueKey<R>Internal. createUniqueKey(Table<R> table, TableField<R,?>... fields)
Factory method for unique keys.<R extends Record>
DeleteUsingStep<R>DefaultDSLContext. delete(Table<R> table)
static <R extends Record>
DeleteUsingStep<R>DSL. delete(Table<R> table)
Create a new DSL delete statement.<R extends Record>
DeleteUsingStep<R>DefaultDSLContext. deleteFrom(Table<R> table)
static <R extends Record>
DeleteUsingStep<R>DSL. deleteFrom(Table<R> table)
Create a new DSL delete statement.<R extends Record>
DeleteQuery<R>DefaultDSLContext. deleteQuery(Table<R> table)
<R extends Record>
Result<R>DefaultDSLContext. fetch(ResultQuery<R> query)
<R extends Record>
Result<R>DefaultDSLContext. fetch(Table<R> table)
<R extends Record>
Result<R>DefaultDSLContext. fetch(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
Result<R>DefaultDSLContext. fetch(Table<R> table, Condition condition)
<R extends Record>
Result<R>DefaultDSLContext. fetch(Table<R> table, Condition... conditions)
<R extends Record>
RDefaultDSLContext. fetchAny(Table<R> table)
<R extends Record>
RDefaultDSLContext. fetchAny(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
RDefaultDSLContext. fetchAny(Table<R> table, Condition condition)
<R extends Record>
RDefaultDSLContext. fetchAny(Table<R> table, Condition... conditions)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Executor executor, ResultQuery<R> query)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Executor executor, Table<R> table)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Executor executor, Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Executor executor, Table<R> table, Condition condition)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Executor executor, Table<R> table, Condition... conditions)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(ResultQuery<R> query)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Table<R> table)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Table<R> table, Condition condition)
<R extends Record>
CompletionStage<Result<R>>DefaultDSLContext. fetchAsync(Table<R> table, Condition... conditions)
<R extends Record>
Cursor<R>DefaultDSLContext. fetchLazy(ResultQuery<R> query)
<R extends Record>
Cursor<R>DefaultDSLContext. fetchLazy(Table<R> table)
<R extends Record>
Cursor<R>DefaultDSLContext. fetchLazy(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
Cursor<R>DefaultDSLContext. fetchLazy(Table<R> table, Condition condition)
<R extends Record>
Cursor<R>DefaultDSLContext. fetchLazy(Table<R> table, Condition... conditions)
<R extends Record>
ResultsDefaultDSLContext. fetchMany(ResultQuery<R> query)
<R extends Record>
RDefaultDSLContext. fetchOne(ResultQuery<R> query)
<R extends Record>
RDefaultDSLContext. fetchOne(Table<R> table)
<R extends Record>
RDefaultDSLContext. fetchOne(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
RDefaultDSLContext. fetchOne(Table<R> table, Condition condition)
<R extends Record>
RDefaultDSLContext. fetchOne(Table<R> table, Condition... conditions)
<R extends Record>
Optional<R>DefaultDSLContext. fetchOptional(ResultQuery<R> query)
<R extends Record>
Optional<R>DefaultDSLContext. fetchOptional(Table<R> table)
<R extends Record>
Optional<R>DefaultDSLContext. fetchOptional(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
Optional<R>DefaultDSLContext. fetchOptional(Table<R> table, Condition condition)
<R extends Record>
Optional<R>DefaultDSLContext. fetchOptional(Table<R> table, Condition... conditions)
<R extends Record>
RDefaultDSLContext. fetchSingle(ResultQuery<R> query)
<R extends Record>
RDefaultDSLContext. fetchSingle(Table<R> table)
<R extends Record>
RDefaultDSLContext. fetchSingle(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
RDefaultDSLContext. fetchSingle(Table<R> table, Condition condition)
<R extends Record>
RDefaultDSLContext. fetchSingle(Table<R> table, Condition... conditions)
<R extends Record>
Stream<R>DefaultDSLContext. fetchStream(ResultQuery<R> query)
<R extends Record>
Stream<R>DefaultDSLContext. fetchStream(Table<R> table)
<R extends Record>
Stream<R>DefaultDSLContext. fetchStream(Table<R> table, Collection<? extends Condition> conditions)
<R extends Record>
Stream<R>DefaultDSLContext. fetchStream(Table<R> table, Condition condition)
<R extends Record>
Stream<R>DefaultDSLContext. fetchStream(Table<R> table, Condition... conditions)
<R extends Record>
InsertSetStep<R>DefaultDSLContext. insertInto(Table<R> into)
<R extends Record>
InsertValuesStepN<R>DefaultDSLContext. insertInto(Table<R> into, Collection<? extends Field<?>> fields)
<R extends Record>
InsertValuesStepN<R>DefaultDSLContext. insertInto(Table<R> into, Field<?>... fields)
<R extends Record,T1>
InsertValuesStep1<R,T1>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1)
<R extends Record,T1,T2>
InsertValuesStep2<R,T1,T2>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)
<R extends Record,T1,T2,T3>
InsertValuesStep3<R,T1,T2,T3>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)
<R extends Record,T1,T2,T3,T4>
InsertValuesStep4<R,T1,T2,T3,T4>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
<R extends Record,T1,T2,T3,T4,T5>
InsertValuesStep5<R,T1,T2,T3,T4,T5>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
<R extends Record,T1,T2,T3,T4,T5,T6>
InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
<R extends Record,T1,T2,T3,T4,T5,T6,T7>
InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>DefaultDSLContext. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>DefaultDSLContext. insertInto(Table<R> 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>DefaultDSLContext. insertInto(Table<R> 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>DefaultDSLContext. insertInto(Table<R> 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, Field<T10> field10)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>DefaultDSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>DefaultDSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>DefaultDSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>DefaultDSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>DefaultDSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>DefaultDSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>DefaultDSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>DefaultDSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>DefaultDSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>DefaultDSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>DefaultDSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>DefaultDSLContext. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)
static <R extends Record>
InsertSetStep<R>DSL. insertInto(Table<R> into)
Create a new DSL insert statement.static <R extends Record>
InsertValuesStepN<R>DSL. insertInto(Table<R> into, Collection<? extends Field<?>> fields)
Create a new DSL insert statement.static <R extends Record>
InsertValuesStepN<R>DSL. insertInto(Table<R> into, Field<?>... fields)
Create a new DSL insert statement.static <R extends Record,T1>
InsertValuesStep1<R,T1>DSL. insertInto(Table<R> into, Field<T1> field1)
Create a new DSL insert statement.static <R extends Record,T1,T2>
InsertValuesStep2<R,T1,T2>DSL. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3>
InsertValuesStep3<R,T1,T2,T3>DSL. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4>
InsertValuesStep4<R,T1,T2,T3,T4>DSL. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5>
InsertValuesStep5<R,T1,T2,T3,T4,T5>DSL. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6>
InsertValuesStep6<R,T1,T2,T3,T4,T5,T6>DSL. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7>
InsertValuesStep7<R,T1,T2,T3,T4,T5,T6,T7>DSL. insertInto(Table<R> into, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
InsertValuesStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>DSL. insertInto(Table<R> 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
InsertValuesStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>DSL. insertInto(Table<R> 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)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
InsertValuesStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>DSL. insertInto(Table<R> 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, Field<T10> field10)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
InsertValuesStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>DSL. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
InsertValuesStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>DSL. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
InsertValuesStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>DSL. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
InsertValuesStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>DSL. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
InsertValuesStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>DSL. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
InsertValuesStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>DSL. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
InsertValuesStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>DSL. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
InsertValuesStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>DSL. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
InsertValuesStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>DSL. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
InsertValuesStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>DSL. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
InsertValuesStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>DSL. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)
Create a new DSL insert statement.static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
InsertValuesStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>DSL. insertInto(Table<R> 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)
Create a new DSL insert statement.<R extends Record>
InsertQuery<R>DefaultDSLContext. insertQuery(Table<R> into)
static <R extends Record>
Table<R>DSL. lateral(TableLike<R> table)
Create aLATERAL
joined table.<R extends Record>
LoaderOptionsStep<R>DefaultDSLContext. loadInto(Table<R> table)
<R extends Record>
Table<R>DefaultDSLContext. map(Table<R> table)
<R extends Record>
MergeUsingStep<R>DefaultDSLContext. mergeInto(Table<R> table)
<R extends Record>
MergeKeyStepN<R>DefaultDSLContext. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
<R extends Record>
MergeKeyStepN<R>DefaultDSLContext. mergeInto(Table<R> table, Field<?>... fields)
<R extends Record,T1>
MergeKeyStep1<R,T1>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1)
<R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)
<R extends Record,T1,T2,T3>
MergeKeyStep3<R,T1,T2,T3>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
<R extends Record,T1,T2,T3,T4>
MergeKeyStep4<R,T1,T2,T3,T4>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
<R extends Record,T1,T2,T3,T4,T5>
MergeKeyStep5<R,T1,T2,T3,T4,T5>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
<R extends Record,T1,T2,T3,T4,T5,T6>
MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
<R extends Record,T1,T2,T3,T4,T5,T6,T7>
MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>DefaultDSLContext. mergeInto(Table<R> table, 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)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>DefaultDSLContext. mergeInto(Table<R> table, 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, Field<T10> field10)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>DefaultDSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>DefaultDSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>DefaultDSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>DefaultDSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>DefaultDSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>DefaultDSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>DefaultDSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>DefaultDSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>DefaultDSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>DefaultDSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>DefaultDSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>DefaultDSLContext. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)
static <R extends Record>
MergeUsingStep<R>DSL. mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.static <R extends Record>
MergeKeyStepN<R>DSL. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax).static <R extends Record>
MergeKeyStepN<R>DSL. mergeInto(Table<R> table, Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax).static <R extends Record,T1>
MergeKeyStep1<R,T1>DSL. mergeInto(Table<R> table, Field<T1> field1)
static <R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)
static <R extends Record,T1,T2,T3>
MergeKeyStep3<R,T1,T2,T3>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
static <R extends Record,T1,T2,T3,T4>
MergeKeyStep4<R,T1,T2,T3,T4>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
static <R extends Record,T1,T2,T3,T4,T5>
MergeKeyStep5<R,T1,T2,T3,T4,T5>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5)
static <R extends Record,T1,T2,T3,T4,T5,T6>
MergeKeyStep6<R,T1,T2,T3,T4,T5,T6>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7>
MergeKeyStep7<R,T1,T2,T3,T4,T5,T6,T7>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
MergeKeyStep8<R,T1,T2,T3,T4,T5,T6,T7,T8>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
MergeKeyStep9<R,T1,T2,T3,T4,T5,T6,T7,T8,T9>DSL. mergeInto(Table<R> table, 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 <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
MergeKeyStep10<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>DSL. mergeInto(Table<R> table, 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, Field<T10> field10)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
MergeKeyStep11<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>DSL. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
MergeKeyStep12<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>DSL. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
MergeKeyStep13<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>DSL. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
MergeKeyStep14<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>DSL. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
MergeKeyStep15<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>DSL. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
MergeKeyStep16<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>DSL. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
MergeKeyStep17<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>DSL. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
MergeKeyStep18<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>DSL. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
MergeKeyStep19<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>DSL. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
MergeKeyStep20<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>DSL. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
MergeKeyStep21<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>DSL. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>
MergeKeyStep22<R,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>DSL. mergeInto(Table<R> table, 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, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22)
<R extends Record>
RDefaultDSLContext. newRecord(Table<R> table)
<R extends Record>
RDefaultDSLContext. newRecord(Table<R> table, Object source)
<R extends Record>
Result<R>DefaultDSLContext. newResult(Table<R> table)
<R extends Record,E>
RecordMapper<R,E>DefaultRecordMapperProvider. provide(RecordType<R> rowType, Class<? extends E> type)
<E,R extends Record>
RecordUnmapper<E,R>DefaultRecordUnmapperProvider. provide(Class<? extends E> type, RecordType<R> rowType)
<R extends Record>
SelectWhereStep<R>DefaultDSLContext. selectFrom(Table<R> table)
static <R extends Record>
SelectWhereStep<R>DSL. selectFrom(Table<R> table)
Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
SelectQuery<R>DefaultDSLContext. selectQuery(TableLike<R> table)
static <R extends Record>
Table<R>DSL. table(Result<R> result)
Use a previously obtained result as a newTable
that can be used in SQL statements throughDSL.values(RowN...)
.static <R extends Record>
Table<R>DSL. table(Select<R> select)
A synonym forTableLike.asTable()
, which might look a bit more fluent like this, to some users.static <R extends Record>
Table<R>DSL. table(R record)
Use a previously obtained record as a new Tablestatic <R extends Record>
Table<R>DSL. table(R... records)
Use a previously obtained set of records as a new Table<R extends Record>
TruncateIdentityStep<R>DefaultDSLContext. truncate(Table<R> table)
static <R extends Record>
TruncateIdentityStep<R>DSL. truncate(Table<R> table)
Create a new DSL truncate statement.<R extends Record>
TruncateIdentityStep<R>DefaultDSLContext. truncateTable(Table<R> table)
static <R extends Record>
TruncateIdentityStep<R>DSL. truncateTable(Table<R> table)
Create a new DSL truncate statement.<R extends Record>
UpdateSetFirstStep<R>DefaultDSLContext. update(Table<R> table)
static <R extends Record>
UpdateSetFirstStep<R>DSL. update(Table<R> table)
Create a new DSL update statement.<R extends Record>
UpdateQuery<R>DefaultDSLContext. updateQuery(Table<R> table)
Methods in org.jooq.impl that return Record Modifier and Type Method Description Record
DefaultDSLContext. fetchOne(String sql)
Record
DefaultDSLContext. fetchOne(String sql, Object... bindings)
Record
DefaultDSLContext. fetchOne(String sql, QueryPart... parts)
Record
DefaultDSLContext. fetchOne(ResultSet rs)
Record
DefaultDSLContext. fetchOne(ResultSet rs, Class<?>... types)
Record
DefaultDSLContext. fetchOne(ResultSet rs, DataType<?>... types)
Record
DefaultDSLContext. fetchOne(ResultSet rs, Field<?>... fields)
Record
DefaultDSLContext. fetchOne(SQL sql)
Record
DefaultDSLContext. fetchSingle(String sql)
Record
DefaultDSLContext. fetchSingle(String sql, Object... bindings)
Record
DefaultDSLContext. fetchSingle(String sql, QueryPart... parts)
Record
DefaultDSLContext. fetchSingle(ResultSet rs)
Record
DefaultDSLContext. fetchSingle(ResultSet rs, Class<?>... types)
Record
DefaultDSLContext. fetchSingle(ResultSet rs, DataType<?>... types)
Record
DefaultDSLContext. fetchSingle(ResultSet rs, Field<?>... fields)
Record
DefaultDSLContext. fetchSingle(Collection<? extends SelectField<?>> fields)
Record
DefaultDSLContext. fetchSingle(SelectField<?>... fields)
Record
DefaultDSLContext. fetchSingle(SQL sql)
Record
UpdatableRecordImpl. key()
Record
DefaultDSLContext. newRecord(Collection<? extends Field<?>> fields)
Record
DefaultDSLContext. newRecord(Field<?>... fields)
Methods in org.jooq.impl that return types with arguments of type Record Modifier and Type Method Description CreateViewAsStep<Record>
DefaultDSLContext. createOrReplaceView(String view, String... fields)
CreateViewAsStep<Record>
DefaultDSLContext. createOrReplaceView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createOrReplaceView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createOrReplaceView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createOrReplaceView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createOrReplaceView(Name view, Name... fields)
CreateViewAsStep<Record>
DefaultDSLContext. createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createOrReplaceView(Table<?> view, Field<?>... fields)
CreateViewAsStep<Record>
DefaultDSLContext. createView(String view, String... fields)
CreateViewAsStep<Record>
DefaultDSLContext. createView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createView(Name view, Name... fields)
CreateViewAsStep<Record>
DefaultDSLContext. createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createView(Table<?> view, Field<?>... fields)
CreateViewAsStep<Record>
DefaultDSLContext. createViewIfNotExists(String view, String... fields)
CreateViewAsStep<Record>
DefaultDSLContext. createViewIfNotExists(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createViewIfNotExists(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createViewIfNotExists(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createViewIfNotExists(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createViewIfNotExists(Name view, Name... fields)
CreateViewAsStep<Record>
DefaultDSLContext. createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
CreateViewAsStep<Record>
DefaultDSLContext. createViewIfNotExists(Table<?> view, Field<?>... fields)
static Table<Record>
DSL. dual()
TheDUAL
table to be used for syntactic completeness.Result<Record>
DefaultDSLContext. fetch(String sql)
Result<Record>
DefaultDSLContext. fetch(String sql, Object... bindings)
Result<Record>
DefaultDSLContext. fetch(String sql, QueryPart... parts)
Result<Record>
DefaultDSLContext. fetch(ResultSet rs)
Result<Record>
DefaultDSLContext. fetch(ResultSet rs, Class<?>... types)
Result<Record>
DefaultDSLContext. fetch(ResultSet rs, DataType<?>... types)
Result<Record>
DefaultDSLContext. fetch(ResultSet rs, Field<?>... fields)
Result<Record>
DefaultDSLContext. fetch(SQL sql)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(String sql)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(String sql, Object... bindings)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(String sql, QueryPart... parts)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(ResultSet rs)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(ResultSet rs, Class<?>... types)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(ResultSet rs, DataType<?>... types)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(ResultSet rs, Field<?>... fields)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(Executor executor, String sql)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(Executor executor, String sql, Object... bindings)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(Executor executor, String sql, QueryPart... parts)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(Executor executor, ResultSet rs)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(Executor executor, ResultSet rs, Class<?>... types)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(Executor executor, ResultSet rs, DataType<?>... types)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(Executor executor, ResultSet rs, Field<?>... fields)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(Executor executor, SQL sql)
CompletionStage<Result<Record>>
DefaultDSLContext. fetchAsync(SQL sql)
Result<Record>
DefaultDSLContext. fetchFromCSV(String string)
Result<Record>
DefaultDSLContext. fetchFromCSV(String string, boolean header)
Result<Record>
DefaultDSLContext. fetchFromCSV(String string, boolean header, char delimiter)
Result<Record>
DefaultDSLContext. fetchFromCSV(String string, char delimiter)
Result<Record>
DefaultDSLContext. fetchFromHTML(String string)
Result<Record>
DefaultDSLContext. fetchFromJSON(String string)
Result<Record>
DefaultDSLContext. fetchFromStringData(String[]... strings)
Result<Record>
DefaultDSLContext. fetchFromStringData(List<String[]> strings)
Result<Record>
DefaultDSLContext. fetchFromStringData(List<String[]> strings, boolean header)
Result<Record>
DefaultDSLContext. fetchFromTXT(String string)
Result<Record>
DefaultDSLContext. fetchFromTXT(String string, String nullLiteral)
Result<Record>
DefaultDSLContext. fetchFromXML(String string)
Cursor<Record>
DefaultDSLContext. fetchLazy(String sql)
Cursor<Record>
DefaultDSLContext. fetchLazy(String sql, Object... bindings)
Cursor<Record>
DefaultDSLContext. fetchLazy(String sql, QueryPart... parts)
Cursor<Record>
DefaultDSLContext. fetchLazy(ResultSet rs)
Cursor<Record>
DefaultDSLContext. fetchLazy(ResultSet rs, Class<?>... types)
Cursor<Record>
DefaultDSLContext. fetchLazy(ResultSet rs, DataType<?>... types)
Cursor<Record>
DefaultDSLContext. fetchLazy(ResultSet rs, Field<?>... fields)
Cursor<Record>
DefaultDSLContext. fetchLazy(SQL sql)
Optional<Record>
DefaultDSLContext. fetchOptional(String sql)
Optional<Record>
DefaultDSLContext. fetchOptional(String sql, Object... bindings)
Optional<Record>
DefaultDSLContext. fetchOptional(String sql, QueryPart... parts)
Optional<Record>
DefaultDSLContext. fetchOptional(ResultSet rs)
Optional<Record>
DefaultDSLContext. fetchOptional(ResultSet rs, Class<?>... types)
Optional<Record>
DefaultDSLContext. fetchOptional(ResultSet rs, DataType<?>... types)
Optional<Record>
DefaultDSLContext. fetchOptional(ResultSet rs, Field<?>... fields)
Optional<Record>
DefaultDSLContext. fetchOptional(SQL sql)
Stream<Record>
DefaultDSLContext. fetchStream(String sql)
Stream<Record>
DefaultDSLContext. fetchStream(String sql, Object... bindings)
Stream<Record>
DefaultDSLContext. fetchStream(String sql, QueryPart... parts)
Stream<Record>
DefaultDSLContext. fetchStream(ResultSet rs)
Stream<Record>
DefaultDSLContext. fetchStream(ResultSet rs, Class<?>... types)
Stream<Record>
DefaultDSLContext. fetchStream(ResultSet rs, DataType<?>... types)
Stream<Record>
DefaultDSLContext. fetchStream(ResultSet rs, Field<?>... fields)
Stream<Record>
DefaultDSLContext. fetchStream(SQL sql)
Result<Record>
DefaultDSLContext. newResult(Collection<? extends Field<?>> fields)
Result<Record>
DefaultDSLContext. newResult(Field<?>... fields)
static <T1> RecordType<Record>
DSL. recordType(Collection<? extends Field<?>> fields)
Create aRecordType
of an arbitrary degree.static <T1> RecordType<Record>
DSL. recordType(Field<?>[] fields)
Create aRecordType
of an arbitrary degree.ResultQuery<Record>
DefaultDSLContext. resultQuery(String sql)
ResultQuery<Record>
DefaultDSLContext. resultQuery(String sql, Object... bindings)
ResultQuery<Record>
DefaultDSLContext. resultQuery(String sql, QueryPart... parts)
ResultQuery<Record>
DefaultDSLContext. resultQuery(SQL sql)
static ResultQuery<Record>
DSL. resultQuery(String sql)
Create a new query holding plain SQL.static ResultQuery<Record>
DSL. resultQuery(String sql, Object... bindings)
Create a new query holding plain SQL.static ResultQuery<Record>
DSL. resultQuery(String sql, QueryPart... parts)
Create a new query holding plain SQL.static ResultQuery<Record>
DSL. resultQuery(SQL sql)
Create a new query holding plain SQL.static Field<Record>
DSL. rowField(RowN row)
EXPERIMENTAL: Turn a row value expression of arbitrary degree into aField
.static Table<Record>
DSL. rowsFrom(Table<?>... tables)
Create aROWS FROM (tables...)
expression.SelectSelectStep<Record>
DefaultDSLContext. select(Collection<? extends SelectFieldOrAsterisk> fields)
SelectSelectStep<Record>
DefaultDSLContext. select(SelectFieldOrAsterisk... fields)
static SelectSelectStep<Record>
DSL. select(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL subselect statement.static SelectSelectStep<Record>
DSL. select(SelectFieldOrAsterisk... fields)
Create a new DSL subselect statement.SelectSelectStep<Record>
DefaultDSLContext. selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
SelectSelectStep<Record>
DefaultDSLContext. selectDistinct(SelectFieldOrAsterisk... fields)
static SelectSelectStep<Record>
DSL. selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL subselect statement.static SelectSelectStep<Record>
DSL. selectDistinct(SelectFieldOrAsterisk... fields)
Create a new DSL subselect statement.SelectWhereStep<Record>
DefaultDSLContext. selectFrom(String sql)
SelectWhereStep<Record>
DefaultDSLContext. selectFrom(String sql, Object... bindings)
SelectWhereStep<Record>
DefaultDSLContext. selectFrom(String sql, QueryPart... parts)
SelectWhereStep<Record>
DefaultDSLContext. selectFrom(Name table)
SelectWhereStep<Record>
DefaultDSLContext. selectFrom(SQL sql)
static SelectWhereStep<Record>
DSL. selectFrom(String sql)
Create a new DSL select statement, projecting*
.static SelectWhereStep<Record>
DSL. selectFrom(String sql, Object... bindings)
Create a new DSL select statement, projecting*
.static SelectWhereStep<Record>
DSL. selectFrom(String sql, QueryPart... parts)
Create a new DSL select statement, projecting*
.static SelectWhereStep<Record>
DSL. selectFrom(Name table)
Create a new DSL select statement, projecting*
.static SelectWhereStep<Record>
DSL. selectFrom(SQL sql)
Create a new DSL select statement, projecting*
.SelectQuery<Record>
DefaultDSLContext. selectQuery()
static Table<Record>
DSL. table(String sql)
A custom SQL clause that can render arbitrary table expressions.static Table<Record>
DSL. table(String sql, Object... bindings)
A custom SQL clause that can render arbitrary table expressions.static Table<Record>
DSL. table(String sql, QueryPart... parts)
A custom SQL clause that can render arbitrary table expressions.static Table<Record>
DSL. table(Name name)
Create a qualified table, given its table name.static Table<Record>
DSL. table(Name name, Comment comment)
Create a qualified table, given its table name.static Table<Record>
DSL. table(SQL sql)
A custom SQL clause that can render arbitrary table expressions.static Table<Record>
DSL. tableByName(String... qualifiedName)
Deprecated.- [#3843] - 3.6.0 - useDSL.table(Name)
insteadTruncateIdentityStep<Record>
DefaultDSLContext. truncate(String table)
TruncateIdentityStep<Record>
DefaultDSLContext. truncate(Name table)
static TruncateIdentityStep<Record>
DSL. truncate(String table)
Create a new DSL truncate statement.static TruncateIdentityStep<Record>
DSL. truncate(Name table)
Create a new DSL truncate statement.TruncateIdentityStep<Record>
DefaultDSLContext. truncateTable(String table)
TruncateIdentityStep<Record>
DefaultDSLContext. truncateTable(Name table)
static TruncateIdentityStep<Record>
DSL. truncateTable(String table)
Create a new DSL truncate statement.static TruncateIdentityStep<Record>
DSL. truncateTable(Name table)
Create a new DSL truncate statement.static Table<Record>
DSL. values(RowN... rows)
Create aVALUES()
expression of arbitrary degree.Methods in org.jooq.impl with parameters of type Record Modifier and Type Method Description static Condition
DSL. condition(Record record)
static <R extends Record>
Table<R>DSL. table(R... records)
Use a previously obtained set of records as a new Table -
Uses of Record in org.jooq.tools.jdbc
Methods in org.jooq.tools.jdbc with parameters of type Record Modifier and Type Method Description static MockDataProvider
Mock. of(Record record)
Create a newMockDataProvider
that always returns a single record for all queries.Constructors in org.jooq.tools.jdbc with parameters of type Record Constructor Description MockResult(Record data)
Create a newMockResult
. -
Uses of Record in org.jooq.util.aurorapostgres
Fields in org.jooq.util.aurorapostgres with type parameters of type Record Modifier and Type Field Description static DataType<Result<Record>>
AuroraPostgresDataType. REFCURSOR
Deprecated. -
Uses of Record in org.jooq.util.h2
Fields in org.jooq.util.h2 with type parameters of type Record Modifier and Type Field Description protected static DataType<Result<Record>>
H2DataType. __RESULT
Deprecated. -
Uses of Record in org.jooq.util.hsqldb
Fields in org.jooq.util.hsqldb with type parameters of type Record Modifier and Type Field Description static DataType<Result<Record>>
HSQLDBDataType. ROW
Deprecated. -
Uses of Record in org.jooq.util.oracle
Fields in org.jooq.util.oracle with type parameters of type Record Modifier and Type Field Description static DataType<Result<Record>>
OracleDataType. REF_CURSOR
Deprecated. -
Uses of Record in org.jooq.util.postgres
Fields in org.jooq.util.postgres with type parameters of type Record Modifier and Type Field Description static DataType<Result<Record>>
PostgresDataType. REFCURSOR
Deprecated.Methods in org.jooq.util.postgres that return types with arguments of type Record Modifier and Type Method Description static Table<Record>
PostgresDSL. only(Table<?> table)
Get the PostgreSQL-specificONLY [table]
clause for use with table inheritance.Methods in org.jooq.util.postgres with parameters of type Record Modifier and Type Method Description static String
PostgresUtils. toPGString(Record r)
Create a PostgreSQL string representation of a record. -
Uses of Record in org.jooq.util.redshift
Fields in org.jooq.util.redshift with type parameters of type Record Modifier and Type Field Description static DataType<Result<Record>>
RedshiftDataType. REFCURSOR
Deprecated. -
Uses of Record in org.jooq.util.vertica
Fields in org.jooq.util.vertica with type parameters of type Record Modifier and Type Field Description static DataType<Result<Record>>
VerticaDataType. ROW
Deprecated.
-