def dotransform(request, response): # Setup the sqlite database connection watcher_db = 'Watcher/resources/databases/watcher.db' con = lite.connect(watcher_db) ap_name = request.value ap_list = [] with con: cur = con.cursor() cur.execute('SELECT * FROM aplist WHERE ssid like ' + "\"" + ap_name + "\"") while True: row = cur.fetchone() if row == None: break if row not in ap_list: ap_list.append(row) for ddate, dtime, ssid, bssid, channel, enc, rssi, monint in ap_list: e = AccessPoint(ssid) e.apbssid = bssid e.apchannel = channel e.apencryption = enc e.apmoninterface = monint e.aprssi = rssi response += e return response