def red(): #红点 if request.method == 'POST' or request.method == 'GET': conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) userID = a["userID"] zzz = [] sql1 = """SELECT * FROM `enquire` where sign = 0 and userID = "%s" """ % ( userID) cur.execute(sql1) results1 = cur.fetchall() # 提交 aa = {} for row in results1: aa[row[0]] = row[3] print(aa) bb = [] for i in aa: if aa[i] != "暂时无解答": print(i) bb.append(i) print(bb) if bb: data = {'enquireID': bb, "newAnswer": "true"} else: data = {'enquireID': bb, "newAnswer": "false"} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data else: return None
def delRed(): #去掉红点 if request.method == 'POST': conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) enquireID = a["enquireID"].split(',') print(enquireID) for i in enquireID: print(i) sql1 = """UPDATE enquire SET `sign` = 1 where enquireID = %s""" % i try: cur.execute(sql1) # 提交 conn.commit() except Exception as e: # 错误回滚 conn.rollback() return ('修改失败') data = {'judge': '1'} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data else: return None
def delRed(): #红点 if request.method == 'POST' or request.method == 'GET': conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) problemID = a["problemID"] zzz = [] sql1 = """UPDATE answer SET `bed` = `bed` + 1 where problemID = %s""" % problemID cur.execute(sql1) results1 = cur.fetchall() # 提交 aa = {} for row in results1: aa[row[0]] = row[3] print(aa) bb = [] for i in aa: if aa[i] != "暂时无解答": print(i) bb.append(i) print(bb) if bb: data = {'problemID': bb, "newAnswer": "true"} else: data = {'problemID': bb, "newAnswer": "false"} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data else: return None
def problem(): #查找问题详细信息 if request.method == 'POST': conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) print(a) problem = a["problem"] zzz = [] sql1 = """SELECT * FROM `answer` WHERE trueProblem = "%s" """ % ( problem) cur.execute(sql1) results1 = cur.fetchall() # 提交 for row in results1: date = { "problemID": str(row[0]), "trueProblem": row[1], "answer": row[2], "good": str(row[4]), "bad": str(row[4]) } zzz.append(date) data = {'data': zzz, "judge": "1"} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data else: return None
def information(): #查询个人信息 if request.method == 'POST' or request.method == 'GET': conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) openid = a["openid"] sql1 = """SELECT * FROM `user` where userID = "%s" """ % (openid) cur.execute(sql1) results1 = cur.fetchall() data1 = 0 print("==========") print(results1) print("==========") for row in results1: data1 = { "openid": str(row[0]), "username": row[1], "portrait": row[6], "sex": row[4], "grade": row[3] } data = {"data": data1, "judge": "1"} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data else: return None
def useful(): #查找对我有用 if request.method == 'POST': conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) page = a["page"] userID = a["userID"] zzz = [] sql1 = """SELECT trueProblem,answer FROM useful,answer WHERE useful.userID = "%s" and useful.problemID = answer.problemID limit %s,10""" % (userID, page) cur.execute(sql1) results1 = cur.fetchall() # 提交 for row in results1: date = {"trueProble": row[0], "answer": row[1]} zzz.append(date) data = {'data': zzz, "judge": "1"} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data else: return None
def login(): conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') dict1 = json.loads(a) telephone = dict1['telephone'] password = dict1['password'] sql1 = "select * from user WHERE telephone = '%s' " % (telephone) cur.execute(sql1) results1 = cur.fetchall() if results1: sql1 = "select * from user WHERE telephone = '%s'and password = '******' " % ( telephone, password) cur.execute(sql1) results1 = cur.fetchall() cur.close() conn.close() if results1: return ('1') else: return ('0') else: cur.close() conn.close() return ('2')
def select_organize(): conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) print(a) organize = a["organize"] zzz = [] sql1 = """SELECT * FROM student WHERE organize = %s """ % (organize) sql2 = """SELECT count(*) FROM student WHERE organize = %s """ % (organize) cur.execute(sql1) results1 = cur.fetchall() cur.execute(sql2) results2 = cur.fetchall() # 提交 for row in results1: date = { "ID": str(row[0]), "SName": row[1], "Grade": row[2], "Telephone": str(row[4]) } zzz.append(date) data = {'data': zzz, 'total': results2[0][0]} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data
def register(): conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) username = a["username"] password = a["password"] telephone = a["telephone"] portrait = a["portrait"] sql1 = """insert into user (username,password,telephone,portrait) values('%s','%s','%s','%s') """ % (username, password, telephone, 1) try: cur.execute(sql1) # 提交 conn.commit() except Exception as e: # 错误回滚 conn.rollback() return ('电话号码已经注册') finally: cur.close() conn.close() return ('注册成功')
def concreteClass(): #查找分类问题 if request.method == 'POST': conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) page = a["page"] categoryID = a["category"] classification = a["classification"] zzz = [] sql1 = """SELECT trueProblem FROM `answer` WHERE category = "%s" and classification = "%s" limit %s,10""" % ( categoryID, classification, page) cur.execute(sql1) results1 = cur.fetchall() # 提交 for row in results1: date = {"problem": row[0]} zzz.append(date) data = {'data': zzz, "judge": "1"} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data else: return None
def barrage(): #弹幕 if request.method == 'POST' or request.method == 'GET': conn = get_connection() cur = conn.cursor() zzz = [] sql1 = """SELECT * FROM `answer` ORDER BY RAND() LIMIT 20 """ cur.execute(sql1) results1 = cur.fetchall() # 提交 resultList = random.sample(range(0, 80), 20) # 表示从[A,B]间随机生成N个数,结果以列表返回 i = 0 problem = {} for row in results1: date = { "problemID": str(row[0]), "trueProblem": row[1], "duration": random.randint(0, 10), "top": resultList[i], "color": randomcolor() } i = i + 1 zzz.append(date) data = {'data': zzz, "judge": "1"} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data else: return None
def userProblem(): #查找我的提问 if request.method == 'POST': conn = get_connection() cur = conn.cursor() a = request.get_data() print(".......") print(a) print(".......") a = str(a, 'utf-8') a = json.loads(a) userID = a["userID"] page = a["page"] zzz = [] sql1 = """SELECT * FROM enquire WHERE userID = "%s" limit %s,10""" % ( userID, page) cur.execute(sql1) results1 = cur.fetchall() # 提交 for row in results1: date = { "enquireID": row[0], "userProblem": row[2], "userAnswer": row[3] } zzz.append(date) data = {'data': zzz, "judge": "1"} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data else: return None
def enquire():#提问 if request.method == 'POST': conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) userID = a["userID"] userProblem = a["userProblem"] userAnswer = "暂时无解答" print(userProblem) sql1 = """insert into enquire (userID,userProblem,userAnswer,sign) values('%s','%s','%s',"%s") """ % (userID, userProblem,userAnswer,0) print() print(sql1) print() try: cur.execute(sql1) # 提交 conn.commit() except Exception as e: # 错误回滚 conn.rollback() return ('修改失败') data = {'judge': '1'} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data else: return None
def information(): #插入个人信息 if request.method == 'POST' or request.method == 'GET': conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) openid = a["openid"] username = a["username"] portrait = a["portrait"] sex = a["sex"] grade = a["grade"] print("update:%s" % a) if sex == "2" or sex == 2: sex = "女" elif sex == "1" or sex == 1: sex = "男" elif sex == "0" or sex == 0: sex = "未知" zzz = [] sql1 = """UPDATE `user` SET `username` = "%s",portrait="%s",sex="%s",grade="%s" where userID = "%s" """ \ % (username,portrait,sex,grade,openid) print("sql1 = %s" % sql1) cur.execute(sql1) # 提交 conn.commit() try: cur.execute(sql1) # 提交 conn.commit() except Exception as e: # 错误回滚 conn.rollback() return ('修改失败') data = { "openid": openid, "username": username, "portrait": portrait, "sex": sex, "grade": grade, "judge": "1" } data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data else: return None
def information(): #插入个人信息 if request.method == 'POST'or request.method == 'GET': conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) print("--------------------------") print(a) print("--------------------------") openid = a["openid"] username = a["username"] portrait = a["portrait"] sex = a["sex"] grade = a["grade"] if sex=="2" or sex==2: sex = "女" elif sex=="1" or sex==1: sex = "男" elif sex=="0"or sex==0: sex = "未知" zzz=[] sql1 = """insert into `user` (userID,username,grade,sex,portrait) values('%s','%s','%s','%s','%s') """ % (openid, username, grade,sex,portrait) print(sql1) # cur.execute(sql1) # # 提交 # conn.commit() try: cur.execute(sql1) # 提交 conn.commit() except Exception as e: # 错误回滚 conn.rollback() return ('已经保存过这个人的信息,修改请访问update/information 接口') data = {"openid": openid,"username": username,"portrait": portrait,"sex": sex,"grade": grade,"judge": "1"} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data else: return None
def add_input(): conn = get_connection() cur = conn.cursor() if request.method == 'GET': return render_template('login.html') SName = request.form.get('SName') # 项目id Grade = request.form.get('Grade') # 项目id Organize = request.form.get('Organize') # 项目id Telephone = request.form.get('Telephone') # 项目id QQ = request.form.get('QQ') # 项目id WeChat = request.form.get('WeChat') # 项目id Mailbox = request.form.get('Mailbox') # 项目id Other = request.form.get('Other') # 项目id EntryName = request.form.get('EntryName') # 项目id Winning = request.form.get('Winning') # 项目id Code = request.form.get('Code') # 项目id Occupation = request.form.get('Occupation') # 项目id WorkAddress = request.form.get('WorkAddress') # 项目id Direction = request.form.get('Direction') # 项目id if (SName == '' or Grade == '' or Organize == ''): return render_template('error1.html') sql1 = """insert into student (SName,Grade,Organize,Telephone,QQ,WeChat,Mailbox,Other,EntryName,Winning,Code,Occupation,WorkAddress,Direction) values('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s') """ \ % (SName,Grade,Organize,Telephone,QQ,WeChat,Mailbox,Other,EntryName,Winning,Code,Occupation,WorkAddress,Direction) cur.execute(sql1) # 提交 conn.commit() try: cur.execute(sql1) # 提交 conn.commit() except Exception as e: # 错误回滚 conn.rollback() return render_template('error2.html') finally: cur.close() conn.close() return render_template('login1.html')
def classification(): # 查找3个类别 if request.method == 'POST' or request.method == 'GET': conn = get_connection() cur = conn.cursor() zzz = [] sql1 = """SELECT * FROM classbbb """ cur.execute(sql1) results1 = cur.fetchall() # 提交 for row in results1: date = {"ID": row[0], "classification": row[1]} zzz.append(date) data = {'data': zzz, "judge": "1"} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data else: return None
def good(): #有用,并且添加 if request.method == 'POST': conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) userID = a["userID"] judge = a["judge"] problemID = a["problemID"] sql3 = """SELECT good,bed FROM `answer` WHERE problemID = "%s" """ % ( problemID) if judge == "1" or judge == 1: sql1 = """UPDATE answer SET `good` = `good` + 1 where problemID = %s""" % problemID sql2 = """insert into useful (userID,problemID) values('%s','%s') """ % ( userID, problemID) elif judge == "0" or judge == 0: sql1 = """UPDATE answer SET `good` = `good` - 1 where problemID = %s""" % problemID sql2 = """delete from useful where userID = '%s'and problemID = '%s'""" % ( userID, problemID) try: cur.execute(sql1) cur.execute(sql2) # 提交 conn.commit() cur.execute(sql3) results1 = cur.fetchall() except Exception as e: # 错误回滚 conn.rollback() return ('修改失败') zzz = [] for row in results1: date = {"good": str(row[0]), "bad": str(row[1]), "judge": "1"} zzz.append(date) # data = {'data': zzz,"judge": "1"} data = json.dumps(date, ensure_ascii=False) cur.close() conn.close() return data else: return None
def select_name(): conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) print(a) SName = a["SName"] zzz = [] sql1 = """SELECT * FROM student WHERE SName = %s """ % (SName) sql2 = """SELECT count(*) FROM student WHERE SName = %s """ % (SName) cur.execute(sql1) results1 = cur.fetchall() cur.execute(sql2) results2 = cur.fetchall() # 提交 for row in results1: date = { "ID": str(row[0]), "SName": row[1], "Grade": row[2], "Organize": str(row[3]), "Telephone": str(row[4]), "QQ": str(row[5]), "WeChat": str(row[6]), "Mailbox": str(row[7]), "Other": str(row[8]), "EntryName": str(row[9]), "Winning": str(row[10]), "Code": str(row[11]), "Occupation": str(row[12]), "WorkAddress": str(row[13]), "Direction": str(row[14]) } zzz.append(date) data = {'data': zzz, 'total': results2[0][0]} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data
def bed(): #无用 if request.method == 'POST': conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) problemID = a["problemID"] judge = a["judge"] print(judge) sql3 = """SELECT good,bed FROM `answer` WHERE problemID = "%s" """ % ( problemID) if judge == "1" or judge == 1: sql1 = """UPDATE answer SET `bed` = `bed` + 1 where problemID = %s""" % problemID elif judge == "0" or judge == 0: sql1 = """UPDATE answer SET `bed` = `bed` - 1 where problemID = %s""" % problemID try: cur.execute(sql1) # 提交 conn.commit() cur.execute(sql3) results1 = cur.fetchall() except Exception as e: # 错误回滚 conn.rollback() return ('修改失败') zzz = [] for row in results1: date = {"good": str(row[0]), "bad": str(row[1]), "judge": "1"} zzz.append(date) # data = {'data': zzz,"judge": "1"} data = json.dumps(date, ensure_ascii=False) cur.close() conn.close() return data else: return None
from MySQL import get_connection from flask import jsonify, make_response #训练 from gensim import corpora, models, similarities import jieba import xlrd from MySQL import get_connection from flask import request from flask import render_template, redirect, request, url_for, jsonify, send_from_directory, abort, send_file from flask import Flask, make_response import pymysql, json, os import time import time conn = get_connection() cur = conn.cursor() sql1 = """SELECT problem,trueProblem FROM problem """ cur.execute(sql1) results1 = cur.fetchall() # print(results1) rows1 = [] aa = [] for i in results1: rows1.append(i[0]) aa.append(i[1]) # print(rows1) # print(aa) d = dict(zip(rows1, aa))
def login_(): if request.method == 'POST' or request.method == 'GET': conn = get_connection() cur = conn.cursor() a = request.get_data() a = str(a, 'utf-8') a = json.loads(a) # print(a) code = a["code"] appid = a["appid"] secret = a["secret"] # https://api.weixin.qq.com/sns/jscode2session?appid=你的appid&secret=你的secret&grant_type=authorization_code&js_code=登录code url = "https://api.weixin.qq.com/sns/jscode2session" \ "?appid=%s&secret=%s&grant_type=authorization_code&js_code=%s"%(appid,secret,code) def WWWrequest(): content = requests.get(url) # print(content.text) c = content.text # c = str(content, 'utf-8') c = json.loads(c) return c c = WWWrequest() try: while 1: errcode = c["errcode"] errmsg = c["errmsg"] if errcode == "-1": c = WWWrequest() else: break if errcode == 40013 or errcode == 40163: # print(errmsg) data = {'errmsg1': errmsg, "errmsg": "code无效", "judge": "0"} data = json.dumps(data, ensure_ascii=False) return data except KeyError: pass if 1: # openid和sessionid session_key = c["session_key"] openid = c["openid"] # unionid = c["unionid"] sql1 = """insert into `user` (userID) values('%s') """ % (openid) try: cur.execute(sql1) # 提交 conn.commit() except Exception as e: # 错误回滚 conn.rollback() aaaa = '已经注册' sql1 = """UPDATE `user` SET `session_key` = '%s' where userID = '%s'""" % ( session_key, openid) print("sql1=%s" % sql1) try: cur.execute(sql1) # 提交 conn.commit() except Exception as e: # 错误回滚 conn.rollback() return ('修改失败') zzz = [] data = {'openid': openid, "session_key": session_key, "judge": "1"} data = json.dumps(data, ensure_ascii=False) cur.close() conn.close() return data else: return None