写
with open(csvname,'w',newline='') as f:
field = ['站点名称','数据库','站点状态','数据库地址']
writer = csv.DictWriter(f,fieldnames=field)
writer.writeheader()
data =show_databases(host)
for i in data :
database =i.get('Database')
if database not in l:
if '_'in database:
databases = database[4:]
else:databases =database
status,name,dbhost = show_status(databases)
writer.writerow({'站点名称':name,'数据库':i.get('Database'),'站点状态': status,'数据库地址':dbhost})
读
with open('fenlei1.csv','r')as f1,open('fenlei2.csv','r')as f2,open('fenlei3.csv') as f3:
reader1 = csv.reader(f1)
reader2 = csv.reader(f2)
reader3 = csv.reader(f3)
header = next(reader1)
for row in reader1:
hostname_l.append(row[1])
header = next(reader2)
for row in reader2:
if row not in hostname_l:
hostname_l.append(row[1])
header = next(reader3)
for row in reader3:
if row not in hostname_l:
hostname_l.append(row[1])
