When to set del cursor?

Question

Hi,

I have a very simple question in regards to the del cursor. I use it from time to time but I have not thought about it.

When is the del cursor used? I have a sample script with a del cursor but I am not sure if I used it in the right manner.

edit.startEditing(False, True)
edit.startOperation()

with updateLines as cursor:
    for row in updateLines:
        if row[0] in UpdateIsolatedIDs_Lines:
            IsolationID = UpdateIsolatedIDs_Lines[row[0]]
            print (row)
            #print (IsolationID)
            if IsolationID:
                row[0] = row[0]
                row[1] = IsolationID
                row[2] = row[2]
                updateLines.updateRow(row)
            print (row)
            print ('
')

del cursor

edit.stopOperation()
edit.stopEditing(True)

I am not sure if the del cursor is used properly but I just wanted to ask.

JohannesLindner · Accepted Answer

This way is incorrect.

When you use a with block, this is what happens (on a very, very conceptual level!)

with arcpy.da.UpdateCursor(...) as cursor:
    your_code()

# this gets translated into
cursor = arcpy.da.UpdateCursor(...)
cursor.__enter__()
your_code()
cursor.__exit__()

The __exit__ method of the cursors resets iteration and removes locks. When you delete the cursor object before the __exit__ method is called, there's a good chance that you'll get persistent locks.

Deleting the cursor object is optional. I use cursors all the time and never delete them, never had a problem. ESRI recommends considering using the del to be absolutely sure there are no locks left:

https://pro.arcgis.com/de/pro-app/latest/arcpy/get-started/data-access-using-cursors.htm 
Cursors support with statements to reset iteration and aid in removal of locks. However, using a del statement to delete the object or wrapping the cursor in a function to have the cursor object go out of scope should be considered to guard against all locking cases.

If you want to use it, delete OUTSIDE of the with block:

with arcpy.da.UpdateCursor(...) as cursor:
    for row in cursor:
        stuff()
del cursor