def question_add():
app.config['TOKEN'] = call_console.query_integral(int(current_user.id))[0]
if request.method == 'POST':
cur = mysql.connection.cursor()
cur.execute('''SELECT * FROM question WHERE question_id=%s ''',
(request.form['question_id'], ))
rv = cur.fetchall()
if rv:
return render_template("question_add.html", e=1)
else:
cur.execute(
'''INSERT INTO question (question_id,student_id, question_intro, token, status, question_info) VALUES (%s, %s, %s, %s, %s,%s)''',
(request.form['question_id'], current_user.id,
request.form['question_intro'], request.form['token'], 0,
request.form['question_info']))
mysql.connection.commit()
call_console.release_reward(int(current_user.id),
int(request.form['token']),
'/question_list')
temp = call_console.query_integral(int(current_user.id))
print(temp)
app.config['TOKEN'] = temp[0]
return render_template("question_add.html", e=0)
return render_template("question_add.html", e=-1)
def likes(cid):
tid = request.args.get('tid')
sid = request.args.get('sid')
print(sid, cid, tid)
call_console.like_course(int(sid), int(cid), int(tid))
# 给cid课程号点赞
app.config['TOKEN'] = call_console.query_integral(int(current_user.id))[0]
return (redirect(url_for('course_info', cid=cid)))
def login():
if request.method == 'POST':
id = request.form['user_id']
password = request.form['password']
cur = mysql.connection.cursor()
cur.execute('''SELECT * FROM user_list WHERE user_id=%s ''', (id, ))
user_seen = cur.fetchall()
if not user_seen:
return "用户ID输入错误"
if password != user_seen[0]["password"]:
return "密码输入错误"
name = user_seen[0]["user_name"]
type = user_seen[0]["user_type"]
session['name'] = name
session['type'] = type
user = User(id, name, type)
login_user(user, remember='remember_me' in request.form)
#### 定义 jinja2 全局变量 ####
# 交易变量
trans = [{
'token_change': +3.00,
'time': '2019年8月1日 19:32:11',
'own': '某个用户',
'info': '我帮他带饭了，他给我转了3积分'
}, {
'token_change': -2.00,
'time': '2019年8月1日 19:32:11',
'own': '某个用户',
'info': '我把他捶了一顿，赔偿他2积分'
}, {
'token_change': +1.50,
'time': '2019年8月1日 19:32:11',
'own': '某个用户',
'info': '卖屁股，赚了1.5积分'
}, {
'token_change': -4.50,
'time': '2019年8月1日 19:32:11',
'own': '某个用户',
'info': '练习时长两年半'
}]
if len(trans) <= 4:
app.config['TRANS'] = trans
else:
app.config['TRANS'] = trans[0:4]
app.config['TOKEN'] = call_console.query_integral(int(
current_user.id))[0]
#### 停止定义 ####
return redirect(url_for("index"))
else:
return render_template('login.html')
def question_list():
app.config['TOKEN'] = call_console.query_integral(int(current_user.id))[0]
cur = mysql.connection.cursor()
cur.execute('''SELECT * FROM question''')
rv = cur.fetchall()
for r in rv:
cur = mysql.connection.cursor()
cur.execute('''SELECT user_name FROM user_list WHERE user_id=%s''',
(r['student_id'], ))
rvv = cur.fetchall()
if rvv:
r['student_name'] = rvv[0]['user_name']
else:
r['student_name'] = 'NULL'
return render_template('question_list.html', question_list=rv)
def question_info():
app.config['TOKEN'] = call_console.query_integral(int(current_user.id))[0]
e = int(request.args.get('e'))
qid = request.args.get('id')
f = request.args.get('f')
cur = mysql.connection.cursor()
cur.execute('''SELECT * FROM question WHERE question_id=%s ''', (qid, ))
rv = cur.fetchall()
if rv:
cur = mysql.connection.cursor()
cur.execute('''SELECT user_name FROM user_list WHERE user_id=%s''',
(rv[0]['student_id'], ))
rvv = cur.fetchall()
if rvv:
rv[0]['student_name'] = rvv[0]['user_name']
else:
rv[0]['student_name'] = 'NULL'
cur = mysql.connection.cursor()
cur.execute('''SELECT * FROM answer_list WHERE question_id=%s''', (qid, ))
mv = cur.fetchall()
if mv:
for m in mv:
cur = mysql.connection.cursor()
cur.execute(
'''SELECT user_name,user_type FROM user_list WHERE user_id=%s''',
(m['answer_id'], ))
mvv = cur.fetchall()
if rvv:
m['answer_type'] = mvv[0]['user_type']
m['answer_name'] = mvv[0]['user_name']
else:
m['answer_type'] = 'NULL'
m['answer_name'] = 'NULL'
if request.method == 'POST':
cur = mysql.connection.cursor()
cur.execute(
'''INSERT INTO answer_list (question_id, answer_id, answer_info) VALUES (%s, %s, %s) ''',
(qid, current_user.id, request.form['answer_info']))
mysql.connection.commit()
return redirect(url_for('question_info', id=qid, e=e, f=1))
return render_template('question_info.html',
question=rv[0],
e=e,
mv=mv,
f=f)