All Downloads are FREE. Search and download functionalities are using the official Maven repository.
  • Log In
  • Register

    • com.higgschain.trust.slave.dao.mysql.config.ConfigJDBCDao Maven / Gradle / Ivy

    package com.higgschain.trust.slave.dao.mysql.config;

import com.google.common.collect.Lists;
import com.higgschain.trust.slave.common.enums.SlaveErrorEnum;
import com.higgschain.trust.slave.common.exception.SlaveException;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
import org.springframework.stereotype.Component;

import java.util.List;

/**
 * The type Config jdbc dao.
 *
 * @author liuyu
 * @description
 * @date 2018 -08-02
 */
@Component @Slf4j public class ConfigJDBCDao {
    @Autowired private NamedParameterJdbcTemplate jdbc;
    @Autowired private JdbcTemplate jdbcTemplate;

    /**
     * batch update
     *
     * @param nodes the nodes
     */
    public void batchEnable(List nodes) {
        String sql = "UPDATE config SET ";
        String errorCodeConditionSql = "`pubKey`= `tmpPubKey`";
        String errorMsgConditionSql = ",`priKey`= `tmpPriKey`";
        String updateStatusSql = ", `valid`=true";
        String updateTimeSql = ", `update_time`=NOW(3)";
        String whereSql = "";
        List txIdList = Lists.newLinkedList();
        for (String node : nodes) {
            txIdList.add(node);
            whereSql += ",?";
        }
        whereSql = " WHERE `node_name` in (" + whereSql.substring(1) + ") and `usage` = 'biz'";
        sql += errorCodeConditionSql + errorMsgConditionSql + updateStatusSql + updateTimeSql + whereSql;
        List params = Lists.newLinkedList();
        params.addAll(txIdList);
        int size = jdbcTemplate.update(sql, params.toArray());
        if (size != nodes.size()) {
            log.error("[batchEnable] has fail ,updated.size:{},data.size:{}", size, nodes.size());
            throw new SlaveException(SlaveErrorEnum.SLAVE_CA_BATCH_UPDATE_ERROR);
        }
    }

    /**
     * batch update
     *
     * @param nodes the nodes
     */
    public void batchCancel(List nodes) {
        String sql = "UPDATE config SET ";
        String updateStatusSql = " `valid`=false";
        String updateTimeSql = ", `update_time`=NOW(3)";
        String whereSql = "";
        List txIdList = Lists.newLinkedList();
        for (String node : nodes) {
            txIdList.add(node);
            whereSql += ",?";
        }
        whereSql = " WHERE `node_name` in (" + whereSql.substring(1) + ") and `usage` = 'biz'";
        sql += updateStatusSql + updateTimeSql + whereSql;
        List params = Lists.newLinkedList();
        params.addAll(txIdList);
        int size = jdbcTemplate.update(sql, params.toArray());
        if (size != nodes.size()) {
            log.error("[batchCancel] has fail ,updated.size:{},data.size:{}", size, nodes.size());
            throw new SlaveException(SlaveErrorEnum.SLAVE_CA_BATCH_UPDATE_ERROR);
        }
    }
}
    
    
    
    

    




    
    
    © 2015 - 2025 Weber Informatics LLC | Privacy Policy