Uses of Interface
org.jooq.Record
-
Packages that use Record Package Description org.jooq This package contains jOOQ's public API.org.jooq.impl This package contains jOOQ's implementation classes.org.jooq.tools.jdbc This package contains compatibility classes to bridge between JDBC 4.0 and JDBC 4.1.org.jooq.util.aurorapostgres This package contains classes related to theSQLDialect.AURORA_POSTGRES
dialect family.org.jooq.util.h2 This package contains classes related to theSQLDialect.H2
dialect family.org.jooq.util.hsqldb This package contains classes related to theSQLDialect.HSQLDB
dialect family.org.jooq.util.oracle This package contains classes related to theSQLDialect.ORACLE
dialect family.org.jooq.util.postgres This package contains classes related to theSQLDialect.POSTGRES
dialect family.org.jooq.util.redshift This package contains classes related to theSQLDialect.REDSHIFT
dialect family.org.jooq.util.vertica This package contains classes related to theSQLDialect.VERTICA
dialect family. -
-
Uses of Record in org.jooq
Classes in org.jooq with type parameters of type Record Modifier and Type Interface Description interface
BetweenAndStepR<R extends Record>
An intermediate DSL type for the construction of aBETWEEN
predicate.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
InsertOnConflictWhereIndexPredicateStep<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>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep2<R extends Record,T1,T2>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep3<R extends Record,T1,T2,T3>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep4<R extends Record,T1,T2,T3,T4>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep5<R extends Record,T1,T2,T3,T4,T5>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep6<R extends Record,T1,T2,T3,T4,T5,T6>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeKeyStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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
MergeMatchedThenStep<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>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep2<R extends Record,T1,T2>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep3<R extends Record,T1,T2,T3>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep4<R extends Record,T1,T2,T3,T4>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep5<R extends Record,T1,T2,T3,T4,T5>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
interface
MergeValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
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 by
.SelectQuery
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
SelectCorrelatedSubqueryStep<R extends Record>
interface
SelectDistinctOnStep<R extends Record>
interface
SelectFinalStep<R extends Record>
interface
SelectForJSONCommonDirectivesStep<R extends Record>
interface
SelectForJSONStep<R extends Record>
interface
SelectForStep<R extends Record>
interface
SelectForUpdateOfStep<R extends Record>
interface
SelectForUpdateStep<R extends Record>
interface
SelectForUpdateWaitStep<R extends Record>
interface
SelectForXMLCommonDirectivesStep<R extends Record>
interface
SelectForXMLPathDirectivesStep<R extends Record>
interface
SelectForXMLRawDirectivesStep<R extends Record>
interface
SelectForXMLStep<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>
@NotNull CommonTableExpression<R>DerivedColumnList. as(Select<R> select)
Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>Name. as(Select<R> select)
Specify a subselect to refer to by theName
to form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>DerivedColumnList. asMaterialized(Select<R> select)
Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>Name. asMaterialized(Select<R> select)
Specify a materialized subselect to refer to by theName
to form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>DerivedColumnList. asNotMaterialized(Select<R> select)
Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R>Name. asNotMaterialized(Select<R> select)
Specify a non-materialized subselect to refer to by theName
to form a common table expression.<X extends Record>
@NotNull ResultQuery<X>ResultQuery. coerce(Table<X> table)
Coerce the result record type of this query to that of a table.<R extends Record>
@NotNull DeleteUsingStep<R>DSLContext. delete(Table<R> table)
Create a new DSL delete statement.<R extends Record>
@NotNull DeleteUsingStep<R>WithStep. delete(Table<R> table)
Create a new DSL delete statement.<R extends Record>
@NotNull DeleteUsingStep<R>DSLContext. deleteFrom(Table<R> table)
Create a new DSL delete statement.<R extends Record>
@NotNull DeleteQuery<R>DSLContext. deleteQuery(Table<R> table)
Create a newDeleteQuery
<R extends Record>
@NotNull Result<R>DSLContext. fetch(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return results.<R extends Record>
@NotNull Result<R>DSLContext. fetch(Table<R> table)
Execute and return all records for<R extends Record>
@NotNull Result<R>DSLContext. fetch(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records for<R extends Record>
@NotNull Result<R>DSLContext. fetch(Table<R> table, Condition condition)
Execute and return all records for<R extends Record>
@NotNull 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 on e record for<Z extends Record>
ZResultQuery. fetchAnyInto(Table<Z> table)
Map resulting records onto a custom record.<R extends Record>
@NotNull 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>
@NotNull CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table)
Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table, Condition condition)
Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext. fetchAsync(Executor executor, Table<R> table, Condition... conditions)
Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext. fetchAsync(ResultQuery<R> query)
Fetch results in a newCompletionStage
.<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table)
Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table, Collection<? extends Condition> condition)
Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table, Condition condition)
Execute and return all records asynchronously for<R extends Record>
@NotNull CompletionStage<Result<R>>DSLContext. fetchAsync(Table<R> table, Condition... condition)
Execute and return all records asynchronously for<S extends Record>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull Result<Z>Cursor. fetchInto(Table<Z> table)
Map resulting records onto a custom record.<Z extends Record>
@NotNull Result<Z>ResultQuery. fetchInto(Table<Z> table)
Map resulting records onto a custom record.<R extends Record>
@NotNull Cursor<R>DSLContext. fetchLazy(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a cursor.<R extends Record>
@NotNull Cursor<R>DSLContext. fetchLazy(Table<R> table)
Execute and return all records lazily for<R extends Record>
@NotNull Cursor<R>DSLContext. fetchLazy(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records lazily for<R extends Record>
@NotNull Cursor<R>DSLContext. fetchLazy(Table<R> table, Condition condition)
Execute and return all records lazily for<R extends Record>
@NotNull Cursor<R>DSLContext. fetchLazy(Table<R> table, Condition... conditions)
Execute and return all records lazily for<R extends Record>
@NotNull ResultsDSLContext. fetchMany(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a cursor.<S extends Record>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull Optional<R>DSLContext. fetchOptional(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a record.<R extends Record>
@NotNull Optional<R>DSLContext. fetchOptional(Table<R> table)
Execute and return zero or one record for<R extends Record>
@NotNull Optional<R>DSLContext. fetchOptional(Table<R> table, Collection<? extends Condition> conditions)
Execute and return zero or one record for<R extends Record>
@NotNull Optional<R>DSLContext. fetchOptional(Table<R> table, Condition condition)
Execute and return zero or one record for<R extends Record>
@NotNull Optional<R>DSLContext. fetchOptional(Table<R> table, Condition... conditions)
Execute and return zero or one record for<Z extends Record>
@NotNull Optional<Z>Cursor. fetchOptionalInto(Table<Z> table)
Deprecated.- 3.10 - [#6363] - UseCursor.fetchNextOptionalInto(Table)
instead.<Z extends Record>
@NotNull 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>
@NotNull Stream<R>DSLContext. fetchStream(ResultQuery<R> query)
Execute aResultQuery
in the context of thisDSLContext
and return a stream.<R extends Record>
@NotNull Stream<R>DSLContext. fetchStream(Table<R> table)
Execute and return all records lazily for<R extends Record>
@NotNull Stream<R>DSLContext. fetchStream(Table<R> table, Collection<? extends Condition> conditions)
Execute and return all records lazily for<R extends Record>
@NotNull Stream<R>DSLContext. fetchStream(Table<R> table, Condition condition)
Execute and return all records lazily for<R extends Record>
@NotNull Stream<R>DSLContext. fetchStream(Table<R> table, Condition... conditions)
Execute and return all records lazily for<Z extends Record>
@NotNull Stream<Z>ResultQuery. fetchStreamInto(Table<Z> table)
Stream this query, mapping records into a custom record.<O extends Record>
@NotNull 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>
@NotNull 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>
@NotNull InsertSetStep<R>DSLContext. insertInto(Table<R> into)
Create a new DSL insert statement.<R extends Record>
@NotNull InsertValuesStepN<R>DSLContext. insertInto(Table<R> into, Collection<? extends Field<?>> fields)
Create a new DSL insert statement.<R extends Record>
@NotNull InsertValuesStepN<R>DSLContext. insertInto(Table<R> into, Field<?>... fields)
Create a new DSL insert statement.<R extends Record,T1>
@NotNull InsertValuesStep1<R,T1>DSLContext. insertInto(Table<R> into, Field<T1> field1)
Create a new DSL insert statement.<R extends Record,T1,T2>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull InsertSetStep<R>WithStep. insertInto(Table<R> into)
Create a new DSL insert statement.<R extends Record>
@NotNull InsertValuesStepN<R>WithStep. insertInto(Table<R> into, Collection<? extends Field<?>> fields)
Create a new DSL insert statement.<R extends Record>
@NotNull InsertValuesStepN<R>WithStep. insertInto(Table<R> into, Field<?>... fields)
Create a new DSL insert statement.<R extends Record,T1>
@NotNull InsertValuesStep1<R,T1>WithStep. insertInto(Table<R> into, Field<T1> field1)
Create a new DSL insert statement.<R extends Record,T1,T2>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull Result<Z>Result. into(Table<Z> table)
Map resulting records onto a custom record.<S extends Record>
@NotNull Map<S,Result<R>>Result. intoGroups(Table<S> table)
Return aMap
with the result grouped by the given key table.<E,S extends Record>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull LoaderOptionsStep<R>DSLContext. loadInto(Table<R> table)
Create a newLoader
object to load data from a CSV or XML source.<R extends Record>
@Nullable Table<R>DSLContext. map(Table<R> table)
Map a table to another one.<R extends Record>
@Nullable Table<R>SchemaMapping. map(Table<R> table)
Deprecated.Apply mapping to a given table<R extends Record>
@NotNull MergeUsingStep<R>DSLContext. mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.<R extends Record>
@NotNull MergeKeyStepN<R>DSLContext. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record>
@NotNull MergeKeyStepN<R>DSLContext. mergeInto(Table<R> table, Field<?>... fields)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1>
@NotNull MergeKeyStep1<R,T1>DSLContext. mergeInto(Table<R> table, Field<T1> field1)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2>
@NotNull MergeKeyStep2<R,T1,T2>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3>
@NotNull MergeKeyStep3<R,T1,T2,T3>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4>
@NotNull MergeKeyStep4<R,T1,T2,T3,T4>DSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<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>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSLContext.mergeInto(Table)
<R extends Record>
@NotNull MergeUsingStep<R>WithStep. mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.<R extends Record>
@NotNull MergeKeyStepN<R>WithStep. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
Create a new DSL merge statement (H2-specific syntax).<R extends Record>
@NotNull MergeKeyStepN<R>WithStep. mergeInto(Table<R> table, Field<?>... fields)
Create a new DSL merge statement (H2-specific syntax).<R extends Record,T1>
@NotNull MergeKeyStep1<R,T1>WithStep. mergeInto(Table<R> table, Field<T1> field1)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2>
@NotNull MergeKeyStep2<R,T1,T2>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3>
@NotNull MergeKeyStep3<R,T1,T2,T3>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4>
@NotNull MergeKeyStep4<R,T1,T2,T3,T4>WithStep. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<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>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaWithStep.mergeInto(Table)
<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>
@NotNull Result<R>DSLContext. newResult(Table<R> table)
Create a new emptyResult
.<R extends Record,E>
@NotNull RecordMapper<R,E>RecordMapperProvider. provide(RecordType<R> recordType, Class<? extends E> type)
Provide aRecordMapper
instance.<E,R extends Record>
@NotNull RecordUnmapper<E,R>RecordUnmapperProvider. provide(Class<? extends E> type, RecordType<R> recordType)
Provide aRecordUnmapper
instance.<R extends Record>
@NotNull SelectWhereStep<R>DSLContext. selectFrom(Table<R> table)
Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
@NotNull SelectWhereStep<R>WithStep. selectFrom(Table<R> table)
Create a new DSL select statement, projecting the known columns from a table.<R extends Record>
@NotNull SelectQuery<R>DSLContext. selectQuery(TableLike<R> table)
Create a newSelectQuery
<R extends Record>
@NotNull TruncateIdentityStep<R>DSLContext. truncate(Table<R> table)
Create a new DSL truncate statement.<R extends Record>
@NotNull TruncateIdentityStep<R>DSLContext. truncateTable(Table<R> table)
Create a new DSL truncate statement.<R extends Record>
@NotNull UpdateSetFirstStep<R>DSLContext. update(Table<R> table)
Create a new DSL update statement.<R extends Record>
@NotNull UpdateSetFirstStep<R>WithStep. update(Table<R> table)
Create a new DSL update statement.<R extends Record>
@NotNull UpdateQuery<R>DSLContext. updateQuery(Table<R> table)
Create a newUpdateQuery
Methods in org.jooq that return Record Modifier and Type Method Description @NotNull Record[]
RecordContext. batchRecords()
TheRecord
(s) that are being manipulated in batch mode.@NotNull R[]
ResultQuery. fetchArray()
Execute the query and return the generated result as an array of records.@Nullable Record
DSLContext. fetchOne(String sql)
Execute a new query holding plain SQL.@Nullable Record
DSLContext. fetchOne(String sql, Object... bindings)
Execute a new query holding plain SQL.@Nullable Record
DSLContext. fetchOne(String sql, QueryPart... parts)
Execute a new query holding plain SQL.@Nullable Record
DSLContext. fetchOne(ResultSet rs)
@Nullable Record
DSLContext. fetchOne(ResultSet rs, Class<?>... types)
@Nullable Record
DSLContext. fetchOne(ResultSet rs, DataType<?>... types)
@Nullable Record
DSLContext. fetchOne(ResultSet rs, Field<?>... fields)
@Nullable Record
DSLContext. fetchOne(SQL sql)
Execute a new query holding plain SQL.@NotNull Record
DSLContext. fetchSingle(String sql)
Execute a new query holding plain SQL.@NotNull Record
DSLContext. fetchSingle(String sql, Object... bindings)
Execute a new query holding plain SQL.@NotNull Record
DSLContext. fetchSingle(String sql, QueryPart... parts)
Execute a new query holding plain SQL.@NotNull Record
DSLContext. fetchSingle(ResultSet rs)
@NotNull Record
DSLContext. fetchSingle(ResultSet rs, Class<?>... types)
@NotNull Record
DSLContext. fetchSingle(ResultSet rs, DataType<?>... types)
@NotNull Record
DSLContext. fetchSingle(ResultSet rs, Field<?>... fields)
@NotNull Record
DSLContext. fetchSingle(Collection<? extends SelectField<?>> fields)
Execute and return exactly one record for@NotNull Record
DSLContext. fetchSingle(SelectField<?>... fields)
Execute and return exactly one record for@NotNull Record
DSLContext. fetchSingle(SQL sql)
Execute a new query holding plain SQL.@NotNull Record
Record. into(Field<?>... fields)
Copy this record into a new record holding only a subset of the previous fields.@NotNull Record
UpdatableRecord. key()
A Record copy holding values for theTable.getPrimaryKey()
.@NotNull Record
DSLContext. newRecord(Collection<? extends Field<?>> fields)
Create a new emptyRecord
.@NotNull Record
DSLContext. newRecord(Field<?>... fields)
Create a new emptyRecord
.@NotNull Record
Record. original()
Get this record containing the original values as fetched from the database.@Nullable Record
ExecuteContext. record()
The last record that was fetched from the result set, ornull
if no record has been fetched.@NotNull Record
RecordContext. record()
TheRecord
that is being manipulated.<T> @NotNull Record
Record. with(Field<T> field, T value)
Set a value into this record.<T,U>
@NotNull 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 @NotNull ResultQuery<Record>
ResultQuery. coerce(Collection<? extends Field<?>> fields)
Coerce the result record type of this query to that of a set of fields.@NotNull ResultQuery<Record>
ResultQuery. coerce(Field<?>... fields)
Coerce the result record type of this query to that of a set of fields.@NotNull CreateViewAsStep<Record>
DSLContext. createOrReplaceView(String view, String... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext. createOrReplaceView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createOrReplaceView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Name view, Name... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createOrReplaceView(Table<?> view, Field<?>... fields)
Create a new DSLCREATE OR REPLACE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext. createView(String view, String... fields)
Create a new DSLCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext. createView(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createView(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createView(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createView(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createView(Name view, Name... fields)
Create a new DSLCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext. createView(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createView(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createView(Table<?> view, Field<?>... fields)
Create a new DSLCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(String view, String... fields)
Create a new DSLCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(String view, BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(String view, Function<? super Field<?>,? extends String> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Name view, BiFunction<? super Field<?>,? super Integer,? extends Name> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Name view, Function<? super Field<?>,? extends Name> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Name view, Name... fields)
Create a new DSLCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Table<?> view, BiFunction<? super Field<?>,? super Integer,? extends Field<?>> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Table<?> view, Function<? super Field<?>,? extends Field<?>> fieldNameFunction)
Deprecated.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext. createViewIfNotExists(Table<?> view, Field<?>... fields)
Create a new DSLCREATE VIEW
statement.@NotNull Table<Record>
Table. crossApply(String sql)
CROSS APPLY
a table to this table.@NotNull Table<Record>
Table. crossApply(String sql, Object... bindings)
CROSS APPLY
a table to this table.@NotNull Table<Record>
Table. crossApply(String sql, QueryPart... parts)
CROSS APPLY
a table to this table.@NotNull Table<Record>
Table. crossApply(Name name)
CROSS APPLY
a table to this table.@NotNull Table<Record>
Table. crossApply(SQL sql)
CROSS APPLY
a table to this table.@NotNull Table<Record>
Table. crossApply(TableLike<?> table)
CROSS APPLY
a table to this table.@NotNull Table<Record>
Table. crossJoin(String sql)
CROSS JOIN
a table to this table.@NotNull Table<Record>
Table. crossJoin(String sql, Object... bindings)
CROSS JOIN
a table to this table.@NotNull Table<Record>
Table. crossJoin(String sql, QueryPart... parts)
CROSS JOIN
a table to this table.@NotNull Table<Record>
Table. crossJoin(Name name)
CROSS JOIN
a table to this table.@NotNull Table<Record>
Table. crossJoin(SQL sql)
CROSS JOIN
a table to this table.@NotNull Table<Record>
Table. crossJoin(TableLike<?> table)
CROSS JOIN
a table to this table.@NotNull Result<Record>
DSLContext. fetch(String sql)
Execute a new query holding plain SQL.@NotNull Result<Record>
DSLContext. fetch(String sql, Object... bindings)
Execute a new query holding plain SQL.@NotNull Result<Record>
DSLContext. fetch(String sql, QueryPart... parts)
Execute a new query holding plain SQL.@NotNull Result<Record>
DSLContext. fetch(ResultSet rs)
@NotNull Result<Record>
DSLContext. fetch(ResultSet rs, Class<?>... types)
@NotNull Result<Record>
DSLContext. fetch(ResultSet rs, DataType<?>... types)
@NotNull Result<Record>
DSLContext. fetch(ResultSet rs, Field<?>... fields)
@NotNull Result<Record>
DSLContext. fetch(SQL sql)
Execute a new query holding plain SQL.@NotNull CompletionStage<Result<Record>>
DSLContext. fetchAsync(String sql)
Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext. fetchAsync(String sql, Object... bindings)
Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext. fetchAsync(String sql, QueryPart... parts)
Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext. fetchAsync(ResultSet rs)
Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext. fetchAsync(ResultSet rs, Class<?>... types)
Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext. fetchAsync(ResultSet rs, DataType<?>... types)
Fetch results in a newCompletionStage
.@NotNull CompletionStage<Result<Record>>
DSLContext. fetchAsync(ResultSet rs, Field<?>... fields)
Fetch results in a newCompletionStage
.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull CompletionStage<Result<Record>>
DSLContext. fetchAsync(SQL sql)
Fetch results in a newCompletionStage
.@NotNull Result<Record>
DSLContext. fetchFromCSV(String string)
Fetch all data from a CSV string.@NotNull Result<Record>
DSLContext. fetchFromCSV(String string, boolean header)
Fetch all data from a CSV string.@NotNull Result<Record>
DSLContext. fetchFromCSV(String string, boolean header, char delimiter)
Fetch all data from a CSV string.@NotNull Result<Record>
DSLContext. fetchFromCSV(String string, char delimiter)
Fetch all data from a CSV string.@NotNull Result<Record>
DSLContext. fetchFromHTML(String string)
Convert an HTML table into a jOOQResult
.@NotNull Result<Record>
DSLContext. fetchFromJSON(String string)
Fetch all data from a JSON string.@NotNull Result<Record>
DSLContext. fetchFromStringData(String[]... data)
Fetch all data from a list of strings.@NotNull Result<Record>
DSLContext. fetchFromStringData(List<String[]> data)
Fetch all data from a list of strings.@NotNull Result<Record>
DSLContext. fetchFromStringData(List<String[]> data, boolean header)
Fetch all data from a list of strings.@NotNull Result<Record>
DSLContext. fetchFromTXT(String string)
Fetch all data from a formatted string.@NotNull Result<Record>
DSLContext. fetchFromTXT(String string, String nullLiteral)
Fetch all data from a formatted string.@NotNull Result<Record>
DSLContext. fetchFromXML(String string)
Fetch all data from an XML string.@NotNull Map<Record,Result<R>>
ResultQuery. fetchGroups(int[] keyFieldIndexes)
Execute the query and return aMap
with the result grouped by the given keys.@NotNull Map<Record,Result<Record>>
ResultQuery. fetchGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)
Execute the query and return aMap
with the result grouped by the given keys.@NotNull 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> @NotNull 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> @NotNull 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.@NotNull Map<Record,Result<R>>
ResultQuery. fetchGroups(String[] keyFieldNames)
Execute the query and return aMap
with the result grouped by the given keys.<E> @NotNull 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.@NotNull Map<Record,Result<Record>>
ResultQuery. fetchGroups(String[] keyFieldNames, String[] valueFieldNames)
Execute the query and return aMap
with the result grouped by the given keys.@NotNull 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> @NotNull 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.@NotNull Map<Record,Result<R>>
ResultQuery. fetchGroups(Field<?>[] keys)
Execute the query and return aMap
with the result grouped by the given keys.<E> @NotNull 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.@NotNull Map<Record,Result<Record>>
ResultQuery. fetchGroups(Field<?>[] keys, Field<?>[] values)
Execute the query and return aMap
with the result grouped by the given keys.@NotNull 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> @NotNull 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.@NotNull Map<Record,Result<R>>
ResultQuery. fetchGroups(Name[] keyFieldNames)
Execute the query and return aMap
with the result grouped by the given keys.<E> @NotNull 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.@NotNull Map<Record,Result<Record>>
ResultQuery. fetchGroups(Name[] keyFieldNames, Name[] valueFieldNames)
Execute the query and return aMap
with the result grouped by the given keys.@NotNull 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> @NotNull 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.@NotNull Cursor<Record>
DSLContext. fetchLazy(String sql)
Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Cursor<Record>
DSLContext. fetchLazy(String sql, Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Cursor<Record>
DSLContext. fetchLazy(String sql, QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Cursor<Record>
DSLContext. fetchLazy(ResultSet rs)
@NotNull Cursor<Record>
DSLContext. fetchLazy(ResultSet rs, Class<?>... types)
@NotNull Cursor<Record>
DSLContext. fetchLazy(ResultSet rs, DataType<?>... types)
@NotNull Cursor<Record>
DSLContext. fetchLazy(ResultSet rs, Field<?>... fields)
@NotNull Cursor<Record>
DSLContext. fetchLazy(SQL sql)
Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull 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.@NotNull Optional<Record>
DSLContext. fetchOptional(String sql)
Execute a new query holding plain SQL.@NotNull Optional<Record>
DSLContext. fetchOptional(String sql, Object... bindings)
Execute a new query holding plain SQL.@NotNull Optional<Record>
DSLContext. fetchOptional(String sql, QueryPart... parts)
Execute a new query holding plain SQL.@NotNull Optional<Record>
DSLContext. fetchOptional(ResultSet rs)
@NotNull Optional<Record>
DSLContext. fetchOptional(ResultSet rs, Class<?>... types)
@NotNull Optional<Record>
DSLContext. fetchOptional(ResultSet rs, DataType<?>... types)
@NotNull Optional<Record>
DSLContext. fetchOptional(ResultSet rs, Field<?>... fields)
@NotNull Optional<Record>
DSLContext. fetchOptional(SQL sql)
Execute a new query holding plain SQL.@NotNull Stream<Record>
DSLContext. fetchStream(String sql)
Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Stream<Record>
DSLContext. fetchStream(String sql, Object... bindings)
Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Stream<Record>
DSLContext. fetchStream(String sql, QueryPart... parts)
Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Stream<Record>
DSLContext. fetchStream(ResultSet rs)
@NotNull Stream<Record>
DSLContext. fetchStream(ResultSet rs, Class<?>... types)
@NotNull Stream<Record>
DSLContext. fetchStream(ResultSet rs, DataType<?>... types)
@NotNull Stream<Record>
DSLContext. fetchStream(ResultSet rs, Field<?>... fields)
@NotNull Stream<Record>
DSLContext. fetchStream(SQL sql)
Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull TableOnStep<Record>
Table. fullJoin(String sql)
FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. fullJoin(String sql, Object... bindings)
FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. fullJoin(String sql, QueryPart... parts)
FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. fullJoin(Name name)
FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. fullJoin(SQL sql)
FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. fullJoin(TableLike<?> table)
FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. fullOuterJoin(String sql)
FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. fullOuterJoin(String sql, Object... bindings)
FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. fullOuterJoin(String sql, QueryPart... parts)
FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. fullOuterJoin(Name name)
FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. fullOuterJoin(SQL sql)
FULL OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. fullOuterJoin(TableLike<?> table)
FULL OUTER JOIN
a table to this table.@NotNull Table<Record>
PivotInStep. in(Collection<? extends Field<T>> fields)
Specify the acceptable values for pivoting@NotNull Table<Record>
PivotInStep. in(Field<?>... fields)
Specify the acceptable values for pivoting@NotNull Table<Record>
PivotInStep. in(T... values)
Specify the acceptable values for pivoting@NotNull TableOnStep<Record>
Table. innerJoin(String sql)
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. innerJoin(String sql, Object... bindings)
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. innerJoin(String sql, QueryPart... parts)
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. innerJoin(Name name)
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. innerJoin(SQL sql)
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. innerJoin(TableLike<?> table)
INNER JOIN
a table to this table.@NotNull 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.@NotNull SelectFromStep<Record>
SelectIntoStep. into(Table<?> table)
Add anINTO
clause to theSELECT
statement.@NotNull Map<Record,Result<R>>
Result. intoGroups(int[] keyFieldIndexes)
Return aMap
with the result grouped by the given keys.@NotNull Map<Record,Result<Record>>
Result. intoGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)
Return aMap
with the result grouped by the given keys.@NotNull Map<Record,Result<Record>>
Result. intoGroups(int[] keyFieldIndexes, int[] valueFieldIndexes)
Return aMap
with the result grouped by the given keys.<E> @NotNull 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> @NotNull 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.@NotNull Map<Record,Result<R>>
Result. intoGroups(String[] keyFieldNames)
Return aMap
with the result grouped by the given keys.<E> @NotNull 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.@NotNull Map<Record,Result<Record>>
Result. intoGroups(String[] keyFieldNames, String[] valueFieldNames)
Return aMap
with the result grouped by the given keys.@NotNull Map<Record,Result<Record>>
Result. intoGroups(String[] keyFieldNames, String[] valueFieldNames)
Return aMap
with the result grouped by the given keys.<E> @NotNull 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.@NotNull Map<Record,Result<R>>
Result. intoGroups(Field<?>[] keys)
Return aMap
with the result grouped by the given keys.<E> @NotNull 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.@NotNull Map<Record,Result<Record>>
Result. intoGroups(Field<?>[] keys, Field<?>[] values)
Return aMap
with the result grouped by the given keys.@NotNull Map<Record,Result<Record>>
Result. intoGroups(Field<?>[] keys, Field<?>[] values)
Return aMap
with the result grouped by the given keys.<E> @NotNull 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.@NotNull Map<Record,Result<R>>
Result. intoGroups(Name[] keyFieldNames)
Return aMap
with the result grouped by the given keys.<E> @NotNull 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.@NotNull Map<Record,Result<Record>>
Result. intoGroups(Name[] keyFieldNames, Name[] valueFieldNames)
Return aMap
with the result grouped by the given keys.@NotNull Map<Record,Result<Record>>
Result. intoGroups(Name[] keyFieldNames, Name[] valueFieldNames)
Return aMap
with the result grouped by the given keys.<E> @NotNull 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.@NotNull Map<Record,R>
Result. intoMap(int[] keyFieldIndexes)
Return aMap
with the given keys as a map key and the corresponding record as value.@NotNull 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.@NotNull 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.@NotNull Map<Record,R>
Result. intoMap(String[] keyFieldNames)
Return aMap
with the given keys as a map key and the corresponding record as value.@NotNull 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.@NotNull 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.@NotNull Map<Record,R>
Result. intoMap(Field<?>[] keys)
Return aMap
with the given keys as a map key and the corresponding record as value.@NotNull 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.@NotNull 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.@NotNull Map<Record,R>
Result. intoMap(Name[] keyFieldNames)
Return aMap
with the given keys as a map key and the corresponding record as value.@NotNull 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.@NotNull 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.@NotNull TableOnStep<Record>
Table. join(String sql)
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. join(String sql, Object... bindings)
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. join(String sql, QueryPart... parts)
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. join(Name name)
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. join(SQL sql)
INNER JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. join(TableLike<?> table)
INNER JOIN
a table to this table.@NotNull TableOptionalOnStep<Record>
Table. join(TableLike<?> table, JoinType type)
Join a table to this table using aJoinType
@NotNull TableOnStep<Record>
TableOuterJoinStep. join(TableLike<?> table, JoinType type)
Join a table to this table using aJoinType
.@NotNull TablePartitionByStep<Record>
Table. leftJoin(String sql)
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. leftJoin(String sql, Object... bindings)
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. leftJoin(String sql, QueryPart... parts)
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. leftJoin(Name name)
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. leftJoin(SQL sql)
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. leftJoin(TableLike<?> table)
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. leftJoin(String sql)
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. leftJoin(String sql, Object... bindings)
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. leftJoin(String sql, QueryPart... parts)
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. leftJoin(Name name)
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. leftJoin(SQL sql)
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. leftJoin(TableLike<?> table)
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. leftOuterJoin(String sql)
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. leftOuterJoin(String sql, Object... bindings)
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. leftOuterJoin(String sql, QueryPart... parts)
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. leftOuterJoin(Name name)
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. leftOuterJoin(SQL sql)
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. leftOuterJoin(TableLike<?> table)
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. leftOuterJoin(String sql)
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. leftOuterJoin(String sql, Object... bindings)
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. leftOuterJoin(String sql, QueryPart... parts)
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. leftOuterJoin(Name name)
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. leftOuterJoin(SQL sql)
LEFT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. leftOuterJoin(TableLike<?> table)
LEFT OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalFullOuterJoin(String sql)
NATURAL FULL OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalFullOuterJoin(String sql, Object... bindings)
NATURAL FULL OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalFullOuterJoin(String sql, QueryPart... parts)
NATURAL FULL OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalFullOuterJoin(Name name)
NATURAL FULL OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalFullOuterJoin(SQL sql)
NATURAL FULL OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalFullOuterJoin(TableLike<?> table)
NATURAL FULL OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalJoin(String sql)
NATURAL JOIN
a table to this table.@NotNull Table<Record>
Table. naturalJoin(String sql, Object... bindings)
NATURAL JOIN
a table to this table.@NotNull Table<Record>
Table. naturalJoin(String sql, QueryPart... parts)
NATURAL JOIN
a table to this table.@NotNull Table<Record>
Table. naturalJoin(Name name)
NATURAL JOIN
a table to this table.@NotNull Table<Record>
Table. naturalJoin(SQL sql)
NATURAL JOIN
a table to this table.@NotNull Table<Record>
Table. naturalJoin(TableLike<?> table)
NATURAL JOIN
a table to this table.@NotNull Table<Record>
Table. naturalLeftOuterJoin(String sql)
NATURAL LEFT OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalLeftOuterJoin(String sql, Object... bindings)
NATURAL LEFT OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalLeftOuterJoin(String sql, QueryPart... parts)
NATURAL LEFT OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalLeftOuterJoin(Name name)
NATURAL LEFT OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalLeftOuterJoin(SQL sql)
NATURAL LEFT OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalLeftOuterJoin(TableLike<?> table)
NATURAL LEFT OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalRightOuterJoin(String sql)
NATURAL RIGHT OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalRightOuterJoin(String sql, Object... bindings)
NATURAL RIGHT OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalRightOuterJoin(String sql, QueryPart... parts)
NATURAL RIGHT OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalRightOuterJoin(Name name)
NATURAL RIGHT OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalRightOuterJoin(SQL sql)
NATURAL RIGHT OUTER JOIN
a table to this table.@NotNull Table<Record>
Table. naturalRightOuterJoin(TableLike<?> table)
NATURAL RIGHT OUTER JOIN
a table to this table.@NotNull Result<Record>
DSLContext. newResult(Collection<? extends Field<?>> fields)
Create a new emptyRecord
.@NotNull Result<Record>
DSLContext. newResult(Field<?>... fields)
Create a new emptyRecord
.@NotNull Table<Record>
Table. outerApply(String sql)
OUTER APPLY
a table to this table.@NotNull Table<Record>
Table. outerApply(String sql, Object... bindings)
OUTER APPLY
a table to this table.@NotNull Table<Record>
Table. outerApply(String sql, QueryPart... parts)
OUTER APPLY
a table to this table.@NotNull Table<Record>
Table. outerApply(Name name)
OUTER APPLY
a table to this table.@NotNull Table<Record>
Table. outerApply(SQL sql)
OUTER APPLY
a table to this table.@NotNull Table<Record>
Table. outerApply(TableLike<?> table)
OUTER APPLY
a table to this table.@NotNull TableOuterJoinStep<Record>
Table. partitionBy(Collection<? extends Field<?>> fields)
Add aPARTITION BY
clause to the left hand side of theOUTER JOIN
keywords@NotNull TableOuterJoinStep<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.@NotNull ResultQuery<Record>
DSLContext. resultQuery(String sql)
Create a new query holding plain SQL.@NotNull ResultQuery<Record>
DSLContext. resultQuery(String sql, Object... bindings)
Create a new query holding plain SQL.@NotNull ResultQuery<Record>
DSLContext. resultQuery(String sql, QueryPart... parts)
Create a new query holding plain SQL.@NotNull ResultQuery<Record>
DSLContext. resultQuery(SQL sql)
Create a new query holding plain SQL.@NotNull Table<Record>
DivideByReturningStep. returning(Collection<? extends Field<?>> fields)
Specify the fields that you want the division to return from the dividend@NotNull Table<Record>
DivideByReturningStep. returning(Field<?>... fields)
Specify the fields that you want the division to return from the dividend@NotNull DeleteResultStep<Record>
DeleteReturningStep. returningResult(Collection<? extends SelectFieldOrAsterisk> fields)
Configure theDELETE
statement to return a list of fields inR
.@NotNull DeleteResultStep<Record>
DeleteReturningStep. returningResult(SelectFieldOrAsterisk... fields)
Configure theDELETE
statement to return a list of fields inR
.@NotNull InsertResultStep<Record>
InsertReturningStep. returningResult(Collection<? extends SelectFieldOrAsterisk> fields)
Configure theINSERT
statement to return a list of fields inR
.@NotNull InsertResultStep<Record>
InsertReturningStep. returningResult(SelectFieldOrAsterisk... fields)
Configure theINSERT
statement to return a list of fields inR
.@NotNull UpdateResultStep<Record>
UpdateReturningStep. returningResult(Collection<? extends SelectFieldOrAsterisk> fields)
Configure theUPDATE
statement to return a list of fields inR
.@NotNull UpdateResultStep<Record>
UpdateReturningStep. returningResult(SelectFieldOrAsterisk... fields)
Configure theUPDATE
statement to return a list of fields inR
.@NotNull TablePartitionByStep<Record>
Table. rightJoin(String sql)
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. rightJoin(String sql, Object... bindings)
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. rightJoin(String sql, QueryPart... parts)
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. rightJoin(Name name)
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. rightJoin(SQL sql)
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. rightJoin(TableLike<?> table)
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. rightJoin(String sql)
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. rightJoin(String sql, Object... bindings)
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. rightJoin(String sql, QueryPart... parts)
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. rightJoin(Name name)
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. rightJoin(SQL sql)
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. rightJoin(TableLike<?> table)
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. rightOuterJoin(String sql)
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. rightOuterJoin(String sql, Object... bindings)
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. rightOuterJoin(String sql, QueryPart... parts)
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. rightOuterJoin(Name name)
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. rightOuterJoin(SQL sql)
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
Table. rightOuterJoin(TableLike<?> table)
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. rightOuterJoin(String sql)
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. rightOuterJoin(String sql, Object... bindings)
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. rightOuterJoin(String sql, QueryPart... parts)
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. rightOuterJoin(Name name)
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. rightOuterJoin(SQL sql)
RIGHT OUTER JOIN
a table to this table.@NotNull TableOnStep<Record>
TableOuterJoinStep. rightOuterJoin(TableLike<?> table)
RIGHT OUTER JOIN
a table to this table.@NotNull SelectSelectStep<Record>
DSLContext. select(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.@NotNull SelectSelectStep<Record>
DSLContext. select(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.@NotNull SelectSelectStep<Record>
SelectSelectStep. select(Collection<? extends SelectFieldOrAsterisk> fields)
Add additional fields to theSELECT
clause of this query@NotNull SelectSelectStep<Record>
SelectSelectStep. select(SelectFieldOrAsterisk... fields)
Add additional fields to theSELECT
clause of this query@NotNull SelectSelectStep<Record>
WithStep. select(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.@NotNull SelectSelectStep<Record>
WithStep. select(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.@NotNull SelectSelectStep<Record>
DSLContext. selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.@NotNull SelectSelectStep<Record>
DSLContext. selectDistinct(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.@NotNull SelectSelectStep<Record>
WithStep. selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL select statement.@NotNull SelectSelectStep<Record>
WithStep. selectDistinct(SelectFieldOrAsterisk... fields)
Create a new DSL select statement.@NotNull SelectWhereStep<Record>
DSLContext. selectFrom(String sql)
Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
DSLContext. selectFrom(String sql, Object... bindings)
Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
DSLContext. selectFrom(String sql, QueryPart... parts)
Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
DSLContext. selectFrom(Name table)
Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
DSLContext. selectFrom(SQL sql)
Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep. selectFrom(String sql)
Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep. selectFrom(String sql, Object... bindings)
Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep. selectFrom(String sql, QueryPart... parts)
Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep. selectFrom(Name table)
Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep. selectFrom(SQL sql)
Create a new DSL select statement, projecting*
.@NotNull SelectQuery<Record>
DSLContext. selectQuery()
Create a newSelectQuery
@NotNull TableOnStep<Record>
Table. straightJoin(String sql)
STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. straightJoin(String sql, Object... bindings)
STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. straightJoin(String sql, QueryPart... parts)
STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. straightJoin(Name name)
STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. straightJoin(SQL sql)
STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table. straightJoin(TableLike<?> table)
STRAIGHT_JOIN
a table to this table.@NotNull TruncateIdentityStep<Record>
DSLContext. truncate(String table)
Create a new DSL truncate statement.@NotNull TruncateIdentityStep<Record>
DSLContext. truncate(Name table)
Create a new DSL truncate statement.@NotNull TruncateIdentityStep<Record>
DSLContext. truncateTable(String table)
Create a new DSL truncate statement.@NotNull TruncateIdentityStep<Record>
DSLContext. truncateTable(Name table)
Create a new DSL truncate statement.@NotNull Table<Record>
TableOnStep. using(Collection<? extends Field<?>> fields)
Join a table with theUSING(column [, column...])
syntax.@NotNull 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 @NotNull Condition
BetweenAndStepN. and(Record maxValue)
Create a condition to check this field against some bounds@NotNull BetweenAndStepN
RowN. between(Record minValue)
Check if this row value expression is within a range of two records.@NotNull Condition
RowN. between(Record minValue, Record maxValue)
Check if this row value expression is within a range of two records.@NotNull BetweenAndStepN
RowN. betweenSymmetric(Record minValue)
Check if this row value expression is within a symmetric range of two records.@NotNull 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)
.@NotNull Table<R>
ForeignKey. children(O... records)
Get a table expression representing the children of a record, given this foreign key.@NotNull 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.@NotNull Condition
RowN. eq(Record record)
Compare this row value expression with a record for equality.@NotNull Condition
RowN. equal(Record record)
Compare this row value expression with a record for equality.@NotNull Result<R>
ForeignKey. fetchChildren(O... records)
Fetch child records of a given set of records through this foreign key@NotNull Result<O>
ForeignKey. fetchParents(R... records)
Fetch parent records of a given set of record through this foreign key@Nullable Field<T>
Field. field(Record record)
The inverse operation offield(Field)
.@Nullable Record1<T>
Field. from(Record record)
The inverse operation ofinto(Field)
.R
Table. from(Record record)
The inverse operation ofinto(Table)
.@NotNull 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)
.@NotNull Condition
RowN. greaterOrEqual(Record record)
Compare this row value expression with a record for order.@NotNull Condition
RowN. greaterThan(Record record)
Compare this row value expression with a record for order.@NotNull Condition
RowN. gt(Record record)
Compare this row value expression with a record for order.@NotNull Condition
RowN. in(Record... record)
Compare this row value expression with a set of records for equality.@NotNull Condition
SelectCorrelatedSubqueryStep. in(R... records)
Compare this subquery with a set of records for equality.@NotNull Condition
RowN. isDistinctFrom(Record record)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
RowN. isNotDistinctFrom(Record record)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
RowN. le(Record record)
Compare this row value expression with a record for order.@NotNull Condition
RowN. lessOrEqual(Record record)
Compare this row value expression with a record for order.@NotNull Condition
RowN. lessThan(Record record)
Compare this row value expression with a record for order.@NotNull LoaderRowsStep<R>
LoaderSourceStep. loadRecords(Record... records)
Load in-memory data.@NotNull Condition
RowN. lt(Record record)
Compare this row value expression with a record for order.@NotNull Condition
RowN. ne(Record record)
Compare this row value expression with a record for non-equality.@NotNull BetweenAndStepN
RowN. notBetween(Record minValue)
Check if this row value expression is within a range of two records.@NotNull Condition
RowN. notBetween(Record minValue, Record maxValue)
Check if this row value expression is within a range of two records.@NotNull BetweenAndStepN
RowN. notBetweenSymmetric(Record minValue)
Check if this row value expression is not within a symmetric range of two records.@NotNull Condition
RowN. notBetweenSymmetric(Record minValue, Record maxValue)
Check if this row value expression is not within a symmetric range of two records.@NotNull Condition
RowN. notEqual(Record record)
Compare this row value expression with a record for non-equality@NotNull Condition
RowN. notIn(Record... record)
Compare this row value expression with a set of records for non-equality.@NotNull Condition
SelectCorrelatedSubqueryStep. notIn(R... records)
Compare this subquery with a set of records for non-equality.T
Field. original(Record record)
The inverse operation oforiginal(Field)
.@NotNull Table<O>
ForeignKey. parents(R... records)
Get a table expression representing the parents of a record, given this foreign key.void
ExecuteContext. record(Record record)
Calling this has no effect.void
Field. reset(Record record)
The inverse operation ofreset(Field)
.@NotNull InsertOnDuplicateSetMoreStep<R>
InsertOnDuplicateSetStep. set(Record record)
Set multiple values forUPDATE
in theINSERT
statement'sON DUPLICATE KEY UPDATE
orON CONFLICT ...
@NotNull InsertSetMoreStep<R>
InsertSetMoreStep. set(Record record)
Set values in theINSERT
statement.@NotNull InsertSetMoreStep<R>
InsertSetStep. set(Record record)
Set values in theINSERT
statement.@NotNull MergeMatchedSetMoreStep<R>
MergeMatchedSetStep. set(Record record)
Set multiple values forUPDATE
in theMERGE
statement'sWHEN MATCHED
clause.@NotNull MergeNotMatchedSetMoreStep<R>
MergeNotMatchedSetStep. set(Record record)
Set multiple values forINSERT
in theMERGE
statement'sWHEN NOT MATCHED
clause.@NotNull 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 @NotNull Condition
RowN. compare(Comparator comparator, QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
RowN. compare(Comparator comparator, Select<? extends Record> select)
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
RowN. eq(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
RowN. eq(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
RowN. equal(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
RowN. equal(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
RowN. ge(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull Condition
RowN. ge(Select<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull Condition
RowN. greaterOrEqual(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull Condition
RowN. greaterOrEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull Condition
RowN. greaterThan(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull Condition
RowN. greaterThan(Select<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull Condition
RowN. gt(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull Condition
RowN. gt(Select<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull Condition
RowN. in(Result<? extends Record> result)
Compare this row value expression with a set of records for equality.@NotNull Condition
RowN. in(Select<? extends Record> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
RowN. isDistinctFrom(Select<? extends Record> select)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
RowN. isNotDistinctFrom(Select<? extends Record> select)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
RowN. le(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull Condition
RowN. le(Select<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull Condition
RowN. lessOrEqual(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull Condition
RowN. lessOrEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull Condition
RowN. lessThan(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull Condition
RowN. lessThan(Select<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull LoaderRowsStep<R>
LoaderSourceStep. loadRecords(Iterable<? extends Record> records)
Load in-memory data.@NotNull LoaderRowsStep<R>
LoaderSourceStep. loadRecords(Iterator<? extends Record> records)
Load in-memory data.@NotNull LoaderRowsStep<R>
LoaderSourceStep. loadRecords(Stream<? extends Record> records)
Load in-memory data.@NotNull Condition
RowN. lt(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for order.@NotNull 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.@NotNull Condition
RowN. ne(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for non-equality.@NotNull Condition
RowN. ne(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.@NotNull Condition
RowN. notEqual(QuantifiedSelect<? extends Record> select)
Compare this row value expression with a subselect for non-equality.@NotNull Condition
RowN. notEqual(Select<? extends Record> select)
Compare this row value expression with a subselect for non-equality.@NotNull Condition
RowN. notIn(Result<? extends Record> result)
Compare this row value expression with a set of records for equality.@NotNull 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, which applies tointo(Class)
,Result.into(Class)
, and similar calls.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>
@NotNull QuantifiedSelect<R>DSL. all(Select<R> select)
Create anALL
quantified select to be used in quantified comparison predicate expressions.static <R extends Record>
@NotNull QuantifiedSelect<R>DSL. any(Select<R> select)
Create anANY
quantified select to be used in quantified comparison predicate expressions.static <R extends Record>
@NotNull Check<R>Internal. createCheck(Table<R> table, Name name, String condition)
Factory method for check constraints.static <R extends Record>
@NotNull Check<R>Internal. createCheck(Table<R> table, Name name, String condition, boolean enforced)
Factory method for check constraints.static <R extends Record,E extends EmbeddableRecord<E>>
@NotNull TableField<R,E>Internal. createEmbeddable(Name name, Class<E> recordType, boolean replacesFields, Table<R> table, TableField<R,?>... fields)
Factory method for embeddable types.static <R extends Record,E extends EmbeddableRecord<E>>
@NotNull TableField<R,E>Internal. createEmbeddable(Name name, Class<E> 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>
@NotNull ForeignKey<R,U>Internal. createForeignKey(Table<R> table, Name name, TableField<R,?>[] fkFields, UniqueKey<U> uk, TableField<U,?>[] ukFields, boolean enforced)
Factory method for foreign keys.static <R extends Record,U extends Record>
@NotNull ForeignKey<R,U>Internal. createForeignKey(Table<R> table, Name name, TableField<R,?>[] fkFields, UniqueKey<U> uk, TableField<U,?>[] ukFields, boolean enforced)
Factory method for foreign keys.static <R extends Record,U extends Record,ER extends EmbeddableRecord<ER>>
@NotNull ForeignKey<R,U>Internal. createForeignKey(Table<R> table, Name name, TableField<R,ER> fkEmbeddableField, UniqueKey<U> uk, TableField<U,ER> ukEmbeddableField, boolean enforced)
Factory method for foreign keys.static <R extends Record,U extends Record,ER extends EmbeddableRecord<ER>>
@NotNull ForeignKey<R,U>Internal. createForeignKey(Table<R> table, Name name, TableField<R,ER> fkEmbeddableField, UniqueKey<U> uk, TableField<U,ER> ukEmbeddableField, boolean enforced)
Factory method for foreign keys.static <R extends Record,U extends Record>
@NotNull ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)
Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.static <R extends Record,U extends Record>
@NotNull ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>... fields)
Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.static <R extends Record,U extends Record>
@NotNull ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)
Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.static <R extends Record,U extends Record>
@NotNull ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)
Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.static <R extends Record,U extends Record>
@NotNull ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields)
Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.static <R extends Record,U extends Record>
@NotNull ForeignKey<R,U>Internal. createForeignKey(UniqueKey<U> key, Table<R> table, TableField<R,?>... fields)
Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.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>
@NotNull 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>
@NotNull UniqueKey<R>Internal. createUniqueKey(Table<R> table, String name, TableField<R,?>... fields)
Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.static <R extends Record>
@NotNull UniqueKey<R>Internal. createUniqueKey(Table<R> table, String name, TableField<R,?>[] fields, boolean enforced)
Deprecated.- 3.14.0 - [#9404] - Please re-generate your code.static <R extends Record>
@NotNull UniqueKey<R>Internal. createUniqueKey(Table<R> table, Name name, TableField<R,?>... fields)
Factory method for unique keys.static <R extends Record>
@NotNull UniqueKey<R>Internal. createUniqueKey(Table<R> table, Name name, TableField<R,?>[] fields, boolean enforced)
Factory method for unique keys.static <R extends Record,ER extends EmbeddableRecord<ER>>
@NotNull UniqueKey<R>Internal. createUniqueKey(Table<R> table, Name name, TableField<R,ER> embeddableField, boolean enforced)
Factory method for unique keys.static <R extends Record>
@NotNull 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>
@NotNull 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>
@NotNull 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)
static <R extends Record,ER extends EmbeddableRecord<ER>>
@NotNull TableField<R,?>[]Internal. fields(TableField<R,ER> embeddableField)
Deprecated.- [#11058] - 3.14.5 - Please re-generate your code.static <R extends Record,ER extends EmbeddableRecord<ER>>
@NotNull RowInternal. fieldsRow(TableField<R,ER> embeddableField)
Get the fields row of an embeddable type.<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>
@NotNull InsertSetStep<R>DSL. insertInto(Table<R> into)
Create a new DSL insert statement.static <R extends Record>
@NotNull InsertValuesStepN<R>DSL. insertInto(Table<R> into, Collection<? extends Field<?>> fields)
Create a new DSL insert statement.static <R extends Record>
@NotNull InsertValuesStepN<R>DSL. insertInto(Table<R> into, Field<?>... fields)
Create a new DSL insert statement.static <R extends Record,T1>
@NotNull InsertValuesStep1<R,T1>DSL. insertInto(Table<R> into, Field<T1> field1)
Create a new DSL insert statement.static <R extends Record,T1,T2>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<R extends Record,T1,T2>
MergeKeyStep2<R,T1,T2>DefaultDSLContext. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
<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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDefaultDSLContext.mergeInto(Table)
static <R extends Record>
@NotNull MergeUsingStep<R>DSL. mergeInto(Table<R> table)
Create a new DSL SQL standard MERGE statement.static <R extends Record>
@NotNull MergeKeyStepN<R>DSL. mergeInto(Table<R> table, Collection<? extends Field<?>> fields)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record>
@NotNull MergeKeyStepN<R>DSL. mergeInto(Table<R> table, Field<?>... fields)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1>
@NotNull MergeKeyStep1<R,T1>DSL. mergeInto(Table<R> table, Field<T1> field1)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2>
@NotNull MergeKeyStep2<R,T1,T2>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3>
@NotNull MergeKeyStep3<R,T1,T2,T3>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4>
@NotNull MergeKeyStep4<R,T1,T2,T3,T4>DSL. mergeInto(Table<R> table, Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
static <R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
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>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
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>
@NotNull 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)
Deprecated.- [#10045] - 3.14.0 - Use the standard SQL MERGE API instead, viaDSL.mergeInto(Table)
<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>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull Table<R>DSL. table(R record)
Use a previously obtained record as a new Tablestatic <R extends Record>
@NotNull 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>
@NotNull 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>
@NotNull 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>
@NotNull 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 @NotNull 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> @NotNull RecordType<Record>
DSL. recordType(Collection<? extends Field<?>> fields)
Create aRecordType
of an arbitrary degree.static <T1> @NotNull 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 @NotNull ResultQuery<Record>
DSL. resultQuery(String sql)
Create a new query holding plain SQL.static @NotNull ResultQuery<Record>
DSL. resultQuery(String sql, Object... bindings)
Create a new query holding plain SQL.static @NotNull ResultQuery<Record>
DSL. resultQuery(String sql, QueryPart... parts)
Create a new query holding plain SQL.static @NotNull ResultQuery<Record>
DSL. resultQuery(SQL sql)
Create a new query holding plain SQL.static @NotNull Field<Record>
DSL. rowField(RowN row)
EXPERIMENTAL: Turn a row value expression of arbitrary degree into aField
.static @NotNull 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 @NotNull SelectSelectStep<Record>
DSL. select(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL subselect statement.static @NotNull 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 @NotNull SelectSelectStep<Record>
DSL. selectDistinct(Collection<? extends SelectFieldOrAsterisk> fields)
Create a new DSL subselect statement.static @NotNull 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 @NotNull SelectWhereStep<Record>
DSL. selectFrom(String sql)
Create a new DSL select statement, projecting*
.static @NotNull SelectWhereStep<Record>
DSL. selectFrom(String sql, Object... bindings)
Create a new DSL select statement, projecting*
.static @NotNull SelectWhereStep<Record>
DSL. selectFrom(String sql, QueryPart... parts)
Create a new DSL select statement, projecting*
.static @NotNull SelectWhereStep<Record>
DSL. selectFrom(Name table)
Create a new DSL select statement, projecting*
.static @NotNull SelectWhereStep<Record>
DSL. selectFrom(SQL sql)
Create a new DSL select statement, projecting*
.SelectQuery<Record>
DefaultDSLContext. selectQuery()
static @NotNull Table<Record>
DSL. table(String sql)
A custom SQL clause that can render arbitrary table expressions.static @NotNull Table<Record>
DSL. table(String sql, Object... bindings)
A custom SQL clause that can render arbitrary table expressions.static @NotNull Table<Record>
DSL. table(String sql, QueryPart... parts)
A custom SQL clause that can render arbitrary table expressions.static @NotNull Table<Record>
DSL. table(Name name)
Create a qualified table, given its table name.static @NotNull Table<Record>
DSL. table(Name name, Comment comment)
Create a qualified table, given its table name.static @NotNull Table<Record>
DSL. table(SQL sql)
A custom SQL clause that can render arbitrary table expressions.static @NotNull 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 @NotNull TruncateIdentityStep<Record>
DSL. truncate(String table)
Create a new DSL truncate statement.static @NotNull 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 @NotNull TruncateIdentityStep<Record>
DSL. truncateTable(String table)
Create a new DSL truncate statement.static @NotNull TruncateIdentityStep<Record>
DSL. truncateTable(Name table)
Create a new DSL truncate statement.static @NotNull 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 @NotNull Condition
DSL. condition(Record record)
static <R extends Record>
@NotNull 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 @NotNull 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.
-