from BasicInterface import executeMysqlData
#该脚本主要功能是拉取所有蜜罐端点IP
serverlist = [2,5,4]
for server in serverlist:
    sql= """ select net_info from hosts"""
    if server == 2:
        print ('CST')
    elif server == 5:
        print ('SA')
    elif server == 4:
        print ('公网')
    result = executeMysqlData(server,'read', sql)
    for i in result:
        for j in i[θ].split('|'):
            sqlForCheck = f"""select up from honeypot where ip = {"'"+ j.split("&&")[2] + "'"}"""
            resultForCheck = executeMysqlData(3,'read',sqlForCheck)
            if len(resultForCheck) == 0:
                sqlForInsert = f"""insert into honeypot (ip) values({"'" + j.split("&&")[2] + "'"})"""
                executeMysqlData (3,'write',sqlForInsert)