extract SQL statements from Java source

最新推荐文章于 2024-07-20 23:55:03 发布

kgrass

最新推荐文章于 2024-07-20 23:55:03 发布

阅读量298

点赞数

分类专栏： Ruby Scripts 文章标签： java sql

本文链接：https://blog.csdn.net/kgrass/article/details/2881960

版权

Ruby Scripts 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

 
 $KCODE='SJIS'
d=""
deappend=false
i=0
File.open("in.txt").each_line{|l|
        l.strip!
        i+=1
        if(i==1)
            if(l.include?(".append") || l.include?("StringBuffer"))
                    deappend=true
            end
        end
        if(!deappend)
            if (l.strip.rindex("--") ==0)
                d << "      // #{l.strip}/n"
            elsif (l.strip=="")
                next
            else
                d <<"       sql.append(/"#{l.strip} /");/n"
            end
        end
        if(deappend)
            if(l=~/^(.*)/)
                d << "-- #{$1.delete("--")}/n"
            elsif(l.strip=~/^.*/.append/s*/((.*)/)/s*;/)                
                d << $1.strip.delete("/"") << "/n"
            else
                puts "-- ignore >> #{l.chomp.strip}"
            end
        end
}
puts d
 

kgrass

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
extract SQL statements from Java source

$KCODE=SJISd=""deappend=falsei=0File.open("in.txt").each_line{|l| l.strip! i+=1 if(i==1) if(l.include?(".append") || l.include?("StringBuffer"))
复制链接

扫一扫