ROC交易所数据库迁移

zainali5120

2020-10-09 de30aec3c3dfe436ad8e9ba73a5ead7a0dc003c7

ROC交易所数据库迁移

 src/main/java/com/xcong/excoin/modules/member/dao/MemberAuthenticationDao.java

@@ -6,5 +6,6 @@
public interface MemberAuthenticationDao extends BaseMapper<MemberAuthenticationEntity> {



    int findMemberbyIdCardNoCount(String idCardNo);

    int findAuthenByMemberId(Long memberId);

    

}


 src/main/java/com/xcong/excoin/modules/member/service/impl/MemberServiceImpl.java

@@ -383,6 +383,11 @@
            if (count > 0) {
                return Result.fail(MessageSourceUtils.getString("member_service_0060"));
            }
            // 同一个人只能认证一次
            int authenByMemberId = memberAuthenticationDao.findAuthenByMemberId(memberId);
            if (authenByMemberId > 0) {
                return Result.fail(MessageSourceUtils.getString("member_service_0055"));
            }
            if (StrUtil.isBlank(memberAuthenticationDto.getIdCardFront())
                    || StrUtil.isBlank(memberAuthenticationDto.getIdCardReverse())
                    || StrUtil.isBlank(memberAuthenticationDto.getIdCardImage())) {

 src/main/resources/application-prod.yml

@@ -7,7 +7,7 @@
  profiles:
    active: dev
  datasource:
    url: jdbc:mysql://47.114.114.219:3306/db_roc?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2b8
    url: jdbc:mysql://rm-bp1i2g5rg5dubo9s40o.mysql.rds.aliyuncs.com:3306/db_roc?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2b8
    username: roc_user
    password: roc123pasd!@
    driver-class-name: com.mysql.jdbc.Driver

 src/main/resources/application.yml

@@ -5,7 +5,7 @@

spring:
  profiles:
    active: test
    active: prod
  datasource:
    url: jdbc:mysql://rm-bp151tw8er79ig9kb5o.mysql.rds.aliyuncs.com:3306/db_biue?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2b8
    username: ctcoin_data

 src/main/resources/mapper/member/MemberAuthenticationDao.xml

@@ -5,5 +5,9 @@
    <select id="findMemberbyIdCardNoCount" resultType="int">

        select count(*) from member_authentication where idcard_No = #{idCardNo}

    </select>



    <select id="findAuthenByMemberId" resultType="int">

        select count(*) from member_authentication where member_id = #{memberId}

    </select>

    

</mapper>

 src/main/resources/mapper/walletCoinOrder/OrderCoinDealDao.xml

@@ -47,8 +47,8 @@
    <select id="selectAllCoinDealsOrderBySymbol"

            resultType="com.xcong.excoin.modules.coin.entity.OrderCoinsDealEntity">

        select * from coins_order_deal

        where symbol = #{symbol}

        order by create_time desc limit 100

        where symbol = #{symbol} and order_status = 3

        order by create_time desc limit 50

    </select>



    <select id="selectWalletCoinOrder" resultType="com.xcong.excoin.modules.coin.entity.OrderCoinsDealEntity">