• python文本文件,生成指定的文件格式


    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+"
    ")
        elif s.find(findStr2) != -1:
            outFileIns.write(s)
            outFileIns.write(writeStr2+"
    ")
        elif s.find(findStr3) != -1:
            outFileIns.write(s)
            outFileIns.write("				"+writeStr3+"
    ")
        elif s.find(findStr4) != -1:
            outFileIns.write(s)
            outFileIns.write("					"+writeStr3+"
    ")
        elif s.find("CS_OSLGIS") != -1:
            outFileIns.write(s.replace("CS_OSLGIS","CQ_RMW"))
        elif s.find("AND A.LONGITUDE >") != -1:
            outFileIns.write("			AND A.LONGITUDE IS NOT NULL
    			AND A.LONGITUDE IS NOT NULL
    			AND ROWNUM<2
    ")
        elif s.find(") LOOP") != -1:
            outFileIns.write("		) LOOP
    ")
        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()
        
        
        
    

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

  • 相关阅读:
    git生成SSH秘钥
    ifconfig
    接口自动化测试平台:简介
    Gitd的使用
    jenkins自动化部署和Tomcat中间件容器
    Struts2——用来开发 MVC 应用程序的框架,可用于创建企业级Java web应用程序
    Hibernate——Java 领域的持久化ORM框架
    jQuery——JavaScript库
    JavaScript HTML DOM——文档对象模型
    JVM 完整深入解析
  • 原文地址:https://www.cnblogs.com/mengfanrong/p/4713663.html
Copyright © 2020-2023  润新知