#!/usr/local/bin/python3.3 import cgi import os import cgitb import pymysql cgitb.enable() #unsure of purpose fname = cookie["fname"].value lname = cookie["lname"].value name = " ".join((fname, lname)) admin = cookie["admin"].value uid = cookie["uid"].value uname = cookie["uname"].value form = cgi.FieldStorage() geneFile = form.getvalue("file") def runQuery(name, location, description,command): connection = pymysql.connect(host="bioed.bu.edu", user="d4prdb17", db="group9", passwd="d4prp455") cursor = connection.cursor() query1 = """INSERT INTO BEDfile (name, location, description, upload_date, bedtoolcommand) VALUES ("%s", "%s", "%s", now(), "%s");"""%(name, location, description,command) cursor.execute(query1) connection.commit() cursor.close() connection.close() print("Content-type: text/html\n") if geneFile == None: print(""" DASR

Manage

BEDTools

Upload


""") print("""

Upload Data To A New Experiment

Description:
BEDtools command:

Project: (set up new project)

Studies: (set up new Study) """) print("""

Experiments: (set up new experiment) """) print("""



""") else: fileitem = form['file'] description = form.getvalue("description") command = form.getvalue("command") eid = form.getvalue("exp") if fileitem.filename: fn = os.path.basename(fileitem.filename.replace("\\", "/" )) open('/www/html/students_17/Group9/bedfiles/' + fn, 'wb').write(fileitem.file.read()) message = 'The file "' + fn + '" was successfully uploaded' location = '/students_17/Group9/bedfiles/' + fn runQuery(fn.split('.')[0], location, description,command) q2 = """ select bid from BEDfile where name="%s" order by upload_date DESC limit 1; """ % fn.split('.')[0] bid = RunQuery(q2, "exampleUsername", "BF768") runQuery2(bid[0][0],eid) else: message = 'No file was uploaded' print("""\ upload file

%s,%s



""" % (message,bid[0][0]))