import osimport sysimport string#在一个特定的模式打开指定的文件，获取文件句柄def getFileIns(filePath,model):    print("打开文件")    print(filePath)    print(model)    return open(filePath,model)#获取须要处理的文件def getProcFile(path):    return os.listdir(path)#推断是否满足某个条件，假设满足则运行def isTrue(outFileIns,s):    findStr1 = "LINE_COUNT_UPDATE      INTEGER := 0;"    writeStr1 = "LINE_COUNT_ERROR       INTEGER := 0;        --错误数据XX条"    findStr2 = "DBMS_OUTPUT.PUT_LINE('处理完成"    writeStr2 = "DBMS_OUTPUT.PUT_LINE('错误数据['||LINE_COUNT_ERROR||']条.');"    findStr3 = "DBMS_OUTPUT.PUT_LINE('插入数据['||CUR_RESULT.INT_ID||']时发生异常...');"    writeStr3 = "LINE_COUNT_ERROR := LINE_COUNT_ERROR+1;"    findStr4 = "DBMS_OUTPUT.PUT_LINE('更新数据['||CUR_RESULT.INT_ID||']时发生异常...');"        if s.find(findStr1) != -1:        outFileIns.write(s)        outFileIns.write(writeStr1+"\n")    elif s.find(findStr2) != -1:        outFileIns.write(s)        outFileIns.write(writeStr2+"\n")    elif s.find(findStr3) != -1:        outFileIns.write(s)        outFileIns.write("\t\t\t\t"+writeStr3+"\n")    elif s.find(findStr4) != -1:        outFileIns.write(s)        outFileIns.write("\t\t\t\t\t"+writeStr3+"\n")    elif s.find("CS_OSLGIS") != -1:        outFileIns.write(s.replace("CS_OSLGIS","CQ_RMW"))    elif s.find("AND A.LONGITUDE >") != -1:        outFileIns.write("\t\t\tAND A.LONGITUDE IS NOT NULL\n\t\t\tAND A.LONGITUDE IS NOT NULL\n\t\t\tAND ROWNUM<2\n")    elif s.find(") LOOP") != -1:        outFileIns.write("\t\t) LOOP\n")    else:        outFileIns.write(s.replace("||')',2","||')',3"))                #读取并处理文本def getAndProc(inFileIns,outFileIns):    lines = inFileIns.readlines()    for s in lines:        #print(s)        isTrue(outFileIns,s)if __name__=="__main__":        inFileMod = "r"    outFileMod = "w"    path = "D:\\rmsdata2gis"    for tmpFile in os.listdir(path):        inFilePath = path+"\\"+tmpFile        outFilePath = path+"\\BAK_"+tmpFile        inFileIns = getFileIns(inFilePath,inFileMod)        outFileIns = getFileIns(outFilePath,outFileMod)        getAndProc(inFileIns,outFileIns)        inFileIns.close()        outFileIns.close()

版权声明：本文博客原创文章。博客，未经同意，不得转载。