hnykda

# How to run it

```
sqlite3 Test.db ".read scripts/init.sql" # creates the dabatase structure
sqlite3 Test.db ".read scripts/seed.sql" # populates with dummy data
sqlite3 Test.db ".read scripts/query1.sql"
sqlite3 Test.db ".read scripts/query2.sql"
```

To run the rules program:

hnykda

import os
import glob
import argparse
import json

from supabase import create_client, Client

url: str = os.environ.get("NEXT_PUBLIC_SUPABASE_URL")
key: str = os.environ.get("SUPABASE_SERVICE_ROLE_KEY")
supabase: Client = create_client(url, key)

hnykda

{"device":{"type":"SHRGBW2","mac":"E8DB84807745","hostname":"shellyrgbw2-807745","num_outputs":4, "mode":"white"},"wifi_ap":{"enabled":false,"ssid":"shellyrgbw2-807745","key":""},"wifi_sta":{"enabled":true,"ssid":"artpolis","ipv4_method":"dhcp","ip":null,"gw":null,"mask":null,"dns":null},"wifi_sta1":{"enabled":false,"ssid":null,"ipv4_method":"dhcp","ip":null,"gw":null,"mask":null,"dns":null},"ap_roaming":{"enabled":false,"threshold":-70},"mqtt": {"enable":false,"server":"192.168.33.3:1883","user":"","id":"shellyrgbw2-807745","reconnect_timeout_max":60.000000,"reconnect_timeout_min":2.000000,"clean_session":true,"keep_alive":60,"max_qos":0,"retain":false,"update_period":30},"coiot": {"enabled":true,"update_period":15,"peer":""},"sntp":{"server":"time.google.com","enabled":true},"login":{"enabled":false,"unprotected":false,"username":"admin"},"pin_code":"","name":null,"fw":"20230329-162716/v1.13.0-rc2-g1b3e5af","factory_reset_from_switch":true,"discoverable":false,"build_info":{"build_id":"20230329-162716/v1.13

hnykda

{"device":{"type":"SHRGBW2","mac":"E8DB84807745","hostname":"shellyrgbw2-807745","num_outputs":4, "mode":"white"},"wifi_ap":{"enabled":false,"ssid":"shellyrgbw2-807745","key":""},"wifi_sta":{"enabled":true,"ssid":"artpolis","ipv4_method":"dhcp","ip":null,"gw":null,"mask":null,"dns":null},"wifi_sta1":{"enabled":false,"ssid":null,"ipv4_method":"dhcp","ip":null,"gw":null,"mask":null,"dns":null},"ap_roaming":{"enabled":false,"threshold":-70},"mqtt": {"enable":false,"server":"192.168.33.3:1883","user":"","id":"shellyrgbw2-807745","reconnect_timeout_max":60.000000,"reconnect_timeout_min":2.000000,"clean_session":true,"keep_alive":60,"max_qos":0,"retain":false,"update_period":30},"coiot": {"enabled":true,"update_period":15,"peer":""},"sntp":{"server":"time.google.com","enabled":true},"login":{"enabled":false,"unprotected":false,"username":"admin"},"pin_code":"","name":null,"fw":"20221027-100516/v1.12.1-ga9117d3","factory_reset_from_switch":true,"discoverable":false,"build_info":{"build_id":"20221027-100516/v1.12.1-g

hnykda

{"device":{"type":"SHRGBW2","mac":"E8DB84807745","hostname":"shellyrgbw2-807745","num_outputs":4},"wifi_ap":{"enabled":false,"ssid":"shellyrgbw2-807745","key":""},"wifi_sta":{"enabled":true,"ssid":"artpolis","ipv4_method":"dhcp","ip":null,"gw":null,"mask":null,"dns":null},"wifi_sta1":{"enabled":false,"ssid":null,"ipv4_method":"dhcp","ip":null,"gw":null,"mask":null,"dns":null},"ap_roaming":{"enabled":false,"threshold":-70},"mqtt": {"enable":false,"server":"192.168.33.3:1883","user":"","id":"shellyrgbw2-807745","reconnect_timeout_max":60.000000,"reconnect_timeout_min":2.000000,"clean_session":true,"keep_alive":60,"max_qos":0,"retain":false,"update_period":30},"coiot": {"enabled":true,"update_period":15,"peer":""},"sntp":{"server":"time.google.com","enabled":true},"login":{"enabled":false,"unprotected":false,"username":"admin"},"pin_code":"","name":null,"fw":"20220209-094013/v1.11.8-g8c7bb8d","factory_reset_from_switch":true,"discoverable":false,"build_info":{"build_id":"20220209-094013/v1.11.8-g8c7bb8d","build_

hnykda

substitutions:
  device_name: bottommirror

esphome:
  name: ${device_name}
  platform: ESP8266
  board: esp01_1m

logger:
api:

hnykda

info  2023-03-17 12:13:04: MQTT publish: topic 'zigbee2mqtt/TRVGamma', payload '{"auto_lock":"MANUAL","away_mode":"OFF","away_preset_days":1,"away_preset_temperature":15,"battery_low":false,"boost_time":300,"child_lock":"UNLOCK","comfort_temperature":19,"current_heating_setpoint":13.5,"eco_temperature":15,"force":"normal","holidays":[{"hour":6,"minute":0,"temperature":19},{"hour":8,"minute":0,"temperature":15},{"hour":11,"minute":30,"temperature":15},{"hour":12,"minute":30,"temperature":15},{"hour":17,"minute":30,"temperature":19},{"hour":22,"minute":0,"temperature":15}],"holidays_schedule":"06:00/19°C 08:00/15°C 11:30/15°C 12:30/15°C 17:30/19°C 22:00/15°C","last_seen":"2023-03-17T12:13:04+01:00","linkquality":83,"local_temperature":14,"local_temperature_calibration":-1,"max_temperature":19,"min_temperature":5,"position":0,"preset":"manual","programming_mode":null,"running_state":"idle","system_mode":"auto","update":{"installed_version":-1,"latest_version":-1,"state":null},"update_available":null,"valve_detec

hnykda

Fri Aug  5 13:33:52 2022 daemon.notice netifd: Interface 'wanv6' is setting up now
Fri Aug  5 13:33:52 2022 user.debug netifd: ubus  call network.interface notify_proto { "action": 1, "command": [ "\/usr\/sbin\/pppd", "nodetach", "ifname", "pppoev6-wanv6", "ipparam", "wanv6", "lcp-echo-interval", "20", "lcp-echo-failure", "5", "nodefaultroute", "noaccomp", "nopcomp", "ipv6", "maxfail", "1", "user", "wia", "password", "wia", "ip-up-script", "\/lib\/netifd\/pppv6-up", "ipv6-up-script", "\/lib\/netifd\/pppv6-up", "ip-down-script", "\/lib\/netifd\/ppp-down", "ipv6-down-script", "\/lib\/netifFri Aug  5 13:33:52 2022 daemon.info pppd[18458]: pppoe_init() success
Fri Aug  5 13:33:52 2022 daemon.notice netifd: wanv6 (18458): pppoe_init() success
Fri Aug  5 13:33:52 2022 daemon.notice pppd[18458]: PPPoE DevName Hook, the name is nic-br-wan
Fri Aug  5 13:33:52 2022 daemon.notice netifd: wanv6 (18458): PPPoE DevName Hook, the name is nic-br-wan
Fri Aug  5 13:33:52 2022 daemon.notice pppd[18458]: make the channel with pp

hnykda

INFO Reading configuration /config/esphome/esphome-web-aee2ce.yaml...
INFO Generating C++ source...
INFO Compiling app...
Processing hrv-controller (board: nodemcuv2; framework: arduino; platform: platformio/espressif8266 @ 3.2.0)
--------------------------------------------------------------------------------
HARDWARE: ESP8266 80MHz, 80KB RAM, 4MB Flash
LDF: Library Dependency Finder -> https://bit.ly/configure-pio-ldf
Dependency Graph
|-- <ESPAsyncTCP-esphome> 1.2.3
|-- <ESPAsyncWebServer-esphome> 2.1.0

hnykda

[16:04:30][I][app:102]: ESPHome version 2022.3.1 compiled on Jan 29 2023, 16:02:29
[16:04:30][C][wifi:491]: WiFi:
[16:04:30][C][wifi:353]:   Local MAC: E8:DB:84:AE:E2:CE
[16:04:30][C][wifi:354]:   SSID: [redacted]
[16:04:30][C][wifi:355]:   IP Address: 192.168.0.19
[16:04:30][C][wifi:356]:   BSSID: [redacted]
[16:04:30][C][wifi:358]:   Hostname: 'esphome-web-aee2ce'
[16:04:30][C][wifi:360]:   Signal strength: -66 dB ▂▄▆█
[16:04:30][V][wifi:362]:   Priority: 0.0
[16:04:30][C][wifi:364]:   Channel: 3