blob: e803073ed1afd7a0dc5bce4c183830786dd51142 (
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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
# Energyscripts
This is a small collection of scripts I use to collect information about my
energyconsumption.
## Set up venv
```
python3 -m venv venv
source venv/bin/activate
pip install --upgrade pip
pip install .
```
If running `scripts/neihub.py` or `scripts/esphomeapi.py`, also run `pip install
".[esphome]"` and `pip install ".[neohub]"`.
## Schema
Install schema
```
psql el < schema.sql
```
schema.sql created with:
```
pg_dump --schema-only --no-owner --no-privileges el
```
## Systemd
Example:
```
ln -s /opt/energyscripts/energyscripts-SCRIPT@ADDRESS.service /etc/systemd/system/energyscripts-mqtt_listener.service
ln -s /opt/energyscripts/energyscripts-SCRIPT@ADDRESS.service /etc/systemd/system/energyscripts-esphomeapi@airgradient.local.net.service
systemctl enable energyscripts-mqtt_listener.service energyscripts-esphomeapi@airgradient.local.net.service
systemctl start energyscripts-mqtt_listener.service energyscripts-esphomeapi@airgradient.local.net.service
journalctl -fu "energyscripts-*"
```
## TODO:
Put every state in `states`-table. Entities in an entity-table, and devices in
a device-table.
|