P1_Energy/influx.py at master · BoedieJB/P1_Energy · GitHub

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
from datetime import datetime
from influxdb_client import InfluxDBClient, Point, WritePrecision
from influxdb_client.client.write_api import SYNCHRONOUS

URL = 'http://192.168.1.2:8086'

token = "XOMsKupabsqnNqcjjmSWxcfk9UjXi2y6vZEjdImA4ugnAg6vamBcyk4rmMtZZUVgKhdJzqSv5LtWrUdfUAx6Gg=="
org = "brugts"
bucket = "energy"

client = InfluxDBClient(url=URL, token=token)
write_api = client.write_api(write_options=SYNCHRONOUS)

def influx_point(bron,data):
    match bron:
        case 'meterkast':
            point = Point(bron)\
            .tag("host", data['meter_model'])\
            .field("active_power_w", data['active_power_w'])\
            .time(datetime.utcnow(), WritePrecision.NS)
            write_api.write(bucket, org, point)

            point = Point(bron)\
            .tag("host", data['meter_model'])\
            .field("active_power_l1_w", data['active_power_l1_w'])\
            .time(datetime.utcnow(), WritePrecision.NS)
            write_api.write(bucket, org, point)

            point = Point(bron)\
            .tag("host", data['meter_model'])\
            .field("total_gas_m3", data['total_gas_m3'])\
            .time(datetime.utcnow(), WritePrecision.NS)
            write_api.write(bucket, org, point)

        case 'woonkamer':
            point = Point(bron)\
            .tag("host", bron)\
            .field("active_power_w", data['active_power_w'])\
            .time(datetime.utcnow(), WritePrecision.NS)
            write_api.write(bucket, org, point)

            point = Point(bron)\
            .tag("host", bron)\
            .field("active_power_l1_w", data['active_power_l1_w'])\
            .time(datetime.utcnow(), WritePrecision.NS)
            write_api.write(bucket, org, point)

        case 'kantoor':
            point = Point(bron)\
            .tag("host", bron)\
            .field("active_power_w", data['active_power_w'])\
            .time(datetime.utcnow(), WritePrecision.NS)
            write_api.write(bucket, org, point)

            point = Point(bron)\
            .tag("host", bron)\
            .field("active_power_l1_w", data['active_power_l1_w'])\
            .time(datetime.utcnow(), WritePrecision.NS)
            write_api.write(bucket, org, point)