#!/usr/local/bin/python3.3

import cgi
import cgitb
import pymysql
import DAPRfunctions as dapr

#dapr.loadConfiguration()

cookie = dapr.get_cookies()
db=dapr.DBConnection()

cgitb.enable()

if cookie:
    print(cookie)
    fname = cookie["fname"].value
    lname = cookie["lname"].value
    name = " ".join((fname, lname))
    admin = cookie["admin"].value
    uid = cookie["uid"].value
    uname = cookie["uname"].value

print("Content-type: text/html\n")

q2 = """
select cmid, name from ComputationalMethod
"""
ComMethod = db.runQuery(q2)

print("""<option value="0" >--please select a computational method--</option>""")
for row in ComMethod:
    print("<option value=%s>%s</option>" % (row[0], row[1]))