Package com.alibaba.druid.wall.spi

Examples of com.alibaba.druid.wall.spi.MySqlWallProvider.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
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
33
34
35
36
37
38
39
40
41
42
43
    public void test_false() throws Exception {
        WallProvider provider = new MySqlWallProvider();
        provider.getConfig().setSchemaCheck(true);

        Assert.assertTrue(provider.checkValid(//
        "SELECT c.table_name, column_name, column_type, is_nullable, column_key" + //
                "   , column_default, extra, collation_name, character_set_name, column_comment " + //
                "FROM information_schema.columns c " + //
                "INNER JOIN (" + //
                "   SELECT table_schema, table_name " + //
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
41
42
43
44
45
46
47
48
49
50
51
    private String update_sql = "UPDATE members SET FNAME = ? WHERe FID = ?";
    private String delete_sql = "DELETE members WHERE FID = ?";

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

        Assert.assertFalse(provider.checkValid(insert_sql));
        Assert.assertFalse(provider.checkValid(update_sql));
        Assert.assertFalse(provider.checkValid(delete_sql));
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
    public void testMySql() throws Exception {
        MySqlWallProvider provider = new MySqlWallProvider(config);
        Assert.assertTrue(provider.checkValid(sql));

        Assert.assertFalse(provider.checkValid(insert_sql));
        Assert.assertFalse(provider.checkValid(update_sql));
        Assert.assertFalse(provider.checkValid(delete_sql));

    }
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
    public void testMySql() throws Exception {
        MySqlWallProvider provider = new MySqlWallProvider(config);
        Assert.assertTrue(provider.checkValid(sql));

        Assert.assertFalse(provider.checkValid(insert_sql));
        Assert.assertFalse(provider.checkValid(update_sql));
        Assert.assertFalse(provider.checkValid(delete_sql));

    }

    public void testORACLE() throws Exception {
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
        MySqlWallProvider provider = new MySqlWallProvider(config);
        Assert.assertTrue(provider.checkValid(sql));

        Assert.assertFalse(provider.checkValid(insert_sql));
        Assert.assertFalse(provider.checkValid(update_sql));
        Assert.assertFalse(provider.checkValid(delete_sql));

    }

    public void testORACLE() throws Exception {
        OracleWallProvider provider = new OracleWallProvider(config);
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.