topic Re: SQL sort parameter syntax for da.cursors? in Python Questions

SQL sort parameter syntax for da.cursors?

ChrisSnyder — Mon, 13 Aug 2012 20:03:33 GMT

Looking for examples of using the "ORDER_BY" SQL syntax that is now suported in the arcpy.da cursor model...

Help system is lacking in examples on this front...

Can any v10.1 pro rewrite this in arcpy.da format?

arcpy.UpdateCursor(oesfHydroDislvFC, "", "", "", "SL_WTRTY_CD A;RIP_COMBO_UID D")

Re: SQL sort parameter syntax for da.cursors?

ChrisFox3 — Sun, 12 Dec 2021 03:38:52 GMT

it would be something like:

sqlClause = (None, "ORDER BY Field1 ASC, Field2 DESC")
arcpy.da.UpdateCursor(inFC, fields, sql_clause=sqlClause)

Make sure any fields you use in the sql expression are also passed in the field_names parameter.

Re: SQL sort parameter syntax for da.cursors?

ChrisSnyder — Mon, 13 Aug 2012 20:29:37 GMT

Thanks Chris

I'm thinking the "fancy" SQL parameter is the 6th one down the line, so it probably should be something like this:

arcpy.da.UpdateCursor(oesfHydroDislvFC, fieldList, None, None, False, (None, 'ORDER_BY SL_WTRTY_CD, RIP_COMBO_UID DESC'))

But that is thowing an error:
Traceback (most recent call last):
File "<interactive input>", line 1, in <module>
TypeError: expected callable function - logger(obj)

Been trying a lot of things for a while - with nothing working out...

Re: SQL sort parameter syntax for da.cursors?

ChrisSnyder — Mon, 13 Aug 2012 20:39:29 GMT

Re: SQL sort parameter syntax for da.cursors?

ChrisFox3 — Mon, 13 Aug 2012 20:48:18 GMT

Thanks Chris

I'm thinking the "fancy" SQL parameter is the 6th one down the line, so it probably should be something like this:

arcpy.da.UpdateCursor(oesfHydroDislvFC, fieldList, None, None, False, (None, 'ORDER_BY SL_WTRTY_CD, RIP_COMBO_UID DESC'))

But that is thowing an error:
Traceback (most recent call last):
File "<interactive input>", line 1, in <module>
TypeError: expected callable function - logger(obj)

Been trying a lot of things for a while - with nothing working out...

If you used a named parameter than you don't have to specify the value for every optional paramater to the function. This makes your code a lot easier to write and read and sometimes resolves errors that may have accidentally been added. So since you are just accepting the defaults for the 3rd 4th and 5th parameter you could change your code to:

arcpy.da.UpdateCursor(oesfHydroDislvFC, fieldList, sql_clause=(None, 'ORDER_BY SL_WTRTY_CD, RIP_COMBO_UID DESC'))

Also make sure the input is a Geodatasbase Feature Class, the sql_clause paramater does not work on shapefiles. I just tested this similar expression on my data and it worked as expected. If you remove the sql_clause paramater is the cursor created succesfully? Did you want to share a small subset of your data?

Re: SQL sort parameter syntax for da.cursors?

ChrisFox3 — Sun, 12 Dec 2021 03:38:54 GMT

Additional info, I get the same error as you if I attempt to enter all the parameters in the same order as specified in the function's signature.

>>> rows = arcpy.da.UpdateCursor("U.S. Cities", fields, None, None, False, (None, 'Order By STATE_NAME, TYPE DESC'))
Runtime error 
Traceback (most recent call last):
  File "<string>", line 1, in <module>
TypeError: expected callable function - logger(obj)

This seems to be a bug, I will look into this further. Using sql_clause= instead works.

>>> rows = arcpy.da.UpdateCursor("U.S. Cities", fields, None, None, False, sql_clause=(None, 'Order By STATE_NAME, TYPE DESC'))

Re: SQL sort parameter syntax for da.cursors?

ChrisSnyder — Mon, 13 Aug 2012 21:04:55 GMT

Okay - I get the 'named parameter' thing... .It's working now... Thanks Chris and Jason!

Correct sytax for a multiple field sort:

arcpy.da.UpdateCursor(oesfHydroDislvFC, fieldList, sql_clause=(None, 'ORDER BY SL_WTRTY_CD, RIP_COMBO_UID DESC'))

Note that the Help system indicates "ORDER_BY" but it is really "ORDER BY" (with no underscore).

VERIFIED:
arcpy.da.UpdateCursor(oesfHydroDislvFC, fieldList, None, None, False, (None,'ORDER BY SL_WTRTY_CD, RIP_COMBO_UID DESC'))

results in an error.... Not sure why...

Re: SQL sort parameter syntax for da.cursors?

ChrisFox3 — Mon, 13 Aug 2012 21:57:38 GMT

I logged a new bug for this issue, NIM083765.

Re: SQL sort parameter syntax for da.cursors?

ChrisSnyder — Mon, 13 Aug 2012 23:30:09 GMT

I logged a new bug for this issue, NIM083765.

Appreciate that. Thanks Chris.

Re: SQL sort parameter syntax for da.cursors?

oscarespitia — Thu, 26 Sep 2013 15:49:40 GMT

give a look at this

http://forums.arcgis.com/threads/930...656#post330656