fix
Helius
2021-07-12 e47e795b062e68b55aa28c955a2c8407c6ed9cb5
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
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
package com.matrix;
 
import com.matrix.system.common.bean.SysUsers;
import com.matrix.system.hive.bean.SysShopInfo;
import com.matrix.system.dataMove.DateMoveServiceImpl;
import com.matrix.system.hive.bean.SysVipLevel;
import lombok.Data;
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.context.junit4.SpringRunner;
 
import java.io.UnsupportedEncodingException;
import java.security.NoSuchAlgorithmException;
import java.util.ArrayList;
import java.util.List;
 
/**
 * @author wzy
 * @date 2021-03-18
 **/
@RunWith(SpringRunner.class)
@SpringBootTest(classes = {ZqErpApplication.class},webEnvironment =SpringBootTest.WebEnvironment.RANDOM_PORT)
public class DataMoveTest {
 
    @Autowired
    private DateMoveServiceImpl dataMove;
 
    /**
     * 商铺信息迁移
     */
//    @Test
    public void slaveTest() {
        List<SysShopInfo> shopInfos = dataMove.oldShopInfo();
        dataMove.toNewShopInfo(shopInfos);
    }
 
    /**
     * 后台用户迁移
     * @throws UnsupportedEncodingException
     * @throws NoSuchAlgorithmException
     */
//    @Test
    public void sysUsersMoveTest() throws UnsupportedEncodingException, NoSuchAlgorithmException {
        List<SysUsers> sysUsers = dataMove.oldSysUsers();
        dataMove.newSysUsers(sysUsers);
    }
 
    /**
     * 会员等级迁移
     */
//    @Test
    public void vipLevelMove() {
        List<SysVipLevel> sysVipLevels = dataMove.vipLevelOld();
        dataMove.vipLevelNew(sysVipLevels);
    }
 
    //    @Test
    public void shopStaffMoveTest() throws UnsupportedEncodingException, NoSuchAlgorithmException {
        dataMove.shopStaffInfoNew(dataMove.shopStaffInfoOld());
    }
 
    /**
     * 会员信息迁移
     */
    //@Test
    public void vipInfoMoveTest() {
        dataMove.vipInfoNew(dataMove.vipInfoOld());
    }
 
//    @Test
    public void supplierTypeMoveTest() {
        dataMove.supplierNew(dataMove.supplierTypeOld());
    }
 
//    @Test
    public void supplierInfoMoveTest() {
        dataMove.supplierInfoNew(dataMove.supplierInfoOld());
    }
 
//    @Test
    public void shoppingGoodsCateMoveTest() {
        dataMove.goodsCategoryNew(dataMove.goodsCategoryOld());
        dataMove.goodsCategoryParentIdUpdate();
    }
 
//    @Test
    public void goodsTypeMoveTest() {
        dataMove.goodsTypeNew(dataMove.goodsTypeOld());
        dataMove.updateGoodsTypeParentId();
    }
 
    /**
     * 项目
     * 家居产品
     * 充值卡
     * 套餐
     * 综合卡
     *
     *  ALTER TABLE `hive_test_meidu`.`shopping_goods` MODIFY COLUMN `is_once` int(10) NULL DEFAULT NULL AFTER `is_present`;
     */
//    @Test
    public void shoppingGoodsMoveTest() {
        dataMove.shoppingGoodsNew(dataMove.shoppingGoodsOld("家居产品"), "家居产品");
    }
 
//    @Test
    public void shoppingGoodsProjTest() {
        dataMove.shoppingGoodsNew(dataMove.shoppingGoodsProjectOld(), "项目");
    }
 
//    @Test
    public void shoppingGoodsTcTest() {
        dataMove.shoppingGoodsNew(dataMove.shoppingGoodsTcList(), "套餐");
    }
 
//    @Test
    public void shoppingGoodsCzkTest() {
        dataMove.shoppingGoodsNew(dataMove.shoppingGoodsCzkOld(), "充值卡");
    }
 
//    @Test
    public void shoppingGoodsZhkTest() {
        dataMove.shoppingGoodsZhkNew(dataMove.shoppingGoodsZhkOld());
    }
 
 //   @Test
    public void orderMoveTest() {
        dataMove.orderNew(dataMove.orderOld());
    }
 
   @Test
    public void bedInfoMoveTest() {
        dataMove.bedInfoNew(dataMove.bedInfoOld());
    }
 
    /**
     * isCourse 不能默认为N
     */
    @Test
    public void projUseMoveTest() {
        dataMove.projUseNew(dataMove.projUseMoveOld());
    }
 
    @Test
    public void serviceOrderMoveTest() {
//        dataMove.serviceOrderOld();
        dataMove.serviceOrderNew(dataMove.serviceOrderOld());
    }
 
    @Test
    public void moneyCardUseMoveTest() {
        dataMove.moneyCardUseNew(dataMove.moneyCardUseOld());
    }
 
    @Test
    public void tyOrderAndAchieveDataTest() {
        dataMove.tyOrderAndAchieveMove();
    }
 
    @Test
    public void roleUpdateTest() {
//        dataMove.roleNew(dataMove.roleOld());
 
        dataMove.roleNew2(dataMove.roleOld2());
    }
 
    public void updateServiceOrderStaff() {
        dataMove.updateServiceOrderStaff();
    }
 
    @Test
    public void updateVipInfoStaff() {
        dataMove.updateVipInfoStaff();
    }
 
    @Test
    public void updateProjUseIsCoures() {
        dataMove.updateProjUseIsCourse();
    }
}