package com.nokia.tsl_data;

import com.nokia.tsl_data.dao.HighQualityDataMapper;
import com.nokia.tsl_data.service.DataWarehouseService;
import com.nokia.tsl_data.service.UserCountService;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.io.IOException;
import java.nio.charset.StandardCharsets;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.util.List;
import java.util.Map;

@SpringBootTest
class TslDataApplicationTest {

    @Autowired
    private UserCountService userCountService;

    /**
     * 更新管理端用户数--当前阶段需要修改一下模式
     */
    @Test
    void test1() throws IOException {
        String path = "D:/src/管理端用户数.txt";
        Files.lines(Paths.get(path), StandardCharsets.UTF_8)
                .forEach(line -> {
                    String[] split = line.split("\t");
                    System.out.println(split[0] + Double.parseDouble(split[2]));
                    userCountService.updateManagementUserCount("202310", split[0], Double.parseDouble(split[2]));
                });
    }

    /**
     * 更新客户端用户数
     */
    @Test
    void test2() throws IOException {
        String path = "D:/src/客户端用户数.txt";
        Files.lines(Paths.get(path), StandardCharsets.UTF_8)
                .forEach(line -> {
                    String[] split = line.split("\t");
                    System.out.println(split[0] + Double.parseDouble(split[1]));
                    userCountService.updateCustomerUserCount("202310", split[0], Double.parseDouble(split[1]));
                });
    }

    @Autowired
    private HighQualityDataMapper highQualityDataMapper;

    @Test
    void test() {
        List<Map<String, Object>> maps = highQualityDataMapper.selectRegionTimelyContactRate("20231014");
        maps.forEach(System.out::println);
    }

    @Autowired
    private DataWarehouseService dataWarehouseService;

    @Test
    void test3() {
        dataWarehouseService.warehouseHighQualityCountDay("20231101");
    }
}