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

q3 = """
select wmid, name from WetlabMethod
"""
WetMethod = db.runQuery(q3)

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