topic Re: Update cursor stops in Python Questions

Update cursor stops

CCWeedcontrol — Fri, 06 Jan 2023 20:17:34 GMT

I am trying the following but I only get 25 in the progress field on features that have something in "Field5". It seems to stop if it encounters a blank record in Field5. What am i doing wrong?

valDict{} with arcpy.da.UpdateCursor(table2, ["OBJECTID","Field1","Field2","Field3","Field4","Field5","Field6", "Field7", "Field8","Progress"], where) as cursor: for row in cursor: try: if row[5] is None: #if row[5] not in (None, "", " "): continue if row[5] in list1: print ("{} is in list".format(row[0])) row[9] = valDict.get(row[5]) if row[6] == "Pass" else valDict.get(row[5], 25) - 25 cursor.updateRow(row) except: continue

Re: Update cursor stops

ChrisJRoss13 — Fri, 06 Jan 2023 20:28:57 GMT

I believe there are a few things wrong with your code.

The first line, "valDict{}", is incomplete. It looks like it's supposed to be creating an empty dictionary, but it's missing the "=", so it will throw a syntax error. It should be written as "valDict = {}".
The "where" clause in the UpdateCursor is not defined. It should be replaced with a valid SQL WHERE clause, such as "WHERE Field1 = 'some value'"
The "continue" statement in the "except" block will prevent any errors from being raised or logged. Instead, it would be more helpful to either log the error or raise it to be handled by an enclosing try/except block.

See below for assistance:

valDict = {}

with arcpy.da.UpdateCursor(table2, ["OBJECTID","Field1","Field2","Field3","Field4","Field5","Field6", "Field7", "Field8","Progress"], "WHERE Field1 = 'some value'") as cursor:
for row in cursor:
try:
if row[5] is None: #if row[5] not in (None, "", " "):
continue
if row[5] in list1:
print ("{} is in list".format(row[0]))
row[9] = valDict.get(row[5]) if row[6] == "Pass" else valDict.get(row[5], 25) - 25
cursor.updateRow(row)
except Exception as e:
print(e)

Re: Update cursor stops

CCWeedcontrol — Fri, 06 Jan 2023 20:57:03 GMT

The ValDict and the where do have values, I was just trying to post quickly and didn't include them.

I did try the exception as e: but no message gets printed.

Re: Update cursor stops

CCWeedcontrol — Fri, 06 Jan 2023 21:22:39 GMT

Both row[5] and row[6] have blanks in the fields.

Re: Update cursor stops

RhettZufelt — Fri, 06 Jan 2023 22:38:38 GMT

At a quick glance, it appears you have indentation issues, and some missing colons.

the if row[5] line has another if statement in it, without colon or what to do if true. else statement also wrong indentation and no colon.

Don't know if this is the issue, but would expect it to be throwing syntax errors.

valDict{} with arcpy.da.UpdateCursor(table2, ["OBJECTID","Field1","Field2","Field3","Field4","Field5","Field6", "Field7", "Field8","Progress"], where) as cursor: for row in cursor: try: if row[5] is None: #if row[5] not in (None, "", " "): continue if row[5] in list1: print ("{} is in list".format(row[0])) row[9] = valDict.get(row[5]) if row[6] == "Pass": missing what to do if true else: valDict.get(row[5], 25) - 25 cursor.updateRow(row) except: continue

Re: Update cursor stops

Anonymous User — Sat, 07 Jan 2023 05:17:16 GMT

valDict.get(row[5], 25)

will try to get the key (row[5]) from the dictionary valDict. If there is no key in the dictionary, it returns the default value of 25.

I take it this question is is part of your other question you posted a couple weeks ago and if that is the case, you should continue in that thread because what you are trying to do with the 'decision tree' to assign percent complete is a lot more complex than this code example can handle.