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

import cgi
import cgitb
import pymysql
from functions import get_cookies
import subprocess
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")
    
    form = cgi.FieldStorage()
    
    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()
    bid = form.getvalue("bid")
    

    
    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
    
    q1 = """select location from BEDfile where bid = (%s);"""%(bid)
    
    bedname = runQuery(q1, user, passwd)
    
    def delbedfile(bedname):
        subprocess.call(['rm', '-f', bedname])
    
    
    def delBED(bid):
        connection = pymysql.connect(host=host, user=user, db=db, passwd=passwd)
        cursor = connection.cursor()
        query = """delete from BEDfile where bid = ("%s");""" %(bid)
        cursor.execute(query)
        connection.commit()
        cursor.close()
        connection.close()
        
    delBED(bid)
    delbedfile(bedname)