deptpg.py

python web programming 部分

#
# $Workfile: DeptPg.py $ $Revision: 5 $
# $Date: 10/07/01 1:39p $ $Author: Sholden $
#
import Dept

from cachequery import CacheQuery
from dbsource import dbsource
from Error import Error

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


qPlnk = CacheQuery("PageText",
                    ("PtxLinkText", "PtxSetNum", "PtxLink"),
                    ("PgpSetName", ),
                    conn, refresh=30)
qPttl = CacheQuery("PageText",
                    ("PtxTitle", "PtxContent"),
                    ("PgpSetName", "PtxSetNum"),
                    conn, ORDER=("PtxSetNum", ), refresh=30)

class Page(Dept.Page):

    def Body(self):

        if len(self.path) >= 2:
            self.PgpSetName = self.path[0]
            self.PtxSetNum = self.path[1]
            self.path = self.path[2:]
            linkdata = qPlnk((self.PgpSetName, ))
            pttl = qPttl((self.PgpSetName, self.PtxSetNum))
            if not pttl:
                raise Error(404, "Not Found", errmsg="No such page group page")
            self.pttl = pttl[0]
            result = [self.DeptHeader(), '<font size="-2"><center>']
            links = []
            for PtxLinkText, PtxSetNum, PtxLink in linkdata:
                if not PtxLink:
                    PtxLink = "DeptPgPage"
                if str(PtxSetNum) != self.PtxSetNum:
                    links.append('<A HREF="/%s/%s/%s/%s">%s</A>' % (PtxLink, self.DptCode, self.PgpSetName, PtxSetNum, PtxLinkText))
                else:
                    links.append(PtxLinkText)
            result.append(" | ".join(links)) # XXX need sensible multiline behavior here
            result.append('</center></font>')
            result.append("<BR><HR>%s" % (self.pttl.PtxContent))
            return "\n".join(result)
        else:
            raise Error(400, "Bad request", errmsg="Need a page group and group number")