Module org.jooq

Class MariaDBDSL

    • Constructor Detail

      • MariaDBDSL

        protected MariaDBDSL()
        No instances
    • 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!

      • encode

        public static Field<String> encode​(String string,
                                           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
      • aesEncrypt

        public static Field<String> aesEncrypt​(String string,
                                               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
      • 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
      • 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
      • 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