我尝试使用以下python解析示例文件(sample.txt)。但结果出乎意料
样本:
# Summary Report #######################
System time | 2020-02-27 15:35:32 UTC (local TZ: UTC +0000)
# Instances ##################################################
Port Data Directory Nice OOM Socket
===== ========================== ==== === ======
0 0
# Configuration File #########################################
Config File | /etc/srv.cnf
[mysqld]
server_id = 1
port = 3016
tmpdir = /tmp
performance_schema_instrument = '%=on'
innodb_monitor_enable = 'module_adaptive_hash'
innodb_monitor_enable = 'module_buffer'
[client]
port = 3016
# management library ##################################
jemalloc is not enabled in mysql config for process with id 2425
# The End ####################################################
代码.py
import json
import re
all_lines = open('sample.txt', 'r').readlines()
final_dict = {}
regex = r"^([a-zA-Z]+)(.)+="
config = 0 # not yet found config
for line in all_lines:
if '[mysqld]' in line:
final_dict['mysqld'] = {}
config = 1
continue
if '[client]' in line:
final_dict['client'] = {}
config = 2
continue
if config == 1 and re.search(regex, line):
try:
clean_line = line.strip() # get rid of empty space
k = clean_line.split('=')[0].rstrip() # get the key
v = clean_line.split('=')[1].lstrip()
final_dict['mysqld'][k] = v
except Exception as e:
print(clean_line, e)
if config == 2 and re.search(regex, line):
try:
clean_line = line.strip() # get rid of empty space
k = clean_line.split('=')[0].rstrip() # get the key
v = clean_line.split('=')[1].lstrip()
final_dict['client'][k] = v
except Exception as e:
print(clean_line, e)
print(final_dict)
print(json.dumps(final_dict, indent=4))
with open('my.json', 'w') as f:
json.dump(final_dict, f, sort_keys=True)
意外的结果是:
{ “客户”:{ “端口”:“3016” }, “mysqld”:{ “绩效模式工具”:“%”, “服务器id”:“1”, “innodb\u监视器\u启用”:“模块\u缓冲区”, “端口”:“3016”, “tmpdir”:“/tmp” } }
预期结果:
{
"client": {
"port": "3016"
},
"mysqld": {
"performance_schema_instrument": "'%=on'",
"server_id": "1",
"innodb_monitor_enable": "'module_buffer','module_adaptive_hash'",
"port": "3016",
"tmpdir": "/tmp"
}
}
是否有可能达到上述结果
configparser用于处理python中的配置文件设置
相关问题 更多 >
编程相关推荐