Inicio Explorar Axuda
Iniciar sesión
LiuFan
/
PrivacyScanData
1
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Árbore: c7f56cb0b5
Ramas Etiquetas
PrivacyScanD...
/
truncate
/
new2
/
hobart-update-prod-from-dev-main
/
updateProdFromDev
/
script
/
update-prod-from-dev-hobart.py

update-prod-from-dev-hobart.py 2.5 KB
Histórico Raw

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182 
  1. '''
    2. 

  2. Truncate/Delete Rows and Append
    3. 

  3. tool for Hobart, IN features. '''
    4. 

  4. 

  5. import arcpy
    6. 

  6. 

  7. def replaceData(input_fc, target_fc):
    8. 

  8. 

  9.     arcpy.AddMessage('Starting run...')
    10. 

  10. 

  11.     input_row_count = int(arcpy.GetCount_management(input_fc)[0])
    12. 

  12. 

  13.     et_switch = 0
    14. 

  14. 

  15.     desc = arcpy.da.Describe(target_fc)
    16. 

  16. 

  17.     if desc['editorTrackingEnabled']:
    18. 

  18. 

  19.         arcpy.AddMessage('Editor tracking is enabled...')
    20. 

  20.         et_switch = 1
    21. 

  21. 

  22.         arcpy.AddMessage('Identifying ET fields...')
    23. 

  23.         creator_fld = desc['creatorFieldName']
    24. 

  24.         create_date_fld = desc['createdAtFieldName']
    25. 

  25.         editor_fld = desc['editorFieldName']
    26. 

  26.         edit_date_fld= desc['editedAtFieldName']
    27. 

  27.         
    28. 

  28.         arcpy.AddMessage('Disabling editor tracking...')
    29. 

  29.         arcpy.DisableEditorTracking_management(target_fc, 'DISABLE_CREATOR', 'DISABLE_CREATION_DATE', 'DISABLE_LAST_EDITOR', 'DISABLE_LAST_EDIT_DATE')
    30. 

  30. 

  31.     if desc['isVersioned']:
    32. 

  32.         
    33. 

  33.         arcpy.AddMessage('Dataset is versioned...')
    34. 

  34.         arcpy.AddMessage('Deleting rows...')
    35. 

  35.         arcpy.DeleteRows_management(target_fc)
    36. 

  36.         arcpy.AddMessage('Appending updated data...')
    37. 

  37.         arcpy.Append_management(input_fc, target_fc, 'NO_TEST')
    38. 

  38. 

  39.         if et_switch == 1:
    40. 

  40.             
    41. 

  41.             arcpy.AddMessage('Enabling editor tacking...')
    42. 

  42.             arcpy.EnableEditorTracking_management(target_fc, creator_fld, create_date_fld, editor_fld, edit_date_fld, 'NO_ADD_FIELDS')
    43. 

  43.             
    44. 

  44.     else:
    45. 

  45. 

  46.         arcpy.AddMessage('Truncating dataset...')
    47. 

  47.         arcpy.TruncateTable_management(target_fc)
    48. 

  48.         arcpy.AddMessage('Appending updated data...')
    49. 

  49.         arcpy.Append_management(input_fc, target_fc, 'NO_TEST')
    50. 

  50. 

  51.         if et_switch == 1:
    52. 

  52. 

  53.             arcpy.AddMessage('Enabling editor tacking...')
    54. 

  54.             arcpy.EnableEditorTracking_management(target_fc, creator_fld, create_date_fld, editor_fld, edit_date_fld, 'NO_ADD_FIELDS')
    55. 

  55. 

  56. 

  57.     target_row_count = int(arcpy.GetCount_management(target_fc)[0])
    58. 

  58. 

  59.     if input_row_count == target_row_count:
    60. 

  60. 

  61.         arcpy.AddMessage('Done!')
    62. 

  62.     
    63. 

  63.     else:
    64. 

  64. 

  65.         arcpy.AddWarning('Row counts from input and target do not match!')
    66. 

  66.         arcpy.AddWarning('Manual investigation is required!')
    67. 

  67.         arcpy.AddWarning('Compare field lengths and types to ensure the schemas match.')
    68. 

  68. 

  69. if __name__ == '__main__':
    70. 

  70. 

  71.     dev_fc = arcpy.GetParameterAsText(0)
    72. 

  72.     prod_fc = arcpy.GetParameterAsText(1)
    73. 

  73. 

  74.     try:
    75. 

  75. 

  76.         replaceData(dev_fc, prod_fc)
    77. 

  77. 

  78.     except Exception as e:
    79. 

  79. 

  80.         arcpy.AddWarning(e)
    81. 

  81.         arcpy.AddError('Run failed :(')
    82. 

  82.