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
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
