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

Method Summary

Methods

Modifier and Type	Method and Description
static Field<String>	aesDecrypt(Field<String> cryptString, Field<String> keyString) Get the MariaDB-specific AES_DECRYPT() function
static Field<String>	aesDecrypt(String cryptString, String keyString) Get the MariaDB-specific AES_DECRYPT() function
static Field<String>	aesEncrypt(Field<String> string, Field<String> keyString) Get the MariaDB-specific AES_ENCRYPT() function
static Field<String>	aesEncrypt(String string, String keyString) Get the MariaDB-specific AES_ENCRYPT() function
static Field<String>	compress(Field<String> string) Get the MariaDB-specific COMPRESS() function
static Field<String>	compress(String string) Get the MariaDB-specific COMPRESS() function
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!
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!
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>	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>	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>	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>	encode(Field<String> string, Field<String> keyString) Get the MariaDB-specific ENCODE() function
static Field<String>	encode(String string, 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 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-0A01B12C23 See dev.mysql.com/doc/ refman/5.5/en/enum.html for more details about MySQL enum types static Field<String> password(Field<String> string) Get the MariaDB-specific PASSWORD() function static Field<String> password(String string) Get the MariaDB-specific PASSWORD() function static Field<String> sha1(Field<String> string) Get the MariaDB-specific SHA1() function static Field<String> sha1(String string) Get the MariaDB-specific SHA1() function static Field<String> uncompress(Field<String> string) Get the MariaDB-specific UNCOMPRESS() function static Field<String> uncompress(String string) Get the MariaDB-specific UNCOMPRESS() function static Field<Integer> uncompressedLength(Field<String> string) Get the MariaDB-specific UNCOMPRESSED_LENGTH() function static Field<Integer> uncompressedLength(String string) Get the MariaDB-specific UNCOMPRESSED_LENGTH() function Methods inherited from class org.jooq.impl.DSL abs, abs, acos, acos, all, all, all, any, any, any, ascii, ascii, asin, asin, atan, atan, atan2, atan2, atan2, atan2, avg, avgDistinct, 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, cast, cast, cast, cast, cast, cast, castNull, castNull, castNull, ceil, ceil, charLength, charLength, coalesce, coalesce, coerce, coerce, coerce, concat, concat, condition, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, countDistinct, countDistinct, cube, cumeDist, currentDate, currentTime, currentTimestamp, currentUser, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, day, day, decode, decode, decode, decode, decode, deg, deg, delete, denseRank, dual, e, escape, escape, exists, exp, exp, extract, extract, falseCondition, field, field, field, field, field, field, field, field, field, field, fieldByName, fieldByName, fieldByName, firstValue, floor, floor, function, function, function, function, generateSeries, generateSeries, getDataType, greatest, greatest, groupConcat, groupConcatDistinct, grouping, groupingId, groupingSets, groupingSets, groupingSets, hour, hour, 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, keyword, lag, lag, lag, lag, lastValue, lead, lead, lead, lead, least, least, length, length, level, listAgg, listAgg, ln, ln, log, log, lower, lower, lpad, lpad, lpad, lpad, lpad, 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, min, minDistinct, minute, minute, month, month, name, not, notExists, ntile, nullif, nullif, nullif, nullif, nullSafe, nullSafe, nullSafeDataType, nvl, nvl, nvl, nvl, nvl2, nvl2, nvl2, nvl2, octetLength, octetLength, one, param, param, param, param, percentRank, pi, position, position, position, position, power, power, power, power, prior, queryPart, queryPart, queryPart, rad, rad, rand, rank, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, repeat, repeat, repeat, repeat, replace, replace, replace, replace, 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, rownum, rowNumber, rpad, rpad, rpad, rpad, rpad, rtrim, rtrim, schemaByName, 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, selectOne, selectZero, shl, shl, shl, shl, shr, shr, shr, shr, sign, sign, sin, sin, sinh, sinh, sqrt, sqrt, stddevPop, stddevSamp, substring, substring, substring, substring, sum, sumDistinct, sysConnectByPath, table, table, table, table, table, table, table, table, tableByName, tan, tan, tanh, tanh, timestampAdd, timestampAdd, timestampDiff, timestampDiff, timestampDiff, timestampDiff, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, truncate, two, unnest, unnest, unnest, unnest, update, upper, upper, using, using, using, using, using, using, using, using, using, using, using, val, val, val, val, 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, varPop, varSamp, year, year, zero Methods inherited from class java.lang.Object clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait 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 Overview Package Class Use Deprecated Index Help Prev Class Next Class Frames No Frames All Classes Summary: Nested | Field | Constr | Method Detail: Field | Constr | Method Copyright © 2013. All Rights Reserved.