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
package tech.powerjob.server.persistence.storage.impl;
 
import tech.powerjob.common.utils.NetUtils;
import tech.powerjob.server.extension.dfs.DFsService;
 
import java.util.Optional;
 
/**
 * MySqlSeriesDfsServiceTest
 *
 * @author tjq
 * @since 2023/8/10
 */
class MySqlSeriesDfsServiceTest extends AbstractDfsServiceTest {
 
    @Override
    protected Optional<DFsService> fetchService() {
 
        boolean dbAvailable = NetUtils.checkIpPortAvailable("127.0.0.1", 3306);
        if (dbAvailable) {
            MySqlSeriesDfsService mySqlSeriesDfsService = new MySqlSeriesDfsService();
 
            try {
 
                MySqlSeriesDfsService.MySQLProperty mySQLProperty = new MySqlSeriesDfsService.MySQLProperty()
                        .setDriver("com.mysql.cj.jdbc.Driver")
                        .setUrl("jdbc:mysql://localhost:3306/powerjob-daily?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai")
                        .setUsername("root")
                        .setAutoCreateTable(true)
                        .setPassword("No1Bug2Please3!");
                mySqlSeriesDfsService.initDatabase(mySQLProperty);
                mySqlSeriesDfsService.initTable(mySQLProperty);
 
                return Optional.of(mySqlSeriesDfsService);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
 
        return Optional.empty();
    }
}