#!/usr/bin/python

import sys
import traceback
sys.path.insert(0, "/home/fabien/lib/python")
sys.path.insert(0, "./lib")
sys.stderr = sys.stdout

print "Content-type: text/html; charset=iso-8859-1;"
print

# import cgitb; cgitb.enable()
import cgi
from htmltmpl import TemplateManager, TemplateProcessor
import my_db
import time

def main(keyword, id, keywords):
    tmpl = TemplateManager().prepare("edit_kw.tmpl")
    tproc = TemplateProcessor()
    tproc.set('keyword', keyword)
    tproc.set('id', id)
    tproc.set('Keywords', keywords)
    print tproc.process(tmpl)

if (__name__ == "__main__"):
    form = cgi.FieldStorage()
    id = int(form["id"].value)
    db = my_db.connect()
    name = db.get_keyword(id)
    kw = db.get_all_keywords()[1:]
    kw.sort(lambda l,r: cmp(l[1],r[1]))
    kw = map(lambda elem: {
   	 'id' : elem[0],
	 'keyword' : elem[1] }, kw)
    main(name, id, kw)