Top Inners Fields Constructors Methods
org.jooq.impl

pack-priv final Class JSONTable

extends AbstractTable<Record>
implements JSONTableColumnPathStep, UNotYetImplemented
Class Inheritance
All Implemented Interfaces
org.jooq.impl.QOM.UNotYetImplemented, org.jooq.impl.QOM.UEmpty, org.jooq.QueryPart, java.io.Serializable, org.jooq.JSONTableColumnPathStep, org.jooq.JSONTableColumnsStep, org.jooq.Table, org.jooq.SelectField, org.jooq.Typed, org.jooq.Named, org.jooq.SelectFieldOrAsterisk, org.jooq.GroupField, org.jooq.RecordQualifier, org.jooq.Fields, org.jooq.Qualified, org.jooq.TableLike, org.jooq.JSONTableColumnsFirstStep, org.jooq.JSONTableColumnForOrdinalityStep
Static Imports
org.jooq.SQLDialect.MARIADB, .SQLDialect.MYSQL, org.jooq.conf.ParamType.INLINED, org.jooq.impl.DSL.inline, .DSL.keyword, .DSL.rowNumber, .DSL.select, .DSL.val, .Keywords.K_COLUMNS, .Keywords.K_ERROR, .Keywords.K_FOR, .Keywords.K_JSON_TABLE, .Keywords.K_ON, .Keywords.K_ORDINALITY, .Keywords.K_PATH, .Keywords.K_WITH, .Names.N_JSON_TABLE, .Names.N_OPENJSON, .SQLDataType.JSONB, .SubqueryCharacteristics.DERIVED_TABLE, .Tools.map, .Tools.visitSubquery

Deprecated

as a consequence of QOM.UNotYetImplemented being deprecated. See corresponding docs for further information.

Author
Lukas Eder

Nested and Inner Type Summary

Modifier and TypeClass and Description
private static class
JSONTable.JSONTableColumn

Deprecated as a consequence of QOM.UNotYetImplemented being deprecated.

Field Summary

Modifier and TypeField and Description
private final QueryPartList<JSONTable.JSONTableColumn>
private transient FieldsImpl<Record>
private final boolean
private final Field<?>
json

Deprecated as a consequence of Field being deprecated.
private final Field<String>
path

Deprecated as a consequence of Field being deprecated.
private static final Set<SQLDialect>

Constructor Summary

AccessConstructor and Description
pack-priv
JSONTable(Field<?> json, Field<String> path)

Deprecated as a consequence of Field being deprecated.
private
JSONTable(Field<?> json, Field<String> path, QueryPartList<JSONTable.JSONTableColumn> columns, boolean hasOrdinality)

Deprecated as a consequence of Field being deprecated.

Method Summary

Modifier and TypeMethod and Description
public final void
accept(Context<?> ctx)

Implements org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.
private final void
private final void
private final void
public final JSONTable
column(String name)

Implements org.jooq.JSONTableColumnsFirstStep.column.

Deprecated as a consequence of JSONTable being deprecated.
Add a column to the COLUMNS clause of the JSON_TABLE expression.
public final JSONTable
column(Name name)

Implements org.jooq.JSONTableColumnsFirstStep.column.

Deprecated as a consequence of JSONTable being deprecated.
Add a column to the COLUMNS clause of the JSON_TABLE expression.
public final JSONTable
column(Field<?> name)

Implements org.jooq.JSONTableColumnsFirstStep.column.

Deprecated as a consequence of Field and JSONTable being deprecated.
Add a column to the COLUMNS clause of the JSON_TABLE expression.
public final JSONTable
column(String name, DataType<?> type)

Implements org.jooq.JSONTableColumnsFirstStep.column.

Deprecated as a consequence of JSONTable being deprecated.
Add a column to the COLUMNS clause of the JSON_TABLE expression.
public final JSONTable
column(Name name, DataType<?> type)

Implements org.jooq.JSONTableColumnsFirstStep.column.

Deprecated as a consequence of JSONTable being deprecated.
Add a column to the COLUMNS clause of the JSON_TABLE expression.
public final JSONTable
column(Field<?> name, DataType<?> type)

Implements org.jooq.JSONTableColumnsFirstStep.column.

Deprecated as a consequence of Field and JSONTable being deprecated.
Add a column to the COLUMNS clause of the JSON_TABLE expression.
public boolean
pack-priv final FieldsImpl<Record>
fields0()

Implements abstract org.jooq.impl.AbstractTable.fields0.

Subclasses should override this method to provide the set of fields contained in the concrete table implementation.
public final JSONTable
forOrdinality()

Implements org.jooq.JSONTableColumnForOrdinalityStep.forOrdinality.

Deprecated as a consequence of JSONTable being deprecated.
Specify the FOR ORDINALITY clause on a column in the COLUMNS clause of the JSON_TABLE predicate.
public final Class<? extends Record>
getRecordType()

Implements org.jooq.RecordQualifier.getRecordType.

The record type produced by this UDT or Table.
public final JSONTable
path(String p)

Implements org.jooq.JSONTableColumnPathStep.path.

Deprecated as a consequence of JSONTable being deprecated.
Specify the PATH of a column in the COLUMNS clause of the JSON_TABLE predicate.
private final JSONTable
path0(boolean forOrdinality, String p)

Deprecated as a consequence of JSONTable being deprecated.
Inherited from org.jooq.impl.AbstractTable:
$alias$aliased$dataType$schemaasasasasasasasasasasasasasasasasasMultisetasMultisetasMultisetasMultisetasTableasTableasTableasTableasTableasTableasTableasTableasTableasTableasTableasTableasteriskclausesconvertconvertconvertconvertFromconvertFromconvertToconvertTocreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateFieldcreateField0createField0createField0createField0crossApplycrossApplycrossApplycrossApplycrossApplycrossApplycrossJoincrossJoincrossJoincrossJoincrossJoincrossJoindivideByeqequalfieldsfieldsRowforceIndexforceIndexForGroupByforceIndexForJoinforceIndexForOrderByfromfullJoinfullJoinfullJoinfullJoinfullJoinfullJoinfullOuterJoinfullOuterJoinfullOuterJoinfullOuterJoinfullOuterJoinfullOuterJoingetBindinggetCataloggetChecksgetConvertergetDataTypegetDataTypegetIdentitygetIndexesgetKeysgetOptionsgetPackagegetPrimaryKeygetRecordTimestampgetRecordVersiongetReferencesgetReferencesFromgetReferencesTogetSchemagetTableTypegetTypegetUniqueKeysignoreIndexignoreIndexForGroupByignoreIndexForJoinignoreIndexForOrderByinnerJoininnerJoininnerJoininnerJoininnerJoininnerJoinjoinjoinjoinjoinjoinjoinjoinleftAntiJoinleftJoinleftJoinleftJoinleftJoinleftJoinleftJoinleftOuterJoinleftOuterJoinleftOuterJoinleftOuterJoinleftOuterJoinleftOuterJoinleftSemiJoinnaturalFullOuterJoinnaturalFullOuterJoinnaturalFullOuterJoinnaturalFullOuterJoinnaturalFullOuterJoinnaturalFullOuterJoinnaturalJoinnaturalJoinnaturalJoinnaturalJoinnaturalJoinnaturalJoinnaturalLeftOuterJoinnaturalLeftOuterJoinnaturalLeftOuterJoinnaturalLeftOuterJoinnaturalLeftOuterJoinnaturalLeftOuterJoinnaturalRightOuterJoinnaturalRightOuterJoinnaturalRightOuterJoinnaturalRightOuterJoinnaturalRightOuterJoinnaturalRightOuterJoinnenewRecordnotEqualouterApplyouterApplyouterApplyouterApplyouterApplyouterApplyrecordTyperightJoinrightJoinrightJoinrightJoinrightJoinrightJoinrightOuterJoinrightOuterJoinrightOuterJoinrightOuterJoinrightOuterJoinrightOuterJoinrowidstraightJoinstraightJoinstraightJoinstraightJoinstraightJoinstraightJointfuseIndexuseIndexForGroupByuseIndexForJoinuseIndexForOrderBywherewherewherewherewherewherewherewherewhereExistswhereNotExistswithOrdinality

Field Detail

columnsback to summary
private final QueryPartList<JSONTable.JSONTableColumn> columns
fieldsback to summary
private transient FieldsImpl<Record> fields
hasOrdinalityback to summary
private final boolean hasOrdinality
jsonback to summary
private final Field<?> json

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

pathback to summary
private final Field<String> path

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

REQUIRES_COLUMN_PATHback to summary
private static final Set<SQLDialect> REQUIRES_COLUMN_PATH

Constructor Detail

JSONTableback to summary
pack-priv JSONTable(Field<?> json, Field<String> path)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

JSONTableback to summary
private JSONTable(Field<?> json, Field<String> path, QueryPartList<JSONTable.JSONTableColumn> columns, boolean hasOrdinality)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Method Detail

acceptback to summary
public final void accept(Context<?> ctx)

Implements org.jooq.QueryPartInternal.accept.

Doc from org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.

Annotations
@Override
acceptJSONPathback to summary
private final void acceptJSONPath(Context<?> ctx)
acceptPostgresback to summary
private final void acceptPostgres(Context<?> ctx)
acceptStandardback to summary
private final void acceptStandard(Context<?> ctx)
columnback to summary
public final JSONTable column(String name)

Implements org.jooq.JSONTableColumnsFirstStep.column.

Doc from org.jooq.JSONTableColumnsFirstStep.column.

Deprecated

as a consequence of JSONTable being deprecated. See corresponding docs for further information.

Add a column to the COLUMNS clause of the JSON_TABLE expression.

Annotations
@Override
columnback to summary
public final JSONTable column(Name name)

Implements org.jooq.JSONTableColumnsFirstStep.column.

Doc from org.jooq.JSONTableColumnsFirstStep.column.

Deprecated

as a consequence of JSONTable being deprecated. See corresponding docs for further information.

Add a column to the COLUMNS clause of the JSON_TABLE expression.

Annotations
@Override
columnback to summary
public final JSONTable column(Field<?> name)

Implements org.jooq.JSONTableColumnsFirstStep.column.

Doc from org.jooq.JSONTableColumnsFirstStep.column.

Deprecated

as a consequence of Field and JSONTable being deprecated. See corresponding docs for further information.

Add a column to the COLUMNS clause of the JSON_TABLE expression.

Annotations
@Override
columnback to summary
public final JSONTable column(String name, DataType<?> type)

Implements org.jooq.JSONTableColumnsFirstStep.column.

Doc from org.jooq.JSONTableColumnsFirstStep.column.

Deprecated

as a consequence of JSONTable being deprecated. See corresponding docs for further information.

Add a column to the COLUMNS clause of the JSON_TABLE expression.

Annotations
@Override
columnback to summary
public final JSONTable column(Name name, DataType<?> type)

Implements org.jooq.JSONTableColumnsFirstStep.column.

Doc from org.jooq.JSONTableColumnsFirstStep.column.

Deprecated

as a consequence of JSONTable being deprecated. See corresponding docs for further information.

Add a column to the COLUMNS clause of the JSON_TABLE expression.

Annotations
@Override
columnback to summary
public final JSONTable column(Field<?> name, DataType<?> type)

Implements org.jooq.JSONTableColumnsFirstStep.column.

Doc from org.jooq.JSONTableColumnsFirstStep.column.

Deprecated

as a consequence of Field and JSONTable being deprecated. See corresponding docs for further information.

Add a column to the COLUMNS clause of the JSON_TABLE expression.

Annotations
@Override
declaresTablesback to summary
public boolean declaresTables()

Overrides org.jooq.impl.AbstractQueryPart.declaresTables.

Implements org.jooq.QueryPartInternal.declaresTables.

Doc from org.jooq.impl.AbstractQueryPart.declaresTables.

Subclasses may override this

Annotations
@Override
fields0back to summary
pack-priv final FieldsImpl<Record> fields0()

Implements abstract org.jooq.impl.AbstractTable.fields0.

Doc from org.jooq.impl.AbstractTable.fields0.

Subclasses should override this method to provide the set of fields contained in the concrete table implementation. For example, a TableAlias contains aliased fields of its AliasProvider table.

Annotations
@Override
forOrdinalityback to summary
public final JSONTable forOrdinality()

Implements org.jooq.JSONTableColumnForOrdinalityStep.forOrdinality.

Doc from org.jooq.JSONTableColumnForOrdinalityStep.forOrdinality.

Deprecated

as a consequence of JSONTable being deprecated. See corresponding docs for further information.

Specify the FOR ORDINALITY clause on a column in the COLUMNS clause of the JSON_TABLE predicate.

Annotations
@Override
getRecordTypeback to summary
public final Class<? extends Record> getRecordType()

Implements org.jooq.RecordQualifier.getRecordType.

Doc from org.jooq.RecordQualifier.getRecordType.

The record type produced by this UDT or Table.

Annotations
@Override
pathback to summary
public final JSONTable path(String p)

Implements org.jooq.JSONTableColumnPathStep.path.

Doc from org.jooq.JSONTableColumnPathStep.path.

Deprecated

as a consequence of JSONTable being deprecated. See corresponding docs for further information.

Specify the PATH of a column in the COLUMNS clause of the JSON_TABLE predicate.

Annotations
@Override
path0back to summary
private final JSONTable path0(boolean forOrdinality, String p)

Deprecated

as a consequence of JSONTable being deprecated. See corresponding docs for further information.

org.jooq.impl back to summary

private Class JSONTable.JSONTableColumn

extends AbstractQueryPart
implements UNotYetImplemented
Class Inheritance
All Implemented Interfaces
org.jooq.impl.QOM.UNotYetImplemented, org.jooq.impl.QOM.UEmpty, org.jooq.QueryPart, java.io.Serializable

Deprecated

as a consequence of QOM.UNotYetImplemented being deprecated. See corresponding docs for further information.

Field Summary

Modifier and TypeField and Description
pack-priv final Field<?>
field

Deprecated as a consequence of Field being deprecated.
pack-priv final boolean
pack-priv final String
pack-priv final DataType<?>

Constructor Summary

AccessConstructor and Description
pack-priv
JSONTableColumn(Field<?> field, DataType<?> type, boolean forOrdinality, String path)

Deprecated as a consequence of Field being deprecated.

Method Summary

Modifier and TypeMethod and Description
public final void
accept(Context<?> ctx)

Implements org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.
Inherited from org.jooq.impl.AbstractQueryPart:
clausesconfigurationcreatecreatecreatedeclaresCTEdeclaresFieldsdeclaresTablesdeclaresWindowsequalsgeneratesCasthashCoderendersContenttoStringtranslate

Field Detail

fieldback to summary
pack-priv final Field<?> field

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

forOrdinalityback to summary
pack-priv final boolean forOrdinality
pathback to summary
pack-priv final String path
typeback to summary
pack-priv final DataType<?> type

Constructor Detail

JSONTableColumnback to summary
pack-priv JSONTableColumn(Field<?> field, DataType<?> type, boolean forOrdinality, String path)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Method Detail

acceptback to summary
public final void accept(Context<?> ctx)

Implements org.jooq.QueryPartInternal.accept.

Doc from org.jooq.QueryPartInternal.accept.

This QueryPart can accept a Context object in order to render a SQL string or to bind its variables.

Annotations
@Override