#!/usr/bin/env python 
 
print "Content-type: text/html\n\n" 
 
import cgi, cgitb, sys, time 
cgitb.enable() 
sys.path.append("/home/toxic_elegant/python") 
from sqlalchemy import create_engine, MetaData, Table, Column, desc 
from sqlalchemy.orm import mapper, sessionmaker 
from sqlalchemy.types import Integer, Unicode, Date, Text 
from peter import engine, users, User, poems, Poem 
 
cookie_expiry = time.time() + 315360000 
print "Set-Cookie: betacookie=%s; expires=%s" % (4, cookie_expiry) 
 
f = "head.html" 
print open(f).read() 
 
form = cgi.FieldStorage() 
 
Session = sessionmaker(bind=engine) 
session = Session() 
 
mapper(Poem, poems) 
mapper(User, users) 
 
 
if "id" in form: 
     
    id = form.getfirst("id") 
     
    if id == "main": 
        print "MAIN." 
     
    elif id == "poetry": 
        print "<ul>" 
         
        for row in session.query(Poem).order_by(desc(Poem.id)): 
            user = session.query(User).filter(User.id==row.userid) 
            print """<li><a href="http://elegance.chanlu.org/beta/poem/%d">%s</a> (by %s)</li>""" % (row.id, row.title, user[0].user) 
         
        print "</ul>" 
 
f = "foot.html" 
print open(f).read() 

print "Header-name: value" 
print "Header-name: value" 
print "Last-header: value\n" 
 
print content 

cookie_expiry = time.time() + 315360000  
print "Set-Cookie: betacookie=%s; expires=%s" % (4, cookie_expiry)  
 
print "Content-type: text/html\n"