1 files changed, 75 insertions, 0 deletions

diff --git a/cgi-bin/page_builder.py b/cgi-bin/page_builder.py
new file mode 100644
index 0000000..096fda8
--- /dev/null
+++ b/cgi-bin/page_builder.py
@@ -0,0 +1,75 @@
+#!C:\Python364\python3.exe
+# -*- coding: utf-8 -*-
+import sys, codecs
+import cgi, cgitb
+import pymysql
+import issuedb
+import config 
+from issuedb import IssueDBFactory
+from config import Config
+
+sys.stdout = codecs.getwriter('utf8')(sys.stdout.buffer)
+
+class Page_Builder(object):
+    def build(pagen): 
+        db = IssueDBFactory.produce()
+        cursor = db.cursor() 
+
+        tag_unit_html_file = open("tag_unit.html", 'r', encoding='utf8')
+        page_html_file = open("page.html", 'r', encoding= 'utf8')
+        issue_unit_html_file = open("issue_unit.html", 'r', encoding = 'utf8')
+        page_html = page_html_file.read()
+        issue_unit_html = issue_unit_html_file.read()
+        tag_unit_html = tag_unit_html_file.read() 
+
+        issue_unit_html_file.close() 
+        page_html_file.close()
+        tag_unit_html_file.close()
+
+        issues_list = ""
+        issues_count = Config.get("config", "issues_count")
+        issues_count = int(issues_count)
+        if pagen == None:
+            pagen = 0 
+        pageprev = int(pagen) - 1 
+        if pageprev < 0: 
+            pageprev = 0 
+        pagenext = int(pagen) + 1 
+        try:
+            cursor.execute("select * from issue ORDER BY issueId DESC LIMIT {0}, {1}".format(pagen*issues_count, issues_count)) 
+            issues_rows = cursor.fetchall()
+            odd = True
+            for row in issues_rows:
+                tagslist = "" 
+                cursor.execute("select * from tag where tagId in (select tagId from \
+                        relation where issueId = {0})".format(row[0]))
+                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 = '' 
+                    )
+                    tagslist += tag
+                issue = issue_unit_html.format(\
+                    issueid = row[0], \
+                    title = row[1], \
+                    description = row[2], \
+                    tags = tagslist, \
+                    oddoreven = ((odd == True) and "odd" or "even")
+                )
+                odd = not odd
+                issues_list += issue
+        except: 
+            print("Error: unable to fetch data") 
+
+        page = page_html.format(\
+            issues = issues_list, \
+            page_prev = pageprev, \
+            page_next = pagenext,\
+        )
+        db.commit() 
+        cursor.close() 
+        db.close()
+        return page
+