Package com.alibaba.druid.wall.spi

Examples of com.alibaba.druid.wall.spi.SQLServerWallProvider

30
31
32
33
34
35
36
37
38
39
40
41
* @see
*/
public class SQLServerWallTest_8 extends TestCase {

    public void test_true() throws Exception {
        WallProvider provider = new SQLServerWallProvider();

        provider.getConfig().setMustParameterized(true);

        Assert.assertFalse(provider.checkValid("select * from t where fid = 1"));

    }
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
* @see
*/
public class SQLServerWallTest_5 extends TestCase {

    public void test_true() throws Exception {
        WallProvider provider = new SQLServerWallProvider();

        provider.getConfig().setSelectHavingAlwayTrueCheck(true);

        Assert.assertFalse(provider.checkValid(//
        "delete t where LEN(HOST_NAME()) > 0"));

        Assert.assertEquals(1, provider.getTableStats().size());
        Assert.assertTrue(provider.getTableStats().containsKey("t"));
    }
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
61
        WallTableStat tableStat = provider.getTableStat("t");
        Assert.assertEquals(1, tableStat.getDropCount());
    }

    public void testSQLServer() throws Exception {
        WallProvider provider = new SQLServerWallProvider();
        provider.getConfig().setDropTableAllow(true);

        Assert.assertTrue(provider.checkValid(sql));
        WallTableStat tableStat = provider.getTableStat("t");
        Assert.assertEquals(1, tableStat.getDropCount());
    }
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
* @see
*/
public class SQLServerWallTest_9 extends TestCase {

    public void test_true() throws Exception {
        WallProvider provider = new SQLServerWallProvider();

        String sql = "SELECT s.id FROM snapshots s " //
                     + "WHERE s.scope='PRJ'"//
                     + " and s.qualifier IN ('TRK', 'BRC')"//
                     + " AND status='P'" //
                     + " AND islast=0" //
                     + " AND NOT EXISTS (select m.id from project_measures m WHERE m.snapshot_id=s.id)";

        Assert.assertTrue(provider.checkValid(sql));

    }
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
* @see
*/
public class SQLServerWallTest_0 extends TestCase {

    private WallProvider initWallProvider() {
        WallProvider provider = new SQLServerWallProvider();

        provider.getConfig().setStrictSyntaxCheck(false);
        provider.getConfig().setMultiStatementAllow(true);
        provider.getConfig().setConditionAndAlwayTrueAllow(true);
        provider.getConfig().setNoneBaseStatementAllow(true);
        provider.getConfig().setLimitZeroAllow(true);
        provider.getConfig().setConditionDoubleConstAllow(true);

        provider.getConfig().setCommentAllow(true);
        provider.getConfig().setSelectUnionCheck(false);

        return provider;
    }
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
* @see
*/
public class SQLServerWallTest_3 extends TestCase {

    public void test_true() throws Exception {
        WallProvider provider = new SQLServerWallProvider();

        provider.getConfig().setSelectHavingAlwayTrueCheck(true);

        Assert.assertFalse(provider.checkValid(//
        "select * from t where LEN(HOST_NAME()) > 0"));

        Assert.assertEquals(1, provider.getTableStats().size());
        Assert.assertTrue(provider.getTableStats().containsKey("t"));
    }
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
        } else if (JdbcUtils.SQL_SERVER.equals(dbType) || JdbcUtils.JTDS.equals(dbType)) {
            if (config == null) {
                config = new WallConfig(SQLServerWallProvider.DEFAULT_CONFIG_DIR);
            }

            provider = new SQLServerWallProvider(config);
        } else if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            if (config == null) {
                config = new WallConfig(PGWallProvider.DEFAULT_CONFIG_DIR);
            }
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
        } else if (JdbcUtils.SQL_SERVER.equals(dbType) || JdbcUtils.JTDS.equals(dbType)) {
            if (config == null) {
                config = new WallConfig(SQLServerWallProvider.DEFAULT_CONFIG_DIR);
            }

            provider = new SQLServerWallProvider(config);
        } else if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            if (config == null) {
                config = new WallConfig(PGWallProvider.DEFAULT_CONFIG_DIR);
            }
View Full Code Here
111
112
113
114
115
116
117
118
119
120
121
        } else if (JdbcUtils.SQL_SERVER.equals(dbType) || JdbcUtils.JTDS.equals(dbType)) {
            if (config == null) {
                config = new WallConfig(SQLServerWallProvider.DEFAULT_CONFIG_DIR);
            }

            provider = new SQLServerWallProvider(config);
        } else if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            if (config == null) {
                config = new WallConfig(PGWallProvider.DEFAULT_CONFIG_DIR);
            }
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
        } else if (JdbcUtils.SQL_SERVER.equals(dbType) || JdbcUtils.JTDS.equals(dbType)) {
            if (config == null) {
                config = new WallConfig(SQLServerWallProvider.DEFAULT_CONFIG_DIR);
            }

            provider = new SQLServerWallProvider(config);
        } else if (JdbcUtils.POSTGRESQL.equals(dbType)) {
            if (config == null) {
                config = new WallConfig(PGWallProvider.DEFAULT_CONFIG_DIR);
            }
View Full Code Here
TOP

Related Classes of com.alibaba.druid.wall.spi.SQLServerWallProvider

  • com.alibaba.druid.bvt.filter.wall.SQLServerWallTest_0
  • com.alibaba.druid.bvt.filter.wall.SQLServerWallTest_10
  • com.alibaba.druid.bvt.filter.wall.SQLServerWallTest_11
  • com.alibaba.druid.bvt.filter.wall.SQLServerWallTest_12
  • com.alibaba.druid.bvt.filter.wall.SQLServerWallTest_3
  • com.alibaba.druid.bvt.filter.wall.SQLServerWallTest_4
  • com.alibaba.druid.bvt.filter.wall.SQLServerWallTest_5
  • com.alibaba.druid.bvt.filter.wall.SQLServerWallTest_6
  • com.alibaba.druid.bvt.filter.wall.SQLServerWallTest_7
  • com.alibaba.druid.bvt.filter.wall.SQLServerWallTest_8
    • 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.