1.get hosts
2.
#!/usr/bin/env python
# coding: utf-8
# In[13]:
import pandas as pd
import numpy as np
# In[24]:
filename = r"C:\Users\lolo0\Downloads\51b91c776d_202308010805.csv"
#在路径前面加r,即保持字符原始值的意思。
import pandas as pd
# 读取csv文件
df = pd.read_csv(filename)
# 打印列索引名称
print(df.columns)
host_list = df['host'].values.tolist()
# In[61]:
print(host_list)
i=0
# In[62]:
file = open(r"C:\Users\lolo0\Downloads\Acrylic-Portable\AcrylicHosts.txt", "r")
# 读取文件
data = file.read()
#print(data)
OldContent=host_list[i]
#NewContent=host_list[i]
NewContent=host_list[i+1]
# 替换内容
newdata = data.replace(OldContent, NewContent)
print(newdata)
# 关闭文件
file.close()
# 打开文件
file = open(r"C:\Users\lolo0\Downloads\Acrylic-Portable\AcrylicHosts.txt", "w")
# 写入文件
file.write(newdata)
# 关闭文件
file.close()
# In[63]:
i=i+1
# In[64]:
print(i)
# In[68]:
import os
os.system(r"C:\Users\lolo0\Downloads\Acrylic-Portable\RestartAcrylicService.bat")
import time
time.sleep(10)
os.system('ipconfig/flushdns')
# In[ ]: