package org.springblade.common.utils;

import org.springblade.modules.FTP.FtpUtil;

import java.util.List;

/**
 * ftp 内网 sql 同步工具类
 * @author zhongrj
 * @since 2021-12-15
 */
public class FtpSyncUtil {

	/**
	 * sql 处理
	 * @return
	 */
	public static StringBuilder sqlHandler(StringBuilder builder,String sql,int length){
		//拼接
		builder  = builder.append(sql).append(";");
		String[] split = builder.toString().split(";");
		//判断list.size 大小
		if (split.length==length){
			//执行
			FtpUtil.sqlFileUpload(builder.toString());
			//清空
			builder = null;
		}
		return builder;
	}

	/**
	 * sql 处理,执行
	 * @return
	 */
	public static void slqSync(StringBuilder builder){
		//执行
		FtpUtil.sqlFileUpload(builder.toString());
	}
}