def load(request):
init.first()
codeList = []
# for filename in glob.glob(r'
path = os.path.dirname(os.path.abspath("store.sql"))
# codeList.append(path)
fileList = os.listdir(path)
for oneFile in fileList:
m = re.match("^\w+.sql$", oneFile)
if m != None:
codeList.append(oneFile)
strs = "r'" + path + "\\*.sql"
for fileName in glob.glob(strs):
codeList.append(filename)
loadvalue = "no"
if request.POST.has_key("codelist"):
sqlName = ""
sqlName = str(request.POST["codelist"])
fr = open(sqlName, "r")
code = fr.read()
fr.close()
fw = open("load.sql", "w")
fw.write(code)
fw.close()
loadvalue = "yes"
return render_to_response("loadpage.html", {"codelist": codeList, "loadvalue": loadvalue})
def show(request):
init.first()
try:
task = ''
res = ''
if request.POST.has_key('tasklist'):
task = str(request.POST['tasklist'])
fw = open('result_store.sql','w')
fw.write('use python;\n')
fw.write('select * from %s;\n' % task)
fw.close()
cmd = "mysql -h localhost -u root -pflanker < result_store.sql > result_store.res"
child = subprocess.Popen(cmd, shell = True)
child.wait()
fr = open('result_store.res','r')
res = fr.read()
fr.close()
ll = database.getlist('show tables')
return render_to_response('showpage.html', {'tasklist': ll,'cons': res})
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
ferr = open("error.txt","w")
ferr.write("Mysql Error %d: %s" % (e.args[0], e.args[1]))
ferr.close()
def index(request):
init.first()
if request.POST.has_key('taskname'):
taskname = str(request.POST['taskname'])
description = str(request.POST['taskdescription'])
content = str(request.POST['taskcode'])
fw = open("%s.sql" % taskname,"w")
fw.write(content)
fw.close()
#fw.write("mysql -h localhost -u root -pflanker < %s.sql\n" %(taskname))
#subprocess.Popen("chmod +x %s.sh" %(taskname), shell = True)
else:
taskname = ''
description = ''
content = ''
if taskname == '':
return render_to_response('addpage.html', {'taskname': taskname, 'taskdescription': description, 'sqlcode': content,'addstatus':'no'})
try:
database.execute('insert tasklist (name,file,status,description) values(\'%s\',\'%s.sql\',\'did not start\',\'%s\')' % (taskname, taskname, description))
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def index(request):
init.first()
try:
name = ''
ss = request.path
if name == '':
name = ss[21:]
res = database.getlist('select description from tasklist where name = \'%s\'' % (name))
description = res[0]
ferr = open("error_modify.log","w")
task = ''
if request.POST.has_key('taskname'):
task = str(request.POST['taskname'])
ferr.write(r'-----%s' %(task))
if task == name:
code = str(request.POST['taskcode'])
description = str(request.POST['taskdescription'])
isModify = 'yes'
fw = open("%s.sql" %(task),"w")
fw.write(code)
fw.close()
database.execute('update tasklist set name = \'%s\', file = \'%s.sql\', description = \'%s\' where name = \'%s\'' %(task, task, description, name))
database.execute('update edges set u = \'%s\' where u = \'%s\'' %(task, name))
database.execute('update edges set v = \'%s\' where v = \'%s\'' %(task, name))
else:
task = name
isModify = 'no'
fr = open("%s.sql" %(name),"r")
code = fr.read()
fr.close()
ferr.write(code)
ferr.close()
if request.POST.has_key('taskkind'):
taskkind = str(request.POST['taskkind'])
if taskkind == 'timed':
hour = str(request.POST['hour'])
minute = str(request.POST['minute'])
database.execute('update tasklist set type = \'%s-%s\' where name = \'%s\'' %(hour, minute, task))
else:
database.execute('update tasklist set type = NULL where name = \'%s\'' %task )
return render_to_response('modifypage.html', {'taskname': task,'modifystatus': isModify, 'taskdescription': description,'taskcode': code})
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
return render_to_response('modifypage.html')
def register(request):
init.first()
username = ''
password = ''
ans = 'checkvalue'
if request.POST.has_key('username'):
username = str(request.POST['username'])
password = str(request.POST['password'])
fw = open('re.txt', 'a')
fw.write("lol")
fw.write(username)
fw.write(password)
fw.close()
if(username != ''):
try:
conn=MySQLdb.connect(host='127.0.0.1',user='******',passwd='flanker',port=3306)
cur=conn.cursor()
cur.execute('create database if not exists python')
conn.select_db('python')
cur.execute('create table if not exists user(username varchar(20) primary key, password varchar(20))')
cur.execute('select username from user')
res = cur.fetchall()
fw = open('re.txt', 'w')
fw.write(username)
fw.write(password)
fw.write("lala")
ans = "yes"
for row in res:
fw.write(row[0])
fw.write(" ")
fw.write(ans)
if(row[0] == username):
ans = "no"
break
cmd = "INSERT INTO user(username, password) VALUES(\'" + username + "\', \'" + password + "\')"
if(ans == "yes"):
fw.write("execute")
cur.execute(cmd)
fw.write(ans)
fw.close()
conn.commit()
cur.close()
conn.close()
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def store(request):
init.first()
ans = "storevalue"
codename = str(request.POST.get('codename', ""))
if(codename != ""):
fr = open('store.sql', 'r')
texts = fr.read()
fw = open(codename, 'w')
fw.write(texts)
ans = "yes"
fr.close()
fw.close()
return render_to_response('storepage.html', {'storevalue': ans})
def index(request):
init.first();
tasklist = database.getlist('select name from tasklist')
u = database.getlist('select u from edges')
v = database.getlist('select v from edges')
edges = []
for i in range(0,len(u)):
edges.append(Edge(u[i], v[i]))
fw = open('debug_dag', 'w')
for j in edges:
fw.write(j.u)
fw.close()
return render_to_response('chart2.html', {'tasklist': tasklist,'edgelist': edges})
def check(request):
init.first()
ans = "checkvalue"
username = ""
password = ""
if request.POST.has_key("username"):
username = str(request.POST["username"])
password = str(request.POST["password"])
fw = open("lol.txt", "w")
fw.write(username)
fw.write(str(type(username)))
fw.close()
if username != "":
try:
conn = MySQLdb.connect(host="127.0.0.1", user="******", passwd="flanker", port=3306)
cur = conn.cursor()
cur.execute("create database if not exists python")
conn.select_db("python")
cur.execute("create table if not exists user(username varchar(20) primary key, password varchar(20))")
cmd = "select password FROM user where username = '******'"
# cur.execute('select * from user')
cur.execute(cmd)
res = cur.fetchall()
# fw = open('f.txt', 'w')
# fw.write(username)
# fw.write(password)
# is_exist = 0
for row in res:
# print(row[0], row[1])
# if((row[0] == username) and (row[1] == password)):
if row[0] == password:
ans = "yes"
break
# fw.close()
conn.commit()
cur.close()
conn.close()
except MySQLdb.Error, e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def index(request):
init.first()
u = ''
v = ''
if request.POST.has_key('pretask'):
u = str(request.POST['pretask'])
v = str(request.POST['subtask'])
else:
return render_to_response('prepage.html')
try:
database.execute('insert edges (u,v) values(\'%s\',\'%s\')' % (u,v))
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
fw = open('error.txt','w')
fw.write("Mysql Error %d: %s" % (e.args[0], e.args[1]))
fw.close()
def index(request):
init.first()
try:
conn=MySQLdb.connect(host='127.0.0.1',user='******',passwd='flanker',port=3306)
cur=conn.cursor()
cur.execute('create database if not exists python')
conn.select_db('python')
cur.execute('create table if not exists tasklist(name varchar(125) primary key,type int,file varchar(100),status varchar(25),description varchar(2550))')
name = ''
if request.POST.has_key('taskname'):
name = str(request.POST['taskname'])
ss = request.path
if name == '':
name = ss[19:]
cur.execute('select status from tasklist where name = \'%s\'' % (name))
res = cur.fetchall()
for i in res:
for j in i:
status = str(j)
cur.execute('select description from tasklist where name = \'%s\'' % (name))
res = cur.fetchall()
for i in res:
for j in i:
description = str(j)
fr = open("%s.sql" %(name),"r")
code = fr.read()
fr.close()
conn.commit()
cur.close()
conn.close()
return render_to_response('infopage.html', {'taskname': name,'taskstatus': status,'taskdescription': description,'taskcode': code})
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
def config(request):
init.first()
status = 'no'
if request.POST.has_key('sqladdress'):
address = str(request.POST['sqladdress'])
sql = str(request.POST['sqlsql'])
name = str(request.POST['sqlname'])
password = str(request.POST['sqlpassword'])
if address != '' and sql != '' and name != '' and password != '':
status = 'yes'
fw = open("config.txt", "w")
fw.write(address+'\n')
fw.write(sql+'\n')
fw.write(name+'\n')
fw.write(password+'\n')
fw.close()
return render_to_response('configpage.html',{'configvalue':status})
def work(request):
init.first()
code = ""
buttonvalue = ""
address = '127.0.0.1'
sqlname = 'python'
username = '******'
password = '******'
if(os.path.exists('config.txt')):
fr = open("config.txt")
list_of_all_the_lines = fr.readlines()
address = list_of_all_the_lines[0][0:-1]
sqlname = list_of_all_the_lines[1][0:-1]
username = list_of_all_the_lines[2][0:-1]
password = list_of_all_the_lines[3][0:-1]
fr.close()
if request.POST.has_key('hide'):
code = str(request.POST['hide'])
buttonvalue = str(request.POST['buttonvalue'])
if(os.path.exists('load.sql')):
fr = open('load.sql', 'r')
code = fr.read()
fr.close()
os.system("rm -f load.sql")
workvalue = 'workvalue'
if(code != ''):
fw = open('store.sql', 'w')
fw.write("use %s;\n" %(sqlname))
fw.write(timevar.timevar(code))
fw.close()
if(buttonvalue == "store"):
workvalue = 'yes'
result_store = ''
if(buttonvalue == "execute"):
#conn=MySQLdb.connect(host='127.0.0.1',user='******',passwd='flanker',port=3306)
#cur=conn.cursor()
#cur.execute('create database if not exists python')
#conn.select_db('python')
#cur.execute('create table if not exists user(username varchar(20) primary key, password varchar(20))')
#cmd = 'mysql -h localhost -u root -pflanker < .\store.sql'
#cur.execute(cmd)
#conn.commit()
#cur.close()
#conn.close()
cmd = "mysql -h localhost -u %s -p%s < store.sql > result_store.txt" %(username, password)
temp = cmd.split()
child = subprocess.Popen(cmd, shell = True)
child.wait()
if(os.path.exists('result_store.txt')):
fr = open('result_store.txt','r')
result_store = fr.read()
fr.close()
return render_to_response('workpage.html', {'workvalue' : workvalue, 'sqlname' : sqlname, 'code' : code, 'cons' : result_store})
def index(request):
init.first()
try:
buttonvalue = ''
task = ''
if request.POST.has_key('tasklist'):
buttonvalue = str(request.POST['buttonvalue'])
task = str(request.POST['tasklist'])
if(buttonvalue == "delete"):
database.execute('delete from tasklist where name = \'%s\'' % (task))
database.execute('delete from edges where u = \'%s\' or v = \'%s\'' % (task,task))
ss = str(request.path)
site = ""
if(buttonvalue == "modify"):
site = "modifypage/%s" % (task)
if(buttonvalue == "info"):
site = "infopage/%s" % (task)
if(buttonvalue == "presub"):
site = "/prepage"
if(buttonvalue == "start"):
database.execute('update tasklist set status = \'started\' where name = \'%s\'' %task)
init.checktask(task)
#fw = open('listerr.txt','a')
#fw.write(buttonvalue)
#fw.write('\n python scheduler.py %s %s.sql\n' %(task,task))
#fw.close()
if(buttonvalue == "execute"):
subprocess.Popen('python hw/scheduler.py %s %s.sql' %(task,task), shell = True)
if(buttonvalue == "terminate"):
res = database.getlist('select status from tasklist where name = \'%s\'' %task)[0]
if res == 'started':
database.execute('update tasklist set status = \'did not start\' where name = \'%s\'' %task)
elif res == 'running':
database.execute('update tasklist set status = \'failed\' where name = \'%s\'' %task)
fw = open("log.txt","w")
fw.write(site)
fw.close()
tasklist = database.getlist('select name from tasklist')
statuslist = database.getlist('select status from tasklist')
ll = []
for i in range(0,len(tasklist)):
ll.append(Task(tasklist[i],statuslist[i]))
return render_to_response('taskpage.html', {'tasklist': ll,'skipsite': site})
except MySQLdb.Error,e:
print "Mysql Error %d: %s" % (e.args[0], e.args[1])
ferr = open("error.txt","w")
ferr.write("Mysql Error %d: %s" % (e.args[0], e.args[1]))
ferr.close()
