- java.lang.Object
-
- org.jooq.impl.DSL
-
- org.jooq.util.mariadb.MariaDBDSL
-
public class MariaDBDSL extends DSL
TheSQLDialect.MARIADB
specific DSL.- Author:
- Lukas Eder
-
-
Constructor Summary
Constructors Modifier Constructor Description protected
MariaDBDSL()
No instances
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static Field<String>
aesDecrypt(String cryptString, String keyString)
Get the MariaDB-specificAES_DECRYPT()
functionstatic Field<String>
aesDecrypt(Field<String> cryptString, Field<String> keyString)
Get the MariaDB-specificAES_DECRYPT()
functionstatic Field<String>
aesEncrypt(String string, String keyString)
Get the MariaDB-specificAES_ENCRYPT()
functionstatic Field<String>
aesEncrypt(Field<String> string, Field<String> keyString)
Get the MariaDB-specificAES_ENCRYPT()
functionstatic Field<String>
compress(String string)
Get the MariaDB-specificCOMPRESS()
functionstatic Field<String>
compress(Field<String> string)
Get the MariaDB-specificCOMPRESS()
functionstatic Field<String>
decode(String cryptString, String keyString)
Get the MariaDB-specificDECODE()
functionstatic Field<String>
decode(Field<String> cryptString, Field<String> keyString)
Get the MariaDB-specificDECODE()
functionstatic Field<String>
desDecrypt(String cryptString)
Get the MariaDB-specificDES_DECRYPT()
functionstatic Field<String>
desDecrypt(String cryptString, String keyString)
Get the MariaDB-specificDES_DECRYPT()
functionstatic Field<String>
desDecrypt(Field<String> cryptString)
Get the MariaDB-specificDES_DECRYPT()
functionstatic Field<String>
desDecrypt(Field<String> cryptString, Field<String> keyString)
Get the MariaDB-specificDES_DECRYPT()
functionstatic Field<String>
desEncrypt(String string)
Get the MariaDB-specificDES_ENCRYPT()
functionstatic Field<String>
desEncrypt(String string, String keyString)
Get the MariaDB-specificDES_ENCRYPT()
functionstatic Field<String>
desEncrypt(Field<String> string)
Get the MariaDB-specificDES_ENCRYPT()
functionstatic Field<String>
desEncrypt(Field<String> string, Field<String> keyString)
Get the MariaDB-specificDES_ENCRYPT()
functionstatic Field<String>
encode(String string, String keyString)
Get the MariaDB-specificENCODE()
functionstatic Field<String>
encode(Field<String> string, Field<String> keyString)
Get the MariaDB-specificENCODE()
functionstatic <E extends Enum<E> & EnumType>
EenumType(Class<E> type, int index)
Get a field basedEnumType
by its MariaDB-specific index.static Field<String>
password(String string)
Get the MariaDB-specificPASSWORD()
functionstatic Field<String>
password(Field<String> string)
Get the MariaDB-specificPASSWORD()
functionstatic Field<String>
sha1(String string)
Get the MariaDB-specificSHA1()
functionstatic Field<String>
sha1(Field<String> string)
Get the MariaDB-specificSHA1()
functionstatic Field<String>
uncompress(String string)
Get the MariaDB-specificUNCOMPRESS()
functionstatic Field<String>
uncompress(Field<String> string)
Get the MariaDB-specificUNCOMPRESS()
functionstatic Field<Integer>
uncompressedLength(String string)
Get the MariaDB-specificUNCOMPRESSED_LENGTH()
functionstatic Field<Integer>
uncompressedLength(Field<String> string)
Get the MariaDB-specificUNCOMPRESSED_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, 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, 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, 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, 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, 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, reverse, reverse, revoke, revoke, revoke, revokeGrantOptionFor, revokeGrantOptionFor, revokeGrantOptionFor, right, right, right, right, role, role, rollup, rollup, 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, 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, statements, statements, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, 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
-
-
-
-
Method Detail
-
decode
public static Field<String> decode(String cryptString, String keyString)
Get the MariaDB-specificDECODE()
functionDon'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-specificDECODE()
functionDon't mix this up with the various
DSL.decode()
methods!
-
encode
public static Field<String> encode(String string, String keyString)
Get the MariaDB-specificENCODE()
function
-
encode
public static Field<String> encode(Field<String> string, Field<String> keyString)
Get the MariaDB-specificENCODE()
function
-
aesDecrypt
public static Field<String> aesDecrypt(String cryptString, String keyString)
Get the MariaDB-specificAES_DECRYPT()
function
-
aesDecrypt
public static Field<String> aesDecrypt(Field<String> cryptString, Field<String> keyString)
Get the MariaDB-specificAES_DECRYPT()
function
-
aesEncrypt
public static Field<String> aesEncrypt(String string, String keyString)
Get the MariaDB-specificAES_ENCRYPT()
function
-
aesEncrypt
public static Field<String> aesEncrypt(Field<String> string, Field<String> keyString)
Get the MariaDB-specificAES_ENCRYPT()
function
-
desDecrypt
public static Field<String> desDecrypt(String cryptString)
Get the MariaDB-specificDES_DECRYPT()
function
-
desDecrypt
public static Field<String> desDecrypt(Field<String> cryptString)
Get the MariaDB-specificDES_DECRYPT()
function
-
desDecrypt
public static Field<String> desDecrypt(String cryptString, String keyString)
Get the MariaDB-specificDES_DECRYPT()
function
-
desDecrypt
public static Field<String> desDecrypt(Field<String> cryptString, Field<String> keyString)
Get the MariaDB-specificDES_DECRYPT()
function
-
desEncrypt
public static Field<String> desEncrypt(String string)
Get the MariaDB-specificDES_ENCRYPT()
function
-
desEncrypt
public static Field<String> desEncrypt(Field<String> string)
Get the MariaDB-specificDES_ENCRYPT()
function
-
desEncrypt
public static Field<String> desEncrypt(String string, String keyString)
Get the MariaDB-specificDES_ENCRYPT()
function
-
desEncrypt
public static Field<String> desEncrypt(Field<String> string, Field<String> keyString)
Get the MariaDB-specificDES_ENCRYPT()
function
-
compress
public static Field<String> compress(String string)
Get the MariaDB-specificCOMPRESS()
function
-
compress
public static Field<String> compress(Field<String> string)
Get the MariaDB-specificCOMPRESS()
function
-
uncompress
public static Field<String> uncompress(String string)
Get the MariaDB-specificUNCOMPRESS()
function
-
uncompress
public static Field<String> uncompress(Field<String> string)
Get the MariaDB-specificUNCOMPRESS()
function
-
uncompressedLength
public static Field<Integer> uncompressedLength(String string)
Get the MariaDB-specificUNCOMPRESSED_LENGTH()
function
-
uncompressedLength
public static Field<Integer> uncompressedLength(Field<String> string)
Get the MariaDB-specificUNCOMPRESSED_LENGTH()
function
-
sha1
public static Field<String> sha1(Field<String> string)
Get the MariaDB-specificSHA1()
function
-
password
public static Field<String> password(String string)
Get the MariaDB-specificPASSWORD()
function
-
password
public static Field<String> password(Field<String> string)
Get the MariaDB-specificPASSWORD()
function
-
enumType
public static <E extends Enum<E> & EnumType> E enumType(Class<E> type, int index)
Get a field basedEnumType
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
-
-