Module org.jooq

Package org.jooq.util.mariadb

Class MariaDBDSL

java.lang.Object

org.jooq.impl.DSL

org.jooq.util.mariadb.MariaDBDSL

public class MariaDBDSL
extends DSL

The SQLDialect.MARIADB specific DSL.

Author:

Lukas Eder

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	MariaDBDSL()	No instances

Method Summary

Modifier and Type	Method	Description
static Field<String>	aesDecrypt(String cryptString, String keyString)	Get the MariaDB-specific AES_DECRYPT() function
static Field<String>	aesDecrypt(Field<String> cryptString, Field<String> keyString)	Get the MariaDB-specific AES_DECRYPT() function
static Field<String>	aesEncrypt(String string, String keyString)	Get the MariaDB-specific AES_ENCRYPT() function
static Field<String>	aesEncrypt(Field<String> string, Field<String> keyString)	Get the MariaDB-specific AES_ENCRYPT() function
static Field<String>	compress(String string)	Get the MariaDB-specific COMPRESS() function
static Field<String>	compress(Field<String> string)	Get the MariaDB-specific COMPRESS() function
static Field<String>	decode(String cryptString, String keyString)	Get the MariaDB-specific DECODE() function
static Field<String>	decode(Field<String> cryptString, Field<String> keyString)	Get the MariaDB-specific DECODE() function
static Field<String>	desDecrypt(String cryptString)	Get the MariaDB-specific DES_DECRYPT() function
static Field<String>	desDecrypt(String cryptString, String keyString)	Get the MariaDB-specific DES_DECRYPT() function
static Field<String>	desDecrypt(Field<String> cryptString)	Get the MariaDB-specific DES_DECRYPT() function
static Field<String>	desDecrypt(Field<String> cryptString, Field<String> keyString)	Get the MariaDB-specific DES_DECRYPT() function
static Field<String>	desEncrypt(String string)	Get the MariaDB-specific DES_ENCRYPT() function
static Field<String>	desEncrypt(String string, String keyString)	Get the MariaDB-specific DES_ENCRYPT() function
static Field<String>	desEncrypt(Field<String> string)	Get the MariaDB-specific DES_ENCRYPT() function
static Field<String>	desEncrypt(Field<String> string, Field<String> keyString)	Get the MariaDB-specific DES_ENCRYPT() function
static Field<String>	encode(String string, String keyString)	Get the MariaDB-specific ENCODE() function
static Field<String>	encode(Field<String> string, Field<String> keyString)	Get the MariaDB-specific ENCODE() function
static <E extends Enum<E> & EnumType> E	enumType(Class<E> type, int index)	Get a field based EnumType by its MariaDB-specific index.
static Field<String>	password(String string)	Get the MariaDB-specific PASSWORD() function
static Field<String>	password(Field<String> string)	Get the MariaDB-specific PASSWORD() function
static Field<String>	sha1(String string)	Get the MariaDB-specific SHA1() function
static Field<String>	sha1(Field<String> string)	Get the MariaDB-specific SHA1() function
static Field<String>	uncompress(String string)	Get the MariaDB-specific UNCOMPRESS() function
static Field<String>	uncompress(Field<String> string)	Get the MariaDB-specific UNCOMPRESS() function
static Field<Integer>	uncompressedLength(String string)	Get the MariaDB-specific UNCOMPRESSED_LENGTH() function
static Field<Integer>	uncompressedLength(Field<String> string)	Get the MariaDB-specific UNCOMPRESSED_LENGTH() function

Methods inherited from class org.jooq.impl.DSL

abs, abs, acos, acos, all, all, all, all, alterIndex, alterIndex, alterIndex, alterIndexIfExists, alterIndexIfExists, alterIndexIfExists, alterSchema, alterSchema, alterSchema, alterSchemaIfExists, alterSchemaIfExists, alterSchemaIfExists, alterSequence, alterSequence, alterSequence, alterSequenceIfExists, alterSequenceIfExists, alterSequenceIfExists, alterTable, alterTable, alterTable, alterTableIfExists, alterTableIfExists, alterTableIfExists, alterType, alterType, alterView, alterView, alterView, alterViewIfExists, alterViewIfExists, alterViewIfExists, and, and, and, any, any, any, any, array, array, array, arrayAgg, arrayAggDistinct, ascii, ascii, asin, asin, asterisk, atan, atan, atan2, atan2, atan2, atan2, avg, avgDistinct, begin, begin, bitAnd, bitAnd, bitAnd, bitAnd, bitCount, bitCount, bitLength, bitLength, bitNand, bitNand, bitNand, bitNand, bitNor, bitNor, bitNor, bitNor, bitNot, bitNot, bitOr, bitOr, bitOr, bitOr, bitXNor, bitXNor, bitXNor, bitXNor, bitXor, bitXor, bitXor, bitXor, boolAnd, boolAnd, boolOr, boolOr, case_, case_, case_, cast, cast, cast, cast, cast, cast, castNull, castNull, castNull, catalog, ceil, ceil, century, century, century, characterSet, characterSet, charLength, charLength, check, choose, choose, choose, choose, choose, choose, choose, coalesce, coalesce, coalesce, coerce, coerce, coerce, coerce, coerce, coerce, collation, collation, collect, collect, collectDistinct, collectDistinct, comment, commentOnColumn, commentOnColumn, commentOnTable, commentOnTable, commentOnTable, commentOnView, commentOnView, commentOnView, concat, concat, concat, concat, condition, condition, condition, condition, condition, condition, condition, condition, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, constraint, constraint, constraint, continue_, continue_, continueWhen, convert, convert, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, count, count, countDistinct, countDistinct, countDistinct, countDistinct, createGlobalTemporaryTable, createGlobalTemporaryTable, createGlobalTemporaryTable, createIndex, createIndex, createIndex, createIndex, createIndexIfNotExists, createIndexIfNotExists, createIndexIfNotExists, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createOrReplaceView, createSchema, createSchema, createSchema, createSchemaIfNotExists, createSchemaIfNotExists, createSchemaIfNotExists, createSequence, createSequence, createSequence, createSequenceIfNotExists, createSequenceIfNotExists, createSequenceIfNotExists, createTable, createTable, createTable, createTableIfNotExists, createTableIfNotExists, createTableIfNotExists, createTemporaryTable, createTemporaryTable, createTemporaryTable, createTemporaryTableIfNotExists, createTemporaryTableIfNotExists, createTemporaryTableIfNotExists, createType, createType, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndex, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createUniqueIndexIfNotExists, createView, createView, createView, createView, createView, createView, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, createViewIfNotExists, cube, cube, cumeDist, cumeDist, cumeDist, currentDate, currentInstant, currentLocalDate, currentLocalDateTime, currentLocalTime, currentOffsetDateTime, currentOffsetTime, currentSchema, currentTime, currentTimestamp, currentTimestamp, currentUser, date, date, date, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, dateSub, dateSub, dateSub, dateSub, dateSub, dateSub, day, day, day, dayOfWeek, dayOfWeek, dayOfWeek, dayOfYear, dayOfYear, dayOfYear, decade, decade, decade, declare, decode, decode, decode, decode, decode, default_, default_, default_, default_, defaultValue, defaultValue, defaultValue, defaultValue, deg, deg, delete, deleteFrom, denseRank, denseRank, denseRank, dropIndex, dropIndex, dropIndex, dropIndexIfExists, dropIndexIfExists, dropIndexIfExists, dropSchema, dropSchema, dropSchema, dropSchemaIfExists, dropSchemaIfExists, dropSchemaIfExists, dropSequence, dropSequence, dropSequence, dropSequenceIfExists, dropSequenceIfExists, dropSequenceIfExists, dropTable, dropTable, dropTable, dropTableIfExists, dropTableIfExists, dropTableIfExists, dropTemporaryTable, dropTemporaryTable, dropTemporaryTable, dropTemporaryTableIfExists, dropTemporaryTableIfExists, dropTemporaryTableIfExists, dropType, dropType, dropType, dropType, dropType, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropTypeIfExists, dropView, dropView, dropView, dropViewIfExists, dropViewIfExists, dropViewIfExists, dual, e, epoch, epoch, epoch, escape, escape, every, every, execute, execute, execute, exists, exit, exit, exitWhen, exp, exp, extract, extract, extract, falseCondition, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, field, fieldByName, fieldByName, fieldByName, firstValue, floor, floor, for_, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, foreignKey, function, function, function, function, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, generateSeries, getDataType, goto_, grant, grant, grant, greatest, greatest, groupConcat, groupConcat, groupConcatDistinct, groupId, grouping, groupingId, groupingSets, groupingSets, groupingSets, groupsBetweenCurrentRow, groupsBetweenFollowing, groupsBetweenPreceding, groupsBetweenUnboundedFollowing, groupsBetweenUnboundedPreceding, groupsCurrentRow, groupsFollowing, groupsPreceding, groupsUnboundedFollowing, groupsUnboundedPreceding, hour, hour, hour, if_, ifnull, ifnull, ifnull, ifnull, iif, iif, iif, iif, index, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, inline, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, insertInto, instant, instant, instant, isnull, isnull, isnull, isnull, isoDayOfWeek, isoDayOfWeek, isoDayOfWeek, jsonArray, jsonArray, jsonbArray, jsonbArray, jsonbObject, jsonbObject, jsonEntry, jsonObject, jsonObject, jsonObject, keyword, label, label, lag, lag, lag, lag, lastValue, lateral, lead, lead, lead, lead, least, least, left, left, left, left, length, length, level, link, link, link, list, list, listAgg, listAgg, ln, ln, localDate, localDate, localDate, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateAdd, localDateDiff, localDateDiff, localDateDiff, localDateDiff, localDateSub, localDateSub, localDateSub, localDateSub, localDateSub, localDateSub, localDateTime, localDateTime, localDateTime, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeAdd, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeDiff, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localDateTimeSub, localTime, localTime, localTime, log, log, log, loop, loop, lower, lower, lpad, lpad, lpad, lpad, lpad, ltrim, ltrim, ltrim, ltrim, max, maxDistinct, md5, md5, median, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, mergeInto, microsecond, microsecond, microsecond, mid, mid, millennium, millennium, millennium, millisecond, millisecond, millisecond, min, minDistinct, minus, minute, minute, minute, mode, mode, month, month, month, name, name, name, name, neg, noCondition, not, not, not, notExists, notUnique, now, now, nthValue, nthValue, ntile, nullif, nullif, nullif, nullif, nullSafe, nullSafe, nullSafe, nullSafeDataType, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, offsetDateTime, offsetDateTime, offsetDateTime, offsetTime, offsetTime, offsetTime, one, or, or, or, orderBy, orderBy, orderBy, param, param, param, param, param, param, param, param, param, partitionBy, partitionBy, percentileCont, percentileCont, percentileDisc, percentileDisc, percentRank, percentRank, percentRank, period, period, period, pi, position, position, position, position, position, position, position, position, position, position, position, position, power, power, power, power, primaryKey, primaryKey, primaryKey, prior, privilege, product, productDistinct, quarter, quarter, quarter, queries, queries, query, query, query, query, queryPart, queryPart, queryPart, quotedName, quotedName, quotedName, rad, rad, rand, rangeBetweenCurrentRow, rangeBetweenFollowing, rangeBetweenPreceding, rangeBetweenUnboundedFollowing, rangeBetweenUnboundedPreceding, rangeCurrentRow, rangeFollowing, rangePreceding, rangeUnboundedFollowing, rangeUnboundedPreceding, rank, rank, rank, ratioToReport, ratioToReport, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, recordType, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, repeat, repeat, repeat, repeat, repeat, repeat, replace, replace, replace, replace, resultQuery, resultQuery, resultQuery, resultQuery, return_, return_, return_, reverse, reverse, revoke, revoke, revoke, revokeGrantOptionFor, revokeGrantOptionFor, revokeGrantOptionFor, right, right, right, right, role, role, rollup, rollup, round, round, round, round, round, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rowField, rownum, rowNumber, rowsBetweenCurrentRow, rowsBetweenFollowing, rowsBetweenPreceding, rowsBetweenUnboundedFollowing, rowsBetweenUnboundedPreceding, rowsCurrentRow, rowsFollowing, rowsFrom, rowsPreceding, rowsUnboundedFollowing, rowsUnboundedPreceding, rpad, rpad, rpad, rpad, rpad, rtrim, rtrim, rtrim, rtrim, schema, schemaByName, second, second, second, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, select, selectCount, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectDistinct, selectFrom, selectFrom, selectFrom, selectFrom, selectFrom, selectFrom, selectOne, selectZero, sequence, sequence, sequence, sequence, sequence, sequence, sequenceByName, sequenceByName, sequenceByName, set, setCatalog, setCatalog, setCatalog, setSchema, setSchema, setSchema, shl, shl, shl, shl, shr, shr, shr, shr, sign, sign, sin, sin, sinh, sinh, space, space, sql, sql, sql, sqrt, sqrt, statement, statement, statement, statement, statements, statements, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, systemTime, systemTime, systemTime, table, table, table, table, table, table, table, table, table, table, table, table, table, table, tableByName, tan, tan, tanh, tanh, time, time, time, timestamp, timestamp, timestamp, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampAdd, timestampDiff, timestampDiff, timestampDiff, timestampDiff, timestampSub, timestampSub, timestampSub, timestampSub, timestampSub, timestampSub, timezone, timezone, timezone, timezoneHour, timezoneHour, timezoneHour, timezoneMinute, timezoneMinute, timezoneMinute, toDate, toDate, toDate, toDate, toLocalDate, toLocalDate, toLocalDate, toLocalDate, toLocalDateTime, toLocalDateTime, toLocalDateTime, toLocalDateTime, toTimestamp, toTimestamp, toTimestamp, toTimestamp, translate, translate, trim, trim, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, trunc, truncate, truncate, truncate, truncateTable, truncateTable, truncateTable, two, unique, unique, unique, unique, unnest, unnest, unnest, unnest, unquotedName, unquotedName, unquotedName, update, upper, upper, user, user, using, using, using, using, using, using, using, using, using, using, using, using, using, using, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, val, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, value, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, values, var, var, variable, variable, varPop, varSamp, week, week, week, when, when, when, while_, widthBucket, widthBucket, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, with, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, withRecursive, year, year, year, zero

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

MariaDBDSL

protected MariaDBDSL()

No instances

Method Detail

decode

public static Field<String> decode(String cryptString,
                                   String keyString)

Get the MariaDB-specific DECODE() function

Don't mix this up with the various DSL.decode() methods!

decode

public static Field<String> decode(Field<String> cryptString,
                                   Field<String> keyString)

Get the MariaDB-specific DECODE() function

Don't mix this up with the various DSL.decode() methods!

encode

public static Field<String> encode(String string,
                                   String keyString)

Get the MariaDB-specific ENCODE() function

encode

public static Field<String> encode(Field<String> string,
                                   Field<String> keyString)

Get the MariaDB-specific ENCODE() function

aesDecrypt

public static Field<String> aesDecrypt(String cryptString,
                                       String keyString)

Get the MariaDB-specific AES_DECRYPT() function

aesDecrypt

public static Field<String> aesDecrypt(Field<String> cryptString,
                                       Field<String> keyString)

Get the MariaDB-specific AES_DECRYPT() function

aesEncrypt

public static Field<String> aesEncrypt(String string,
                                       String keyString)

Get the MariaDB-specific AES_ENCRYPT() function

aesEncrypt

public static Field<String> aesEncrypt(Field<String> string,
                                       Field<String> keyString)

Get the MariaDB-specific AES_ENCRYPT() function

desDecrypt

public static Field<String> desDecrypt(String cryptString)

Get the MariaDB-specific DES_DECRYPT() function

desDecrypt

public static Field<String> desDecrypt(Field<String> cryptString)

Get the MariaDB-specific DES_DECRYPT() function

desDecrypt

public static Field<String> desDecrypt(String cryptString,
                                       String keyString)

Get the MariaDB-specific DES_DECRYPT() function

desDecrypt

public static Field<String> desDecrypt(Field<String> cryptString,
                                       Field<String> keyString)

Get the MariaDB-specific DES_DECRYPT() function

desEncrypt

public static Field<String> desEncrypt(String string)

Get the MariaDB-specific DES_ENCRYPT() function

desEncrypt

public static Field<String> desEncrypt(Field<String> string)

Get the MariaDB-specific DES_ENCRYPT() function

desEncrypt

public static Field<String> desEncrypt(String string,
                                       String keyString)

Get the MariaDB-specific DES_ENCRYPT() function

desEncrypt

public static Field<String> desEncrypt(Field<String> string,
                                       Field<String> keyString)

Get the MariaDB-specific DES_ENCRYPT() function

compress

public static Field<String> compress(String string)

Get the MariaDB-specific COMPRESS() function

compress

public static Field<String> compress(Field<String> string)

Get the MariaDB-specific COMPRESS() function

uncompress

public static Field<String> uncompress(String string)

Get the MariaDB-specific UNCOMPRESS() function

uncompress

public static Field<String> uncompress(Field<String> string)

Get the MariaDB-specific UNCOMPRESS() function

uncompressedLength

public static Field<Integer> uncompressedLength(String string)

Get the MariaDB-specific UNCOMPRESSED_LENGTH() function

uncompressedLength

public static Field<Integer> uncompressedLength(Field<String> string)

Get the MariaDB-specific UNCOMPRESSED_LENGTH() function

sha1

public static Field<String> sha1(String string)

Get the MariaDB-specific SHA1() function

sha1

public static Field<String> sha1(Field<String> string)

Get the MariaDB-specific SHA1() function

password

public static Field<String> password(String string)

Get the MariaDB-specific PASSWORD() function

password

public static Field<String> password(Field<String> string)

Get the MariaDB-specific PASSWORD() function

enumType

public static <E extends Enum<E> & EnumType> E enumType(Class<E> type,
                                                        int index)

Get a field based EnumType by its MariaDB-specific index.

If your MariaDB enum type contains these three values: A, B, C , then this will be the mapping of indexes to values:

Enum literal as in Enum.name()	Enum ordinal as in Enum.ordinal()	MariaDB index
null	-	0
A	0	1
B	1	2
C	2	3

See dev.mysql.com/doc/ refman/5.5/en/enum.html for more details about MySQL enum types