def create_reviewer_session(reviewer_db, session):
# Check out a Data Reviewer extension license
arcpy.CheckOutExtension("datareviewer")
arcpy.env.overwriteOutput = "true"
arcpy.CreateReviewerSession_Reviewer(reviewer_db, session)
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
def create_reviewer_workspace(workspacepath, name, session):
# Check out a Data Reviewer extension license
arcpy.CheckOutExtension("datareviewer")
# Set environment
arcpy.env.workspace = workspacepath
# Create new geodatabase
workspace = arcpy.CreateFileGDB_management(workspacepath, name)
# Execute EnableDataReviewer
arcpy.EnableDataReviewer_Reviewer(workspace, "2227", "#", "DEFAULTS")
print "created spatial reference"
# Create a new Reviewer session
arcpy.CreateReviewerSession_Reviewer(workspace, session, "#")
arcpy.CheckInExtension("datareviewer")
# Open file in append mode
logfile.write(message + '\n') # Write message to log file and close
# Enable extension for data reviewer and overwriting output.
arcpy.CheckOutExtension("datareviewer")
arcpy.env.overwriteOutput = "true"
# Delete previous session:
# This will delete previous records and clean up the db
DeleteSession.deleteSessions(reviewer_db, start)
# 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])
