topic Re: InsertCursor will not work with the Set function in Python Questions

InsertCursor will not work with the Set function

LarryAdgate — Fri, 16 Mar 2018 20:07:35 GMT

#I would really appreciate some help on this: I need to use the Set function on this script to remove all
# my duplicates but the InsertCursor refuses to work here. Any Ideas, Thank You- Larry Adgate

import arcpy

fc1 = "Database Connections\\TaskmasterServer.sde\\sde_gsw.GSW_SDE.CCB_Updates1"
fc2= "Database Connections\\TaskmasterServer.sde\\sde_gsw.GSW_SDE.CCB_Data\\sde_gsw.GSW_SDE.Master_CCB_Points"
fc3 = "K:\\808 - TariffMaps\\MyResults\\MyTable.dbf"

set_one = set(r[0] for r in arcpy.da.SearchCursor(fc1,"PREM_ID"))
set_two = set(r[0] for r in arcpy.da.SearchCursor(fc2,"PREM_ID"))
print "Items unique to the Primary Field: {}".format(", ".join(sorted(set_one-set_two)))

results = set(set_one-set_two)
print results

cursor = arcpy.da.InsertCursor(fc3, ["result"])
#Below is my error= TypeError: value #0 - unsupported type: set
cursor.insertRow([results])

del cursor

Re: InsertCursor will not work with the Set function

JoshuaBixby — Fri, 16 Mar 2018 20:12:50 GMT

In the geodatabase, what data type is the "result" field in for fc3? You can't store Python data structures likes lists, tuples, sets, dictionaries, etc... directly in a record in a geodatabase, so I am trying to understand what data type "result" is since the field is already created.

Re: InsertCursor will not work with the Set function

LarryAdgate — Fri, 16 Mar 2018 20:30:00 GMT

Hi Joshuba,

My result data structure are numbers in a text field: Ex: 0000256677

My numbers have leading zeros so the field needs to be text

Thank You,

Larry

Re: InsertCursor will not work with the Set function

JoshuaBixby — Fri, 16 Mar 2018 20:56:09 GMT

what does one of your sets look like? Something like set(000025667, 000026443, ....)? If so, how do you want that to look in the text field in the geodatabase?

Re: InsertCursor will not work with the Set function

LarryAdgate — Fri, 16 Mar 2018 21:15:25 GMT

A A Typical set is in a text Field column. called PREM_ID-

Re: InsertCursor will not work with the Set function

XanderBakker — Fri, 16 Mar 2018 21:15:50 GMT

You can cast the result to string before writing the result using something similar as you already did with:

", ".join(sorted(set_one-set_two))‍

(this may generate too many characters to be contained in the field), but I don't understand the purpose of what you are trying to do. Every record will have a string representing the list of ID's that are in fc1 but not in fc2. When you have that, what will you do with this result?

Re: InsertCursor will not work with the Set function

JoshuaBixby — Fri, 10 Dec 2021 20:52:19 GMT

What about:

cursor = arcpy.da.InsertCursor(fc3, ["result"])
for i in results:
    cursor.insertRow([i])

del cursor‍‍‍‍‍

Re: InsertCursor will not work with the Set function

LarryAdgate — Fri, 16 Mar 2018 21:30:57 GMT

Thank You so Much........it Works

Larry

Re: InsertCursor will not work with the Set function

DanPatterson_Retired — Fri, 16 Mar 2018 21:48:36 GMT

You inadvertently marked your answer as correct, I unmarked it, please go back and mark the correct response as being the one