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
