task otm  {
    doLast {
        otmcp.execute()
        otmchk.execute()
    }
}
// 复制缺少的mysql数据库mapper文件
task otmcp  {
    doLast {
        FileTree oracleMappers = fileTree(dir: '.', include: 'src/**/oracle/*.xml')
        // 遍历
        oracleMappers.each {File file ->
            def oracleMapperPath =  file.getPath()
            def mysqlMapperPath = oracleMapperPath.replace('oracle','mysql')

            File mysqlMapperFile = new File(mysqlMapperPath)
            def mysqlMapperFileParent = mysqlMapperPath.substring(0,mysqlMapperPath.lastIndexOf(File.separator))
            if(mysqlMapperFile.isDirectory()){
                delete mysqlMapperPath
            }
            if(!mysqlMapperFile.exists()){
                File mysqlMapperDir = new File(mysqlMapperFileParent)
                if(!mysqlMapperDir.exists()){
                    mysqlMapperDir.mkdirs()
                }
                copy {
                    from oracleMapperPath
                    into mysqlMapperFileParent
                }
            }
        }
        println 'Finished copy Oracle mapper file to Mysql.'

    }
}
// 检查的mysql数据库mapper文件是否包含oracle专用语法
task otmchk  {
    doLast {
        FileTree mysqlMappers = fileTree(dir: '.', include: 'src/**/mysql/*.xml')
        def oracleKyeWords = ['decode','nvl','(+)','rownum','||', 'sysdate']
        mysqlMappers.each {File file ->
            def fileContents = file.getText('UTF-8')
            oracleKyeWords.each{
                if(fileContents.contains(it)){
                    println 'WARN: Mysql mapper file [ '+file.getName()+' ] contains oracle key word [ '+ it +' ], please check!'
                }
            }
        }
    }
}
//
task getMysqlXml  {
    doLast {
        FileTree mysqlMappers = fileTree(dir: '.', include: 'src/**/mysql/*.xml')
        mysqlMappers.each {File file ->
            println file
        }
    }
}
task getOracleXml  {
    doLast {
        FileTree mysqlMappers = fileTree(dir: '.', include: 'src/**/oracle/*.xml')
        mysqlMappers.each {File file ->
            println file
        }
    }
}