Package com.alibaba.druid.wall

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

33
34
35
36
37
38
39
40
41
42
43
    public void test_true() throws Exception {
        WallProvider provider = new MySqlWallProvider();
        provider.getConfig().setLimitZeroAllow(true);

        Assert.assertTrue(provider.checkValid(//
        "select * from t limit 0,0"));

        Assert.assertEquals(1, provider.getTableStats().size());
    }
   
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
    }
   
    public void test_false() throws Exception {
        WallProvider provider = new MySqlWallProvider();
       
        Assert.assertFalse(provider.checkValid(//
                "select * from t limit 0,0"));
       
        Assert.assertEquals(1, provider.getTableStats().size());
    }
}
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
    public void test_true() throws Exception {
        WallProvider provider = new MySqlWallProvider();
        provider.getConfig().setSchemaCheck(false);

        Assert.assertTrue(provider.checkValid(//
        "SELECT *FROM T UNION select `ENGINE`, `SUPPORT` from information_schema.Engines"));

        Assert.assertEquals(2, provider.getTableStats().size());
    }
   
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
    }
   
    public void test_false() throws Exception {
        WallProvider provider = new MySqlWallProvider();
       
        Assert.assertFalse(provider.checkValid(//
                "SELECT *FROM T UNION select `ENGINE`, `SUPPORT` from information_schema.Engines"));
       
        Assert.assertEquals(2, provider.getTableStats().size());
    }
}
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
        WallContext.clearContext();
    }

    public void testMySql() throws Exception {
        WallProvider provider = new MySqlWallProvider();
        Assert.assertTrue(provider.checkValid(sql));

        {
            WallTableStat tableStat = provider.getTableStat("t");
            Assert.assertEquals(1, tableStat.getSelectCount());
            Assert.assertEquals(0, tableStat.getSelectIntoCount());
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
        }
    }

    public void testOracle() throws Exception {
        WallProvider provider = new OracleWallProvider();
        Assert.assertTrue(provider.checkValid(sql));
        WallTableStat tableStat = provider.getTableStat("t");
        Assert.assertEquals(1, tableStat.getSelectCount());
    }

    public void testPG() throws Exception {
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
        Assert.assertEquals(1, tableStat.getSelectCount());
    }

    public void testPG() throws Exception {
        WallProvider provider = new PGWallProvider();
        Assert.assertTrue(provider.checkValid(sql));
        WallTableStat tableStat = provider.getTableStat("t");
        Assert.assertEquals(1, tableStat.getSelectCount());
    }

    public void testSQLServer() throws Exception {
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
        Assert.assertEquals(1, tableStat.getSelectCount());
    }

    public void testSQLServer() throws Exception {
        WallProvider provider = new SQLServerWallProvider();
        Assert.assertTrue(provider.checkValid(sql));
        WallTableStat tableStat = provider.getTableStat("t");
        Assert.assertEquals(1, tableStat.getSelectCount());
    }

}
View Full Code Here
35
36
37
38
39
40
41
42
43
                     + "where not exists   ("//
                     + "    select EMAIL" //
                     + "    from T01_CHECKIN_CUSTOMER" //
                     + "    where WEB_USER_ID=2 and EMAIL='1223@123.com'" //
                     + ")";
        Assert.assertTrue(provider.checkValid(sql));
    }

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

        provider.getConfig().setCommentAllow(true);

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

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

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.