def serve_not_forever():
"""
this server keeps serving until stop_server() is called
"""
ip= read_conf.read_config('ip')
port= (int) (read_conf.read_config('port'))
server = BaseHTTPServer.HTTPServer
handler = CGIHTTPServer.CGIHTTPRequestHandler
server_address = (ip, port) # stay empty for localhost ip
handler.cgi_directories = ["/cgi-bin"]
httpd = server(server_address, handler)
while keep_serving:
httpd.handle_request()
from read_conf import read_config
import packs
from IPython import embed
blank_dict, info_dict = read_config()
blank_file = open("Fake/{}.java".format(info_dict["CLASS"]), "w")
blank_file.write(packs.l1 % (info_dict["CLASS"]))
blank_file.write(
packs.l2 %
(info_dict["RETURN"], info_dict["FUNC_NAME"], info_dict["INPUT"]))
blank_file.write(" " + blank_dict[info_dict["RETURN"]] + '\n')
blank_file.write(packs.end)
blank_file.close()
# Create instance of FieldStorage
form = cgi.FieldStorage()
# Get data from fields
print form.getvalue('inputCount')
vars = []
while True:
var = 'var' + str(len(vars) + 1)
if None == form.getvalue(var, default=None):
break
vars.append(var)
# Open and update the excel file
excel_file = read_conf.read_config('excel_file')
wb = load_workbook(excel_file)
ws = wb.get_active_sheet()
# Add the new row
for row in ws.rows:
if row[0].value is None:
count = 0
for key in vars:
value = form.getvalue(key, default=None)
row[count].value = value
count += 1
break
# Seve the updated file
wb.save(excel_file)
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
File Name: pdb
Author: wyb
Date: 2018/9/24 0024
Description: 连接postgresql数据库
"""
import psycopg2
import configparser
import read_conf
cf = configparser.ConfigParser()
cf.read("../application.conf",encoding='utf-8')
rt = read_conf.read_config(cf)
dbhost = rt['host']
port = rt['port']
dbname = rt['dbname']
user=rt['user']
pwd = rt['pwd']
conn = psycopg2.connect(database=dbname, user=user, password=pwd, host=dbhost, port=port)
def open(dbname):
global conn
conn = psycopg2.connect(database=dbname, user=user, password=pwd, host=dbhost, port=port)
def execute(sql,args, **kwargs):
cur = conn.cursor()
cur.execute(sql,args)
conn.commit()
# Create instance of FieldStorage
form = cgi.FieldStorage()
# Get data from fields
print form.getvalue('inputCount')
vars= []
while True:
var= 'var' + str(len(vars) + 1)
if None == form.getvalue(var, default=None):
break;
vars.append(var)
# Open and update the excel file
excel_file= read_conf.read_config('excel_file')
wb= load_workbook(excel_file)
ws=wb.get_active_sheet()
# Add the new row
for row in ws.rows:
if row[0].value is None:
count= 0
for key in vars:
value= form.getvalue(key, default=None)
row[count].value=value
count+= 1
break
# Seve the updated file
wb.save(excel_file)
