def get_current_load(self):
db = Database(self.filePath)
APs = db.get_data_raw("SELECT * FROM wlc_aps")
data = []
for ap in APs:
node = {}
node['key'] = ap[0]
node['name'] = ap[1]
node['location'] = ap[2]
node['cnt'] = int(db.get_data_single("SELECT clients from wlc_ap_clients WHERE ap_key=? ORDER BY timestamp DESC",(str(ap[0]),)))
data.append(node)
data = sorted(data, key=lambda k: k['cnt'], reverse = True)
return data
def get_groups(self):
db = Database(self.filePath)
data = []
groups = db.get_data_raw("SELECT * FROM wlc_ap_groups")
for group in groups:
node = {}
node['id'] = group[0]
node['name'] = group[1]
node['lat'] = group[2]
node['lng'] = group[3]
node['aps'] = []
node['cnt'] = 0
bindings = db.get_data("SELECT * FROM wlc_ap_group_binding WHERE group_id=?",(node['id'],))
for binding in bindings:
apNode = {}
apNode['key'] = binding[2]
adDetails = db.get_data("SELECT * FROM wlc_aps WHERE ap_key=?",(apNode['key'],))
apNode["name"] = adDetails[0][1]
node['aps'].append(apNode)
node['cnt'] += int(db.get_data_single("SELECT clients from wlc_ap_clients WHERE ap_key=? ORDER BY timestamp DESC",(str(apNode['key']),)))
data.append(node)
data = sorted(data, key=lambda k: k['cnt'], reverse = True)
return data
def get_updateStamp(self):
sql = Database(self.filePath)
query = "SELECT value from wlc_settings WHERE key='lastUpdate'"
return sql.get_data_single(query)
def get(self, key):
sql = Database(self.filePath)
return sql.get_data_single("SELECT value FROM wlc_settings WHERE key=?",(key,))