trush / webmagic-canrd-service · Files

package com.canrd.webmagic.utils;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;

import com.canrd.webmagic.BaseTest;

import com.canrd.webmagic.common.utils.StringUtils;

import com.canrd.webmagic.domain.dto.ArticleDO;
import com.canrd.webmagic.service.ArticleService;

import org.junit.Test;

import javax.annotation.Resource;
import java.util.List;

/**
 * @author: xms
 * @description: TODO
 * @date: 2023/2/10 14:09
 * @version: 1.0
 */
public class DateTimeUtilTest extends BaseTest {

    @Resource

    private ArticleService articleService;

    @Test
    public void export() {

        List<ArticleDO> articleDOList = articleService.list(new LambdaQueryWrapper<ArticleDO>().select(ArticleDO::getEmailInfo));

        JSONArray array = new JSONArray();

        for (ArticleDO articleDO : articleDOList) {

            if (StringUtils.isBlank(articleDO.getEmailInfo())) {
                continue;
            }

            JSONArray jsonArray = JSONArray.parseArray(articleDO.getEmailInfo());
            array.addAll(jsonArray);
        }
        System.out.println("联系作者,邮箱");
        for (Object o : array) {
            JSONObject jsonObject = JSONObject.parseObject(JSON.toJSONString(o));
            String authorEmailName = jsonObject.getString("authorEmailName");
            String email = jsonObject.getString("email");
            System.out.println(authorEmailName + "," + email);
        }
    }
}