diff options
Diffstat (limited to 'cgi-bin/page.py')
-rw-r--r-- | cgi-bin/page.py | 59 |
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() |