aboutsummaryrefslogtreecommitdiffstats
path: root/scripts/neohub.py
blob: 7cc11605b2a88ab59d6386d9720d066e89b32e5c (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
#!/usr/bin/python3
''' Get stuff from neohub! This is mostly the usage-example from https://gitlab.com/neohubapi/neohubapi/ '''

import os
import asyncio
from datetime import datetime
import neohubapi.neohub as neohub

from common import dbi

neohub_ip = os.environ['el_neohub_ip']
neohub_port = os.environ['el_neohub_port']

async def run():
    ''' async runner! w00p '''
    # Legacy connection
    hub = neohub.NeoHub(neohub_ip, int(neohub_port))
    # Or, for a websocket connection:
    # hub = neohub.Neohub(port=4243, token='xxx-xxxxxxx')
    system = await hub.get_system()
    hub_data, devices = await hub.get_live_data()
    for device in devices['thermostats']:
        print(f"Temperature in zone {device.name}: {device}")
        sql = "INSERT INTO neohub (timestamp, time, device_id, away, heat_mode, heat_on, current_floor_temperature, target_temperature, temperature) VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s)"
        values = (datetime.utcnow(), device.time, device.device_id, device.away, device.heat_mode, device.heat_on, device.current_floor_temperature, device.target_temperature, device.temperature)
        dbi(sql, values)

asyncio.run(run())