On Jan 17, 2009, at 12:48 PM, Neha Gupta wrote:
Hey,
I only have little experience with web.py and psycopg2 and am running
into a weird problem, I'd appreciate any help I can get with debugging
it.
Hi Neha,
There's a lot of pieces involved here and your subject implies you've
isolated the problem to psycopg2, but I'm not convinced.
I know it is not the date picker that
causing trouble.
So don't confuse us by mentioning it. =)
class departures:
def buildDepartureTableHtml(self, date):
web.debug('date', date)
try:
web.debug("About to issue query")
query = "SELECT avg(dep_delay), extract(hour from
crs_dep_time) as
crs_dep_hour, origin from flightdata where date = '01-05-2007' group
by origin, crs_dep_hour order by origin, crs_dep_hour";
cur.execute(query)
web.debug('query executed!')
rows = cur.fetchall()
web.debug('rows fetched!')
web.debug(rows)
except Exception, e:
print repr(e)
database_conn.rollback()
return "<div id='welcome-text'>Invalid Date</div>"
You can see above that I even ignored the date passed from the form
and I have hardcoded '01-05-2007'.
That's a good first step. Simplify even further. What happens if you
simplify the query? FOr instance:
SELECT 1, 2 as crs_dep_hour, origin
from flightdata
where date = '01-05-2007'
If a simple query like that doesn't work, I suspect you have something
fundamental wrong with your setup.
HTH
Philip
--
http://mail.python.org/mailman/listinfo/python-list
