first commit

WangHan

2024-09-12 d5855a4926926698b740bc6c7ba489de47adb68b

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
package tech.powerjob.official.processors.impl.sql;
 
import com.alibaba.fastjson.JSONObject;
import org.junit.jupiter.api.Test;
import tech.powerjob.official.processors.TestUtils;
import tech.powerjob.official.processors.util.SecurityUtils;
import tech.powerjob.worker.core.processor.ProcessResult;
import tech.powerjob.worker.core.processor.TaskContext;
 
import static org.junit.jupiter.api.Assertions.*;
 
/**
 * @author tjq
 * @since 2021/3/14
 */
class DynamicDatasourceSqlProcessorTest {
 
    @Test
    void testSecurity() throws Exception {
        ProcessResult ps = new DynamicDatasourceSqlProcessor().process(genDynamicSqlCtx());
        assertFalse(ps.isSuccess());
    }
 
    @Test
    void testProcess() throws Exception {
        System.setProperty(SecurityUtils.ENABLE_DYNAMIC_SQL_PROCESSOR, Boolean.TRUE.toString());
        ProcessResult ps = new DynamicDatasourceSqlProcessor().process(genDynamicSqlCtx());
        assertTrue(ps.isSuccess());
    }
 
    private static TaskContext genDynamicSqlCtx() {
        JSONObject params = new JSONObject();
 
        // connection info
        params.put("jdbcUrl", "jdbc:mysql://localhost:3306/powerjob-daily?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai");
        params.put("user", "root");
        params.put("password", "No1Bug2Please3!");
 
        params.put("sql", "select * from job_info");
        params.put("showResult", true);
 
        String jobParams = params.toJSONString();
 
        System.out.println(jobParams);
 
        return TestUtils.genTaskContext(jobParams);
    }
}