org.jooq.util.mysql

Class MySQLDSL

java.lang.Object

org.jooq.impl.DSL

org.jooq.util.mysql.MySQLDSL

public class MySQLDSL
extends DSL

The SQLDialect.MYSQL 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 MySQL-specific AES_DECRYPT() function
static Field<String>	aesDecrypt(String cryptString, String keyString) Get the MySQL-specific AES_DECRYPT() function
static Field<String>	aesEncrypt(Field<String> string, Field<String> keyString) Get the MySQL-specific AES_ENCRYPT() function
static Field<String>	aesEncrypt(String string, String keyString) Get the MySQL-specific AES_ENCRYPT() function
static Field<String>	compress(Field<String> string) Get the MySQL-specific COMPRESS() function
static Field<String>	compress(String string) Get the MySQL-specific COMPRESS() function
static Field<String>	decode(Field<String> cryptString, Field<String> keyString) Get the MySQL-specific DECODE() function Don't mix this up with the various DSL.decode() methods!
static Field<String>	decode(String cryptString, String keyString) Get the MySQL-specific DECODE() function Don't mix this up with the various DSL.decode() methods!
static Field<String>	desDecrypt(Field<String> cryptString) Get the MySQL-specific DES_DECRYPT() function
static Field<String>	desDecrypt(Field<String> cryptString, Field<String> keyString) Get the MySQL-specific DES_DECRYPT() function
static Field<String>	desDecrypt(String cryptString) Get the MySQL-specific DES_DECRYPT() function
static Field<String>	desDecrypt(String cryptString, String keyString) Get the MySQL-specific DES_DECRYPT() function
static Field<String>	desEncrypt(Field<String> string) Get the MySQL-specific DES_ENCRYPT() function
static Field<String>	desEncrypt(Field<String> string, Field<String> keyString) Get the MySQL-specific DES_ENCRYPT() function
static Field<String>	desEncrypt(String string) Get the MySQL-specific DES_ENCRYPT() function
static Field<String>	desEncrypt(String string, String keyString) Get the MySQL-specific DES_ENCRYPT() function
static Field<String>	encode(Field<String> string, Field<String> keyString) Get the MySQL-specific ENCODE() function
static Field<String>	encode(String string, String keyString) Get the MySQL-specific ENCODE() function
static <E extends Enum<E> & EnumType> E	enumType(Class<E> type, int index) Get a field based EnumType by its MySQL-specific index.
static Field<String>	password(Field<String> string) Get the MySQL-specific PASSWORD() function
static Field<String>	password(String string) Get the MySQL-specific PASSWORD() function
static Field<String>	sha1(Field<String> string) Get the MySQL-specific SHA1() function
static Field<String>	sha1(String string) Get the MySQL-specific SHA1() function
static Field<String>	sha2(Field<String> string, Field<Integer> hashLength) Get the MySQL-specific SHA2() function
static Field<String>	sha2(String string, int hashLength) Get the MySQL-specific SHA2() function
static Field<String>	uncompress(Field<String> string) Get the MySQL-specific UNCOMPRESS() function
static Field<String>	uncompress(String string) Get the MySQL-specific UNCOMPRESS() function
static Field<Integer>	uncompressedLength(Field<String> string) Get the MySQL-specific UNCOMPRESSED_LENGTH() function
static Field<Integer>	uncompressedLength(String string) Get the MySQL-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 MySQL-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 MySQL-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 MySQL-specific ENCODE() function

encode

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

Get the MySQL-specific ENCODE() function

aesDecrypt

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

Get the MySQL-specific AES_DECRYPT() function

aesDecrypt

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

Get the MySQL-specific AES_DECRYPT() function

aesEncrypt

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

Get the MySQL-specific AES_ENCRYPT() function

aesEncrypt

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

Get the MySQL-specific AES_ENCRYPT() function

desDecrypt

public static Field<String> desDecrypt(String cryptString)

Get the MySQL-specific DES_DECRYPT() function

desDecrypt

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

Get the MySQL-specific DES_DECRYPT() function

desDecrypt

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

Get the MySQL-specific DES_DECRYPT() function

desDecrypt

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

Get the MySQL-specific DES_DECRYPT() function

desEncrypt

public static Field<String> desEncrypt(String string)

Get the MySQL-specific DES_ENCRYPT() function

desEncrypt

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

Get the MySQL-specific DES_ENCRYPT() function

desEncrypt

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

Get the MySQL-specific DES_ENCRYPT() function

desEncrypt

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

Get the MySQL-specific DES_ENCRYPT() function

compress

public static Field<String> compress(String string)

Get the MySQL-specific COMPRESS() function

compress

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

Get the MySQL-specific COMPRESS() function

uncompress

public static Field<String> uncompress(String string)

Get the MySQL-specific UNCOMPRESS() function

uncompress

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

Get the MySQL-specific UNCOMPRESS() function

uncompressedLength

public static Field<Integer> uncompressedLength(String string)

Get the MySQL-specific UNCOMPRESSED_LENGTH() function

uncompressedLength

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

Get the MySQL-specific UNCOMPRESSED_LENGTH() function

sha1

public static Field<String> sha1(String string)

Get the MySQL-specific SHA1() function

sha1

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

Get the MySQL-specific SHA1() function

sha2

public static Field<String> sha2(String string,
                 int hashLength)

Get the MySQL-specific SHA2() function

sha2

public static Field<String> sha2(Field<String> string,
                 Field<Integer> hashLength)

Get the MySQL-specific SHA2() function

password

public static Field<String> password(String string)

Get the MySQL-specific PASSWORD() function

password

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

Get the MySQL-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 MySQL-specific index.

If your MySQL 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()	MySQL 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