topic Using pathlib with SearchCursor in Python Questions

Using pathlib with SearchCursor

BlakeTerhune — Thu, 24 Jun 2021 16:53:28 GMT

I'm trying to switch from using the os module to pathlib.Path for working with file paths. For some reason, when I construct the path to the feature class (or table) with Path, it fails with

RuntimeError: 'in_table' is not a table or a featureclass

If I simply convert the path to string in the cursor using str(), it works fine. A print() of the path looks normal; not a weird object or something. I get the same behavior with a file geodatabase and Oracle 12c enterprise geodatabase. I also tried using Path.joinpath() instead of the shorthand / but had the same error.

Is there a different way I should be constructing paths?

from pathlib import Path egdb_conn = r"C:\GISConnections\user@instance.sde" fc_path = Path(egdb_conn) / "schema.tablename" print(fc_path) print(arcpy.Exists(fc_path)) with arcpy.da.SearchCursor(fc_path, ["OID@"]) as search_cursor: for row in search_cursor: print(row)

BTW, I'm on ArcGIS Pro 2.8

Re: Using pathlib with SearchCursor

JoshuaBixby — Thu, 24 Jun 2021 19:16:39 GMT

Not surprising, the ArcPy DA module was originally written before pathlib came around. I am guessing Esri will view this as an Enhancement Request to support pathlib.

Re: Using pathlib with SearchCursor

DanPatterson — Thu, 24 Jun 2021 19:20:39 GMT

It returns a different object type, print works since its __repr__ method returns a string

.... pathlib.WindowsPath

convert to string before arc'ing it

Re: Using pathlib with SearchCursor

BlakeTerhune — Thu, 24 Jun 2021 20:48:42 GMT

Thank you both for sharing your thoughts. I have created a new Python Idea.

Update arcpy cursors to work with paths constructe... - Esri Community