17 lines
578 B
Python
17 lines
578 B
Python
|
import csv
|
||
|
|
|
||
|
|
# 导入数据
|
||
|
|
config_data = []
|
||
|
|
with open('config.csv', 'r', encoding='utf-8-sig') as file:
|
||
|
|
reader = csv.DictReader(file)
|
||
|
|
for row in reader:
|
||
|
|
config_data.append(row)
|
||
|
|
|
||
|
|
# 生成 sql 更新语句
|
||
|
|
output = open('update.sql', 'w', encoding='utf-8')
|
||
|
|
for _, config in enumerate(config_data):
|
||
|
|
sql = f"UPDATE `server` SET `ip`='{config['public']}' WHERE `address` = '{config['domain']}1.jhip.net';\n"
|
||
|
|
output.write(sql)
|
||
|
|
sql = f"UPDATE `server` SET `ip`='{config['public']}' WHERE `address` = '{config['domain']}2.jhip.net';\n"
|
||
|
|
output.write(sql)
|