解決erwin逆向工程,logical不顯示中文問題
時間 2021-01-19
標籤
erwin
python
oracle
我們利用Ca Erwin 生成erwin視圖後,存在logical不能轉成中文的問題,正常我們都logical是中文,physical是英文
利用python解決
所需工具下載:點擊打開鏈接 https://download.csdn.net/my
安裝python-2.7.13.msi 、python-2.7.13.msi 這兩個python文件,安裝後需要配置環境,跟java差不多(自行百度)
然後執行以下代碼,以下代碼轉自robot_sql ,進行微調,在win10可用
- #!/usr/bin/python
- # -*- coding: UTF8-*-
- # robot_lei
- import win32com.client
- import re
-
-
- # 創建COM對象
- scapi = win32com.client.Dispatch('AllFusionERwin.SCAPI')
- # conn=win32com.client.Dispatch('ADODB.Connection')
- # 建立與持久裝置中模型的連接
- # 源文件
- filename = "C:\\MGDB_MODEL.erwin"
- # 目標文件
- newfilename = "C:\\MGDB_MODEL1.erwin"
- scPUnit = scapi.PersistenceUnits.Add(filename, "RDO=yes")
- # 建立存取內存中模型數據的連接
- scSession = scapi.Sessions.Add()
- scSession.Open(scPUnit, 0, 0)
- # 事務控制
- scTranId = scSession.BeginTransaction()
- # 獲取所有Entity模型對象
- scMObjects = scSession.ModelObjects.Collect(scSession.ModelObjects.Root, 'Entity', 1)
- for scObj in scMObjects:
- # 取Definition屬性的值
- try:
- scDefineName = scObj.Properties('Definition').Value
- except Exception as ex:
- scDefineName = ''
- try:
- scName = scObj.Properties('Name').Value
- except Exception as ex:
- scName = ''
- # 對象名賦值
- # print "His scName is %s" % scName
- # print "His scDefineName is %s" % scDefineName
- scObj.Properties('Physical_Name').Value = scName
- scObj.Properties('Name').Value = scDefineName
- # 獲取該Entity的所有Attribute對象
- scAttrObjects = scSession.ModelObjects.Collect(scObj, 'Attribute', 1)
- for scAttrObj in scAttrObjects:
- # scAttrDefineName = scAttrObj.Properties('Definition').Value
- # scAttrName = scAttrObj.Properties('Name').Value
- try:
- scAttrDefineName = scAttrObj.Properties('Definition').Value
- except Exception as ex:
- scAttrDefineName = ''
- try:
- scAttrName = scAttrObj.Properties('Name').Value
- except Exception as ex:
- scAttrName = ''
- # 對象名賦值
- scAttrObj.Properties('Physical_Name').Value = scAttrName
- # 註釋可能帶有括號之類的 這邊做了特殊處理,不要處理的直接註釋掉if代碼即可
- if scAttrDefineName != '':
- scAttrDefineName = scAttrDefineName.replace('(', '(')
- is_find = re.findall(r'\(', scAttrDefineName)
- if is_find:
- scAttrDefineName = re.findall(r'(.*?)\(', scAttrDefineName)
- scAttrDefineName = scAttrDefineName[0]
- scAttrObj.Properties('Name').Value = scAttrDefineName
- scSession.CommitTransaction(scTranId)
- # 另存爲一個新的文件
- scPUnit.Save(newfilename, 'OVF=yes')
最後生成後的效果爲: