org.jooq.util.mysql

Class MySQLFactory

java.lang.Object

org.jooq.impl.Factory

org.jooq.util.mysql.MySQLFactory

All Implemented Interfaces:

Serializable, Configuration, FactoryOperations

public class MySQLFactory
extends Factory

A SQLDialect.MYSQL specific factory

Author:

Lukas Eder

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor and Description
MySQLFactory() Create a connection-less factory Without a connection, this factory cannot execute queries.
MySQLFactory(Connection connection) Create a factory with connection
MySQLFactory(Connection connection, SchemaMapping mapping) Deprecated. - 2.0.5 - Use MySQLFactory(Connection, Settings) instead
MySQLFactory(Connection connection, Settings settings) Create a factory with connection and a settings configured
MySQLFactory(DataSource dataSource) Create a factory with a data source
MySQLFactory(DataSource dataSource, Settings settings) Create a factory with a data source and a settings configured
MySQLFactory(Settings settings) Create a factory with settings configured Without a connection, this factory cannot execute queries.

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 Factory.decode() methods!
static Field<String>	decode(String cryptString, String keyString) Get the MySQL-specific DECODE() function Don't mix this up with the various Factory.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 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-0A01B12C23 See dev.mysql.com/doc/ refman/5.5/en/enum.html for more details about MySQL enum types static Field<String> md5(Field<String> string) Get the MySQL-specific MD5() function static Field<String> md5(String string) Get the MySQL-specific MD5() function 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.Factory abs, abs, acos, acos, ascii, ascii, asin, asin, atan, atan, atan2, atan2, atan2, atan2, attach, attach, avg, avgDistinct, batch, batch, batch, batchStore, batchStore, bind, bindContext, 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, castNull, castNull, castNull, ceil, ceil, charLength, charLength, coalesce, coalesce, commit, concat, concat, condition, condition, condition, connectByIsCycle, connectByIsLeaf, connectByRoot, cos, cos, cosh, cosh, cot, cot, coth, coth, count, count, countDistinct, countDistinct, cube, cumeDist, currentDate, currentTime, currentTimestamp, currentUser, currval, dateAdd, dateAdd, dateDiff, dateDiff, dateDiff, dateDiff, day, day, decode, decode, decode, decode, decode, deg, deg, delete, deleteQuery, denseRank, e, escape, escape, execute, execute, execute, executeDelete, executeDelete, executeDelete, executeDelete, executeDeleteOne, executeDeleteOne, executeInsert, executeInsert, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdateOne, executeUpdateOne, exists, exp, exp, extract, extract, falseCondition, fetch, fetch, fetch, fetch, fetch, fetch, fetchAny, fetchFromCSV, fetchFromCSV, fetchLazy, fetchLazy, fetchLazy, fetchLazy, fetchMany, fetchMany, fetchMany, fetchOne, fetchOne, fetchOne, fetchOne, fetchOne, field, field, field, field, field, field, field, field, field, fieldByName, fieldByName, fieldByName, firstValue, floor, floor, function, function, getAutoCommit, getConnection, getData, getData, getDataSource, getDataType, getDialect, getHoldability, getSchemaMapping, getSettings, getTransactionIsolation, greatest, greatest, groupConcat, groupConcatDistinct, grouping, groupingId, groupingSets, groupingSets, groupingSets, hour, hour, inline, inline, inline, inline, inline, inline, inline, insertInto, insertInto, insertInto, insertInto, insertQuery, lag, lag, lag, lag, lastID, lastValue, lead, lead, lead, lead, least, least, length, length, level, listAgg, listAgg, literal, literal, literal, ln, ln, loadInto, log, log, lower, lower, lpad, lpad, lpad, lpad, lpad, ltrim, ltrim, max, maxDistinct, median, mergeInto, mergeInto, mergeInto, min, minDistinct, minute, minute, month, month, name, newRecord, newRecord, newRecord, nextval, 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, query, query, query, rad, rad, rand, rank, regrAvgX, regrAvgY, regrCount, regrIntercept, regrR2, regrSlope, regrSXX, regrSXY, regrSYY, releaseSavepoint, render, renderContext, renderInlined, renderNamedParams, repeat, repeat, repeat, repeat, replace, replace, replace, replace, resultQuery, resultQuery, resultQuery, rollback, rollback, rollup, round, round, round, round, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, row, rowNumber, rpad, rpad, rpad, rpad, rpad, rtrim, rtrim, schemaByName, second, second, select, select, selectCount, selectDistinct, selectDistinct, selectFrom, selectOne, selectQuery, selectQuery, selectZero, setAutoCommit, setConnection, setData, setDataSource, setHoldability, setSavepoint, setSavepoint, setTransactionIsolation, 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, toString, trim, trim, trueCondition, trunc, trunc, trunc, trunc, trunc, truncate, two, unnest, unnest, unnest, unnest, update, updateQuery, upper, upper, use, use, val, val, val, val, vals, value, value, value, value, varPop, varSamp, year, year, zero Methods inherited from class java.lang.Object clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait Constructor Detail MySQLFactory @Deprecated public MySQLFactory(Connection connection, SchemaMapping mapping) Deprecated. - 2.0.5 - Use MySQLFactory(Connection, Settings) instead Create a factory with connection and a schema mapping configured Parameters: connection - The connection to use with objects created from this factory mapping - The schema mapping to use with objects created from this factory MySQLFactory public MySQLFactory(Connection connection, Settings settings) Create a factory with connection and a settings configured Parameters: connection - The connection to use with objects created from this factory settings - The runtime settings to apply to objects created from this factory MySQLFactory public MySQLFactory(DataSource dataSource, Settings settings) Create a factory with a data source and a settings configured Parameters: dataSource - The data source to use with objects created from this factory settings - The runtime settings to apply to objects created from this factory MySQLFactory public MySQLFactory(Connection connection) Create a factory with connection Parameters: connection - The connection to use with objects created from this factory MySQLFactory public MySQLFactory(DataSource dataSource) Create a factory with a data source Parameters: dataSource - The data source to use with objects created from this factory MySQLFactory public MySQLFactory(Settings settings) Create a factory with settings configured Without a connection, this factory cannot execute queries. Use it to render SQL only. Parameters: settings - The runtime settings to apply to objects created from this factory MySQLFactory public MySQLFactory() Create a connection-less factory Without a connection, this factory cannot execute queries. Use it to render SQL only. 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 Factory.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 Factory.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 md5 public static Field<String> md5(String string) Get the MySQL-specific MD5() function md5 public static Field<String> md5(Field<String> string) Get the MySQL-specific MD5() 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 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.