def generate_header(conn):
tag_type_list = Sql.get_all_tag_types(conn)
tag_value_list_dict = {}
for tt in tag_type_list:
tag_value_list_dict[tt] = Sql.get_all_tag_values_by_type(conn, tt)
return Web.include_javascript_header(tag_type_list, tag_value_list_dict)
def get_all_tags():
conn = Sql.initialize_db()
taglist = Sql.get_all_tags_with_item_count(conn)
return "<p>View any <a href='/tags/orphans'>orphaned tags</a>.</p>" + Web.full_tag_list_table(
taglist)
def get_orphan_tags():
conn = Sql.initialize_db()
html = ""
if request.method == "POST":
delete_tag_id = request.forms.get("tag-id")
delete_tag = Sql.get_tag_data(conn, int(delete_tag_id))
delete_result = Sql.delete_tag(conn, int(delete_tag_id))
if delete_result:
html += "<p>Deleted tag <b>{} - {}</b> (ID {}).</p>\n".format(
delete_tag[0], delete_tag[1], delete_tag_id)
orphan_tags = Sql.get_orphan_tags(conn)
if len(orphan_tags) > 0:
html += "<p>Orphaned tags:</p>\n"
html += "<p><table border=0>\n"
for tag in orphan_tags:
html += "<tr><form method=post><td>{}</td><td>{}</td>" \
"<td><input type=submit value=Delete></td>" \
"<input type=hidden name=tag-id value='{}'></form></tr>".format(tag[0], tag[1], tag[2])
html += "</table></p>"
else:
html += "<p>There are no orphaned tags in the database.</p>"
html += "Go back to the <a href='/tags'>list of tags</a>."
return html
def get_all_items():
conn = Sql.initialize_db()
item_ids = Sql.get_all_item_ids(conn)
item_summaries = Sql.get_item_summaries(conn, item_ids)
return Web.item_summary_table(
item_summaries
) + "<br><a href='/add_item'>Add an item</a> to the database."
def get_items_by_tag(tag_id):
conn = Sql.initialize_db()
tag_data = Sql.get_tag_data(conn, tag_id)
item_ids = Sql.get_items_by_tag_id(conn, int(tag_id))
item_summaries = Sql.get_item_summaries(conn, item_ids)
html = "<p>Showing items with tag <b>{} - {}</b>.</p>".format(*tag_data)
html += "<p><a href='/tags/{}/manage'>Manage</a> this tag.</p>".format(
tag_id)
return html + Web.item_summary_table(
item_summaries
) + "<p>Go back to the <a href='/tags'>list of tags</a>.</p>"
def add_item():
conn = Sql.initialize_db()
if request.method == 'GET':
return generate_header(
conn
) + "<body onload='createNewTagFieldSet()'>" + Web.add_item_form(
) + "</body>"
if request.method == 'POST':
tags = extract_tags_from_request(request)
new_row_id = Sql.create_new_item_with_tags(conn, tags)
html = "<p><a href='/items/{}'>New item created</a> with {} tags.</p>".format(
new_row_id, len(tags))
html += "<p><a href='/add_item'>Add another item.</a></p>"
return html
def manage_tag(tag_id):
conn = Sql.initialize_db()
html = ""
current_tag = Sql.get_tag_data(conn, tag_id)
if request.method == "GET":
html += "<p>Replace tag {} - {}:</p>".format(current_tag[0],
current_tag[1])
html += Web.replace_tag_form()
if request.method == "POST":
new_tag = request.forms.get("tag-type"), request.forms.get("tag-value")
new_tag_id = Sql.get_tag_id(conn, new_tag[0], new_tag[1])
html += "<p>Replacing tag <b>{} - {}</b> (ID {})<br>".format(
current_tag[0], current_tag[1], int(tag_id))
html += "with <b>{} - {}</b> (ID {})...</p>".format(
new_tag[0], new_tag[1], int(new_tag_id))
tags_replaced = Sql.replace_tag(conn, new_tag_id, tag_id)
html += "<p>Replaced {} tags.</p>".format(tags_replaced)
html += "<p>Go back to the <a href='/tags'>list of tags</a>.</p>"
return html
def get_item(item_id=None):
conn = Sql.initialize_db()
if request.method == "POST":
if 'add_note' in request.forms:
note_text = request.forms.get('note_text')
Sql.add_note_to_item(conn, int(item_id), note_text)
else:
add_tags = extract_tags_from_request(request)
Sql.add_taglist_to_item(conn, int(item_id), add_tags)
taglist = Sql.get_tags_by_item_id(conn, int(item_id))
notelist = Sql.get_notes_by_item_id(conn, int(item_id))
return generate_header(conn) + "<body onload='createNewTagFieldSet()'>" + Web.notes_display(notelist) + \
Web.add_note_form() + Web.item_tag_list_table(taglist) + Web.add_tags_form() + "</body>"
def get_tags_by_type(tag_type):
conn = Sql.initialize_db()
taglist = Sql.get_tags_by_type_with_count(conn, tag_type)
return Web.full_tag_list_table(taglist)