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