topic Re: Add new row to empty file geodatabase table in Python Questions

Add new row to empty file geodatabase table

ClaudineSicker — Mon, 04 Mar 2013 19:34:57 GMT

I am using ArcGIS 10.1 and have created a script that checks to see if a file geodatabase table is empty. It is a table with no spatial referencing.

The code I have thus far can add rows to tables that already have a record in it, but it will not add a new row to an empty table.

Can this be done? Would it be better accomplished if it were a dbf file rather than a geodatabase table?

Snippet of code looks like this:

    addRow =arcpy.da.InsertCursor(Variable1,("Frequency", "Used", "Region"))
    result = arcpy.GetCount_management(Variable1)
    print result
    print addRow
    if result == 0:
    [indent]addRow.insertRow((0, "Locally", 3))[/indent]
    else:
    [indent]do something else[/indent]

result and addRow printouts are correct. Prior tests taking out the if, else statements and just running the addRow.insertRow statement showed that tables that have at least one record get appended with a new row.

So I am of the opinion that I cannot add a new row using this approach. Any other ideas as to how I can add a row to an empty table.

Many thanks.

Re: Add new row to empty file geodatabase table

MathewCoyle — Mon, 04 Mar 2013 20:25:44 GMT

Does the empty table have the fields you are trying to populate?

Re: Add new row to empty file geodatabase table

ClaudineSicker — Mon, 04 Mar 2013 20:45:47 GMT

Does the empty table have the fields you are trying to populate?

Yes. the fields referenced in the addRow variable ("Frequency", "Used", "Region")

I want to populate them with (0, "Locally", 3)

Re: Add new row to empty file geodatabase table

MathewCoyle — Mon, 04 Mar 2013 21:39:55 GMT

Result is not an integer you can compare how you are. You need this.

result = int(arcpy.GetCount_management(Variable1).getOutput(0))

Also don't forget to add this at the end of your script.

del addRow

Re: Add new row to empty file geodatabase table

ClaudineSicker — Mon, 04 Mar 2013 22:12:33 GMT

Result is not an integer you can compare how you are. You need this.
result = int(arcpy.GetCount_management(Variable1).getOutput(0))
Also don't forget to add this at the end of your script.
del addRow

Yippee. It worked.

If results isn't an integer I can compare (and I am not doubting you) why did "0" (without quotes) return for the command "print results" for the empty tables?

Just trying to wrap my head around python.

Thanks a zillion. I have been going around for hours on this snippet.

Re: Add new row to empty file geodatabase table

MathewCoyle — Sat, 11 Dec 2021 14:21:14 GMT

If you want to get as much information as possible about an output or variable you can use the following commands.

type(variable)
repr(variable)

Which shows the value returned by GetCount is an object.

>>> result = arcpy.GetCount_management(fc)
>>> type(result)
<class 'arcpy.arcobjects.arcobjects.Result'>
>>> repr(result)
"<Result '60'>"

Which you must then get the results property from. But we're still not done yet.

>>> result = arcpy.GetCount_management(fc).getOutput(0)
>>> type(result)
<type 'unicode'>
>>> repr(result)
"u'60'"

The getOutput parameter returns a unicode string, not an int. But once we are here it is a simple step to convert it to a numeric value.

>>> result = int(arcpy.GetCount_management(fc).getOutput(0))
>>> type(result)
<type 'int'>
>>> repr(result)
'60'

Hope that helps.