Skip to content

Instantly share code, notes, and snippets.

View theundefined's full-sized avatar

Andrzej Dopierała theundefined

View GitHub Profile
rest:
- resource: 'https://app.weathercloud.net/device/values?code=9186673866'
scan_interval: 600
headers:
X-Requested-With: XMLHttpRequest
sensor:
- name: weathercloud heat 9186673866
value_template: '{{ value_json.heat }}'
unit_of_measurement: '°C'
- name: weathercloud hum 9186673866
1 dongle:
[29123.761682] usb 1-1.2: new full-speed USB device number 13 using ehci-pci
[29123.871651] usb 1-1.2: New USB device found, idVendor=066f, idProduct=4200, bcdDevice= 0.08
[29123.871665] usb 1-1.2: New USB device strings: Mfr=1, Product=2, SerialNumber=0
[29123.871670] usb 1-1.2: Product: IrDA/USB Bridge
[29123.871674] usb 1-1.2: Manufacturer: Sigmatel Inc
Bus 001 Device 013: ID 066f:4200 SigmaTel, Inc. STIr4200 IrDA Bridge
2 dongle:
# wyszukanie dat gdzie są dziury:
select * from statistics where metadata_id = 108;
# aktualizacja wartości na ostatnią znaną przy dacie gdzie była dziura
update statistics set state=4489.043,sum=1249.331 where state=0 and date(created)='2022-02-02' and metadata_id=108;
# aktualizacja sumy
update statistics_short_term set sum=state-3239.712 where metadata_id=108 and state > 0;
update statistics set sum=state-3239.712 where metadata_id=108 and state > 0;
# wyswietlenie tabel
alias: Światła - XXX
description: ''
trigger:
- platform: device
domain: mqtt
device_id: 1e500fe397f9f537bfdbc6e7242c3f28
type: action
subtype: 'on'
discovery_id: 0xb4e3f9fffebddc7e action_on
id: 'on'
undefine@uml:~$ echo |openssl s_client -connect letsencrypt.org:443 -showcerts >x.pem
depth=2 C = US, O = Internet Security Research Group, CN = ISRG Root X1
verify return:1
depth=1 C = US, O = Let's Encrypt, CN = R3
verify return:1
depth=0 CN = lencr.org
verify return:1
DONE
undefine@uml:~$ openssl verify -CAfile x.pem x.pem
C = US, O = Internet Security Research Group, CN = ISRG Root X1
rest_command:
pvmonitor:
url: 'http://dane.pvmonitor.pl/pv/get2.php?idl=IDL&p=HASLO{{pvm}}'
method: GET
automations:
- id: pvmonitorproduction
alias: PvMonitorProduction
description: PV_Production
trigger:
- minutes: /5
- platform: rest
scan_interval: 900
name: syngeos 605
resource: https://api.syngeos.pl/api/public/data/device/605
value_template: " {{ address }}"
json_attributes:
- sensors
- id: '1604785510049'
alias: Pralka - off
description: ''
trigger:
- entity_id: sensor.sp111_3_pralka_power
platform: numeric_state
for: 00:01
below: '2'
condition: []
action:
@theundefined
theundefined / gist:224701e80de9b5d5a2521ada0e0f4379
Created January 14, 2021 16:21
Powiadomienie o otwartej bramie garażu
alias: Powiadom mnie jak drzwi do garazu są otwarte przez 15 minut
description: ''
trigger:
- platform: state
entity_id: binary_sensor.garaz_gate_open
from: 'off'
to: 'on'
condition: []
action:
- delay: '00:10'
custom:
power_l1:
key: '6100_40464000'
unit: W
power_l2:
key: '6100_40464100'
unit: W
power_l3:
key: '6100_40464200'
unit: W