为数据库批量巡检脚本准备
仅作为练习使用
def dbreadlist(dcfile):
retres = []
cfile = open(dcfile,mode='r')
databaselist = cfile.readlines()
for res in databaselist:
if len(res.strip()) == 0:
pass
else:
up = res.split('@')[0]
url = res.split('@')[1]
username = up.split('/')[0]
password = up.split('/')[1]
temp = username + ',' + password + ',' + url.replace('n', '')
retres.append(temp)
cfile.close()
return retres
def sqlreadlist(dcfile):
retres = []
cfile = open(dcfile, mode='r')
sqllist = cfile.readlines()
for res in sqllist:
if len(res.strip()) == 0:
pass
else:
temp = res.strip()
retres.append(temp)
cfile.close()
return retres
