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 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)