it seems like a basic question, but even with the documentation and other posts I cannot get it to work properly. I've got a Python-Toolbox in which I establish the connection to a ArcSDE using a connection file. now I would like to list the content of the ArcSDE in my dockpane (because it looks prettier). I can list the content of my dockpane in my Python-Toolbox and display them. It seems that it's also correct how I pass them back (at least there is no error message). But I don't see how I can access the returned strings and arrays. How do I pass my ArcSDE content as string or array (or anything else) to my dockpane?
here is what I've got in my Python Toolbox:
import arcpy
from tkinter import messagebox
from osgeo import gdal
import os
import ast
class Toolbox(object):
def __init__(self):
"""Define the toolbox (the name of the toolbox is the name of the
.pyt file)."""
self.label = "Toolbox"
self.alias = "toolbox"
# List of tool classes associated with this toolbox
self.tools = [ArcSDEContent]
def read_sde():
if os.path.exists(os.environ['AppDAta']+"/Esri/ArcGISPro/Favorites/xxx.sde"):
sde_connfile = os.environ['AppDAta']+"/Esri/ArcGISPro/Favorites/xxx.sde"
conn = arcpy.ArcSDESQLExecute(sde_connfile)
sql = "select t.name as mytype,i.name as myname, \
CASE \
WHEN has_table_privilege(user,i.name,'SELECT') THEN 1 \
ELSE 0 \
END AS mypriv \
FROM GDB_itemtypes t \
right join GDB_items i \
ON i.type = t.uuid \
where t.name in ( \
'Tin', \
'Geometric Network', \
'Survey Dataset', \
'Schematic Dataset', \
'Table', \
'Feature Class', \
'Raster Dataset', \
'Raster Catalog', \
'Network Dataset', \
'Terrain', \
'Parcel Fabric', \
'Mosaic Dataset', \
'Utility Network', \
'Parcel Dataset' \
);"
try:
sql_return = conn.execute(sql)
layer_files = []
layer_schemas = []
for i in sql_return:
if i[2] == 0:
continue
layer_type = i[0]
layer_fullname = sde_connfile + '/' + i[1]
layer_name = i[1].split('.')[1] + '.' + i[1].split('.')[2]
layer_shortname = i[1].split('.')[2]
layer_schema = i[1].split('.')[1]
if layer_schema not in layer_schemas:
layer_schemas.append(layer_schema)
layer_files.append([layer_name,layer_shortname,layer_schema,layer_fullname,layer_type])
layer_schemas.sort()
layer_files.sort()
return layer_files, layer_schemas
except Exception as err:
sql_return = False
else:
messagebox.showinfo(title="test 2", message="sde file does not exist")
class ArcSDEContent(object):
def __init__(self):
"""Define the tool (tool name is the name of the class)."""
self.label = "ArcSDE Content"
self.description = ""
def getParameterInfo(self):
"""Define parameter definitions"""
params = []
params.append({
'name': 'layer_files',
'displayName': 'Layer Files',
'datatype': 'String',
'parameterType': 'Derived',
'direction': 'Output'
})
params.append({
'name': 'layer_schemas',
'displayName': 'Layer Schemas',
'datatype': 'String',
'parameterType': 'Derived',
'direction': 'Output'
})
return params
def isLicensed(self):
return True
def updateParameters(self, parameters):
return
def updateMessages(self, parameters):
return
def execute(self, parameters, messages):
layer_files, layer_schemas = read_sde()
# Set the output parameters with the results
parameters[0].value = ";".join(layer_files) # Join the list to a string
parameters[1].value = ";".join(layer_schemas)
and in my dockpane.xaml.cs I've got:
private async void ReadArcSDE(object sender, RoutedEventArgs e)
{
string installPath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location);
string toolboxPath = System.IO.Path.Combine(installPath, "MyPythonToolbox.pyt\\ArcSDEContent");
IGPResult result = await Geoprocessing.ExecuteToolAsync(toolboxPath, null, null, null, null, GPExecuteToolFlags.InheritGPOptions);
}
thanks for any hint
