How can I list the target location associated with a replica?
1 Solution
Accepted Solutions
Full Solution: of what I was trying to get to. This would work pretty much as a standalone, with a few modifications for local use. I plan to have this included in several of my tools, and a tool just to give me some type of status.
Joshua Bixby ...we (or should I say tech support) figured that out last night. I was just about to post my solution and mark as assumed when your comment came in (now will give you the check for answering).
import arcpy
# shows messages for python window or tool
def myMsgs(message):
arcpy.AddMessage(message)
print(message)
# Note: sample uses arcpy.ArcSDESQLExecute(mySDEConneciton) to
# extract the xml string, then sde_conn.execute(sql) to
# grab the SibConnectionString value, which is the child path.
# This method could also extract other by modifying sql = type line.
# Most likely, addition tests and "splits" would be need to pull
# out the infomation. This includes:
# Name
# ReplicaVersion, CreationDate, AccessType, ModelType,
# DatasetName (and other information about the datasets)
# However, "replica." (used in MyMsg/Print) allows for most
# things needed (but not path I wanted). These include
# hasConflicts, isParent, isSender, lastReceive, lastSend, name
# owner, type, version
setOwner = "dbo" # maybe be sde or other
masterConnect = "__prod-me@wcgis_master.sde" # your connection with admin rights
masterGDB = r'Database Connections\{0}'.format(masterConnect)
sde_conn = arcpy.ArcSDESQLExecute(masterGDB)
# refresh replica list after process, and list all replicas and last sync date
replicaList = arcpy.da.ListReplicas(masterGDB)
replicaCount = len(replicaList)
# get list of the target/child path
try:
#sde_conn = arcpy.ArcSDESQLExecute(masterGDB)
# NOTE: error came when nvarchar(max) was used. 1000 works for my current needs.
sql = ("SELECT ITEMS.Definition.value('(/GPReplica/SibConnectionString)[1]','nvarchar(1000)') from {0}.GDB_ITEMS AS ITEMS INNER JOIN {0}.GDB_ITEMTYPES AS ITEMTYPES ON ITEMS.Type = ITEMTYPES .UUID WHERE ITEMTYPES. Name = 'Replica';".format(setOwner))
childpathList = sde_conn.execute(sql)
gotChildPath = True
except:
gotChildPath = False
myMsgs("not able to get child replica path list")
# This section is to print the info only. In tool, will do more.
if replicaCount == 0:
myMsgs("No replicas found\n")
elif replicaCount == 1: # the path is a [] if more than one
myMsgs("\n{0}\n List current replicas for: {1}".format("*" * 80, masterGDB))
for replica in replicaList:
myMsgs(" - Name: {0} path: {2} last update: {1}".format(replica.name, replica.lastReceive, childpathList.split(";")[0][9:]))
#myMsgs(" {0}".format(replica.lastReceive))
myMsgs("\n #### Note: strange date means no syncronization has happened yet ####\n{0}".format("*" * 80))
else:
count = 0
myMsgs("\n{0}\n List current replicas for: {1}".format("*" * 80, masterGDB))
for replica in replicaList:
myMsgs(" - Name: {0} last update: {1}".format(replica.name, replica.lastReceive))
myMsgs(" Last sync: {0}".format(replica.lastReceive))
cpath = childpathList[count]
if gotChildPath:
myMsgs(" child-path: {0}".format(cpath[0].split(";")[0][9:]))
count =+ 1
myMsgs("\n #### Note: strange date means no syncronization has happened yet ####\n{0}".format("*" * 80))
This will produce an out put similar to:
I hope this will help others in the future.
by
