1
935090232@qq.com
2020-12-01 611146e69aaa62296cf84f2ccb5aca5ebba17677
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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
package com.matrix;
 
import com.matrix.core.tools.StringUtils;
import com.matrix.system.constance.Dictionary;
import com.matrix.system.hive.bean.MoneyCardUse;
import com.matrix.system.hive.bean.ShoppingGoods;
import com.matrix.system.hive.bean.SysSourceFlow;
import com.matrix.system.hive.bean.SysVipInfo;
import com.matrix.system.hive.dao.MoneyCardUseDao;
import com.matrix.system.hive.dao.ShoppingGoodsDao;
import com.matrix.system.hive.dao.SysSourceFlowDao;
import com.matrix.system.hive.dao.SysVipInfoDao;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.annotation.Rollback;
import org.springframework.test.context.junit4.SpringRunner;
import org.springframework.transaction.annotation.Transactional;
 
import javax.sql.DataSource;
import java.util.List;
 
/**
 * 测试类示例
 * 
 * @author jiangyouyao
 * @email 512061637@qq.com
 * @date 2019年2月25日
 */
@RunWith(SpringRunner.class)
@SpringBootTest
public class SourceFlowTests {
 
    @Autowired
    DataSource dataSource;
 
    @Test
    public void contextLoads() {
        System.out.println(dataSource.getClass());
    }
 
 
    @Autowired
    private SysSourceFlowDao sysSourceFlowDao;
 
    @Autowired
    private ShoppingGoodsDao shoppingGoodsDao;
 
 
    @Autowired
    private SysVipInfoDao vipInfoDao;
 
 
 
    @Test
    @Transactional
    @Rollback
    public void insertFlow() {
        SysSourceFlow sysSourceFlow=new SysSourceFlow();
        sysSourceFlow.setCreateBy("1");
        sysSourceFlow.setUpdateBy("2");
 
        sysSourceFlowDao.insert(sysSourceFlow);
    }
 
 
    @Test
    @Transactional
    @Rollback(false)
    public void initGoodsPingyin() {
 
        List<ShoppingGoods> shoppingGoods = shoppingGoodsDao.selectByModel(null);
        shoppingGoods.forEach(shoppingGood -> {
            shoppingGood.setZjm(StringUtils.toHanyuPinyin(shoppingGood.getName())+","+StringUtils.toHeadWordHanyuPinyin(shoppingGood.getName()));
            ShoppingGoods s=new ShoppingGoods();
            s.setId(shoppingGood.getId());
            s.setZjm(shoppingGood.getZjm());
            shoppingGoodsDao.update(s);
        });
 
    }
 
 
    @Test
    @Transactional
    @Rollback(false)
    public void initVipInfoPingyin() {
 
        List<SysVipInfo> vipInfoList = vipInfoDao.selectByModel(null);
        vipInfoList.forEach(sysVipInfo -> {
            if(StringUtils.isNotBlank(sysVipInfo.getVipName())){
                String name=  sysVipInfo.getVipName().replaceAll("[\\x{10000}-\\x{10FFFF}]", "");
                sysVipInfo.setZjm(StringUtils.toHanyuPinyin(name)+","+StringUtils.toHeadWordHanyuPinyin(name));
                SysVipInfo s=new SysVipInfo();
                s.setId(sysVipInfo.getId());
                s.setZjm(sysVipInfo.getZjm());
                vipInfoDao.update(s);
            }
 
        });
 
    }
 
 
}