courseshow.py

python web programming 部分

#
# $Workfile: CourseShow.py $ $Revision: 3 $
# $Date: 10/07/01 1:37p $ $Author: Sholden $
#
import Courses
from Error import Error
from cachequery import CacheQuery
from dbsource import dbsource

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

qCrs = CacheQuery("Course", Courses.CrsNames, ("CrsNum", ),
                     conn, refresh=30)

class Page(Courses.Page):

    def Body(self):
        if not self.path:
            raise Error(404, "Not Found", errmsg="No course number")
        crsNum = self.path[0]
        c = qCrs(crsNum)[0]
        a = Courses.qIns(c.CrsAuthor)[0]
        return """
    <P>Course %d : %s : $%d [<A HREF="/CourseByNum/%s/">Schedule</A>]</P>
    <P>%s</P>
    <P><FONT SIZE="-2">This course, written by <A HREF="/Instructor/%d/">%s</a>, can
        accommodate a maximum of %d students.</P>""" % \
                (c.CrsNum, c.CrsTitle, c.CrsPrice, c.CrsNum, c.CrsDescription,
                        c.CrsAuthor, a.InsName, c.CrsPlaces)