svn hooks 增加数据库数据校验

业务需求:

  小乌龟提交java文件时如果该java文件中存在StrUtil.getText("");则拿到里面的数据,使用该数据查数据库如果数据库不存在该数据则不让用户提交svn

windows系统下

  1:在svn服务端中找到对应项目的hooks

       svn hooks 增加数据库数据校验

 

 

 

 

  2:写pre-commit.bat

@echo off
set export LANG=zh_CN.UTF-8
setlocal
set Repos=%1
set TXN=%2
set SCM=admin
set CUR=%~dp0
rem 输出路径 预先存放数据库驱动包、conf.properties文件
set outdir=D:\hdcn\multlang_svn\out
set tmpfile=
for /f %%k in (java -classpath ".;C:/Repositories/springboot/hooks" CheckString "uuid") do set tmpfile=%%k
for /f "tokens=1-2 delims= " %%i in (svnlook changed -t "%TXN%" "%Repos%") do (
    svnlook cat -t "%TXN%" "%Repos%" "%%j" >%outdir%\%tmpfile%
    for /f %%y in (java -cp ".;C:/Repositories/springboot/hooks;D:/hdcn/multlang_svn/out/ojdbc8.jar" CheckString "%%i" "%outdir%\%tmpfile%" "%%j" "%outdir%") do (
        echo file:"%%j" "no found [%%y] in t_sys_language" 1>&2
        goto err
    )
)
del %outdir%\%tmpfile%
goto right

:err
del %outdir%\%tmpfile%
exit 1

:right
exit 0

  3:写java类CheckString 供bat调用

import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.*;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

public class CheckString {
    private final static String varregex = "\"(.*?)\"";
    private final static String javaregex = "StrUtil\\s*.\\s*getText\\s*\\(\\s*\"(.*?)\"\\s*\\)";
    Properties properties = null;
    Connection connection = null;

    private String dbdriver;
    private String dburl;
    private String dbuser;
    private String dbpasswd;
    private String logfile;
    private String curdir;
    public static void main(String[] args) {
        CheckString svnLang = new CheckString();
        if (args[0].equalsIgnoreCase("uuid")) {
            System.out.println(svnLang.getRandFileName());
            return;
        }
        svnLang.setCurdir(args[3]);
        try { 
            svnLang.loadConf();
            svnLang.vaildLang(args[0], args[1], args[2]);
            svnLang.writeLog("success");
        } catch (Exception e) {
            StringWriter sw = new StringWriter();
            PrintWriter pw = new PrintWriter(sw);
            e.printStackTrace(pw);
            svnLang.writeLog(sw.toString());
            pw.close();
        }
   }

   public boolean vaildLang(String ope, String textfile, String svnfile) throws Exception {
       //只有新增和修改的数据才需要校验 U修改  A新增
       if (!("U".equalsIgnoreCase(ope) || "A".equalsIgnoreCase(ope))) {
           return true;
       }
       List<String> langKey = new ArrayList<>();
       String extname = getFileExt(svnfile);
       if ("java".equalsIgnoreCase(extname)) {
           String textcontext = txt2String(textfile);
           langKey.addAll(regularJava(textcontext));
       } else {
           return true;
       }
       if (langKey.size() <= 0) { 
           return true;
       }
       try {
           for (String key: langKey) {
               if (!hasLang(key)) {
                   System.out.println(key);
                   return false;
               }
           }
       } finally {
           closeDb();
       }
       return true;
   }
    
   private void connDb() throws Exception {
       Class.forName(dbdriver);
       connection = DriverManager.getConnection(dburl, dbuser, dbpasswd);
   }

   private void closeDb() throws Exception {
       if (connection != null) {
           connection.close();
       }
   }

   private boolean hasLang(String msgname) throws Exception {
       if (connection == null) {
           connDb();
       }
       String sql = "select count(1) as cou from t_language where msgname=? ";
       PreparedStatement pstmt = connection.prepareStatement(sql);
       pstmt.setString(1, msgname);
       ResultSet rst = pstmt.executeQuery();
       rst.next();
       Long cou = rst.getLong("cou");
       if (cou > 0) {
           return true;
       }
       return false;
   }

   private static String txt2String(String filename) throws Exception {
       File file = new File(filename);
       StringBuilder result = new StringBuilder();
       InputStreamReader read = new InputStreamReader(new FileInputStream(file),"UTF-8");  
       BufferedReader br = new BufferedReader(read);
       try {
           String s;
           while ((s = br.readLine()) != null) {
               result.append(System.lineSeparator() + s);
           }
       } finally {
           br.close();
       }
       return result.toString();
   }

   private List<String> regularJava(String text) {
       return regular(text, javaregex);
   }

   private List<String> regular(String text, String regex) {
       List<String> rt = new ArrayList<>();
       Pattern p=Pattern.compile(regex);
       Matcher m=p.matcher(text);
       while(m.find()){
           String gs = m.group();
           String v = getVarLang(gs);
           if (v != null) {
               rt.add(v);
           }
       }
       return rt;
   }

   private String getVarLang(String text) {
       Pattern p=Pattern.compile(varregex);
       Matcher m=p.matcher(text);
       while(m.find()){
           String gs = m.group();
           gs = gs.substring(1, gs.length()-1);
           return gs;
       }
       return null;
   }

   private String getFileExt(String filename) {
       String extname = filename.substring(filename.lastIndexOf(".") + 1);
       return extname;
   }

   public String getRandFileName() {
       UUID uuid = UUID.randomUUID();
       return uuid.toString().replace("-", "")+".txt";
   }

   private void loadConf() throws Exception {
       if (properties == null) {
           properties = new Properties();
           properties.load(new FileInputStream(this.curdir+ System.getProperty("file.separator")+ "conf.properties"));
           Enumeration<?> enum1 = properties.propertyNames();
           while(enum1.hasMoreElements()) {
               String strKey = (String) enum1.nextElement();
               String strValue = properties.getProperty(strKey);
               if ("db_driver".equalsIgnoreCase(strKey)) {
                   this.dbdriver = strValue;
               } else if ("db_url".equalsIgnoreCase(strKey)) {
                   this.dburl = strValue;
               } else if ("db_username".equalsIgnoreCase(strKey)) {
                   this.dbuser = strValue;
               } else if ("db_password".equalsIgnoreCase(strKey)) {
                   this.dbpasswd = strValue;
               }
           }
       }
   }
   public void writeLog(String txt) {
       FileWriter fw = null;
       PrintWriter pw = null;
       try {
           File file = new File(this.logfile);
           fw = new FileWriter(file, true);
           pw = new PrintWriter(fw);
           pw.write(txt);
           pw.write("\r\n");
           pw.flush();
           pw.close();
       } catch (Exception e) {
           e.printStackTrace();
       } finally {
           if (fw != null) {
               try {
                   fw.close();
               } catch (Exception e) {
                   e.printStackTrace();
               }
           }
           if (pw != null) {
               try {
                   pw.close();
               } catch (Exception e) {
                   e.printStackTrace();
               }
           }
       }

   }
   public void setCurdir(String dir) {
       this.curdir = dir;
       this.logfile = this.curdir + System.getProperty("file.separator") + "log.log";
   }
}

  4:将checkString编译的.class文件、pre-commit.bat 放到hooks路径底下

svn hooks 增加数据库数据校验

  5:小乌龟测试提交

svn hooks 增加数据库数据校验

 

 

FAQ

 

 

 bat 容易出现乱码问题

svn hooks 增加数据库数据校验

 

java 回写到bat中乱码问题(这边是读取文件指定编码格式)

svn hooks 增加数据库数据校验

 

svn hooks 增加数据库数据校验

上一篇:Linux+Nginx Web Server+Mysql+PHP


下一篇:SQL 中的游标实例