def post(self):
result = {}
user_list = []
user_infos = mrd.select_table(table="baoxiu",
column="*",
condition="1",
value="1")
for user_info in user_infos:
oneInofo = {}
oneInofo['id'] = user_info[0]
oneInofo['fangjian_id'] = user_info[1]
oneInofo['shui'] = user_info[2]
oneInofo['dian'] = user_info[3]
oneInofo['meiqi'] = user_info[4]
oneInofo['mensuo'] = user_info[5]
oneInofo['deng'] = user_info[6]
oneInofo['xiashui'] = user_info[7]
oneInofo['dire'] = user_info[8]
fangjian_info = mrd.select_table(table="fangjian",
column="name,loudong_id",
condition="id",
value=str(
oneInofo['fangjian_id']))[0]
oneInofo['fangjian_name'] = fangjian_info[0]
oneInofo['loudong_name'] = mrd.select_table(
table="loudong",
column="name",
condition="id",
value=str(fangjian_info[1]))[0][0]
user_list.append(oneInofo)
result.setdefault('code', 200)
result.setdefault('data', user_list)
self.write(result)
def post(self):
user = self.get_argument("username")
pid = self.get_argument("pid")
lang = self.get_argument("language")
code = self.get_argument("code")
try:
int(pid)
except:
self.write("-1")
return
p = mrd.select_table(table="problems",
column="id",
other="where `index` = '" + pid + "'")
if not p:
self.write("-1")
return
cur.execute(
"insert into submissions(username,pid,lang,result,length)values('%s',%s,%s,'等待评测',%d)"
% (user, p[0][0], lang, len(code)))
last = mrd.select_table(
table="submissions",
column="id",
other="where username = '******' and pid = " + str(p[0][0]) +
" and lang = " + lang + " and length = " + str(len(code)) +
" order by id desc limit 1")
conn.commit()
self.write(str(last[0][0]))
f = open("./submissions/" + str(last[0][0]) + "." + suffix[int(lang)],
"w")
f.write(code)
f.close()
cur.execute("insert into judge_queue(rid)values(%d)" % last[0][0])
conn.commit()
def post(self):
result = {}
user_list = []
user_infos = mrd.select_table(table="yijian",
column="*",
condition="1",
value="1")
for user_info in user_infos:
oneInofo = {}
oneInofo['id'] = user_info[0]
oneInofo['fangjian_id'] = user_info[1]
oneInofo['yijian'] = user_info[2]
fangjian_info = mrd.select_table(table="fangjian",
column="name,loudong_id",
condition="id",
value=str(
oneInofo['fangjian_id']))[0]
oneInofo['fangjian_name'] = fangjian_info[0]
oneInofo['loudong_name'] = mrd.select_table(
table="loudong",
column="name",
condition="id",
value=str(fangjian_info[1]))[0][0]
user_list.append(oneInofo)
result.setdefault('code', 200)
result.setdefault('data', user_list)
self.write(result)
def get(self):
user = get_user(self)
problems = mrd.select_table(table="problems",
column="id,`index`,name,sub,ac",
other="order by `index`")
temp = []
if not user:
temp = [p + (-1, ) for p in problems]
else:
for p in problems:
t = -1
r = mrd.select_table(table="submissions",
column="result",
other="where username = '******'")
for i in r:
if not i[0] in not_judged:
t = 0
break
if t == 0:
for i in r:
if i[0] == ac:
t = 1
break
temp.append(p + (t, ))
self.render("problems.html", user=user, problems=temp)
def get(self, rid):
user = get_user(self)
try:
res = mrd.select_table(
table="submissions",
column=
"id,username,pid,lang,length,submittime,testcase,result,time,memory",
other="where id = " + str(int(rid)))
p = mrd.select_table(table="problems",
column="id,name",
other="where id = " + str(res[0][2]))
if not res:
self.render("404.html", user=user)
else:
f = open("./submissions/" + rid + "." + suffix[int(res[0][3])])
code = f.read()
f.close()
self.render("submission.html",
user=user,
res=res[0],
p=p[0],
code=code,
languages=languages,
lan=lan_short[res[0][3]])
except Exception, e:
self.render("404.html", user=user)
def post(self):
page = int(self.get_argument('page'))
ps = mrd.select_table(table="problems",
column="`index`,name",
other="order by `index`")
p = {}
for i in ps:
p[i[0]] = i[1]
sub = mrd.select_table(
table="submissions",
column=
"id,username,pid,lang,length,submittime,testcase,result,time,memory",
other="order by id desc")
if self.get_argument('username', ''):
username = self.get_argument('username')
sub = [i for i in sub if i[1] == username]
if self.get_argument('pid', ''):
try:
pid = ps[int(self.get_argument('pid'))]
sub = [i for i in sub if i[2] == pid]
except:
pass
if self.get_argument('language', '-1') != '-1':
lang = self.get_argument('language')
try:
lang = int(self.get_argument('language'))
sub = [i for i in sub if i[3] == lang]
except:
pass
if self.get_argument('result', '-1') != '-1':
try:
res = int(self.get_argument('result'))
if res == -2:
sub = [
i for i in sub
if (not i[7] in not_judged) and (i[7] != ac)
]
else:
res = results[res]
sub = [i for i in sub if i[7] == res]
except:
pass
sub = sub[page * 20:page * 20 + 20]
res = []
for i in range(len(sub)):
res.append(["%02d" % i])
res[-1].append(sub[i][0])
res[-1].append(sub[i][1])
res[-1].append(p[sub[i][2]])
res[-1].append(sub[i][7])
res[-1].append("--" if sub[i][8] == -1 else "%dms" % sub[8])
res[-1].append("--" if sub[i][9] == -1 else "%.2lfMB" %
(float(sub[9]) / 1024 / 1024))
res[-1].append(languages[sub[i][3]])
res[-1].append("%dB" % sub[i][4])
res[-1].append(sub[i][5].strftime("%Y-%m-%d %H:%M:%S"))
self.write(tornado.escape.json_encode(res))
def post(self):
result = {}
id = self.get_argument("id")
user_infos = mrd.select_table(table="louceng",
column="*",
condition="id",
value=id)
if user_infos:
user_infos = user_infos[0]
result.setdefault('code', 200)
oneInofo = {}
oneInofo['id'] = user_infos[0]
oneInofo['loudong_id'] = user_infos[1]
oneInofo['louceng_id'] = user_infos[2]
oneInofo['name'] = user_infos[3]
oneInofo['shui'] = user_infos[4]
oneInofo['dian'] = user_infos[5]
oneInofo['meiqi'] = user_infos[6]
oneInofo['mensuo'] = user_infos[7]
oneInofo['deng'] = user_infos[8]
oneInofo['xiashui'] = user_infos[9]
oneInofo['dire'] = user_infos[10]
oneInofo['user_name'] = user_infos[11]
oneInofo['phone_number'] = user_infos[12]
oneInofo['status'] = user_infos[14]
result.setdefault('data', oneInofo)
else:
result.setdefault('code', 404)
result.setdefault('data', "failure")
self.write(result)
def post(self):
username = self.get_argument("username", default=None)
password = self.get_argument("password", default=None)
repassword = self.get_argument("repassword", default=None)
email = self.get_argument("email", default=None)
user_infos = mrd.select_table(table="users",
column="*",
condition="username",
value=username)
return_data = {}
if username == "" or email == "" or password == "" or repassword == "":
return_data = {"info": "do_not_full!"}
self.write(return_data)
else:
if username in user_infos[0]:
if email != user_infos[0][3]:
return_data = {"info": "username_email_unfit!"}
self.write(return_data)
else:
if repassword != password:
return_data = {"info": "repassword_is_false!"}
self.write(return_data)
else:
return_data = {"info": "success!"}
mwd.updateinfo("users", username, password, email)
self.write(return_data)
else:
return_data = {"info": "username_not_exist!"}
self.write(return_data)
def post(self):
domain = self.get_argument("domain", default=None)
email = self.get_argument("email", default=None)
dbinfo = mrd.select_dics("users", "*")
usrs, pwds, emails = zip(
*map(lambda x: (x["username"], x["password"], x["email"]), dbinfo))
return_data = {}
if email == "":
return_data = {"info": "no_email_here!"}
self.write(return_data)
else:
if email in emails:
user_infos = mrd.select_table(table="users",
column="*",
condition="email",
value=email)
username = user_infos[0][1]
User_Info = {
"username": username,
"email": email,
"token": token
}
message = "<h1>找回密码</h1>点击下面的链接重置密码<a href=\"http://" + domain + ":8000/modify\">http://" + domain + ":8000/modify</a>"
if send_email(message, "密码找回", [username, email]):
return_data = {"info": "success_send_email"}
self.write(return_data)
else:
return_data = {"info": "no_email_exist"}
self.write(return_data)
def get(self):
# username = self.get_argument("user")
username = tornado.escape.json_decode(self.current_user)
use_infos = mrd.select_table(table="users", column="*", condition="username", value=username)
#this new use_info ((2, 'admin', 'admin'),) 元祖套着元祖模式
self.render("user.html",users = use_infos)
def post(self):
try:
result = {}
username = self.get_argument("username")
user_infos = mrd.select_table(table="admin",
column="*",
condition="username",
value=username)
if user_infos:
result.setdefault('code', 200)
result.setdefault('data', "该用户已存在")
return self.write(result)
password = self.get_argument("password")
key = "(username,password)"
value = f"('{username}',{password})"
user_infos = mrd.add_table(table="admin", key=key, value=value)
if user_infos:
result.setdefault('code', 404)
result.setdefault('data', "failure")
else:
result.setdefault('code', 200)
result.setdefault('data', "successful")
self.write(result)
except:
result.setdefault('code', 200)
result.setdefault('data', "该用户已存在")
self.write(result)
def post(self):
username = self.get_argument("username")
password = self.get_argument("password")
# 在post()方法中，使用get_argument()函数来接收前端传过来的数据，
# 这个函数的完整格式是get_argument(name, default=[], strip=True)，
# 它能够获取name的值。在上面的代码中，name就是从前端传到后端的那个json
# 对象的键的名字，是哪个键就获取该键的值。如果获取不到name的值，就返回
# default的值，但是这个值默认是没有的，如果真的没有就会抛出HTTP 400。
# 特别注意，在get的时候，通过get_argument()函数获得url的参数，
# 如果是多个参数，就获取最后一个的值。要想获取多个值，
# 可以使用get_arguments(name, strip=true)。
# 在设置setting的时候，写上debug = True就表示是调试模式了（参阅：用tornado做网站(1)）。
# 但是，调试模式也不是十全十美，如果修改模板，就不会加载，还需要重启服务
user_infos = mrd.select_table(table="users",
column="*",
condition="username",
value=username)
if user_infos:
db_pwd = user_infos[0][2]
if db_pwd == password:
self.set_current_user(username)
self.write(username)
else:
self.write("-1")
else:
self.write("-1")
def get(self):
username = self.get_argument('user')
user_infos = mrd.select_table(table='users',
column='*',
condition='username',
value=username)
self.render("user.html", users=user_infos)
def get(self):
username = tornado.escape.json_decode(self.current_user)
user_infos = mrd.select_table(table="users",
column="*",
condition="username",
value=username)
self.render("user.html", user=user_infos[0])
def post(self):
'''
头部注意添加#coding=utf-8 申明编码格式，不然中文会报错
self.get_argument()函数 接受客户端post过来的函数 按字段名取值，ps：也可以试试全取
'''
print 'get post username = '******'username', 'ServerDef')
print 'get post password = '******'password', 'ServerDef')
username = self.get_argument("username")
password = self.get_argument("password")
user_infos = mrd.select_table(table="users",
column="*",
condition="username",
value=username)
#self.write为回调函数，返回客户端数据，须为字典
response = {'message': 'Welcome ~'}
errorRes = {"message": 'F**k u.'}
if user_infos:
db_pwd = user_infos[0][2]
if db_pwd == password:
self.write(response)
else:
self.write(errorRes)
else:
self.write({'message': 'Come on, please regist'})
def get(self):
csvoutputfile = self.get_query_argument("csvoutputfile")
timestamp_format = self.get_query_argument("timestamp_format")
chosedlabel = self.get_query_argument("chosedlabel")
username = tornado.escape.json_decode(self.current_user)
user_infos = mrd.select_table(table="users",column="*",condition="username",value=username)
self.render("inputdatashow_timestamp_one.html", user = user_infos[0],timestamp_format=timestamp_format,csvoutputfile=csvoutputfile,chosedlabel=chosedlabel)
def get(self):
username = self.get_argument("user")
user_infos = mrd.select_table(table="users",
column="*",
condition="username",
value=username)
self.render("user.html", users=user_infos)
def get(self):
username = self.get_argument("user")
user_infos = mrd.select_table(table="userinfo",
column="*",
condition="username",
value=username),
print(self.get_secure_cookie(username))
self.render("user.html", user=user_infos)
def get(self):
#username = self.get_argument("user")
username = tornado.escape.json_decode(self.current_user)
user_infos = mrd.select_table(table="users",
column="*",
condition="username",
value=username)
self.render("attackshow_attacktype.html", user=user_infos[0])
def get(self):
#username = self.get_argument("user")
username = tornado.escape.json_decode(self.current_user)
print username
print type(username)
user_infos = mrd.select_table(table="users",column="*",condition="username",value=username)
print user_infos
self.render("user.html", users = user_infos)
def post(self):
username = self.get_argument("username")
password = self.get_argument("password")
user_infos = mrd.select_table(table="users",column="*",condition="username",value=username)
if user_infos:
db_pwd = user_infos[0][2]
if db_pwd == password:
self.write(username)
def get(self):
username = self.get_argument("user")
print("userName:{}".format(username))
user_infos = mrd.select_table(table="user",
column="*",
condition="username",
value=username)
print(user_infos)
self.render("user.html", users=user_infos)
def get(self):
# escape
#username = tornado.escape.json_decode(self.current_user)
#username = self.get_argument("user")
# users = username.split(' ')
# print users[2]
username = tornado.escape.json_decode(self.current_user)
user_infos = mrd.select_table(table="users",column="*",condition="username",value=username)
self.render("user.html", users = user_infos)
def get(self, pid):
user = get_user(self)
problem = mrd.select_table(table="problems",
column="id,name,tl,ml,sub,ac,`index`",
other="where id = " + pid)
if not problem:
self.render("404.html", user=user)
else:
self.render("p/" + pid + ".html", user=user, p=problem[0])
def get(self):
username = self.get_argument('user')
username2 = tornado.escape.json_decode(self.current_user)
if username2 == username:
user_infos = mrd.select_table(table="users",
column='*',
condition='username',
value=username)
self.render('user.html', users=user_infos)
else:
self.render('user.html', users=0)
def get(self):
#username = self.get_argument("user")
filename = self.get_query_argument("filename")
csvopenfilepath = "upload/"+filename
csvoutputfiled = "ips_quchong"
csvoutputpath = extract_two_labels_quchong(csvopenfilepath,csvoutputfiled,"Source IP","Destination IP")
jsonoutputpath = "static/ips_csv_json/"+filename+".json"
ips_csvtojson(csvoutputpath,jsonoutputpath,"suit")
username = tornado.escape.json_decode(self.current_user)
user_infos = mrd.select_table(table="users",column="*",condition="username",value=username)
self.render("inputdatashow_ips.html", user = user_infos[0],jsonoutputpath = jsonoutputpath)
def get(self):
filename = self.get_query_argument("filename")
csvopenfilepath = "upload/"+filename
with open(csvopenfilepath,"r") as csvfile:
firstline = csvfile.readline()
firstline = firstline.replace("\n","")
firstlabels = firstline.split(",")
username = tornado.escape.json_decode(self.current_user)
user_infos = mrd.select_table(table="users",column="*",condition="username",value=username)
self.render("inputdatashow_timestamp.html", user = user_infos[0],firstlabels = firstlabels,filename=filename)
def post(self):
username = self.get_argument("username")
password = self.get_argument("password")
user_infos = mrd.select_table(table="userinfo",
column="*",
condition="username",
value=username)
if user_infos:
self.write("用户名已存在，请修改用户名")
else:
mrd.insert_UserInfo(username, password)
self.write("注册成功")
def post(self):
username = self.get_argument("username")
password = self.get_argument("password")
user_infos = mrd.select_table(table="users",column="*",condition="username",value=username)
if user_infos:
db_pwd = user_infos[0][2]
if db_pwd == password:
self.write("welcome you: " + username)
else:
self.write("your password was not right.")
else:
self.write("There is no this user.")
def post(self):
username = self.get_argument("username")
password = self.get_argument("password")
user_infos = mrd.select_table(table="users",column="*",condition="username",value=username)
if user_infos:
db_pwd = user_infos[0][2]
if db_pwd == password:
self.write(username)
else:
self.write("your password was not right.")
else:
self.write("There is no thi user.")
def get(self):
# escape
#username = tornado.escape.json_decode(self.current_user)
#username = self.get_argument("user")
# users = username.split(' ')
# print users[2]
username = tornado.escape.json_decode(self.current_user)
user_infos = mrd.select_table(table="users",
column="*",
condition="username",
value=username)
self.render("user.html", users=user_infos)
def post(self):
username = self.get_argument('username')
password = self.get_argument('password')
user_infos = mrd.select_table('users', '*', 'username', username)
if user_infos:
db_pwd = user_infos[0][2]
if db_pwd == password:
self.write('Welcome' + username)
else:
self.write('password error')
else:
self.write('user not exists')
def post(self):
username = self.get_argument("username")
password = self.get_argument("password")
user_infos = mrd.select_table(table="users",column="*",condition="username",value=username)
if user_infos:
db_pwd = user_infos[0][2]
if db_pwd == password:
#self.set_secure_cookie('user', username)
self.set_current_user(username)
self.write(username)
else:
self.write("-1")
else:
self.write("-1")
def post(self):
username = self.get_argument('username')
password = self.get_argument('password')
# self.write({"usr": username, "pass": password})
user_infos = mrd.select_table(table="authors", column="*", condition="name", value=username)
if user_infos:
db_pwd = user_infos[0][3]
if db_pwd == password:
self.set_current_user(username)
self.write(username)
else:
self.write("-1")
else:
self.write("-1")
def post(self):
username = self.get_argument("username")
password = self.get_argument("password")
user_infos = mrd.select_table(table="users",column="*",condition="username",value=username)
if user_infos:
db_pwd = user_infos[0][2]
if db_pwd == password:
# self.write("welcome you: " + username)
# self.set_cookie(username,db_pwd) #设置cookie self.write(username)
# self.set_secure_cookie(username,db_pwd)
self.set_current_user(username) #将当前用户名写入cookie，方法见下面
self.write(username)
else:
# self.write("your password was not right.")
self.write("-1")
else:
# self.write("There is no this user.")
self.write("-1")
def post(self):
username = self.get_argument("username")
password = self.get_argument("password")
# 在post()方法中，使用get_argument()函数来接收前端传过来的数据，
# 这个函数的完整格式是get_argument(name, default=[], strip=True)，
# 它能够获取name的值。在上面的代码中，name就是从前端传到后端的那个json
# 对象的键的名字，是哪个键就获取该键的值。如果获取不到name的值，就返回
# default的值，但是这个值默认是没有的，如果真的没有就会抛出HTTP 400。
# 特别注意，在get的时候，通过get_argument()函数获得url的参数，
# 如果是多个参数，就获取最后一个的值。要想获取多个值，
# 可以使用get_arguments(name, strip=true)。
# 在设置setting的时候，写上debug = True就表示是调试模式了（参阅：用tornado做网站(1)）。
# 但是，调试模式也不是十全十美，如果修改模板，就不会加载，还需要重启服务
user_infos = mrd.select_table(table="users", column="*", condition="username", value=username)
if user_infos:
db_pwd = user_infos[0][2]
if db_pwd == password:
self.set_current_user(username)
self.write(username)
else:
self.write("-1")
else:
self.write("-1")
def get(self):
username = self.get_argument("user")
#username = "******"
user_infos = mrd.select_table(table="users",column="*",condition="username",value=username)
self.render("user.html", users = user_infos)
#self.render("user.html", users = " qiwsir")
def get(self):
username = self.get_argument("user")
print self.get_secure_cookie(username)
user_infos = mrd.select_table(table="users",column="*",condition="username",value=username)
self.render("user.html", users = user_infos)
