def set(self, key, value):
sql = Database(self.filePath)
if sql.is_present("SELECT * FROM wlc_settings WHERE key=?",(key,)):
sql.write_data("UPDATE wlc_settings SET value=? WHERE key=?",(value,key,))
else:
sql.write_data("INSERT INTO wlc_settings (key,value) VALUES (?,?)",(key,value,))
sql.commit()
def save_data(self, ap_data):
sql = Database(self.filePath)
paramList = []
timestamp = time.time()
for ap in ap_data:
params = (str(ap['key']),)
query = "SELECT * FROM wlc_aps WHERE ap_key=?"
apPresent = sql.is_present(query,params)
if apPresent:
params = (str(ap['name']),str(ap['location']),str(ap['key']))
query = "UPDATE wlc_aps SET ap_name=?, ap_location=? WHERE ap_key=?"
sql.write_data(query, params)
else:
params = (str(ap['key']),str(ap['name']),str(ap['location']))
query = "Insert INTO wlc_aps (ap_key,ap_name,ap_location) VALUES (?,?,?)"
sql.write_data(query,params)
params = (str(ap['key']),str(timestamp),str(ap['clients']),)
paramList.append(params)
query = "INSERT INTO wlc_ap_clients (ap_key, timestamp , clients) VALUES (?,?,?)"
sql.write_data_dump(query,paramList)
sql.commit()
