def insert_hostlist_in_db(self, hostlist):
"""
Update of the table containing the hosts. Inserts each host in 'hostlist'.
"""
db = MysqlHandler(self.db_username, self.db_passwd, self.db_dbname)
for host in hostlist:
db.update_datas_in_table(
"ip_monitor",
{"mac_addr": host._MacAddr},
{
"last_update": str(time.time()).split(".")[0],
"ip_addr": host._IpAddr,
"hostname": host._Hostname.split(".")[0],
},
)
db.updatedb()
db.close()
def insert_hostlist_in_db(self, hostlist):
"""
Update of the table containing the hosts. Inserts each host in 'hostlist'.
"""
db = MysqlHandler(self.db_username, self.db_passwd, self.db_dbname);
for host in hostlist:
db.update_datas_in_table('ip_monitor',
{"mac_addr": host._MacAddr},
{"last_update": str(time.time()).split('.')[0],
"ip_addr": host._IpAddr,
"hostname": host._Hostname.split('.')[0]});
db.personnal_query("DELETE FROM ip_monitor WHERE last_update<"+str(time.time()-7200).split('.')[0]);
db.updatedb();
query = "UPDATE room_device ";
query += "JOIN ip_monitor ON plus4=mac_addr ";
query += "SET addr=ip_addr ";
query += "WHERE protocol_id=6 AND plus4 != '' AND ip_addr != addr";
self.mysql_handler_personnal_query(query);
db.updatedb();
db.close();
