tsl-data/src/test/java/com/nokia/tsl_data/TslDataApplicationTest.java

package com.nokia.tsl_data;

import java.util.List;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import com.nokia.tsl_data.dao.WorkFlowDao;
import com.nokia.tsl_data.service.TaskService;
import com.nokia.tsl_data.service.UserCountService;
import com.nokia.tsl_data.util.TextUtil;

@SpringBootTest
class TslDataApplicationTest {

    @Autowired
    private TaskService taskService;

    @Test
    void test() {
        taskService.generateReportV3("20240325");
    }

    @Autowired
    private UserCountService userCountService;

    @Test
    void test2() {
        String path = "D:/abc.txt";
        List<String> lines = TextUtil.readLines(path, "utf-8");
        lines.forEach(line -> {
            String[] split = line.split("\t");
            System.out.println(split[0] + "==" + split[2]);
            userCountService.updateManagementUserCount("202403", split[0], Double.parseDouble(split[2]));
        });
    }

    @Autowired
    private WorkFlowDao workFlowDao;

    @Test
    void test3() {
        workFlowDao.selectTsDurationForDayV2("2024-03-13 00:00:00", "2024-03-13 13:00:00");
    }

}