Nalezl jsem jednoduchou konfiguraci, která vytváří SQL senzor:
Kód: Vybrat vše
- platform: sql
db_url: mysql://homeassistant:HESLO@core-mariadb/homeassistant?charset=utf8mb4
queries:
- name: mariadb_size
query: "SELECT table_schema AS 'db_name', ROUND(SUM( data_length + index_length ) / 1024 / 1024, 2) AS 'size_mb' FROM information_schema.TABLES WHERE table_schema='homeassistant'"
column: "size_mb"
unit_of_measurement: MB
Kód: Vybrat vše
- platform: sql
db_url: mysql://homeassistant:HESLOl@core-mariadb/homeassistant?charset=utf8mb4
queries:
- name: daikin_sum_kwh
query: SELECT max(last_changed),sum(state) as x FROM `states` where entity_id like '%daikin%heat%ener%' and last_changed> CURRENT_DATE();
column: "x"
unit_of_measurement: kWh