Module org.jooq

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 Details

    • MariaDBDSL

      protected MariaDBDSL()
      No instances
  • Method Details

    • 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