blob: d0a9f96881636b05ae4e24f05783f26c6b5a434d (
plain) (
tree)
|
|
# 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
pip3 install -r requirements.txt
```
## Handling pip
```
# Create requirements.txt
pip3 freeze > requirements.txt
# Show outdated packages
pip3 list --outdated
# Upgrade package
pip3 install -U name
# Upgrade everything
pip3 install -U -r requirements.txt
# Update requirements.txt
pip3 freeze > requirements.txt
```
## 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.
|
