From 7ca80e57f06922e464626c7a6a1d7965e716b53f Mon Sep 17 00:00:00 2001 From: chai Date: Fri, 13 Jul 2018 21:53:49 +0800 Subject: update --- edit.py | 46 ++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 46 insertions(+) create mode 100644 edit.py (limited to 'edit.py') diff --git a/edit.py b/edit.py new file mode 100644 index 0000000..5e85faa --- /dev/null +++ b/edit.py @@ -0,0 +1,46 @@ +#!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 config +from config import Config +import path +from path import Path + +sys.stdout = codecs.getwriter('utf8')(sys.stdout.buffer) +print("Content-type:text/html\n") +form = cgi.FieldStorage() +w = form.getvalue('w') +if w == None: + print("Invalid whisper") +else: + db = Connect.produce() + cursor = db.cursor() + + query_whisper = "select * from whisper where id={0}".format(w) + cursor.execute(query_whisper) + whisper = cursor.fetchone() + + edit_file = open(Path.template("edit.html"), 'r', encoding="utf8") + edit_templ = edit_file.read() + edit_file.close() + + _url = Config.get("route", "url") + _static = Config.get("route", "static") + + edit_html = edit_templ.format( \ + url = _url, + static = _static, + whisper_id = w, + whisper_content = whisper[1] + ) + + print(edit_html) + + db.commit() + cursor.close() + db.close() -- cgit v1.1-26-g67d0