coursebynum.py

python web programming 部分

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

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


class Page(Courses.Page):

    def Body(self):
        crsnum = None
        if self.op == "POST":
            FD = self.getValidForm()
            crsnum = self.input["CrsNum"]
        elif self.path:
            crsnum = self.path[0]
        if not crsnum:
            raise Error(404, "Not Found", errmsg="No class number 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 Course.CrsNum=?
            AND Class.ClsPublic
            ORDER BY ClsDate"""
        cursor.execute(sql, (crsnum, ))
        r = cursor.fetchall()
        if not r:
            return "<H3>No %s classes are currently scheduled.</H3>" % crsnum
        else:
            return self.ListCourses(r, "Upcoming %s Classes" % crsnum)