diff options
Diffstat (limited to 'cgi-bin/issue_builder.py')
| -rw-r--r-- | cgi-bin/issue_builder.py | 53 |
1 files changed, 53 insertions, 0 deletions
diff --git a/cgi-bin/issue_builder.py b/cgi-bin/issue_builder.py new file mode 100644 index 0000000..caeb83b --- /dev/null +++ b/cgi-bin/issue_builder.py @@ -0,0 +1,53 @@ +#!C:\Python364\python3.exe +# -*- coding: utf-8 -*- +import sys, codecs +import cgi, cgitb +import pymysql +import issuedb +from issuedb import IssueDBFactory +sys.stdout = codecs.getwriter('utf8')(sys.stdout.buffer) + +class Issue_Builder(object): + def build(issueId): + db = IssueDBFactory.produce() + cursor = db.cursor() + + tag_unit_html_file = open("tag_unit.html", 'r', encoding='utf8') + issue_html_file = open("issue.html", 'r', encoding='utf8') + issue_html = issue_html_file.read() + tag_unit_html = tag_unit_html_file.read() + + issue = "" + + try: + cursor.execute("select * from issue where issueId={0}".format(issueId)) + issue_content = cursor.fetchall() + issue_content = issue_content[0] + + if issue_content != None: + taglist = "" + cursor.execute("SELECT * FROM tag WHERE tagId IN (SELECT tagId FROM relation WHERE issueId = {0})".format(issueId)) + tags_rows = cursor.fetchall() + for tag_row in tags_rows: + tag = tag_unit_html.format(\ + tagid = tag_row[0], \ + tag_name = tag_row[1],\ + tag_count = '' \ + ) + taglist += tag + issue = issue_html.format( \ + issueId = issue_content[0], \ + issueTitle = issue_content[1],\ + issueDescription = issue_content[2],\ + issueSolve = issue_content[3],\ + tags = taglist\ + ) + + cursor.close() + db.close() + return issue + except: + cursor.close() + db.close() + return ("Error: unable to fetch issue data \n" + e.message) + |