coursebycity.py

python web programming 部分

#
# $Workfile: CourseByCity.py $ $Revision: 3 $
# $Date: 10/07/01 1:35p $ $Author: Sholden $
#
import Courses
from dbsource import dbsource

conn = dbsource().conn
cursor = conn.cursor()

class Page(Courses.Page):

    def Body(self):
        FD = self.getValidForm()
        city = self.input["CityNum"]
        if not city:
            raise Error(404, "Not Found", errmsg="No city selected")
        sql = """       
        SELECT CtyName, LocName, ClsDate, CrsTitle, ClsNum, CrsPlaces, CrsPrice
        FROM City, Location, Course, Class
        WHERE City.CtyNum = Location.CtyNum
            AND Course.CrsNum = Class.CrsNum
            AND Location.LocNum = Class.LocNum
            AND City.CtyNum=?
            AND Class.ClsPublic
            ORDER BY ClsDate"""
        cursor.execute(sql, (city, ))
        r = cursor.fetchall()
        if not r:
            cursor.execute("SELECT CtyName FROM City WHERE CtyNum=?", (city, ))
            r = cursor.fetchall()
            return "<H3>No classes are currently scheduled for %s</H3>" % r[0][0]
        else:
            return self.ListCourses(r, "Upcoming %s Classes" % r[0][0])