def run_reviewer_batch_job(reviewer_db, session, checks_rbj, prod_data): # Check out a Data Reviewer extension license arcpy.CheckOutExtension("datareviewer") arcpy.env.overwriteOutput = "true" # Execute Reviewer Batch Job function res = arcpy.ExecuteReviewerBatchJob_Reviewer(reviewer_db, session, checks_rbj, prod_data) arcpy.CheckInExtension("datareviewer")
def DRrun(str_dr_db, str_filename_rbj, str_data_db): print "DRrunner_execute()", str_dr_db, str_filename_rbj, str_data_db # Description: Executes a reviewer batch job # Requirements: Production Mapping extension arcpy.env.overwriteOutput = "true" # Delete, and then Create, the DR-session, to make sure it's clean. print "Starting DR session" str_session = "DRrunner" try: arcpy.DeleteReviewerSession_Reviewer(str_dr_db, str_session) except: print " Session didn't exist ..." print "creating session" drs_session = arcpy.CreateReviewerSession_Reviewer(str_dr_db, str_session) #Session = arcpy.CreateReviewerSession_Reviewer(Reviewer_workspace , "TestSession", "Session 1 : Session 1") print " DR session Create - Success : ", str(drs_session) # Execute Reviewer Batch Job function print "Executing DR batch job: " + str_filename_rbj res = arcpy.ExecuteReviewerBatchJob_Reviewer(str_dr_db, drs_session, str_filename_rbj, str_data_db) print " DR execute rbj - Success" # get the output table print "Show results:" tbl = res.getOutput(0) # query the table for row in arcpy.da.SearchCursor(tbl, ("*")): for i in range(len(row)): print " " + str(i) + " : " + str(row[i]) str_batch_run_id = row[1] # Check in the Data Reviewer extension arcpy.CheckInExtension("datareviewer") return str_batch_run_id # ------ End def DRrun() ------------- # Music that accompanied the coding of this script: # Coralie Clement - Salle des pas perdus
# Create a new session: session_name = ("%s_%s_%s" % (start.year, start.month, start.day)) print session_name session = str(arcpy.CreateReviewerSession_Reviewer(reviewer_db, session_name)) print session writeMsg("\nSession Id: " + session) # Set loop to run and log the batch events, or errors if present. for check in rbj: try: use_rbj = rbj_path + check now = datetime.datetime.now() writeMsg("\nStarting Batch job: " + check + " at \n" + str(now)[:-7]) res = arcpy.ExecuteReviewerBatchJob_Reviewer(reviewer_db, session, use_rbj, production_db, area, "") now = datetime.datetime.now() arcpy.Delete_management("in_memory") writeMsg("\nFinished at: " + str(now)[:-7]) except Exception as err: writeMsg("\n Batch job did not work.\n\n") writeMsg(str(err)) # Set variables to run Locate Events along Route tool. # Start by making a copy of the LRSN Road Network that is filtered with the time stamp def query. arcpy.MakeFeatureLayer_management( production_db + "/INVDB.LRSN_RoadNetwork", 'useMe', where_clause= "(FromDate is null or FromDate<=CURRENT_TIMESTAMP) and (ToDate is null or ToDate>CURRENT_TIMESTAMP)"
session_name = ("%s_%s_%s" % (start.year, start.month, start.day)) print session_name session = str(arcpy.CreateReviewerSession_Reviewer(reviewer_db, session_name)) print session writeMsg("\nSession Id: " + session ) # Set loop to run and log the batch events, or errors if present. for check in rbj: try: use_rbj = rbj_path + check now = datetime.datetime.now() writeMsg("\nStarting Batch job: " + check + " at \n" + str(now)[:-7]) res = arcpy.ExecuteReviewerBatchJob_Reviewer( reviewer_db, session, use_rbj, production_db, "", "", production_workspaceversion) now = datetime.datetime.now() arcpy.Delete_management("in_memory") writeMsg("\nFinished at: " + str(now)[:-7]) except Exception as err: writeMsg("\n Batch job did not work.\n\n") writeMsg(str( err )) # Set variables to run Locate Events along Route tool. # Start by making a copy of the LRSN Road Network that is filtered with the time stamp def query. arcpy.MakeFeatureLayer_management( production_db + "/INVDB.LRSN_RoadNetwork",