import os import sys import 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+"http://"+tmpFile     outFilePath = path+"http://BAK_"+tmpFile     inFileIns = getFileIns(inFilePath,inFileMod)     outFileIns = getFileIns(outFilePath,outFileMod)     getAndProc(inFileIns,outFileIns)     inFileIns.close()     outFileIns.close()