summaryrefslogtreecommitdiff
path: root/cgi-bin/page.py
diff options
context:
space:
mode:
Diffstat (limited to 'cgi-bin/page.py')
-rw-r--r--cgi-bin/page.py59
1 files changed, 55 insertions, 4 deletions
diff --git a/cgi-bin/page.py b/cgi-bin/page.py
index 4b03bd4..2200390 100644
--- a/cgi-bin/page.py
+++ b/cgi-bin/page.py
@@ -1,11 +1,62 @@
-#!D:/Programs/Python/Python36/python.exe
+#!D:/Programs/Python3/python.exe
# -*- coding: utf-8 -*-
import cgi, cgitb
import pymysql
import sys, codecs
import configparser, codecs
+import connect
+from connect import Connect
+import whisper
+from whisper import Whisper
+import config
+from config import Config
+import path
+from path import Path
-class PageBuilder(object):
- def build(pagen):
-
+sys.stdout = codecs.getwriter('utf8')(sys.stdout.buffer)
+_url = Config.get("route", "url")
+_static = Config.get("route", "static")
+
+page_file = open(Path.template("page.html"), 'r', encoding="utf8")
+page_templ = page_file.read()
+page_file.close()
+
+pagen = cgi.FieldStorage().getvalue('p')
+if pagen == None:
+ pagen = 0
+pageprev = int(pagen) - 1
+if pageprev < 0:
+ pageprev = 0
+pagenext = int(pagen) + 1
+
+# class PageBuilder(object):
+# def build(pagen):
+print("Content-type:text/html\n")
+
+db = Connect.produce()
+cursor = db.cursor()
+
+query_allwhisper = "select * from whisper"
+cursor.execute(query_allwhisper)
+
+_whispers=""
+whispersdata = cursor.fetchall()
+odd = True
+for whisper in whispersdata:
+ _whispers += Whisper.build(whisper[0], whisper[1], odd)
+ odd = not odd
+
+page = page_templ.format(\
+ url = _url,
+ static = _static,
+ whispers = _whispers,
+ page_prev = pageprev,
+ page_next = pagenext
+)
+
+print(page)
+
+db.commit()
+cursor.close()
+db.close()