hassconfig/configuration.yaml

# Configure a default setup of Home Assistant (frontend, api, etc)
#default_config:
config:
frontend:

logger:
  logs:
    rflink: debug
    homeassistant.components.rflink: debug

homeassistant:
  packages: !include_dir_named packages

counter:
logbook:
notify:
input_boolean:
input_datetime:
input_number:
input_select:
input_text:
timer:
#websocket_api
pyscript:
  allow_all_imports: true

system_health:
recorder:
  purge_keep_days: 5
  db_url: mysql://hassio:hassiopassword@192.168.1.110/hass?charset=utf8
history:



rflink:
  host: 127.0.0.1
  port: 12345
  wait_for_ack: false


# All off (group) 20;01;NewKaku;ID=006d7076;;SWITCH=0;CMD=ALLOFF;

binary_sensor:
  - platform: rflink
    devices:
      newkaku_00066542_1:
        name: Ytterdörr brytare
        device_class: motion
        off_delay: 5  


light:
  - platform: rflink
    automatic_add: true
    devices:
      newkaku_013242b6_2:
        name: Exterior lights
        type: switchable
      newkaku_013242b5_2:
        name: Exterior lights REPEATER
        type: switchable
      
      newkaku_013242b6_3:
        name: Piano-lamp
        type: switchable
      newkaku_013242b5_3:
        name: Piano-lamp REPEATER
        type: switchable

      newkaku_006d7076_1:
        name: Main Button 1
        aliases:
          - newkaku_006d7076_0
      newkaku_006d7076_2:
        name: Main Button 2
        aliases:
          - newkaku_006d7076_0
      newkaku_006d7076_3:
        name: Main Button 3
        aliases:
          - newkaku_006d7076_0
      newkaku_006d7076_4:
        name: Main Button 4
        aliases:
          - newkaku_006d7076_0


sensor:
  - platform: sql
    db_url: mysql://hassio:hassiopassword@192.168.1.110/RemoteRxLog
    queries:
      - name: Lux outside the garage
        query: "SELECT CAST(AVG(data) AS signed) as data FROM (SELECT data FROM RemoteRxLog.rawTemp WHERE type = 'lux' and data < '65535' ORDER BY id DESC LIMIT 3) items;"
        column: 'data'
        unit_of_measurement: Lux
      - name: Outside temperature
        query: "SELECT temp1 FROM RemoteRxLog.temp order by ts desc LIMIT 1;"
        column: 'temp1'
        unit_of_measurement: C
      - name: Piano-lamp repeater status
        query: "SELECT IF(onOff>0,'on','off') AS status FROM RemoteRxLog.nexaLog where rxTx='R' and remote_id = '20071094' and button='2' order by ts desc LIMIT 1;"
        column: 'status'
      - name: Exterior light status
        query: "SELECT IF(onOff>0,'on','off') AS status FROM RemoteRxLog.nexaLog where rxTx='R' and remote_id = '20071094' and button='1' order by ts desc LIMIT 1;"
        column: 'status'



group: !include groups.yaml
automation: !include automations.yaml
script: !include scripts.yaml
scene: !include scenes.yaml