#!/usr/bin/python print('Content-type: text/html\n') import cgitb; cgitb.enable() import psycopg2 conn = psycopg2.connect('user=foo password=bar dbname=baz') curs = conn.cursor() import cgi, sys form = cgi.FieldStorage() reply_to = form.getvalue('reply_to') print(""" Compose Message

Compose Message

""") subject = '' if reply_to is not None: print(''.format(reply_to)) curs.execute('SELECT subject FROM messages WHERE id = %s', (format(reply_to),)) subject = curs.fetchone()[0] if not subject.startswith('Re: '): subject = 'Re: ' + subject print(""" Subject:

Sender:

Message:

Back to the main page' """.format(subject))