def question():
if request.method == 'GET':
question_id = request.args.get('id', -1, type=int)
if question_id == -1:
return render_template('question.html', id=question_id)
else:
question = Question.query.filter(
Question.id == question_id).first()
return render_template('question.html',
id=question_id,
question=question)
else:
name = request.form.get('todo')
if name == 'add':
title = request.form.get('title')
content = request.form.get('content')
question = Question(title=title, content=content)
question.author = g.user
db.session.add(question)
db.session.commit()
return redirect(url_for('index'))
elif name == 'update':
question_id = request.form.get('question_id')
print question_id
question = Question.query.filter(
Question.id == question_id).first()
question.title = request.form.get('title')
question.content = request.form.get('content')
db.session.commit()
return redirect(url_for('index'))
def question():
print('question page')
if request.method == 'GET':
return render_template('question.html')
else:
submitted_question = Question()
submitted_question.title = request.form.get('title')
submitted_question.content = request.form.get('content')
submitted_question.create_time = datetime.now()
submitted_question.author_id = session.get('user_id')
db.session.add(submitted_question)
db.session.commit()
return redirect(url_for('index'))
def write(request):
user = request.session.get('username')
if request.method == "POST":
title = request.POST['title']
content = request.POST['content']
if title and content:
question_new = Question()
question_new.title = title
question_new.content = content
question_new.save()
return JsonResponse({'message': '提交问题成功', 'status': 200})
else:
return JsonResponse({'message': '格式错误', 'status': 500})
return render_to_response('question-write.html', {'username': user})
def question():
if request.method == 'GET':
return render_template('question.html')
else:
title = request.form.get('title')
content = request.form.get('content')
question = Question(title=title, content=content)
# 从数据库读取用户数据，确认是那个作者在发布问题
question.author = g.user
question.content = content
db.session.add(question)
db.session.commit()
#完成后返回首页
return redirect(url_for('index'))
def fetchQuestions(self, start, count):
query = (
"SELECT id, owner_id, content, c_time FROM questions ORDER BY c_time DESC LIMIT %s OFFSET %s;"
)
cursor = self.db.cursor()
ret = []
cursor.execute(query, (int(count), int(start)))
for (id, owner_id, content, c_time) in cursor:
question = Question()
question.id = id
question.owner_id = owner_id
question.content = content
question.create_time = c_time
ret.append(question)
cursor.close()
return ret
def db_insert_q():
if 'user_id' and 'user_email' not in session:
return redirect('/')
form = QuestionForm()
if form.validate_on_submit():
question = Question()
question.q_user_id = session['user_id']
question.subject = form.data.get('subject')
question.topic = form.data.get('topic')
question.content = form.data.get('content')
dbb.session.add(question)
dbb.session.commit()
return render_template('qeustion_success.html',
name=session['user_email'])
return render_template('question_make.html',
form=form,
user_email=session['user_email'])
