#!/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

def main(msg):
    tmpl = TemplateManager().prepare("index.tmpl")
    tproc = TemplateProcessor()
    tproc.set("msg", msg)

#    tproc.set("syntax", user.syntax)
#    for syntax in Tester.syntax_name:
#        tproc.set("syntax_" + syntax,
#                  (Tester.syntax_name[user.syntax] == syntax))
#    tproc.set("id", user.id)
#    tproc.set("gender", user.gender);
#    tproc.set("age", user.age);
#    exp = []
#    for key in Tester.keys:
#        exp.append({ 'name' : key,
#                     'value' : user.experience[key] });
#    tproc.set('Exp', exp);
    print tproc.process(tmpl)

if (__name__ == "__main__"):
    form = cgi.FieldStorage()
    cnx = my_db.connect()
    qry = cnx.query('SELECT name FROM keywords;')
    main(str(qry.getresult()))