View gist:af13672d27fe75eee10c19055a51003c
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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: |
View main.py
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |
View settings
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{"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 |
View settings
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{"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 |
View settings.json
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{"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_ |
View esphome.yaml
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
substitutions: | |
device_name: bottommirror | |
esphome: | |
name: ${device_name} | |
platform: ESP8266 | |
board: esp01_1m | |
logger: | |
api: |
View log.txt
This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
View gist:dcf19279cd34b07a08cb25be4589c9c1
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
View gist:6c2e85ee1c55edd98bb1aabad5155e9f
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
View gist:5a019887e50280dd983b900019e69d58
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[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 |
NewerOlder