Package com.alibaba.druid.wall

Examples of com.alibaba.druid.wall.WallProvider.checkValid()

50
51
52
53
54
55
56
57
58
59
60
    }

    public void test_true_2() throws Exception {
        WallProvider provider = new MySqlWallProvider();

        Assert.assertTrue(provider.checkValid(//
        "SELECT @@version FROM X"));

        Assert.assertEquals(1, provider.getTableStats().size());
    }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
    }

    public void test_false() throws Exception {
        WallProvider provider = new MySqlWallProvider();

        Assert.assertFalse(provider.checkValid(//
        "SELECT * FROM X where id=1 and 1!=1 union select @@version"));

        Assert.assertEquals(1, provider.getTableStats().size());
    }
}
View Full Code Here
34
35
36
37
38
39
40
41
42
43
    public void test_true() throws Exception {
        WallProvider provider = new SQLServerWallProvider();

        provider.getConfig().setMustParameterized(true);

        Assert.assertFalse(provider.checkValid("select * from t where fid = 1"));

    }

}
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
public class MySqlWallTest80 extends TestCase {

    public void test_true() throws Exception {
        WallProvider provider = new MySqlWallProvider();

        Assert.assertTrue(provider.checkValid(//
        "SELECT * FROM T WHERE FID = ? OR FID LIKE 1"));

        Assert.assertEquals(1, provider.getTableStats().size());
    }

View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
    public void test_false() throws Exception {
        WallProvider provider = new MySqlWallProvider();

        provider.getConfig().setCommentAllow(true);

        Assert.assertTrue(provider.checkValid(//
        "SELECT * FROM T WHERE FID = ? OR FID LIKE 1 --"));

        Assert.assertEquals(1, provider.getTableStats().size());
    }

View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
    public void test_false() throws Exception {
        WallProvider provider = new MySqlWallProvider();
       
        provider.getConfig().setCommentAllow(true);

        Assert.assertFalse(provider.checkValid(//
        "select * from t /**/ where fid = 123 AND 1=1"));

        Assert.assertEquals(1, provider.getTableStats().size());
    }

View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
    public void test_true() throws Exception {
        WallProvider provider = new SQLServerWallProvider();

        provider.getConfig().setSelectHavingAlwayTrueCheck(true);

        Assert.assertFalse(provider.checkValid(//
        "delete t where LEN(HOST_NAME()) > 0"));

        Assert.assertEquals(1, provider.getTableStats().size());
        Assert.assertTrue(provider.getTableStats().containsKey("t"));
    }
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
public class MySqlWallTest48 extends TestCase {

    public void test_false() throws Exception {
        WallProvider provider = new MySqlWallProvider();

        Assert.assertTrue(provider.checkValid(//
        "select sum(size) as total " + //
                "from file " + //
                "join file_to_post on file_to_post.file_id = file.id " + //
                "join notice on file_to_post.post_id = notice.id " + //
                "where profile_id = 18544 and file.url like '%/notice/%/file' AND EXTRACT(month FROM file.modified) = EXTRACT(month FROM now()) and EXTRACT(year FROM file.modified) = EXTRACT(year FROM now())"));
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
public class MySqlWallTest83 extends TestCase {

    public void test_false() throws Exception {
        WallProvider provider = new MySqlWallProvider();
       
        Assert.assertTrue(provider.checkValid(//
        "alter table rms.rms_Person_Event drop foreign key FKA382487726D72F65"));

        Assert.assertEquals(1, provider.getTableStats().size());
    }
View Full Code Here
25
26
27
28
29
30
31
32
33
public class MySqlWallTest136 extends TestCase {

    public void test_false() throws Exception {
        WallProvider provider = new MySqlWallProvider();

        Assert.assertFalse(provider.checkValid("SELECT * FROM Users WHERE id = '1' AND MID(@@VERSION,1,1) = '5';"));
    }

}
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.