def clean_pre_data(running_id):
conn = connMysql()
cur = conn.cursor()
sql = "UPDATE `gr`.`main` SET `Et` = null where running_id= " + str(
running_id)
# print sql
cur.execute(sql)
conn.commit()
cur.close()
conn.close()
def mark_as_complete(running_id):
conn = connMysql()
cur = conn.cursor()
sql = "UPDATE `gr`.`main` SET `status` = 1 where running_id= " + str(
running_id)
# print sql
cur.execute(sql)
conn.commit()
cur.close()
conn.close()
def save_res_plot(res, running_id):
conn = connMysql()
cur = conn.cursor()
sql = "UPDATE `gr`.`main` SET `throughput` =\"" + res + "\" where running_id=\
" + str(running_id)
print(sql)
cur.execute(sql)
conn.commit()
cur.close()
conn.close()
def save_res(data, name, running_id):
conn = connMysql()
cur = conn.cursor()
sql = "UPDATE `gr`.`main` SET `" + name + "` = \"" + data + "\" where running_id= " + str(
running_id)
print(sql)
cur.execute(sql)
conn.commit()
cur.close
conn.close()
def get_job():
conn = connMysql()
cur = conn.cursor()
sql = "SELECT * FROM `main` WHERE `status`=0 LIMIT 0,30"
cur.execute(sql)
dataset = cur.fetchall()
cur.close()
conn.close()
return dataset
def save_Et(Et, running_id):
conn = connMysql()
cur = conn.cursor()
get_old_Et = "Select `Et` from `gr`.`main` where running_id = "+\
str(running_id)
cur.execute(get_old_Et)
pre_res = cur.fetchone()[0]
if pre_res:
new_data = pre_res + "," + str(Et)
else:
new_data = str(Et)
print(new_data)
sql = "UPDATE `gr`.`main` SET `Et` = \""+new_data+"\" where running_id="+\
str(running_id)
print(sql)
cur.execute(sql)
conn.commit()
cur.close()
conn.close()