def render(topic_id, newReplyForm, editTopicForm=None):
if not editTopicForm:
editTopicForm = EditTopicForm(request.form)
if not newReplyForm:
newReplyForm = NewReplyForm(request.form)
cursor = g.db.cursor()
if topic_id == "NULL":
cursor.close()
g.db.commit()
return render_template('topicsnotfound.html')
query = 'SELECT group_id, title, content, poster_id, dateposted FROM Topic WHERE id = %s'
cursor.execute(query, [topic_id])
topic = cursor.fetchone()
if not topic:
cursor.close()
g.db.commit()
return render_template('topicsnotfound.html')
path = grouppath.getpath(topic[0], cursor)
query = 'SELECT name FROM RegUser WHERE id = %s'
cursor.execute(query, [topic[3]])
poster = cursor.fetchone()
query = 'SELECT Reply.content, Reply.dateposted, RegUser.name, Reply.id, RegUser.id, Reply.poster_id FROM Reply, RegUser WHERE Reply.deleted = false AND Reply.topic_id = %s AND (RegUser.id = Reply.poster_id OR Reply.poster_id IS NULL)'
cursor.execute(query, [topic_id])
replies = cursor.fetchall()
cursor.close()
g.db.commit()
return render_template('view.html', editTopicForm=editTopicForm, topic_id=topic_id, topic=topic, poster=poster, replies=replies, path=path, newReplyForm=newReplyForm)
def render(group_id, newTopicForm, newGroupForm):
cursor = g.db.cursor()
path = grouppath.getpath(group_id, cursor)
if (not path) and (not group_id == "NULL"):
cursor.close()
g.db.commit()
return render_template('topicsnotfound.html')
# get topics
if not group_id == "NULL":
query = 'SELECT id, title FROM Topic WHERE group_id = %s'
cursor.execute(query, [group_id])
else:
query = 'SELECT id, title FROM Topic WHERE group_id IS NULL'
cursor.execute(query)
topics = cursor.fetchall()
# get subgroups
if not group_id == "NULL":
query = 'SELECT id, name FROM TopicGroup WHERE parent_id = %s'
cursor.execute(query, [group_id])
else:
query = 'SELECT id, name FROM TopicGroup WHERE parent_id IS NULL'
cursor.execute(query)
groups = cursor.fetchall()
cursor.close()
g.db.commit()
if not newTopicForm:
newTopicForm = NewTopicForm(request.form)
if not newGroupForm:
newGroupForm = NewGroupForm(request.form)
return render_template('topics.html', topics=topics, groups=groups, group_id=group_id, path=path, newTopicForm=newTopicForm, newGroupForm=newGroupForm)
