listing26-5.py
来自「《Beginning Python--From Novice to Profes」· Python 代码 · 共 54 行
PY
54 行
#!/usr/bin/pythonprint 'Content-type: text/html\n'import cgitb; cgitb.enable()import psycopgconn = psycopg.connect('dbname=foo user=bar')curs = conn.cursor()print """<html> <head> <title>The FooBar Bulletin Board</title> </head> <body> <h1>The FooBar Bulletin Board</h1> """curs.execute('SELECT * FROM messages')rows = curs.dictfetchall()toplevel = []children = {}for row in rows: parent_id = row['reply_to'] if parent_id is None: toplevel.append(row) else: children.setdefault(parent_id,[]).append(row)def format(row): print '<p><a href="view.cgi?id=%(id)i">%(subject)s</a></p>' % row try: kids = children[row['id']] except KeyError: pass else: print '<blockquote>' for kid in kids: format(kid) print '</blockquote>'print '<p>'for row in toplevel: format(row)print """ </p> <hr /> <p><a href="edit.cgi">Post message</a></p> </body></html>"""⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?