1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
|
#!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
sys.stdout = codecs.getwriter('utf8')(sys.stdout.buffer)
_url = Config.get("route", "url")
_static = Config.get("route", "static")
_whiperperpage = int(Config.get("config", "whisper_count"))
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
else:
pagen = int(pagen)
pageprev = pagen - 1
if pageprev < 0:
pageprev = 0
pagenext = pagen + 1
# class PageBuilder(object):
# def build(pagen):
print("Content-type:text/html\n")
db = Connect.produce()
cursor = db.cursor()
query_count = "select COUNT(*) from whisper"
cursor.execute(query_count)
whispercount = cursor.fetchone()
whispercount = whispercount[0]
query_allwhisper = "select * from whisper ORDER BY id DESC LIMIT {0}, {1}".format(pagen * _whiperperpage, _whiperperpage)
cursor.execute(query_allwhisper)
_whispers = ""
whispersdata = cursor.fetchall()
odd = True
count = 0
for whisper in whispersdata:
count = count + 1
_whispers += Whisper.build(whisper[0], whisper[1], whisper[2], odd, _url)
odd = not odd
if pagen * _whiperperpage + count >= whispercount:
pagenext = pagen
page = page_templ.format(\
url = _url,
static = _static,
whispers = _whispers,
page_prev = pageprev,
page_next = pagenext
)
print(page)
db.commit()
cursor.close()
db.close()
|
