def __init__(self):
self.my_conf = MyConfig()
self.conf_info = ConfigInfo()
self.my_conf.json_reader('configs')
for i in self.my_conf.content:
self.conf_info.set_config(i, self.my_conf.content[i][0],
self.my_conf.content[i][1])
self.folder = ""
self.overview = []
def __init__(self):
self.my_conf = MyConfig()
self.conf_info = ConfigInfo()
self.my_conf.json_reader('configs')
for i in self.my_conf.content:
self.conf_info.set_config(i, self.my_conf.content[i][0],
self.my_conf.content[i][1])
self.folder = ""
self.overview = []
class Controller:
def __init__(self):
self.my_conf = MyConfig()
self.conf_info = ConfigInfo()
self.my_conf.json_reader('configs')
for i in self.my_conf.content:
self.conf_info.set_config(i, self.my_conf.content[i][0],
self.my_conf.content[i][1])
self.folder = ""
self.overview = []
def get_conf_item(self, index):
return self.conf_info.items[index]
def get_conf_config(self, key):
return self.conf_info.get_config(key)[0]
def get_conf_value(self, key):
return self.conf_info.get_config(key)[1]
def set_conf_config(self, key, config, value=None):
self.conf_info.set_config(key, config, value)
def get_conf_exp(self, key):
return self.conf_info.get_exp(key)
def save_config(self):
self.my_conf.json_writer('configs', self.conf_info.config)
def set_files(self, path):
self.folder = path
def apply_file(self, filename):
parser = XMLParser2(filename)
items = self.conf_info.items
new_folder = os.path.dirname(filename) + '_processed/'
message = [os.path.basename(filename)]
for i in items:
config = self.get_conf_config(i)
xpaths = self.conf_info.get_path(i)
fill = True
if config == 1:
for j in xpaths:
old_value = parser.get_attr(j[0], j[1])
self.conf_info.set_original(i, old_value)
parser.del_attrs(j[0], j[1])
if fill:
message.append(old_value)
fill = False
elif config == 2:
for j in xpaths:
old_value = parser.get_attr(j[0], j[1])
self.conf_info.set_original(i, old_value)
new_value = self.conf_info.get_fuzzy(i)
parser.set_attrs(j[0], j[1], new_value)
if fill:
message.append(old_value)
message.append(new_value)
fill = False
self.overview.append(message)
parser.save(new_folder + os.path.basename(filename))
def run(self):
if len(self.folder) == 0:
return 1
if len(self.conf_info.config) == 0:
return 2
new_folder = self.folder + "_processed/"
if not os.path.isdir(new_folder):
os.mkdir(new_folder)
message = ['filename']
for i in self.conf_info.items:
config = self.get_conf_config(i)
if config == 1:
message.append(i)
elif config == 2:
message.append(i + '(old)')
message.append(i + '(new)')
self.overview.append(message)
file_list = os.listdir(self.folder)
for x in file_list:
self.apply_file(self.folder + '/' + x)
self.my_conf.csv_writer(new_folder + 'overview.csv', self.overview)
return 0
class Controller:
def __init__(self):
self.my_conf = MyConfig()
self.conf_info = ConfigInfo()
self.my_conf.json_reader('configs')
for i in self.my_conf.content:
self.conf_info.set_config(i, self.my_conf.content[i][0],
self.my_conf.content[i][1])
self.folder = ""
self.overview = []
def get_conf_item(self, index):
return self.conf_info.items[index]
def get_conf_config(self, key):
return self.conf_info.get_config(key)[0]
def get_conf_value(self, key):
return self.conf_info.get_config(key)[1]
def set_conf_config(self, key, config, value=None):
self.conf_info.set_config(key, config, value)
def get_conf_exp(self, key):
return self.conf_info.get_exp(key)
def save_config(self):
self.my_conf.json_writer('configs', self.conf_info.config)
def set_files(self, path):
self.folder = path
def apply_file(self, filename):
parser = XMLParser2(filename)
items = self.conf_info.items
new_folder = os.path.dirname(filename) + '_processed/'
message = [os.path.basename(filename)]
for i in items:
config = self.get_conf_config(i)
xpaths = self.conf_info.get_path(i)
fill = True
if config == 1:
for j in xpaths:
old_value = parser.get_attr(j[0], j[1])
self.conf_info.set_original(i, old_value)
parser.del_attrs(j[0], j[1])
if fill:
message.append(old_value)
fill = False
elif config == 2:
for j in xpaths:
old_value = parser.get_attr(j[0], j[1])
self.conf_info.set_original(i, old_value)
new_value = self.conf_info.get_fuzzy(i)
parser.set_attrs(j[0], j[1], new_value)
if fill:
message.append(old_value)
message.append(new_value)
fill = False
self.overview.append(message)
parser.save(new_folder + os.path.basename(filename))
def run(self):
if len(self.folder) == 0:
return 1
if len(self.conf_info.config) == 0:
return 2
new_folder = self.folder + "_processed/"
if not os.path.isdir(new_folder):
os.mkdir(new_folder)
message = ['filename']
for i in self.conf_info.items:
config = self.get_conf_config(i)
if config == 1:
message.append(i)
elif config == 2:
message.append(i+'(old)')
message.append(i+'(new)')
self.overview.append(message)
file_list = os.listdir(self.folder)
for x in file_list:
self.apply_file(self.folder + '/' + x)
self.my_conf.csv_writer(new_folder + 'overview.csv', self.overview)
return 0
#coding:UTF-8
#encoding=utf-8
# filename: mysqlaccess.py
import MySQLdb
from configInfo import ConfigInfo
conf = ConfigInfo("conf/footgolf.ini")
dbInfo = conf.getDBInfo()
class MysqlAccessBase(object):
def __init__(self):
self.connFlg = False
try:
self.conn = MySQLdb.connect(host=str(dbInfo['host']),
port=int(dbInfo['port']),
user=str(dbInfo['user']),
passwd=str(dbInfo['pwd']),
db=str(dbInfo['dbname']),
charset='utf8')
self.cursor = self.conn.cursor()
self.connFlg = True
except MySQLdb.Error as e:
self.connFlg = False
print("Mysql Error: %d %s." % (e.args[0], e.args[1]))
# 更新数据
def update(self, sql, sqlParam):
updateFlg = False
try:
if self.connFlg: