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 get_daemons(self): """ Retrieves each daemon stored in the database """ 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"]) return daemons
def get_daemons(self): """ Retrieves each daemon stored in the database """ 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']); return daemons;
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;