Package org.jooq.util.mysql

Examples of org.jooq.util.mysql.MySQLFactory.select()

771
772
773
774
775
776
777
778
779
780
781
    @Test
    public void testMySQLEncryptionFunctions() throws Exception {
        MySQLFactory create = (MySQLFactory) create();

        assertNotNull(create.select(password("abc")).fetchOne(0));
        assertNotNull(create.select(md5("abc")).fetchOne(0));
        assertNotNull(create.select(sha1("abc")).fetchOne(0));
        assertNotNull(create.select(sha2("abc", 256)).fetchOne(0));
        assertEquals("abc", create.select(decode(encode("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(aesDecrypt(aesEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
View Full Code Here
772
773
774
775
776
777
778
779
780
781
782
    @Test
    public void testMySQLEncryptionFunctions() throws Exception {
        MySQLFactory create = (MySQLFactory) create();

        assertNotNull(create.select(password("abc")).fetchOne(0));
        assertNotNull(create.select(md5("abc")).fetchOne(0));
        assertNotNull(create.select(sha1("abc")).fetchOne(0));
        assertNotNull(create.select(sha2("abc", 256)).fetchOne(0));
        assertEquals("abc", create.select(decode(encode("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(aesDecrypt(aesEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
View Full Code Here
773
774
775
776
777
778
779
780
781
782
783
    public void testMySQLEncryptionFunctions() throws Exception {
        MySQLFactory create = (MySQLFactory) create();

        assertNotNull(create.select(password("abc")).fetchOne(0));
        assertNotNull(create.select(md5("abc")).fetchOne(0));
        assertNotNull(create.select(sha1("abc")).fetchOne(0));
        assertNotNull(create.select(sha2("abc", 256)).fetchOne(0));
        assertEquals("abc", create.select(decode(encode("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(aesDecrypt(aesEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc"))).fetchOne(0));
View Full Code Here
774
775
776
777
778
779
780
781
782
783
784
        MySQLFactory create = (MySQLFactory) create();

        assertNotNull(create.select(password("abc")).fetchOne(0));
        assertNotNull(create.select(md5("abc")).fetchOne(0));
        assertNotNull(create.select(sha1("abc")).fetchOne(0));
        assertNotNull(create.select(sha2("abc", 256)).fetchOne(0));
        assertEquals("abc", create.select(decode(encode("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(aesDecrypt(aesEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc"))).fetchOne(0));
        assertEquals("abc", create.select(uncompress(compress("abc"))).fetchOne(0));
View Full Code Here
775
776
777
778
779
780
781
782
783
784
785
        assertNotNull(create.select(password("abc")).fetchOne(0));
        assertNotNull(create.select(md5("abc")).fetchOne(0));
        assertNotNull(create.select(sha1("abc")).fetchOne(0));
        assertNotNull(create.select(sha2("abc", 256)).fetchOne(0));
        assertEquals("abc", create.select(decode(encode("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(aesDecrypt(aesEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc"))).fetchOne(0));
        assertEquals("abc", create.select(uncompress(compress("abc"))).fetchOne(0));
        assertEquals(3, create.select(uncompressedLength(compress("abc"))).fetchOne(0));
View Full Code Here
776
777
778
779
780
781
782
783
784
785
786
        assertNotNull(create.select(password("abc")).fetchOne(0));
        assertNotNull(create.select(md5("abc")).fetchOne(0));
        assertNotNull(create.select(sha1("abc")).fetchOne(0));
        assertNotNull(create.select(sha2("abc", 256)).fetchOne(0));
        assertEquals("abc", create.select(decode(encode("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(aesDecrypt(aesEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc"))).fetchOne(0));
        assertEquals("abc", create.select(uncompress(compress("abc"))).fetchOne(0));
        assertEquals(3, create.select(uncompressedLength(compress("abc"))).fetchOne(0));
    }
View Full Code Here
777
778
779
780
781
782
783
784
785
786
787
        assertNotNull(create.select(md5("abc")).fetchOne(0));
        assertNotNull(create.select(sha1("abc")).fetchOne(0));
        assertNotNull(create.select(sha2("abc", 256)).fetchOne(0));
        assertEquals("abc", create.select(decode(encode("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(aesDecrypt(aesEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc"))).fetchOne(0));
        assertEquals("abc", create.select(uncompress(compress("abc"))).fetchOne(0));
        assertEquals(3, create.select(uncompressedLength(compress("abc"))).fetchOne(0));
    }
View Full Code Here
778
779
780
781
782
783
784
785
786
787
788
        assertNotNull(create.select(sha1("abc")).fetchOne(0));
        assertNotNull(create.select(sha2("abc", 256)).fetchOne(0));
        assertEquals("abc", create.select(decode(encode("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(aesDecrypt(aesEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc"))).fetchOne(0));
        assertEquals("abc", create.select(uncompress(compress("abc"))).fetchOne(0));
        assertEquals(3, create.select(uncompressedLength(compress("abc"))).fetchOne(0));
    }

    @Test
View Full Code Here
779
780
781
782
783
784
785
786
787
788
789
        assertNotNull(create.select(sha2("abc", 256)).fetchOne(0));
        assertEquals("abc", create.select(decode(encode("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(aesDecrypt(aesEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc"))).fetchOne(0));
        assertEquals("abc", create.select(uncompress(compress("abc"))).fetchOne(0));
        assertEquals(3, create.select(uncompressedLength(compress("abc"))).fetchOne(0));
    }

    @Test
    public void testMySQLJavaKeywordEnums() throws Exception {
View Full Code Here
780
781
782
783
784
785
786
787
788
789
790
        assertEquals("abc", create.select(decode(encode("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(aesDecrypt(aesEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc", "pw"), val("pw"))).fetchOne(0));
        assertEquals("abc", create.select(desDecrypt(desEncrypt("abc"))).fetchOne(0));
        assertEquals("abc", create.select(uncompress(compress("abc"))).fetchOne(0));
        assertEquals(3, create.select(uncompressedLength(compress("abc"))).fetchOne(0));
    }

    @Test
    public void testMySQLJavaKeywordEnums() throws Exception {
        reset = false;
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.