topic Geoprocessing with CherryPy web framework in Geoprocessing Questions

Geoprocessing with CherryPy web framework

nickmassaro — Mon, 09 Jul 2012 22:01:43 GMT

I???m trying to return data to a web page from a simple processioning procedure. I keep getting the following error ???self._gp.SearchCursor(*gp_fixargs(args))) RuntimeError: ERROR 999999: Error executing function.??? The processioning function works fine standalone but fails when ran with through CherryPy.
I think it???s a pathing issue but haven???t had any luck solving it.[ATTACH=CONFIG]15889[/ATTACH]

Any help would be greatly appreciated.

Code follows as well as being attached with table.

##
import cherrypy
import arcpy

class StartPage:

def index(self):
 # This is the starting web page for the HOA selection application
 return '''
 <a href="http://TheServerName:8080/get_database" target="_parent">database pull</a>
 <a href="http://TheServerName:8080/get_text" target="_parent">text pull</a>'''
index.exposed = True

def get_database(self):
 info = data_extract()
 return info
get_database.exposed = True

def get_text(self):
 return """Great! this worked<a href="http://TheServerName:8080/" target="_parent">back</a>


"""
get_text.exposed = True

def data_extract():
Notification_Table = "C:/web.dbf"
rows = arcpy.SearchCursor(Notification_Table)
row = rows.next()
return_string = ""
while row:
 name = row.getValue("NAME")
 return_string = return_string + 'name: %s\n' % name
 row = rows.next()
return return_string

import os.path
hoaconf = os.path.join(os.path.dirname(__file__), 'hoa.conf')

if __name__ == '__main__':
 cherrypy.quickstart(StartPage(), config=hoaconf)
else:
 cherrypy.tree.mount(StartPage(), config=hoaconf)
##

Re: Geoprocessing with CherryPy web framework

JasonScheirer — Mon, 09 Jul 2012 23:07:42 GMT

Make sure the server you're using (whether it's the built-in CherryPy one or whatever standard WSGI server you're using) isn't threaded.

Re: Geoprocessing with CherryPy web framework

nickmassaro — Tue, 10 Jul 2012 19:17:58 GMT

Thanks Jason. Is there a WSGI server you would recommend?

Re: Geoprocessing with CherryPy web framework

nickmassaro — Tue, 10 Jul 2012 19:21:49 GMT

From - http://forums.arcgis.com/threads/34814-Exposing-Arcpy-Python-Script-to-Web

>>
There's WSGI, which is an open standard that allows you to develop in Django, or Pyramid, or web.py, or flask, or any of a number of other options. Flask or web.py are probably your best bet for porting from CGI.

If you run a web application that handles multiple requests in the same process (that is, running a Python WSGI server behind your IIS instance) then you don't incur the overhead of importing arcpy over and over.
>>

Re: Geoprocessing with CherryPy web framework

JasonScheirer — Tue, 10 Jul 2012 20:21:07 GMT

Unfortunately, I'm not super knowledgeable about the state of Python HTTP on Windows. However, you may find luck with gevent's WSGI server (example) as it uses greenlets in an event loop instead of threaded workers.

Re: Geoprocessing with CherryPy web framework

nickmassaro — Fri, 13 Jul 2012 20:16:03 GMT

I ended up driving the screw in with a hammer.
CGI and python.