updateFeatures

#-------------------------------------------------------------------------------
# Name:        Update Master Table
# Purpose:     Ensures that the master and new table are identical(matching the new table)
#
# Author:      kara

#-------------------------------------------------------------------------------

import arcpy

mastertable = r""
newtable = r""

mastervalues = []
newvalues = []

with arcpy.da.SearchCursor(newtable, "*") as newCursor: # create a search cursor for the new table
    for new in newCursor:
        newvalues.append(new[1]) # append all values in the new table to a list
        with arcpy.da.UpdateCursor(mastertable, "*") as MasterCursor: # create an update cursor for the master table
            for master in MasterCursor:
                mastervalues.append(master[1]) # append all values in the master table to a list
                if new[1] == master[1]: # determnes if the ID found in the new table is in the master table, procedes if true
                    master[2] = new[2]
                    #master[3] = new[3]
                    MasterCursor.updateRow(master) # updates the records as necessary

    for master in MasterCursor: # removes any records in the master table not found in the new table
        if master[1] not in newvalues:
            MasterCursor.deleteRow()

    del newCursor

with arcpy.da.SearchCursor(newtable, "*") as newCursor:
    for new in newCursor: # adds any records to the master table found in the new table not in the master table
        if new[1] not in mastervalues:
                with arcpy.da.InsertCursor(mastertable, "ID") as updateMaster:
                    updateMaster.insertRow(new[3])

print ("Complete")