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

import cgi
import cgitb
import pymysql
from functions import get_cookies
cgitb.enable()

cookie = get_cookies()
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")

data = []
#data should be in the order: user, passwd, host, db
with open('./dbinfo.txt') as f:
    for line in f:
        line = line.strip('\n')
        data.append(line)      
info = []
for item in data:
    item = item.split(':')
    info.append(item)

user=info[0][1]
passwd=info[1][1]
host=info[2][1]
db=info[3][1]

form = cgi.FieldStorage()


def runQuery(query, user, passwd):
    connection = pymysql.connect(host=host,db=db,user=user,passwd=passwd)
    cursor = connection.cursor()
    cursor.execute(query)
    res = cursor.fetchall()
    cursor.close()
    connection.close()
    return res

	
sid = form.getvalue('sid')

q1 = """
 select plid,plname from Platform join Study using(plid)  where sid=%s ;
""" %sid

studies = runQuery(q1, user, passwd)


for row in studies:
    print("<option value=%s>%s</option>" % (row[0], row[1]))