筛选日志记录中的所有SQL，复制到nativeCat进行格式化美化

最新推荐文章于 2023-12-26 20:59:31 发布

潇湘梦

最新推荐文章于 2023-12-26 20:59:31 发布

阅读量412

点赞数

分类专栏：前端

本文链接：https://blog.csdn.net/iteye_9328/article/details/103769194

版权

前端专栏收录该内容

8 篇文章 0 订阅

订阅专栏

关于处理公司的日志所有SQL筛选出来

923d73ebb4ee000,92d15f72dc2e000$fas]FinancialAccountMapper.selectLeadRoleCompanyNos:==>  Preparing: /AT(COMPANY_NO SEPARATOR "','"),"'") FROM FINANCIAL_ACCOUNT WHERE 1 = 1 AND FINANCIAL_ACCOUNT.GROUP_LEAD_ROLE = '1' AND FINANCIAL_ACCOUNT.STATUS = '1' AND COMPANY_NO IN ( SELECT COMPANY_NO FROM COMPANY WHERE 1=1 AND ORGAN_TYPE_NO = ? AND ZONE_NO NOT IN ('1','2','3','4','5','6','7','8','9') ) 
[DEBUG]2019-12-30 14:07:59[http-bio-80-exec-7 923d73ebb4ee000,92d15f72dc2e000$fas]FinancialAccountMapper.selectLeadRoleCompanyNos:==> Parameters: U010101(String)


<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Log4j_sql</title>
<script type="text/javascript">
    var sqlflag="Preparing:";
    var parmasflag="Parameters:";
    var totalflag="Total:";
    var types=['String','Integer'];


	function testOnClick(){
        var LengSql=1;
		var logParameter=document.getElementById("logParameter").value;
        document.getElementById("id_sql").innerHTML="";
        var sqlOne= logParameter.split(/\n/);

        //sqlOne=dedupe(sqlOne);

        for (var i=0;i<sqlOne.length;i++){

            if(sqlOne[i].indexOf(sqlflag)!=-1){

                if (sqlOne[i+1].indexOf(sqlflag)!=-1){
                    //当两个一模一样的参数放在一起的不符合规范
                    continue;
                }
                var shuchusql="";
                var canshux="";
                var totalcout="";
                var sqlOne_sql= sqlOne[i].split(sqlflag);
                //sql
                var  sql=sqlOne_sql[1].trim();
                //参数
                var canshu=sqlOne[i+1].split(parmasflag);

                //返回数据条数
                var total=sqlOne[i+2].split(totalflag)==undefined?0:sqlOne[i+2].split(totalflag);

                totalcout="--  返回结果：total="+total[1]+"\n";

                var cass=canshu[1]==undefined?"":canshu[1].trim();

                canshux="--  参数:"+cass+"\n";
                var canshulist=cass==""?"":cass.split(",");
                var sqllist=sql.split("?");

                console.log("======="+sqllist.length);

                if(canshulist.length===(sqllist.length-1)) {
                    for (var sl = 0; sl < sqllist.length; sl++) {
                        var sqq1=sqllist[sl];
                        var css1 =canshulist[sl];
                        if(sqq1===" "){
                            sqq1="";
                        }
                        if(css1==undefined){
                            css1="";
                        }else {
                            var type = dataType(css1)
                            css1 = css1.split("(")[0].trim();
                            if (type === "String") {
                                css1 = "'" + css1 + "'";
                            }
                        }
                       shuchusql = shuchusql + sqq1 +css1;
                    }
                    shuchusql=shuchusql+";"+"" +
                        "\n";
                }else{
                        shuchusql="【参数有问题】 sql："+sql+" \n 参数："+canshu[1]+";============"+sqllist.length+"====ca="+canshulist.length;
                }

                var henggang="--  =========================tanli-=====华丽的分割线==============================================="+"\n";
                var  psql="-- 【 SQL 编号:"+LengSql+"】\n"+shuchusql+canshux+totalcout+henggang;
                document.getElementById("id_sql").innerHTML=document.getElementById("id_sql").value+psql;
                LengSql++;

            }
        }

	}
	function dataType(sss){
        for (var i=0;i<types.length;i++){
           if(sss.indexOf(types[i])!=-1){
               return types[i];
           }
        }
        return "String";
    }
    //去重
    function dedupe(array) {
        return Array.from(new  Set(array));
    }

</script>
</head>
<body>
日志：</br>
<textarea id="logParameter" rows="10" cols="200"></textarea></br>
<input type="button" value="日志筛选出SQL" onclick="testOnClick()"></br>
SQL</br>
<textarea id="id_sql" rows="50" cols="200"></textarea></br>
</body>
</html>

潇湘梦

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
2
评论
筛选日志记录中的所有SQL，复制到nativeCat进行格式化美化

关于处理公司的日志所有SQL筛选出来923d73ebb4ee000,92d15f72dc2e000$fas]FinancialAccountMapper.selectLeadRoleCompanyNos:==> Preparing: /AT(COMPANY_NO SEPARATOR "','"),"'") FROM FINANCIAL_ACCOUNT WHERE 1 = 1 AND FI...
复制链接

扫一扫

专栏目录