Package com.alibaba.druid.wall.spi

Examples of com.alibaba.druid.wall.spi.MySqlWallProvider.check()

48
49
50
51
52
53
54
55
56
57
58
        String insert_sql = "INSERT INTO orders (ID, NAME) VALUES (1, \"KIKI\")";
        String expect_sql = "INSERT INTO orders (ID, NAME, tenant)" + //
                            "\nVALUES (1, 'KIKI', 123)";
        {
            MySqlWallProvider provider = new MySqlWallProvider(config_callback);
            WallCheckResult checkResult = provider.check(insert_sql);
            Assert.assertEquals(0, checkResult.getViolations().size());

            String resultSql = SQLUtils.toSQLString(checkResult.getStatementList(), JdbcConstants.MYSQL);
            Assert.assertEquals(expect_sql, resultSql);
        }
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
        }

        {
            WallProvider.setTenantValue(123);
            MySqlWallProvider provider = new MySqlWallProvider(config);
            WallCheckResult checkResult = provider.check(insert_sql);
            Assert.assertEquals(0, checkResult.getViolations().size());

            String resultSql = SQLUtils.toSQLString(checkResult.getStatementList(), JdbcConstants.MYSQL);
            Assert.assertEquals(expect_sql, resultSql);
        }
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
                            "\nVALUES (1, 'KIKI', 123)," + //
                            "\n\t(1, 'CICI', 123)";

        {
            MySqlWallProvider provider = new MySqlWallProvider(config_callback);
            WallCheckResult checkResult = provider.check(insert_sql);
            Assert.assertEquals(0, checkResult.getViolations().size());

            String resultSql = SQLUtils.toSQLString(checkResult.getStatementList(), JdbcConstants.MYSQL);
            Assert.assertEquals(expect_sql, resultSql);
        }
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
        }

        {
            WallProvider.setTenantValue(123);
            MySqlWallProvider provider = new MySqlWallProvider(config);
            WallCheckResult checkResult = provider.check(insert_sql);
            Assert.assertEquals(0, checkResult.getViolations().size());

            String resultSql = SQLUtils.toSQLString(checkResult.getStatementList(), JdbcConstants.MYSQL);
            Assert.assertEquals(expect_sql, resultSql);
        }
View Full Code Here
103
104
105
106
107
108
109
110
111
112
113
                            "\nFROM temp" + //
                            "\nWHERE age = 18";

        {
            MySqlWallProvider provider = new MySqlWallProvider(config_callback);
            WallCheckResult checkResult = provider.check(insert_sql);
            Assert.assertEquals(0, checkResult.getViolations().size());

            String resultSql = SQLUtils.toSQLString(checkResult.getStatementList(), JdbcConstants.MYSQL);
            Assert.assertEquals(expect_sql, resultSql);
        }
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
        }

        {
            WallProvider.setTenantValue(123);
            MySqlWallProvider provider = new MySqlWallProvider(config);
            WallCheckResult checkResult = provider.check(insert_sql);
            Assert.assertEquals(0, checkResult.getViolations().size());

            String resultSql = SQLUtils.toSQLString(checkResult.getStatementList(), JdbcConstants.MYSQL);
            Assert.assertEquals(expect_sql, resultSql);
        }
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
                            "\nSELECT ID, NAME, 123" + //
                            "\nFROM temp3";

        {
            MySqlWallProvider provider = new MySqlWallProvider(config_callback);
            WallCheckResult checkResult = provider.check(insert_sql);
            Assert.assertEquals(0, checkResult.getViolations().size());

            String resultSql = SQLUtils.toSQLString(checkResult.getStatementList(), JdbcConstants.MYSQL);
            Assert.assertEquals(expect_sql, resultSql);
        }
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
        }

        {
            WallProvider.setTenantValue(123);
            MySqlWallProvider provider = new MySqlWallProvider(config);
            WallCheckResult checkResult = provider.check(insert_sql);
            Assert.assertEquals(0, checkResult.getViolations().size());

            String resultSql = SQLUtils.toSQLString(checkResult.getStatementList(), JdbcConstants.MYSQL);
            Assert.assertEquals(expect_sql, resultSql);
        }
View Full Code Here
38
39
40
41
42
43
44
45
46
47
48
    }

    public void testMySql() throws Exception {
        WallProvider.setTenantValue(123);
        MySqlWallProvider provider = new MySqlWallProvider(config);
        WallCheckResult checkResult = provider.check(sql);
        Assert.assertEquals(0, checkResult.getViolations().size());

        String resultSql = SQLUtils.toSQLString(checkResult.getStatementList(), JdbcConstants.MYSQL);
        Assert.assertEquals("DELETE FROM orders" + //
                            "\nWHERE FID = ?", resultSql);
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
    }

    public void testMySql() throws Exception {
        WallProvider.setTenantValue(123);
        MySqlWallProvider provider = new MySqlWallProvider(config);
        WallCheckResult checkResult = provider.check(sql);
        Assert.assertEquals(0, checkResult.getViolations().size());

        String resultSql = SQLUtils.toSQLString(checkResult.getStatementList(), JdbcConstants.MYSQL);
        Assert.assertEquals(expect_sql, resultSql);
    }
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.