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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
#!/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
import common
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}")
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)
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)"""
common.dbi(sql, values)
sql = """INSERT INTO mqtt_temps
(name,
temperature,
time,
room)
SELECT 'neohub', %s, %s, sensors.room
FROM sensors
WHERE sensors.name = 'neohub'"""
values = (device.temperature, datetime.utcnow())
common.dbi(sql, values)
asyncio.run(run())
|
