把hive sql的关键字小写转大写的小程序

痛点：
自己在工作中主要使用notepad++进行编辑sql，而notepad++并不具备sql关键字自动大写的功能，所以需要通过程序来完成。有的人会说你可以用dbeaver之类的工具来写sql呀？ 这类工作确实可以关键字大写，个人习惯用notepad++。
话不多说，上代码。

代码中涉及的keyword.txt文件存放的是hive sql官方定义的关键字，以逗号分隔。关键字如下：

add,admin,after,all,alter,analyze,and,archive,array,as,asc,authorization,before,between,bigint,binary,boolean,both,bucket,buckets,by,cascade,case,cast,change,char,cluster,clustered,clusterstatus,collection,column,columns,comment,compact,compactions,compute,concatenate,conf,continue,create,cross,cube,current,current_date,current_timestamp,cursor,data,database,databases,date,datetime,day,dbproperties,decimal,deferred,defined,delete,delimited,dependency,desc,describe,directories,directory,disable,distinct,distribute,double,drop,elem_type,else,enable,end,escaped,exchange,exclusive,exists,explain,export,extended,external,false,fetch,fields,file,fileformat,first,float,following,for,format,formatted,from,full,function,functions,grant,group,grouping,having,hold_ddltime,hour,idxproperties,if,ignore,import,in,index,indexes,inner,inpath,inputdriver,inputformat,insert,int,intersect,interval,into,is,items,jar,join,keys,key_type,lateral,left,less,like,limit,lines,load,local,location,lock,locks,logical,long,macro,map,mapjoin,materialized,minus,minute,month,more,msck,none,noscan,not,no_drop,null,of,offline,on,option,or,order,out,outer,outputdriver,outputformat,over,overwrite,owner,partialscan,partition,partitioned,partitions,percent,plus,preceding,preserve,pretty,principals,procedure,protection,purge,range,read,readonly,reads,rebuild,recordreader,recordwriter,reduce,regexp,reload,rename,repair,replace,restrict,revoke,rewrite,right,rlike,role,roles,rollup,row,rows,schema,schemas,second,select,semi,serde,serdeproperties,server,set,sets,shared,show,show_database,skewed,smallint,sort,sorted,ssl,statistics,stored,streamtable,string,struct,table,tables,tablesample,tblproperties,temporary,terminated,then,timestamp,tinyint,to,touch,transactions,transform,trigger,true,truncate,unarchive,unbounded,undo,union,uniontype,uniquejoin,unlock,unset,unsigned,update,uri,use,user,using,utc,utctimestamp,values,value_type,varchar,view,when,where,while,window,with,year

hive sql的关键字小写转大写代码如下：

import java.io.{BufferedWriter, FileInputStream, FileWriter}

object SqlFormat {
  def main(args: Array[String]): Unit = {
    file("D:\\workspace\\pinko\\sql-parse\\src\\main\\resources\\test.sql")
//    val hql = "select * from a"
//
//    println(replaceHql(hql, "select"))
  }


  def read(fileName: String): String = {
    val lines =scala.io.Source.fromInputStream(new FileInputStream(fileName),"utf-8").getLines
    val sb = new StringBuilder()
    lines.foreach(sb.append(_).append("\n"))
    return sb.toString
  }

  def replaceHql(hql:String, key:String):String = {
    return hql.replaceAll("\\b" + key + "\\b",key.toUpperCase)
  }

  def file(fileName: String): Unit = {
    var hql=read(fileName)
    val keyWord =read("C:\\Users\\PINKO\\Desktop\\gz\\keyword.txt")
    val keyArr=keyWord.split(",")
    for(w <- keyArr) {
      hql =replaceHql(hql,w)
    }
//    println(hql)

    val bufferWriter =new BufferedWriter(new FileWriter(fileName))
    bufferWriter.write(hql)
    bufferWriter.close
  }

}