Top Fields Constructors Methods
org.jooq.impl

pack-priv final Class ParserImpl

Additional top-level class in compilation unit: DefaultParseContext.

extends Object
implements Parser
Class Inheritance
All Implemented Interfaces
org.jooq.Parser
Static Imports
java.lang.Boolean.FALSE, .Boolean.TRUE, java.util.Arrays.asList, .Collections.emptyList, org.jooq.Comparator.IN, .Comparator.NOT_IN, .DatePart.DAY, .DatePart.HOUR, .DatePart.MINUTE, .DatePart.MONTH, .DatePart.SECOND, .DatePart.YEAR, .JoinType.JOIN, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .VisitListener.onVisitStart, org.jooq.conf.ParseWithMetaLookups.IGNORE_ON_FAILURE, .ParseWithMetaLookups.THROW_ON_FAILURE, .SettingsTools.parseLocale, org.jooq.impl.AbstractName.NO_NAME, .DSL.abs, .DSL.acos, .DSL.acosh, .DSL.acoth, .DSL.all, .DSL.any, .DSL.anyValue, .DSL.arrayAgg, .DSL.arrayAggDistinct, .DSL.arrayAppend, .DSL.arrayConcat, .DSL.arrayGet, .DSL.arrayPrepend, .DSL.arrayRemove, .DSL.arrayReplace, .DSL.ascii, .DSL.asin, .DSL.asinh, .DSL.asterisk, .DSL.atan, .DSL.atanh, .DSL.avg, .DSL.avgDistinct, .DSL.begin, .DSL.bitAnd, .DSL.bitAndAgg, .DSL.bitCount, .DSL.bitLength, .DSL.bitNand, .DSL.bitNandAgg, .DSL.bitNor, .DSL.bitNorAgg, .DSL.bitNot, .DSL.bitOr, .DSL.bitOrAgg, .DSL.bitXNor, .DSL.bitXNorAgg, .DSL.bitXor, .DSL.bitXorAgg, .DSL.boolOr, .DSL.cardinality, .DSL.case_, .DSL.cast, .DSL.catalog, .DSL.ceil, .DSL.century, .DSL.charLength, .DSL.characterSet, .DSL.check, .DSL.choose, .DSL.chr, .DSL.coalesce, .DSL.coerce, .DSL.collation, .DSL.concat, .DSL.condition, .DSL.constraint, .DSL.cos, .DSL.cosh, .DSL.cot, .DSL.coth, .DSL.count, .DSL.countDistinct, .DSL.cube, .DSL.cumeDist, .DSL.currentCatalog, .DSL.currentDate, .DSL.currentSchema, .DSL.currentTime, .DSL.currentTimestamp, .DSL.currentUser, .DSL.date, .DSL.dateAdd, .DSL.day, .DSL.dayOfWeek, .DSL.dayOfYear, .DSL.decade, .DSL.defaultValue, .DSL.default_, .DSL.deg, .DSL.denseRank, .DSL.digits, .DSL.domain, .DSL.epoch, .DSL.every, .DSL.excluded, .DSL.exists, .DSL.exp, .DSL.extract, .DSL.falseCondition, .DSL.field, .DSL.finalTable, .DSL.firstValue, .DSL.floor, .DSL.foreignKey, .DSL.function, .DSL.generateSeries, .DSL.greatest, .DSL.grouping, .DSL.groupingSets, .DSL.groupsBetweenCurrentRow, .DSL.groupsBetweenFollowing, .DSL.groupsBetweenPreceding, .DSL.groupsBetweenUnboundedFollowing, .DSL.groupsBetweenUnboundedPreceding, .DSL.groupsCurrentRow, .DSL.groupsFollowing, .DSL.groupsPreceding, .DSL.groupsUnboundedFollowing, .DSL.groupsUnboundedPreceding, .DSL.hour, .DSL.ifnull, .DSL.iif, .DSL.in, .DSL.inOut, .DSL.inline, .DSL.isnull, .DSL.isoDayOfWeek, .DSL.jsonArray, .DSL.jsonArrayAgg, .DSL.jsonArrayAggDistinct, .DSL.jsonExists, .DSL.jsonGetAttribute, .DSL.jsonGetAttributeAsText, .DSL.jsonGetElement, .DSL.jsonGetElementAsText, .DSL.jsonObject, .DSL.jsonObjectAgg, .DSL.jsonTable, .DSL.jsonValue, .DSL.jsonbArray, .DSL.jsonbArrayAgg, .DSL.jsonbArrayAggDistinct, .DSL.jsonbGetAttribute, .DSL.jsonbGetAttributeAsText, .DSL.jsonbGetElement, .DSL.jsonbGetElementAsText, .DSL.jsonbObject, .DSL.jsonbObjectAgg, .DSL.key, .DSL.keyword, .DSL.lag, .DSL.lastValue, .DSL.lateral, .DSL.lead, .DSL.least, .DSL.length, .DSL.list, .DSL.listAgg, .DSL.listAggDistinct, .DSL.ln, .DSL.log, .DSL.log10, .DSL.lower, .DSL.ltrim, .DSL.max, .DSL.maxDistinct, .DSL.md5, .DSL.median, .DSL.microsecond, .DSL.millennium, .DSL.millisecond, .DSL.min, .DSL.minDistinct, .DSL.minute, .DSL.mode, .DSL.month, .DSL.multisetAgg, .DSL.name, .DSL.newTable, .DSL.now, .DSL.nthValue, .DSL.ntile, .DSL.nullif, .DSL.nvl, .DSL.nvl2, .DSL.octetLength, .DSL.oldTable, .DSL.one, .DSL.orderBy, .DSL.out, .DSL.overlay, .DSL.partitionBy, .DSL.percentRank, .DSL.percentileCont, .DSL.percentileDisc, .DSL.pi, .DSL.primaryKey, .DSL.privilege, .DSL.product, .DSL.productDistinct, .DSL.quarter, .DSL.rad, .DSL.rand, .DSL.rangeBetweenCurrentRow, .DSL.rangeBetweenFollowing, .DSL.rangeBetweenPreceding, .DSL.rangeBetweenUnboundedFollowing, .DSL.rangeBetweenUnboundedPreceding, .DSL.rangeCurrentRow, .DSL.rangeFollowing, .DSL.rangePreceding, .DSL.rangeUnboundedFollowing, .DSL.rangeUnboundedPreceding, .DSL.rank, .DSL.ratioToReport, .DSL.regexpReplaceAll, .DSL.regexpReplaceFirst, .DSL.reverse, .DSL.rollup, .DSL.round, .DSL.row, .DSL.rowNumber, .DSL.rowsBetweenCurrentRow, .DSL.rowsBetweenFollowing, .DSL.rowsBetweenPreceding, .DSL.rowsBetweenUnboundedFollowing, .DSL.rowsBetweenUnboundedPreceding, .DSL.rowsCurrentRow, .DSL.rowsFollowing, .DSL.rowsPreceding, .DSL.rowsUnboundedFollowing, .DSL.rowsUnboundedPreceding, .DSL.rtrim, .DSL.schema, .DSL.second, .DSL.select, .DSL.sequence, .DSL.shl, .DSL.shr, .DSL.sign, .DSL.sin, .DSL.sinh, .DSL.space, .DSL.sql, .DSL.sqrt, .DSL.square, .DSL.stddevPop, .DSL.stddevSamp, .DSL.sum, .DSL.sumDistinct, .DSL.systemName, .DSL.table, .DSL.tan, .DSL.tanh, .DSL.time, .DSL.timestamp, .DSL.timezone, .DSL.timezoneHour, .DSL.timezoneMinute, .DSL.toDate, .DSL.toHex, .DSL.toTimestamp, .DSL.translate, .DSL.trim, .DSL.trueCondition, .DSL.trunc, .DSL.unique, .DSL.unnest, .DSL.user, .DSL.uuid, .DSL.values0, .DSL.varPop, .DSL.varSamp, .DSL.week, .DSL.when, .DSL.widthBucket, .DSL.xmlagg, .DSL.xmlattributes, .DSL.xmlcomment, .DSL.xmlconcat, .DSL.xmlelement, .DSL.xmlexists, .DSL.xmlforest, .DSL.xmlparseContent, .DSL.xmlparseDocument, .DSL.xmlpi, .DSL.xmlquery, .DSL.xmlserializeContent, .DSL.xmlserializeDocument, .DSL.xmltable, .DSL.year, .DSL.zero, .DefaultParseContext.FunctionKeyword.FK_AND, .DefaultParseContext.FunctionKeyword.FK_IN, .Keywords.K_DELETE, .Keywords.K_INSERT, .Keywords.K_SELECT, .Keywords.K_UPDATE, .QOM.JSONOnNull.ABSENT_ON_NULL, .QOM.JSONOnNull.NULL_ON_NULL, .QOM.XMLPassingMechanism.BY_REF, .QOM.XMLPassingMechanism.BY_VALUE, .SQLDataType.BIGINT, .SQLDataType.BINARY, .SQLDataType.BIT, .SQLDataType.BLOB, .SQLDataType.BOOLEAN, .SQLDataType.CHAR, .SQLDataType.CLOB, .SQLDataType.DATE, .SQLDataType.DECIMAL, .SQLDataType.DOUBLE, .SQLDataType.FLOAT, .SQLDataType.GEOGRAPHY, .SQLDataType.GEOMETRY, .SQLDataType.INTEGER, .SQLDataType.INTERVAL, .SQLDataType.INTERVALDAYTOSECOND, .SQLDataType.INTERVALYEARTOMONTH, .SQLDataType.JSON, .SQLDataType.JSONB, .SQLDataType.LONGNVARCHAR, .SQLDataType.LONGVARBINARY, .SQLDataType.LONGVARCHAR, .SQLDataType.NCHAR, .SQLDataType.NCLOB, .SQLDataType.NUMERIC, .SQLDataType.NVARCHAR, .SQLDataType.OTHER, .SQLDataType.REAL, .SQLDataType.SMALLINT, .SQLDataType.TIME, .SQLDataType.TIMESTAMP, .SQLDataType.TIMESTAMPWITHTIMEZONE, .SQLDataType.TIMEWITHTIMEZONE, .SQLDataType.TINYINT, .SQLDataType.VARBINARY, .SQLDataType.VARCHAR, .SQLDataType.XML, .SQLDataType.YEAR, .SelectQueryImpl.EMULATE_SELECT_INTO_AS_CTAS, .SelectQueryImpl.NO_SUPPORT_FOR_UPDATE_OF_FIELDS, .Tools.CONFIG, .Tools.EMPTY_BYTE, .Tools.EMPTY_COLLECTION, .Tools.EMPTY_COMMON_TABLE_EXPRESSION, .Tools.EMPTY_FIELD, .Tools.EMPTY_NAME, .Tools.EMPTY_OBJECT, .Tools.EMPTY_QUERYPART, .Tools.EMPTY_ROW, .Tools.EMPTY_SORTFIELD, .Tools.EMPTY_STRING, .Tools.EMPTY_TABLE, .Tools.aliased, .Tools.anyMatch, .Tools.asInt, .Tools.deleteQueryImpl, .Tools.map, .Tools.normaliseNameCase, .Tools.selectQueryImpl, .Tools.updateQueryImpl, .Tools.BooleanDataKey.DATA_PARSE_ON_CONFLICT, .Transformations.transformAppendMissingTableReferences, org.jooq.tools.StringUtils.defaultIfNull

Author
Lukas Eder

Field Summary

Modifier and TypeField and Description
private final DSLContext
private final Meta
private final ParseWithMetaLookups

Constructor Summary

AccessConstructor and Description
pack-priv
ParserImpl(Configuration configuration)

Method Summary

Modifier and TypeMethod and Description
private final DefaultParseContext
ctx(String sql, Object... bindings)

public final Queries
parse(String
The SQL string
sql
)

Implements org.jooq.Parser.parse.

Parse a SQL string to a set of queries.
public final Queries
parse(String
The SQL string
sql
,
Object...
The bind variables
bindings
)

Implements org.jooq.Parser.parse.

Parse a SQL string with bind variables to a set of queries.
public final Condition
parseCondition(String
The SQL string
sql
)

Implements org.jooq.Parser.parseCondition.

Deprecated as a consequence of Condition being deprecated.
Parse a SQL string to a condition.
public final Condition
parseCondition(String
The SQL string
sql
,
Object...
The bind variables
bindings
)

Implements org.jooq.Parser.parseCondition.

Deprecated as a consequence of Condition being deprecated.
Parse a SQL string with bind variables to a condition.
public final Field<?>
parseField(String
The SQL string
sql
)

Implements org.jooq.Parser.parseField.

Deprecated as a consequence of Field being deprecated.
Parse a SQL string to a field.
public final Field<?>
parseField(String
The SQL string
sql
,
Object...
The bind variables
bindings
)

Implements org.jooq.Parser.parseField.

Deprecated as a consequence of Field being deprecated.
Parse a SQL string with bind variables to a field.
public final Name
parseName(String
The SQL string
sql
)

Implements org.jooq.Parser.parseName.

Parse a SQL string to a name.
public final Name
parseName(String
The SQL string
sql
,
Object...
The bind variables
bindings
)

Implements org.jooq.Parser.parseName.

Parse a SQL string with bind variables to a name.
public final Query
parseQuery(String
The SQL string
sql
)

Implements org.jooq.Parser.parseQuery.

Parse a SQL string to a query.
public final Query
parseQuery(String
The SQL string
sql
,
Object...
The bind variables
bindings
)

Implements org.jooq.Parser.parseQuery.

Parse a SQL string with bind variables to a query.
public final ResultQuery<?>
parseResultQuery(String
The SQL string
sql
)

Implements org.jooq.Parser.parseResultQuery.

Parse a SQL string to a result query.
public final ResultQuery<?>
parseResultQuery(String
The SQL string
sql
,
Object...
The bind variables
bindings
)

Implements org.jooq.Parser.parseResultQuery.

Parse a SQL string with bind variables to a result query.
public final Row
parseRow(String
The SQL string
sql
)

Implements org.jooq.Parser.parseRow.

Parse a SQL string to a row.
public final Row
parseRow(String
The SQL string
sql
,
Object...
The bind variables
bindings
)

Implements org.jooq.Parser.parseRow.

Parse a SQL string with bind variables to a row.
public final Select<?>
parseSelect(String
The SQL string
sql
)

Implements org.jooq.Parser.parseSelect.

Parse a SQL string to a select statement.
public final Select<?>
parseSelect(String
The SQL string
sql
,
Object...
The bind variables
bindings
)

Implements org.jooq.Parser.parseSelect.

Parse a SQL string to a select statement.
public final Statement
parseStatement(String
The SQL string
sql
)

Implements org.jooq.Parser.parseStatement.

Parse a SQL string to a procedural statement.
public final Statement
parseStatement(String
The SQL string
sql
,
Object...
The bind variables
bindings
)

Implements org.jooq.Parser.parseStatement.

Parse a SQL string with bind variables to a procedural statement.
public final Table<?>
parseTable(String
The SQL string
sql
)

Implements org.jooq.Parser.parseTable.

Parse a SQL string to a table.
public final Table<?>
parseTable(String
The SQL string
sql
,
Object...
The bind variables
bindings
)

Implements org.jooq.Parser.parseTable.

Parse a SQL string with bind variables to a table.
Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait

Field Detail

dslback to summary
private final DSLContext dsl
metaback to summary
private final Meta meta
metaLookupsback to summary
private final ParseWithMetaLookups metaLookups

Constructor Detail

ParserImplback to summary
pack-priv ParserImpl(Configuration configuration)

Method Detail

ctxback to summary
private final DefaultParseContext ctx(String sql, Object... bindings)
parseback to summary
public final Queries parse(String sql)

Implements org.jooq.Parser.parse.

Doc from org.jooq.Parser.parse.

Parse a SQL string to a set of queries.

Parameters
sql:String

The SQL string

Annotations
@Override
parseback to summary
public final Queries parse(String sql, Object... bindings)

Implements org.jooq.Parser.parse.

Doc from org.jooq.Parser.parse.

Parse a SQL string with bind variables to a set of queries.

Parameters
sql:String

The SQL string

bindings:Object[]

The bind variables

Annotations
@Override
parseConditionback to summary
public final Condition parseCondition(String sql)

Implements org.jooq.Parser.parseCondition.

Doc from org.jooq.Parser.parseCondition.

Deprecated

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

Parse a SQL string to a condition.

Parameters
sql:String

The SQL string

Annotations
@Override
parseConditionback to summary
public final Condition parseCondition(String sql, Object... bindings)

Implements org.jooq.Parser.parseCondition.

Doc from org.jooq.Parser.parseCondition.

Deprecated

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

Parse a SQL string with bind variables to a condition.

Parameters
sql:String

The SQL string

bindings:Object[]

The bind variables

Annotations
@Override
parseFieldback to summary
public final Field<?> parseField(String sql)

Implements org.jooq.Parser.parseField.

Doc from org.jooq.Parser.parseField.

Deprecated

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

Parse a SQL string to a field.

Parameters
sql:String

The SQL string

Annotations
@Override
parseFieldback to summary
public final Field<?> parseField(String sql, Object... bindings)

Implements org.jooq.Parser.parseField.

Doc from org.jooq.Parser.parseField.

Deprecated

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

Parse a SQL string with bind variables to a field.

Parameters
sql:String

The SQL string

bindings:Object[]

The bind variables

Annotations
@Override
parseNameback to summary
public final Name parseName(String sql)

Implements org.jooq.Parser.parseName.

Doc from org.jooq.Parser.parseName.

Parse a SQL string to a name.

Parameters
sql:String

The SQL string

Annotations
@Override
parseNameback to summary
public final Name parseName(String sql, Object... bindings)

Implements org.jooq.Parser.parseName.

Doc from org.jooq.Parser.parseName.

Parse a SQL string with bind variables to a name.

Parameters
sql:String

The SQL string

bindings:Object[]

The bind variables

Annotations
@Override
parseQueryback to summary
public final Query parseQuery(String sql)

Implements org.jooq.Parser.parseQuery.

Doc from org.jooq.Parser.parseQuery.

Parse a SQL string to a query.

Parameters
sql:String

The SQL string

Annotations
@Override
parseQueryback to summary
public final Query parseQuery(String sql, Object... bindings)

Implements org.jooq.Parser.parseQuery.

Doc from org.jooq.Parser.parseQuery.

Parse a SQL string with bind variables to a query.

Parameters
sql:String

The SQL string

bindings:Object[]

The bind variables

Annotations
@Override
parseResultQueryback to summary
public final ResultQuery<?> parseResultQuery(String sql)

Implements org.jooq.Parser.parseResultQuery.

Doc from org.jooq.Parser.parseResultQuery.

Parse a SQL string to a result query.

Parameters
sql:String

The SQL string

Annotations
@Override
parseResultQueryback to summary
public final ResultQuery<?> parseResultQuery(String sql, Object... bindings)

Implements org.jooq.Parser.parseResultQuery.

Doc from org.jooq.Parser.parseResultQuery.

Parse a SQL string with bind variables to a result query.

Parameters
sql:String

The SQL string

bindings:Object[]

The bind variables

Annotations
@Override
parseRowback to summary
public final Row parseRow(String sql)

Implements org.jooq.Parser.parseRow.

Doc from org.jooq.Parser.parseRow.

Parse a SQL string to a row.

Parameters
sql:String

The SQL string

Annotations
@Override
parseRowback to summary
public final Row parseRow(String sql, Object... bindings)

Implements org.jooq.Parser.parseRow.

Doc from org.jooq.Parser.parseRow.

Parse a SQL string with bind variables to a row.

Parameters
sql:String

The SQL string

bindings:Object[]

The bind variables

Annotations
@Override
parseSelectback to summary
public final Select<?> parseSelect(String sql)

Implements org.jooq.Parser.parseSelect.

Doc from org.jooq.Parser.parseSelect.

Parse a SQL string to a select statement.

Parameters
sql:String

The SQL string

Annotations
@Override
parseSelectback to summary
public final Select<?> parseSelect(String sql, Object... bindings)

Implements org.jooq.Parser.parseSelect.

Doc from org.jooq.Parser.parseSelect.

Parse a SQL string to a select statement.

Parameters
sql:String

The SQL string

bindings:Object[]

The bind variables

Annotations
@Override
parseStatementback to summary
public final Statement parseStatement(String sql)

Implements org.jooq.Parser.parseStatement.

Doc from org.jooq.Parser.parseStatement.

Parse a SQL string to a procedural statement.

Parameters
sql:String

The SQL string

Annotations
@Override
parseStatementback to summary
public final Statement parseStatement(String sql, Object... bindings)

Implements org.jooq.Parser.parseStatement.

Doc from org.jooq.Parser.parseStatement.

Parse a SQL string with bind variables to a procedural statement.

Parameters
sql:String

The SQL string

bindings:Object[]

The bind variables

Annotations
@Override
parseTableback to summary
public final Table<?> parseTable(String sql)

Implements org.jooq.Parser.parseTable.

Doc from org.jooq.Parser.parseTable.

Parse a SQL string to a table.

Parameters
sql:String

The SQL string

Annotations
@Override
parseTableback to summary
public final Table<?> parseTable(String sql, Object... bindings)

Implements org.jooq.Parser.parseTable.

Doc from org.jooq.Parser.parseTable.

Parse a SQL string with bind variables to a table.

Parameters
sql:String

The SQL string

bindings:Object[]

The bind variables

Annotations
@Override