From 605ad677377b5aa3e163890ef3ca43df49f57e67 Mon Sep 17 00:00:00 2001 From: Helius <wangdoubleone@gmail.com> Date: Thu, 18 Mar 2021 19:47:33 +0800 Subject: [PATCH] modify --- /dev/null | 69 ------- zq-erp/src/main/resources/config/application.yml | 69 +++++++ zq-erp/pom.xml | 18 + zq-erp/src/main/java/com/matrix/config/DataSourceConfig.java | 148 ++++++++-------- zq-erp/src/test/java/com/matrix/DataMoveTest.java | 38 ++++ zq-erp/src/main/java/com/matrix/system/common/init/InitWebContainer.java | 17 + zq-erp/src/main/java/com/matrix/system/shopXcx/action/ShopBizUserScoreAction.java | 2 zq-erp/src/main/java/com/matrix/system/dataMove/DateMoveServiceImpl.java | 160 +++++++++++++++++ zq-erp/src/main/java/com/matrix/ZqErpApplication.java | 3 zq-erp/src/main/java/com/matrix/system/dataMove/BeanMapMapper.java | 15 + 10 files changed, 384 insertions(+), 155 deletions(-) diff --git a/zq-erp/pom.xml b/zq-erp/pom.xml index f11f7a0..56f7f9d 100644 --- a/zq-erp/pom.xml +++ b/zq-erp/pom.xml @@ -239,8 +239,8 @@ <!-- https://mvnrepository.com/artifact/com.alibaba/druid --> <dependency> <groupId>com.alibaba</groupId> - <artifactId>druid</artifactId> - <version>1.1.10</version> + <artifactId>druid-spring-boot-starter</artifactId> + <version>1.1.21</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> @@ -371,16 +371,24 @@ <artifactId>mapstruct</artifactId> <version>1.3.0.Final</version> </dependency> + + <dependency> + <groupId>com.baomidou</groupId> + <artifactId>dynamic-datasource-spring-boot-starter</artifactId> + <version>3.0.0</version> + </dependency> + <dependency> <groupId>com.baomidou</groupId> <artifactId>mybatis-plus-boot-starter</artifactId> - <version>3.2.0</version> + <version>3.3.0</version> </dependency> <dependency> <groupId>cn.hutool</groupId> <artifactId>hutool-all</artifactId> <version>5.3.1</version> </dependency> + </dependencies> <build> <resources> @@ -394,12 +402,12 @@ <exclude>config/test/*</exclude> <exclude>config/xcx/*</exclude> - <!----> + <!-- <exclude>config/config.json</exclude> <exclude>config/application.properties</exclude> <exclude>config/system.properties</exclude> - +--> <exclude>**/*.woff</exclude> <exclude>**/*.woff2</exclude> diff --git a/zq-erp/src/main/java/com/matrix/ZqErpApplication.java b/zq-erp/src/main/java/com/matrix/ZqErpApplication.java index 2941bcc..73a39c2 100644 --- a/zq-erp/src/main/java/com/matrix/ZqErpApplication.java +++ b/zq-erp/src/main/java/com/matrix/ZqErpApplication.java @@ -1,5 +1,6 @@ package com.matrix; +import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.context.annotation.ComponentScan; @@ -9,7 +10,7 @@ * * @author jiangyouyao */ -@SpringBootApplication +@SpringBootApplication(exclude = DruidDataSourceAutoConfigure.class) @ComponentScan(basePackages = {"com.matrix.**"}) diff --git a/zq-erp/src/main/java/com/matrix/config/DataSourceConfig.java b/zq-erp/src/main/java/com/matrix/config/DataSourceConfig.java index 7dbf05e..c4c6cf0 100644 --- a/zq-erp/src/main/java/com/matrix/config/DataSourceConfig.java +++ b/zq-erp/src/main/java/com/matrix/config/DataSourceConfig.java @@ -25,80 +25,80 @@ @MapperScan(value = { "com.xincheng.**.dao","com.matrix.**.dao"}) @Configuration public class DataSourceConfig { - - /** - * 数据源配置 - * - * @return - * @author jiangyouyao - */ - @ConfigurationProperties(prefix = "spring.datasource") - @Bean - public DataSource druid() { - - DruidDataSource druidDataSource = new DruidDataSource(); - - List<Filter> filters = new ArrayList<>(); - filters.add(wallFilter()); - druidDataSource.setProxyFilters(filters); - - return druidDataSource; - } - - - /** - * 注册一个StatViewServlet - * @return - */ - @Bean - public ServletRegistrationBean druidStatViewServlet(){ - //org.springframework.boot.context.embedded.ServletRegistrationBean提供类的进行注册. - ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*"); - - //添加初始化参数:initParams - //白名单: - servletRegistrationBean.addInitParameter("allow",""); - //IP黑名单 (存在共同时,deny优先于allow) : 如果满足deny的话提示:Sorry, you are not permitted to view this page. - //servletRegistrationBean.addInitParameter("deny",""); - //登录查看信息的账号密码. - /*servletRegistrationBean.addInitParameter("loginUsername","xc_erp_scop"); - servletRegistrationBean.addInitParameter("loginPassword","xc_erp_scop");*/ - //是否能够重置数据. - servletRegistrationBean.addInitParameter("resetEnable","false"); - return servletRegistrationBean; - } - - /** - * 注册一个:filterRegistrationBean - * @return - */ - @Bean - public FilterRegistrationBean druidStatFilter(){ - - FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter()); - - //添加过滤规则. - filterRegistrationBean.addUrlPatterns("/*"); - - //添加不需要忽略的格式信息. - filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"); - return filterRegistrationBean; - } - - @Bean - public WallFilter wallFilter(){ - WallFilter wallFilter = new WallFilter(); - wallFilter.setConfig(wallConfig()); - return wallFilter; - } - - @Bean - public WallConfig wallConfig() { - WallConfig config = new WallConfig(); - config.setMultiStatementAllow(true);//允许一次执行多条语句 - config.setNoneBaseStatementAllow(true);//允许一次执行多条语句 - return config; - } +// +// /** +// * 数据源配置 +// * +// * @return +// * @author jiangyouyao +// */ +// @ConfigurationProperties(prefix = "spring.datasource") +// @Bean +// public DataSource druid() { +// +// DruidDataSource druidDataSource = new DruidDataSource(); +// +// List<Filter> filters = new ArrayList<>(); +// filters.add(wallFilter()); +// druidDataSource.setProxyFilters(filters); +// +// return druidDataSource; +// } +// +// +// /** +// * 注册一个StatViewServlet +// * @return +// */ +// @Bean +// public ServletRegistrationBean druidStatViewServlet(){ +// //org.springframework.boot.context.embedded.ServletRegistrationBean提供类的进行注册. +// ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*"); +// +// //添加初始化参数:initParams +// //白名单: +// servletRegistrationBean.addInitParameter("allow",""); +// //IP黑名单 (存在共同时,deny优先于allow) : 如果满足deny的话提示:Sorry, you are not permitted to view this page. +// //servletRegistrationBean.addInitParameter("deny",""); +// //登录查看信息的账号密码. +// /*servletRegistrationBean.addInitParameter("loginUsername","xc_erp_scop"); +// servletRegistrationBean.addInitParameter("loginPassword","xc_erp_scop");*/ +// //是否能够重置数据. +// servletRegistrationBean.addInitParameter("resetEnable","false"); +// return servletRegistrationBean; +// } +// +// /** +// * 注册一个:filterRegistrationBean +// * @return +// */ +// @Bean +// public FilterRegistrationBean druidStatFilter(){ +// +// FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter()); +// +// //添加过滤规则. +// filterRegistrationBean.addUrlPatterns("/*"); +// +// //添加不需要忽略的格式信息. +// filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"); +// return filterRegistrationBean; +// } +// +// @Bean +// public WallFilter wallFilter(){ +// WallFilter wallFilter = new WallFilter(); +// wallFilter.setConfig(wallConfig()); +// return wallFilter; +// } +// +// @Bean +// public WallConfig wallConfig() { +// WallConfig config = new WallConfig(); +// config.setMultiStatementAllow(true);//允许一次执行多条语句 +// config.setNoneBaseStatementAllow(true);//允许一次执行多条语句 +// return config; +// } } diff --git a/zq-erp/src/main/java/com/matrix/system/common/init/InitWebContainer.java b/zq-erp/src/main/java/com/matrix/system/common/init/InitWebContainer.java index a9f0527..5425c15 100644 --- a/zq-erp/src/main/java/com/matrix/system/common/init/InitWebContainer.java +++ b/zq-erp/src/main/java/com/matrix/system/common/init/InitWebContainer.java @@ -14,6 +14,9 @@ import com.matrix.system.common.service.SysCompanyService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Value; +import org.springframework.context.event.ContextRefreshedEvent; +import org.springframework.context.event.EventListener; +import org.springframework.stereotype.Component; import org.springframework.stereotype.Controller; import org.springframework.web.context.ServletContextAware; @@ -25,8 +28,8 @@ * @author:姜友瑶 * @date 2016年10月18日 */ -@Controller -public class InitWebContainer implements ServletContextAware{ +@Component +public class InitWebContainer implements ServletContextAware{ private static final String TRUE = "true"; @@ -62,7 +65,6 @@ @Override public void setServletContext(ServletContext sc) { this.servletContext = sc; - // 初始化调试模式 initDebug(); // 初始化语言环境 @@ -70,13 +72,18 @@ //初始化公司 initParams(); LogUtil.info("\r\n\r\n**********************************************\r\n" - + "* =========== Matrix启动成功 ===========\r\n" + + "* =========== Matrix启动成功 ===========\r\n" + "* DEBUG模式:" + debug+"*\r\n" + "* 语言环境:" + Locale.getDefault().getLanguage()+"\r\n" - + + "**********************************************\r\n"); } +// @EventListener +// public void onApplicationEvent(ContextRefreshedEvent event) { +// +// } + private void initDebug() { if (TRUE.equals(debug)) { MatrixConstance.DEBUG = true; diff --git a/zq-erp/src/main/java/com/matrix/system/dataMove/BeanMapMapper.java b/zq-erp/src/main/java/com/matrix/system/dataMove/BeanMapMapper.java new file mode 100644 index 0000000..15190c4 --- /dev/null +++ b/zq-erp/src/main/java/com/matrix/system/dataMove/BeanMapMapper.java @@ -0,0 +1,15 @@ +package com.matrix.system.dataMove; + +import com.matrix.system.common.bean.SysUsers; +import org.mapstruct.Mapper; +import org.mapstruct.factory.Mappers; + +/** + * @author wzy + * @date 2021-03-18 + **/ +@Mapper +public abstract class BeanMapMapper { + public static BeanMapMapper INSTANCE = Mappers.getMapper(BeanMapMapper.class); + +} diff --git a/zq-erp/src/main/java/com/matrix/system/dataMove/DateMoveServiceImpl.java b/zq-erp/src/main/java/com/matrix/system/dataMove/DateMoveServiceImpl.java new file mode 100644 index 0000000..e181e23 --- /dev/null +++ b/zq-erp/src/main/java/com/matrix/system/dataMove/DateMoveServiceImpl.java @@ -0,0 +1,160 @@ +package com.matrix.system.dataMove; + +import cn.hutool.core.collection.CollUtil; +import com.alibaba.fastjson.JSONObject; +import com.baomidou.dynamic.datasource.annotation.DS; +import com.matrix.component.redis.RedisClient; +import com.matrix.system.common.bean.SysUsers; +import com.matrix.system.common.constance.AppConstance; +import com.matrix.system.common.dao.SysUsersDao; +import com.matrix.system.common.tools.PasswordUtil; +import com.matrix.system.hive.bean.SysShopInfo; +import com.matrix.system.hive.dao.SysShopInfoDao; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.jdbc.core.JdbcTemplate; +import org.springframework.stereotype.Service; +import org.springframework.transaction.annotation.Transactional; + +import java.io.UnsupportedEncodingException; +import java.security.NoSuchAlgorithmException; +import java.util.*; + +/** + * @author wzy + * @date 2021-03-18 + **/ +@Service +public class DateMoveServiceImpl { + + @Autowired + private JdbcTemplate jdbcTemplate; + + @Autowired + private SysShopInfoDao sysShopInfoDao; + + @Autowired + private SysUsersDao sysUsersDao; + + @Autowired + private RedisClient redisClient; + + private Long companyId = 35L; + + public List<Map<String, Object>> dataMove() { + return jdbcTemplate.queryForList("select * from sys_vip_info limit 10"); + } + + public <T> List<T> mapsToListBean(List<Map<String, Object>> maps, Class<T> t) { + List<T> list = new ArrayList<>(); + for (Map<String, Object> map : maps) { + String s = JSONObject.toJSONString(map); + T object = JSONObject.parseObject(s, t); + list.add(object); + } + return list; + } + + /** + * 旧系统商店数据 + * + * @return + */ + @DS("slave") + public List<SysShopInfo> oldShopInfo() { + List<Map<String, Object>> maps = jdbcTemplate.queryForList("select * from sys_shop_info"); + + List<SysShopInfo> shopInfos = new ArrayList<>(); + for (Map<String, Object> map : maps) { + String s = JSONObject.toJSONString(map); + SysShopInfo sysShopInfo = JSONObject.parseObject(s, SysShopInfo.class); + shopInfos.add(sysShopInfo); + } + + return shopInfos; + } + + public void toNewShopInfo(List<SysShopInfo> shopInfos) { + if (CollUtil.isNotEmpty(shopInfos)) { + Map<Long, Long> oldAndNewId = new HashMap<>(); + for (SysShopInfo shopInfo : shopInfos) { + if (shopInfo.getShopName().equals("总部")) { + shopInfo.setShopType(1); + shopInfo.setIsOpenNet(2); + } else { + shopInfo.setShopType(2); + shopInfo.setIsOpenNet(1); + } + shopInfo.setShopShortName(shopInfo.getShopName()); + shopInfo.setCompanyId(companyId); + + SysShopInfo query = new SysShopInfo(); + query.setShopNo(shopInfo.getShopNo()); + Long oldId = shopInfo.getId(); + shopInfo.setId(null); + // TODO 若迁往正式环境,这里需要变动 + if (!shopInfo.getShopName().contains("美度") && !shopInfo.getShopName().contains("总店")) { + sysShopInfoDao.insert(shopInfo); + oldAndNewId.put(oldId, shopInfo.getId()); + } else { + SysShopInfo sysShopInfo = sysShopInfoDao.selectByShopName(shopInfo.getShopName()); + oldAndNewId.put(oldId, sysShopInfo.getId()); + } + } + redisClient.saveMapValue("shopId", oldAndNewId); + } + + } + + @DS("slave") + public List<SysUsers> oldSysUsers() throws UnsupportedEncodingException, NoSuchAlgorithmException { + List<Map<String, Object>> maps = jdbcTemplate.queryForList("select * from users"); + + List<SysUsers> list = new ArrayList<>(); + + String shopIds = redisClient.getCachedValue("shopId"); + Map shopMap = JSONObject.parseObject(shopIds, Map.class); + for (Map<String, Object> map : maps) { + SysUsers sysUsers = new SysUsers(); + sysUsers.setSuAccount((String) map.get("account")); + sysUsers.setSuId((Long) map.get("id")); + sysUsers.setSuName((String) map.get("name")); + sysUsers.setSuTel((String) map.get("tel")); + sysUsers.setSuPhoto((String) map.get("photo")); + sysUsers.setSuEmail((String) map.get("email")); + sysUsers.setSuUserType((String) map.get("user_type")); + sysUsers.setSuAccountStatus((String) map.get("account_status")); + sysUsers.setSuValid("Y"); + sysUsers.setCompanyId(companyId); + Long aaa = (Long) map.get("shop_id"); + System.out.println(aaa); + if (aaa != null) { + Integer shopId = (Integer) shopMap.get(aaa.toString()); + if (shopId != null) { + sysUsers.setShopId(Long.parseLong(shopId.toString())); + } + } + sysUsers.setSuRegisterTime((Date) map.get("register_time")); + sysUsers.setCreateBy(AppConstance.SYSTEM_USER); + sysUsers.setUpdateBy(AppConstance.SYSTEM_USER); + sysUsers.setSuPassword(PasswordUtil.getEncrypUserPwd(sysUsers)); + list.add(sysUsers); + } + return list; + } + + @Transactional + public void newSysUsers(List<SysUsers> list) { + if (CollUtil.isNotEmpty(list)) { + Map<Long, Long> sysUsersOldAndNew = new HashMap<>(); + for (SysUsers sysUsers : list) { + Long oldId = sysUsers.getSuId(); + sysUsers.setSuId(null); + sysUsersDao.insert(sysUsers); + sysUsersOldAndNew.put(oldId, sysUsers.getSuId()); + } + + redisClient.saveMapValue("sys_users", sysUsersOldAndNew); + } + } + +} diff --git a/zq-erp/src/main/java/com/matrix/system/shopXcx/action/ShopBizUserScoreAction.java b/zq-erp/src/main/java/com/matrix/system/shopXcx/action/ShopBizUserScoreAction.java index 2097b6c..0c49bd4 100644 --- a/zq-erp/src/main/java/com/matrix/system/shopXcx/action/ShopBizUserScoreAction.java +++ b/zq-erp/src/main/java/com/matrix/system/shopXcx/action/ShopBizUserScoreAction.java @@ -44,7 +44,7 @@ -\ + } \ No newline at end of file diff --git a/zq-erp/src/main/resources/config/application.properties b/zq-erp/src/main/resources/config/application.properties deleted file mode 100644 index a250611..0000000 --- a/zq-erp/src/main/resources/config/application.properties +++ /dev/null @@ -1,69 +0,0 @@ -evn=jyy -server.port=8080 - - -#线上测试环境 - -spring.datasource.username=ct_test -spring.datasource.password=123456 -spring.datasource.url=jdbc:mysql://120.27.238.55:3306/hive_test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&allowMultiQueries=true&transformedBitIsBoolean=true&serverTimezone=GMT%2B8 - - - -spring.datasource.type=com.alibaba.druid.pool.DruidDataSource -spring.datasource.initialSize=3 -spring.datasource.minIdle=3 -spring.datasource.maxActive=20 -spring.datasource.maxWait=60000 -spring.datasource.timeBetweenEvictionRunsMillis=60000 -spring.datasource.minEvictableIdleTimeMillis=300000 -spring.datasource.validationQuery=SELECT 1 FROM DUAL -spring.datasource.testWhileIdle=true -spring.datasource.testOnBorrow=true -spring.datasource.testOnReturn=true -spring.datasource.filters=stat,wall,log4j -spring.datasource.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000 -spring.thymeleaf.prefix: classpath:/templates/views/ -spring.thymeleaf.cache=false -#设置全局时间返回格式 第三行设置为true表示返回时间戳 -#spring.jackson.date-format=yyyy-MM-dd -#spring.jackson.time-zone=GMT+8 -#spring.jackson.serialization.write-dates-as-timestamps=true -#文件上传时的大小限制 单位M -spring.servlet.multipart.max-file-size=100MB -spring.servlet.multipart.max-request-size=100MB -#-------------------------------------- - - -#rabbitMQ配置 -rabbitmq.host=47.111.134.136 -rabbitmq.port=5672 -rabbitmq.username=hivequeue -rabbitmq.password=hivequeueadmin -useRabbit=false - -server.session.timeout=120 - -ali.sms.accessKeyId=LTAI4FrjY9R9iDfC6YQTHfne -ali.sms.accessKeySecret=eSvQslpHpDSGlI9Hxm4y5MynNgLbCp -ali.sms.regionId=cn-hangzhou -ali.sms.signName=\u80bd\u598d - -#hour -activities.groupBuy.limit=24 -#minute -groupBuy.pay.timeLimit=30 - -#定时任务 -scheduling.enabled=false - -swagger.enable=true -swagger.security.username=admin -swagger.security.password=admin - -#默认头像 -default.vip.photo.woman=https://filehive2.jyymatrix.cc/uploadeFile/20210125/db53552e688040afb286686f081e1e68f3fe946f75624598828f01898635152e.png -default.vip.photo.man=https://filehive2.jyymatrix.cc/uploadeFile/20210125/3642f1d827c44c76832fea106c85e0f89e089c16cbcc4dd0a82bb52b9ac700f4.png - -mybatis-plus.config-location=classpath:mybatis/mybatis-config.xml -mybatis-plus.mapper-locations=classpath*:mybatis/mapper/**/*.xml diff --git a/zq-erp/src/main/resources/config/application.yml b/zq-erp/src/main/resources/config/application.yml new file mode 100644 index 0000000..46087ae --- /dev/null +++ b/zq-erp/src/main/resources/config/application.yml @@ -0,0 +1,69 @@ +evn: jyy +server: + port: 8080 + servlet: + session: + timeout: 120 + +mybatis-plus: + config-location: classpath:mybatis/mybatis-config.xml + mapper-locations: classpath*:mybatis/mapper/**/*.xml + +# 文件上传时的大小限制 单位M +spring: + servlet: + multipart: + max-file-size: 100MB + max-request-size: 100MB + datasource: + dynamic: + primary: master + strict: false + datasource: + master: + url: jdbc:mysql://120.27.238.55:3306/hive_test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&allowMultiQueries=true&transformedBitIsBoolean=true&serverTimezone=GMT%2B8 + username: ct_test + password: 123456 + driver-class-name: com.mysql.jdbc.Driver + slave: + url: jdbc:mysql://47.111.134.136:3306/db_meidu8300?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&allowMultiQueries=true&transformedBitIsBoolean=true&serverTimezone=GMT%2B8 + username: meidu_data + password: meidu_4321#&@ + driver-class-name: com.mysql.jdbc.Driver + druid: + filters: stat,slf4j + initial-size: 5 + autoconfigure: + exclude: com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure + +useRabbit: false +rabbitmq: + host: 47.111.134.136 + port: 5672 + username: hivequeue + password: hivequeueadmin + +ali: + sms: + accessKeyId: LTAI4FrjY9R9iDfC6YQTHfne + accessKeySecret: eSvQslpHpDSGlI9Hxm4y5MynNgLbCp + regionId: cn-hangzhou + signName: \u80bd\u598d + +activities: + groupBuy: + limit: 24 +groupBuy: + pay: + timeLimit: 30 +scheduling: + enabled: false + +swagger: + enable: true + +default: + vip: + photo: + woman: https://filehive2.jyymatrix.cc/uploadeFile/20210125/db53552e688040afb286686f081e1e68f3fe946f75624598828f01898635152e.png + man: https://filehive2.jyymatrix.cc/uploadeFile/20210125/3642f1d827c44c76832fea106c85e0f89e089c16cbcc4dd0a82bb52b9ac700f4.png \ No newline at end of file diff --git a/zq-erp/src/test/java/com/matrix/DataMoveTest.java b/zq-erp/src/test/java/com/matrix/DataMoveTest.java new file mode 100644 index 0000000..6a7a3a2 --- /dev/null +++ b/zq-erp/src/test/java/com/matrix/DataMoveTest.java @@ -0,0 +1,38 @@ +package com.matrix; + +import com.matrix.system.common.bean.SysUsers; +import com.matrix.system.hive.bean.SysShopInfo; +import com.matrix.system.dataMove.DateMoveServiceImpl; +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.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); + } + + @Test + public void sysUsersMoveTest() throws UnsupportedEncodingException, NoSuchAlgorithmException { + List<SysUsers> sysUsers = dataMove.oldSysUsers(); + dataMove.newSysUsers(sysUsers); + } +} -- Gitblit v1.9.1