Package com.alibaba.druid.wall

Examples of com.alibaba.druid.wall.WallConfig

8
9
10
11
12
13
14
15
16
17
import com.alibaba.druid.wall.WallUtils;

public class MySqlWallTest_hint extends TestCase {

    public void test_false() throws Exception {
        WallConfig config = new WallConfig();
        config.setHintAllow(false);
        String sql = "select * from person where id = '3'/**/union select 0,1,v from (select 1,2,user/*!() as v*/) a where '1'<>''";
        Assert.assertFalse(WallUtils.isValidateMySql(sql, config)); //
    }
View Full Code Here
15
16
17
18
19
20
21
22
23
24
25
        String sql = "select * from person where id = '3'/**/union select 0,1,v from (select 1,2,user/*!() as v*/) a where '1'<>''";
        Assert.assertFalse(WallUtils.isValidateMySql(sql, config)); //
    }

    public void test_false_1() throws Exception {
        WallConfig config = new WallConfig();
        config.setHintAllow(true);
        config.setMultiStatementAllow(true);
        String sql = "select * from person where id = '3'/**/union select 0,1,v from (select 1,2,user/*!() as v*/) a where '1'<>''";
        Assert.assertFalse(WallUtils.isValidateMySql(sql, config)); //
    }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
49
50
        String sql = "/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */";
        Assert.assertTrue(WallUtils.isValidateMySql(sql)); //
    }
   
    public void test_true_3() throws Exception {
        WallConfig config = new WallConfig();
        config.setHintAllow(true);
        config.setMultiStatementAllow(true);
        String sql = " /*!50003 CREATE*/ /*!50020  /*!50003 PROCEDURE `top_calculate_customer_update`(in update_time DATETIME)"
                     + " DETERMINISTIC"
                     + " BEGIN"
                     + " DECLARE done INT DEFAULT FALSE;"
                     + " DECLARE c_receiver_city,c_receiver_district,c_receiver_address VARCHAR(200);"
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
                     + " END */";
        Assert.assertTrue(WallUtils.isValidateMySql(sql, config));
    }
   
    public void test_true_4() throws Exception {
        WallConfig config = new WallConfig();
        config.setHintAllow(true);
        config.setMultiStatementAllow(true);
        String sql = "LOCK TABLES `m_rpt_adgroupeffect` READ /*!32311 LOCAL */";
        Assert.assertTrue(WallUtils.isValidateMySql(sql, config)); //
    }
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
75
        String sql = "LOCK TABLES `m_rpt_adgroupeffect` READ /*!32311 LOCAL */";
        Assert.assertTrue(WallUtils.isValidateMySql(sql, config)); //
    }
   
    public void test_true_5() throws Exception {
        WallConfig config = new WallConfig();
        config.setHintAllow(true);
        config.setMultiStatementAllow(true);
        String sql = "DROP TABLE IF EXISTS `item_similarity`;"//
                     + "\n/*!40101 SET @saved_cs_client     = @@character_set_client */;"//
                     + "\n/*!40101 SET character_set_client = utf8 */;" //
                     + "\nCREATE TABLE `item_similarity` ("//
                     + " `id` bigint(20) unsigned NOT NULL, "//
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
105
106
        String sql = "SET SQL_QUOTE_SHOW_CREATE=1/*!40102 ,SQL_MODE=concat(@@sql_mode, _utf8 ',NO_KEY_OPTIONS,NO_TABLE_OPTIONS,NO_FIELD_OPTIONS') */";
        Assert.assertTrue(WallUtils.isValidateMySql(sql)); //
    }
   
    public void test_true_9() throws Exception {
        WallConfig config = new WallConfig();
        config.setHintAllow(true);
        config.setMultiStatementAllow(true);
        String sql = "CREATE TABLE `session` ("//
                     + " `sess_id` varchar(128) NOT NULL,"//
                     + " `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',"//
                     + " `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',"//
                     + " `ip` varchar(40) NOT NULL,"//
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
                     + ") /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */ ";
        Assert.assertTrue(WallUtils.isValidateMySql(sql, config)); //
    }
   
    public void test_true_10() throws Exception {
        WallConfig config = new WallConfig();
        config.setHintAllow(true);
        config.setMultiStatementAllow(true);
        config.setNoneBaseStatementAllow(true);
        String sql = "CREATE DATABASE `newsfocus` /*!40100 COLLATE 'big5_chinese_ci' */ ";
        Assert.assertTrue(WallUtils.isValidateMySql(sql, config)); //
    }
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
130
        String sql = "CREATE DATABASE `newsfocus` /*!40100 COLLATE 'big5_chinese_ci' */ ";
        Assert.assertTrue(WallUtils.isValidateMySql(sql, config)); //
    }

    public void test_true_11() throws Exception {
        WallConfig config = new WallConfig();
        config.setHintAllow(true);
        config.setMultiStatementAllow(true);
        config.setNoneBaseStatementAllow(true);
        String sql = "EXPLAIN /*!40100 EXTENDED */ SELECT * FROM trade_order_header WHERE id = ?";
        Assert.assertTrue(WallUtils.isValidateMySql(sql, config)); //
    }
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
* @author wenshao
*/
public class WallUnionTest2 extends TestCase {

    public void testMySql() throws Exception {
        WallConfig config = new WallConfig();
        config.setSelectUnionCheck(true);
        Assert.assertTrue(WallUtils.isValidateMySql("select f1, f2 from t where f1 = 1 union select 1, 2 where 1 = 1",
                                                    config));
        Assert.assertFalse(WallUtils.isValidateMySql("select f1, f2 from t where f1 = 1 union select 1, 2 where 1 = 1 --",
                                                     config));
    }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
        Assert.assertFalse(WallUtils.isValidateMySql("select f1, f2 from t where f1 = 1 union select 1, 2 where 1 = 1 --",
                                                     config));
    }

    public void testOracle() throws Exception {
        WallConfig config = new WallConfig();
        config.setSelectUnionCheck(true);
        Assert.assertTrue(WallUtils.isValidateOracle("select f1, f2 from t where f1 = 1 union select 1, 2 where 1 = 1",
                                                     config));
        Assert.assertFalse(WallUtils.isValidateOracle("select f1, f2 from t where f1 = 1 union select 1, 2 where 1 = 1 --",
                                                      config));
    }
View Full Code Here
TOP

Related Classes of com.alibaba.druid.wall.WallConfig

  • com.alibaba.druid.bvt.filter.wall.BigSqlTest
  • com.alibaba.druid.bvt.filter.wall.BitwiseAndTest
  • com.alibaba.druid.bvt.filter.wall.BitwiseInvertTest
  • com.alibaba.druid.bvt.filter.wall.BitwiseOrTest
  • com.alibaba.druid.bvt.filter.wall.BitwiseXorTest
  • com.alibaba.druid.bvt.filter.wall.BooleanXorTest
  • com.alibaba.druid.bvt.filter.wall.ConstantArithmeticCheckTest
  • com.alibaba.druid.bvt.filter.wall.DoPrivilegedTest
  • com.alibaba.druid.bvt.filter.wall.IntersectTest
  • com.alibaba.druid.bvt.filter.wall.MinusTest
    • Copyright © 2018 www.massapicom. 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.