momoku 2020-09-11
以arcgispro的python脚本为例在arcgispro自带的python窗口下运行python脚本
需求:
将arcgispro的.aprx项目包中gdb的数据源路径更换为sde数据源路径。
示例数据:testaprx_jb51.rar
演示过程:
方式一:脚本中指定好相关参数设置
import arcpy import json import sys import os import argparse import re result = "" jsontext = {'success': {}, 'msg': ''} def checkSavedAprxDatasource(output_aprx_path, mapName, targetDb): check_result = True desc = arcpy.Describe(targetDb) saved_aprx = arcpy.mp.ArcGISProject(output_aprx_path) for saved_map in saved_aprx.listMaps(): if saved_map.name == mapName: for lyr in saved_map.listLayers(): if lyr.isFeatureLayer: # print(lyr.connectionProperties) if lyr.connectionProperties['workspace_factory'].upper() == 'SDE'.upper( ) and lyr.connectionProperties['connection_info']['instance'] == desc.connectionProperties.instance: pass else: check_result = False return check_result if __name__ == '__main__': try: # linux # aprxPath = str(sys.argv[1]) # mapName = str(sys.argv[2]) # sourceDb = str(sys.argv[3]) # targetDb = str(sys.argv[4]) # output_aprx_path = str(sys.argv[5]) # local pc aprxPath = r'D:\rvt\testaprx\testaprx.aprx' mapName = 'Map' sourceDb = r'D:\rvt\testaprx\Data.gdb' targetDb = r'D:\rvt\testaprx\testsde.sde' output_aprx_path = r'D:\rvt\testaprx\output\export5.aprx' aprx = arcpy.mp.ArcGISProject(aprxPath) for m in aprx.listMaps(): if m.name == mapName: m.updateConnectionProperties(sourceDb, targetDb) if os.path.exists(output_aprx_path): os.remove(output_aprx_path) aprx.saveACopy(output_aprx_path) checkResult = checkSavedAprxDatasource( output_aprx_path, mapName, targetDb) if checkResult: jsontext['success'] = True result = json.dumps(jsontext) sys.stdout.write(result) else: jsontext['success'] = False jsontext['msg'] = 'Failed to replace data source' result = json.dumps(jsontext) sys.stdout.write(result) except Exception as e: jsontext['success'] = False jsontext['msg'] = e.args result = json.dumps(jsontext) sys.stdout.write(result)
方式二:使用sys.argv[ ]的形式设置相关参数
(arcgispro-py3) D:\rvt\testaprx>python test.py D:\rvt\testaprx\testaprx.aprx Map D:\rvt\testaprx\Data.gdb D:\rvt\testaprx\testsde.sde D:\rvt\testaprx\output\export5.aprx
import arcpy import json import sys import os import argparse import re result = "" jsontext = {'success': {}, 'msg': ''} def checkSavedAprxDatasource(output_aprx_path, mapName, targetDb): check_result = True desc = arcpy.Describe(targetDb) saved_aprx = arcpy.mp.ArcGISProject(output_aprx_path) for saved_map in saved_aprx.listMaps(): if saved_map.name == mapName: for lyr in saved_map.listLayers(): if lyr.isFeatureLayer: # print(lyr.connectionProperties) if lyr.connectionProperties['workspace_factory'].upper() == 'SDE'.upper( ) and lyr.connectionProperties['connection_info']['instance'] == desc.connectionProperties.instance: pass else: check_result = False return check_result if __name__ == '__main__': try: # linux aprxPath = str(sys.argv[1]) mapName = str(sys.argv[2]) sourceDb = str(sys.argv[3]) targetDb = str(sys.argv[4]) output_aprx_path = str(sys.argv[5]) print("aprx路径: "+aprxPath) print("地图视图的名称: "+mapName) print("当前的数据源路径: "+sourceDb) print("目标数据源路径: "+targetDb) print("aprx另存为路径: "+output_aprx_path) # local pc # aprxPath = r'D:\rvt\testaprx\testaprx.aprx' # mapName = 'Map' # sourceDb = r'D:\rvt\testaprx\Data.gdb' # targetDb = r'D:\rvt\testaprx\testsde.sde' # output_aprx_path = r'D:\rvt\testaprx\output\export5.aprx' aprx = arcpy.mp.ArcGISProject(aprxPath) for m in aprx.listMaps(): if m.name == mapName: m.updateConnectionProperties(sourceDb, targetDb) if os.path.exists(output_aprx_path): os.remove(output_aprx_path) aprx.saveACopy(output_aprx_path) checkResult = checkSavedAprxDatasource( output_aprx_path, mapName, targetDb) if checkResult: jsontext['success'] = True result = json.dumps(jsontext) sys.stdout.write(result) else: jsontext['success'] = False jsontext['msg'] = 'Failed to replace data source' result = json.dumps(jsontext) sys.stdout.write(result) except Exception as e: jsontext['success'] = False jsontext['msg'] = e.args result = json.dumps(jsontext) sys.stdout.write(result)