def view_for_edit_thread(uid: int, messages: Dict[str, str] = None):
thread = Thread.find_by_id(uid)
tags = Tag.find_all()
return render_template('edit_thread.html',
title="Edit thread",
thread=thread,
tags=tags,
messages=messages)
def find_by_id(uid: int) -> 'Account':
rows = db.execute_query(
"""
SELECT id, username, display_name, admin FROM Account WHERE id = %(id)s;
""", {'id': uid})
try:
row = rows.pop(0)
# Deferred in order to prevent circular imports.
from src.models.thread import Thread
threads = Thread.find_by_author_id(row['id'])
account = Account(row['id'], row['username'], row['display_name'],
row['admin'], threads)
return account
except:
return None
def find_by_id(uid: int) -> 'Tag':
rows = db.execute_query(
"""
SELECT *, (
SELECT COUNT(*) FROM ThreadTag
WHERE ThreadTag.tag_id = %(id)s
) AS count FROM Tag
WHERE id = %(id)s;
""", {'id': uid})
try:
row = rows.pop(0)
# Deferred in order to prevent circular imports.
from src.models.thread import Thread
threads = Thread.find_by_tag_id(row['id'])
tag = Tag(row['id'], row['title'], row['count'], threads)
return tag
except:
return None
def author_for_thread(uid: int):
return Thread.author_for_thread(uid)
def thread_exists(uid: int):
return Thread.find_by_id(uid) is not None
def delete(uid: int):
Thread.delete(uid)
def update(uid: int, title: str, tag_ids: List[int]):
result = Thread.update(uid, title, tag_ids)
return result
def create(user_id: int, title: str, content: str, tag_ids: List[int]):
result = Thread.create(user_id, title, content, tag_ids)
return result
def view_for_thread(uid: int, messages: Dict[str, str] = None):
thread = Thread.find_by_id(uid)
return render_template('thread.html',
title="Thread",
thread=thread,
messages=messages)
def view_for_threads():
threads = Thread.find_all()
return render_template('threads.html',
title="Threads",
threads=threads)