[sqlalchemy] Strange occasional ProgrammingError: Cannot operate on a closed database

2011-04-21 Thread Roy H. Han
Lately, I've been getting the following error quite randomly while developing a web app using sqlite3. I'm not sure how to fix it and it hasn't to me before, but it is leading to occasional failed AJAX requests. ProgrammingError: (ProgrammingError) Cannot operate on a closed database. None [{}]

[sqlalchemy] Re: How do we retrieve the database dialect that a specific session is using?

2010-04-24 Thread Roy H. Han
On Apr 24, 10:00 am, Roy Hyunjin Han starsareblueandfara...@gmail.com wrote: Is there any way to retrieve the database dialect that a specific session is using?  e.g. MySQL, PostGIS, etc. I am trying to modify Sanjiv Singh's GeoAlchemy extension so that a person can retrieve the appropriate

[sqlalchemy] Re: connectionless queries with Spatial data (PostGIS)

2009-03-16 Thread Roy H. Han
On Feb 20, 6:52 pm, Michael Bayer mike...@zzzcomputing.com wrote: Also I've built an ORM extension forpostgiswhich is incomplete but   demonstrates how to round trip and createPostGISexpressions in a   clean way, thats in the distribution in examples/postgis/postgis.py . Thanks for this