Example 21 with WallConfig
use of com.alibaba.druid.wall.WallConfig in project druid by alibaba.
the class WallUnionTest method testMySql.
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", config));
Assert.assertFalse(WallUtils.isValidateMySql("select f1, f2 from t where f1=1 union select 1, 2 --", config));
}
Also used :
WallConfig(com.alibaba.druid.wall.WallConfig)
Example 22 with WallConfig
use of com.alibaba.druid.wall.WallConfig in project druid by alibaba.
the class WallUnionTest2 method testOracle.
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));
}
Also used :
WallConfig(com.alibaba.druid.wall.WallConfig)
Example 23 with WallConfig
use of com.alibaba.druid.wall.WallConfig in project druid by alibaba.
the class WallUnionTest2 method testMySql.
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));
}
Also used :
WallConfig(com.alibaba.druid.wall.WallConfig)
Example 24 with WallConfig
use of com.alibaba.druid.wall.WallConfig in project druid by alibaba.
the class WallUnionTest4 method testORACLE.
public void testORACLE() throws Exception {
WallConfig config = new WallConfig();
config.setSelectUnionCheck(true);
Assert.assertTrue(WallUtils.isValidateOracle("SELECT id, product FROM T1 t where id=1 UNION (SELECT * FROM (SELECT 1,'x') X)", config));
Assert.assertFalse(WallUtils.isValidateOracle("SELECT id, product FROM T1 t where id=1 UNION (SELECT * FROM (SELECT 1,'x') X) -- ", config));
}
Also used :
WallConfig(com.alibaba.druid.wall.WallConfig)
Example 25 with WallConfig
use of com.alibaba.druid.wall.WallConfig in project druid by alibaba.
the class WallUpdateTest2 method testMySql_false.
public void testMySql_false() throws Exception {
WallConfig config = new WallConfig();
config.setUpdateAllow(false);
Assert.assertFalse(WallUtils.isValidateMySql(sql, config));
}
Also used :
WallConfig(com.alibaba.druid.wall.WallConfig)
Aggregations
WallConfig (com.alibaba.druid.wall.WallConfig)83
Properties (java.util.Properties)8
WallFilter (com.alibaba.druid.wall.WallFilter)5
DruidDataSource (com.alibaba.druid.pool.DruidDataSource)4
WallCheckResult (com.alibaba.druid.wall.WallCheckResult)3
Filter (com.alibaba.druid.filter.Filter)2
SQLExpr (com.alibaba.druid.sql.ast.SQLExpr)2
OracleMockDriver (com.alibaba.druid.test.util.OracleMockDriver)2
WallContext (com.alibaba.druid.wall.WallContext)2
MySqlWallProvider (com.alibaba.druid.wall.spi.MySqlWallProvider)2
SQLCommentHint (com.alibaba.druid.sql.ast.SQLCommentHint)1
SQLStatement (com.alibaba.druid.sql.ast.SQLStatement)1
SQLStartTransactionStatement (com.alibaba.druid.sql.ast.statement.SQLStartTransactionStatement)1
MySqlCommitStatement (com.alibaba.druid.sql.dialect.mysql.ast.statement.MySqlCommitStatement)1
MySqlDeleteStatement (com.alibaba.druid.sql.dialect.mysql.ast.statement.MySqlDeleteStatement)1
MySqlDescribeStatement (com.alibaba.druid.sql.dialect.mysql.ast.statement.MySqlDescribeStatement)1
MySqlHintStatement (com.alibaba.druid.sql.dialect.mysql.ast.statement.MySqlHintStatement)1
MySqlLockTableStatement (com.alibaba.druid.sql.dialect.mysql.ast.statement.MySqlLockTableStatement)1
MySqlRenameTableStatement (com.alibaba.druid.sql.dialect.mysql.ast.statement.MySqlRenameTableStatement)1
MySqlReplaceStatement (com.alibaba.druid.sql.dialect.mysql.ast.statement.MySqlReplaceStatement)1
