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)