Mercurial > code > home > repos > homeauto
view service/tomatoWifi/tomatoWifi.py @ 417:10ec2744fe8a
mongodb api upgrade
Ignore-this: 2a09182f26109a2744f98d6babc64293
author | drewp@bigasterisk.com |
---|---|
date | Sat, 30 Mar 2019 16:56:31 -0700 |
parents | 8f5a16a55f64 |
children | b3935eac90e1 |
line wrap: on
line source
#!/usr/bin/python """ scrape the tomato router status pages to see who's connected to the wifi access points. Includes leases that aren't currently connected. Returns: json listing (for magma page) rdf graph (for reasoning) activity stream, when we start saving history Todo: this should be the one polling and writing to mongo, not entrancemusic """ from __future__ import division import sys, cyclone.web, json, traceback, time, pystache, datetime, logging import web.utils from cyclone.httpclient import fetch from dateutil import tz from twisted.internet import reactor, task from twisted.internet.defer import inlineCallbacks import docopt from influxdb import InfluxDBClient from pymongo import MongoClient as Connection, DESCENDING from rdflib import Namespace, Literal, URIRef, ConjunctiveGraph from stategraph import StateGraph from wifi import Wifi from patchablegraph import PatchableGraph, CycloneGraphEventsHandler, CycloneGraphHandler from rdfdb.patch import Patch from cycloneerr import PrettyErrorHandler from logsetup import log DEV = Namespace("http://projects.bigasterisk.com/device/") ROOM = Namespace("http://projects.bigasterisk.com/room/") reasoning = "http://bang:9071/" class Index(PrettyErrorHandler, cyclone.web.RequestHandler): def get(self): age = time.time() - self.settings.poller.lastPollTime if age > 10: raise ValueError("poll data is stale. age=%s" % age) self.set_header("Content-Type", "text/html") self.write(open("index.html").read()) def whenConnected(mongo, macThatIsNowConnected): lastArrive = None for ev in mongo.find({'address': macThatIsNowConnected.upper()}, sort=[('created', -1)], max_scan=100000): if ev['action'] == 'arrive': lastArrive = ev if ev['action'] == 'leave': break if lastArrive is None: raise ValueError("no past arrivals") return lastArrive['created'] def connectedAgoString(conn): return web.utils.datestr( conn.astimezone(tz.tzutc()).replace(tzinfo=None)) class Table(PrettyErrorHandler, cyclone.web.RequestHandler): def get(self): def rowDict(row): row['cls'] = "signal" if row.get('connected') else "nosignal" if 'name' not in row: row['name'] = row.get('clientHostname', '-') if 'signal' not in row: row['signal'] = 'yes' if row.get('connected') else 'no' try: conn = whenConnected(self.settings.mongo, row.get('mac', '??')) row['connectedAgo'] = connectedAgoString(conn) except ValueError: row['connectedAgo'] = 'yes' if row.get('connected') else '' row['router'] = row.get('ssid', '') return row self.set_header("Content-Type", "application/xhtml+xml") self.write(pystache.render( open("table.mustache").read(), dict( rows=sorted(map(rowDict, self.settings.poller.lastAddrs), key=lambda a: (not a.get('connected'), a.get('name')))))) class Json(PrettyErrorHandler, cyclone.web.RequestHandler): def get(self): self.set_header("Content-Type", "application/json") age = time.time() - self.settings.poller.lastPollTime if age > 10: raise ValueError("poll data is stale. age=%s" % age) self.write(json.dumps({"wifi" : self.settings.poller.lastAddrs, "dataAge" : age})) class Poller(object): def __init__(self, wifi, mongo): self.wifi = wifi self.mongo = mongo self.lastAddrs = [] self.lastWithSignal = [] self.lastPollTime = 0 def assertCurrent(self): dt = time.time() - self.lastPollTime assert dt < 10, "last poll was %s sec ago" % dt @inlineCallbacks def poll(self): connectedField = 'connected' now = int(time.time()) # UVA mode: addDhcpData = lambda *args: None try: newAddrs = yield self.wifi.getPresentMacAddrs() addDhcpData(newAddrs) newWithSignal = [a for a in newAddrs if a.get('connected')] actions = self.computeActions(newWithSignal) points = [] for action in actions: log.info("action: %s", action) action['created'] = datetime.datetime.now(tz.gettz('UTC')) mongo.save(action) points.append( self.influxPoint(now, action['address'].lower(), 1 if action['action'] == 'arrive' else 0)) try: self.doEntranceMusic(action) except Exception, e: log.error("entrancemusic error: %r", e) if now // 3600 > self.lastPollTime // 3600: log.info('hourly writes') for addr in newWithSignal: points.append(self.influxPoint(now, addr['mac'].lower(), 1)) influx.write_points(points, time_precision='s') self.lastWithSignal = newWithSignal if actions: # this doesn't currently include signal strength changes fetch(reasoning + "immediateUpdate", method='PUT', timeout=2, headers={'user-agent': ['tomatoWifi']}).addErrback(log.warn) self.lastAddrs = newAddrs self.lastPollTime = now self.updateGraph(masterGraph) except Exception, e: log.error("poll error: %r\n%s", e, traceback.format_exc()) def influxPoint(self, now, address, value): return { 'measurement': 'presence', 'tags': {'sensor': 'wifi', 'address': address,}, 'fields': {'value': value}, 'time': now, } def computeActions(self, newWithSignal): actions = [] def makeAction(addr, act): d = dict(sensor="wifi", address=addr.get('mac').upper(), # mongo data is legacy uppercase name=addr.get('name'), networkName=addr.get('clientHostname'), action=act) if act == 'arrive' and 'ip' in addr: # this won't cover the possible case that you get on # wifi but don't have an ip yet. We'll record an # action with no ip and then never record your ip. d['ip'] = addr['ip'] return d for addr in newWithSignal: if addr['mac'] not in [r['mac'] for r in self.lastWithSignal]: actions.append(makeAction(addr, 'arrive')) for addr in self.lastWithSignal: if addr['mac'] not in [r['mac'] for r in newWithSignal]: actions.append(makeAction(addr, 'leave')) return actions # these need to move out to their own service def doEntranceMusic(self, action): import restkit, json dt = self.deltaSinceLastArrive(action['name']) log.debug("dt=%s", dt) if dt > datetime.timedelta(hours=1): hub = restkit.Resource( # PSHB not working yet; "http://bang:9030/" "http://slash:9049/" ) action = action.copy() del action['created'] del action['_id'] log.info("post to %s", hub) hub.post("visitorNet", payload=json.dumps(action)) def deltaSinceLastArrive(self, name): results = list(self.mongo.find({'name' : name}).sort('created', DESCENDING).limit(1)) if not results: return datetime.timedelta.max now = datetime.datetime.now(tz.gettz('UTC')) last = results[0]['created'].replace(tzinfo=tz.gettz('UTC')) return now - last def updateGraph(self, masterGraph): g = ConjunctiveGraph() ctx = DEV['wifi'] # someday i may also record specific AP and their strength, # for positioning. But many users just want to know that the # device is connected to some bigasterisk AP. age = time.time() - self.lastPollTime if age > 10: raise ValueError("poll data is stale. age=%s" % age) for dev in self.lastAddrs: if not dev.get('connected'): continue uri = URIRef("http://bigasterisk.com/mac/%s" % dev['mac'].lower()) g.add((uri, ROOM['macAddress'], Literal(dev['mac'].lower()), ctx)) g.add((uri, ROOM['connected'], { 'wireless': URIRef("http://bigasterisk.com/wifiAccessPoints"), '2.4G': URIRef("http://bigasterisk.com/wifiAccessPoints"), '5G': URIRef("http://bigasterisk.com/wifiAccessPoints"), 'wired': URIRef("http://bigasterisk.com/houseOpenNet")}[dev['contype']], ctx)) if 'clientHostname' in dev and dev['clientHostname']: g.add((uri, ROOM['wifiNetworkName'], Literal(dev['clientHostname']), ctx)) if 'name' in dev and dev['name']: g.add((uri, ROOM['deviceName'], Literal(dev['name']), ctx)) if 'signal' in dev: g.add((uri, ROOM['signalStrength'], Literal(dev['signal']), ctx)) if 'model' in dev: g.add((uri, ROOM['networkModel'], Literal(dev['model']), ctx)) try: conn = whenConnected(mongo, dev['mac']) except ValueError: traceback.print_exc() pass else: g.add((uri, ROOM['connectedAgo'], Literal(connectedAgoString(conn)), ctx)) g.add((uri, ROOM['connected'], Literal(conn), ctx)) masterGraph.setToGraph(g) if __name__ == '__main__': args = docopt.docopt(''' Usage: tomatoWifi [options] Options: -v, --verbose more logging --port=<n> serve on port [default: 9070] --poll=<freq> poll frequency [default: .2] ''') if args['--verbose']: from twisted.python import log as twlog twlog.startLogging(sys.stdout) log.setLevel(10) log.setLevel(logging.DEBUG) mongo = Connection('bang', 27017, tz_aware=True)['visitor']['visitor'] influx = InfluxDBClient('bang', 9060, 'root', 'root', 'main') masterGraph = PatchableGraph() wifi = Wifi() poller = Poller(wifi, mongo) task.LoopingCall(poller.poll).start(1/float(args['--poll'])) reactor.listenTCP(int(args['--port']), cyclone.web.Application( [ (r"/", Index), (r'/json', Json), (r'/graph', CycloneGraphHandler, {'masterGraph': masterGraph}), (r'/graph/events', CycloneGraphEventsHandler, {'masterGraph': masterGraph}), (r'/table', Table), #(r'/activity', Activity), ], wifi=wifi, poller=poller, mongo=mongo)) reactor.run()