Package com.alibaba.druid.wall.spi

Examples of com.alibaba.druid.wall.spi.OracleWallProvider.checkValid()

35
36
37
38
39
40
41
42
43
44
45
    public void testOracle() throws Exception {
        WallProvider provider = new OracleWallProvider();
        provider.getConfig().setDropTableAllow(true);

        Assert.assertTrue(provider.checkValid(sql));
        WallTableStat tableStat = provider.getTableStat("t");
        Assert.assertEquals(1, tableStat.getDropCount());
    }

    public void testPG() throws Exception {
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
        return provider.checkValid(sql);
    }

    public static boolean isValidateOracle(String sql) {
        OracleWallProvider provider = new OracleWallProvider();
        return provider.checkValid(sql);
    }

    public static boolean isValidateOracle(String sql, WallConfig config) {
        OracleWallProvider provider = new OracleWallProvider(config);
        return provider.checkValid(sql);
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
        return provider.checkValid(sql);
    }

    public static boolean isValidateOracle(String sql, WallConfig config) {
        OracleWallProvider provider = new OracleWallProvider(config);
        return provider.checkValid(sql);
    }
   
    public static boolean isValidateSqlServer(String sql) {
        SQLServerProvider provider = new SQLServerProvider();
        return provider.checkValid(sql);
View Full Code Here
16
17
18
19
20
21
22
23
24
25
26
        return provider.checkValid(sql);
    }

    public static boolean isValidateOracle(String sql) {
        OracleWallProvider provider = new OracleWallProvider();
        return provider.checkValid(sql);
    }

    public static boolean isValidateOracle(String sql, WallConfig config) {
        OracleWallProvider provider = new OracleWallProvider(config);
        return provider.checkValid(sql);
View Full Code Here
21
22
23
24
25
26
27
28
29
30
31
        return provider.checkValid(sql);
    }

    public static boolean isValidateOracle(String sql, WallConfig config) {
        OracleWallProvider provider = new OracleWallProvider(config);
        return provider.checkValid(sql);
    }
   
    public static boolean isValidateSqlServer(String sql) {
        SQLServerProvider provider = new SQLServerProvider();
        return provider.checkValid(sql);
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
    public void testORACLE() throws Exception {
        String sql = "SELECT F1, F2 FROM ABC --test";

        OracleWallProvider provider = new OracleWallProvider();
        Assert.assertFalse(provider.checkValid(sql));

        Assert.assertEquals(1, provider.getCommentDenyStat().getDenyCount());
    }
   
    public void testmysql() throws Exception {
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
        Assert.assertEquals(1, tableStat.getSelectCount());
    }

    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
26
27
28
29
30
31
32
33
34
35
36
    public void testOracle() throws Exception {
        String sql = "alter table t add (fname varchar(50))";
        WallProvider provider = new OracleWallProvider();
        provider.getConfig().setAlterTableAllow(true);
       
        Assert.assertTrue(provider.checkValid(sql));
        WallTableStat tableStat =  provider.getTableStat("t");
        Assert.assertEquals(1, tableStat.getAlterCount());
    }
   
//    public void testPG() throws Exception {
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
        }
    }

    public void testOracle() throws Exception {
        WallProvider provider = new OracleWallProvider();
        Assert.assertTrue(provider.checkValid(sql));
        {
            WallTableStat tableStat = provider.getTableStat("lhwbbs_posts_reply");
            Assert.assertEquals(1, tableStat.getSelectCount());
        }
        {
View Full Code Here
28
29
30
31
32
33
34
35
36
    public void testORACLE() throws Exception {
        String sql = "SELECT *FROM T UNION SELECT F1, F2 FROM SYS.ABC";

        OracleWallProvider provider = new OracleWallProvider();
        Assert.assertFalse(provider.checkValid(sql));

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