def update_knx_log(self, json_obj):
"""
Update of the knx log table with values from 'json_obj'
"""
daemon_id = 0
db = MysqlHandler(self.db_username, self.db_passwd, self.db_dbname)
daemons = db.get_datas_from_table_with_names("daemon", ["daemon_id", "name", "serial", "secretkey"])
for d in daemons:
if json_obj["sender_name"] == d[2]:
daemon_id = d[0]
break
db.insert_datas_in_table(
"knx_log",
["type", "addr_src", "addr_dest", "knx_value", "t_date", "daemon_id"],
(
json_obj["type"],
json_obj["src_addr"],
json_obj["dst_addr"],
json_obj["value"],
json_obj["date"],
daemon_id,
),
)
db.updatedb()
db.close()
return daemon_id
def update_enocean_log(self, json_obj):
"""
Update of the enocean log table with values from 'json_obj'
"""
daemon_id = 0;
db = MysqlHandler(self.db_username, self.db_passwd, self.db_dbname);
daemons = db.get_datas_from_table_with_names('daemon', ['daemon_id', 'name', 'serial', 'secretkey']);
for d in daemons:
if json_obj['sender_name'] == d[2]:
daemon_id = d[0];
break;
db.insert_datas_in_table('enocean_log',
['type', 'addr_src', 'addr_dest', 'eo_value', 't_date', 'daemon_id'],
(json_obj['type'], json_obj['src_addr'], json_obj['dst_addr'],
json_obj['value'], json_obj['date'], daemon_id));
db.updatedb();
db.close();
return daemon_id;
