# 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

binary_sensor:
counter:
logbook:
notify:
input_boolean:
input_datetime:
input_number:
input_select:
input_text:
timer:
#websocket_api

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

sensor:
  - platform: rflink
    automatic_add: true

  - 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: Exterior light status
        query: "SELECT onOff FROM RemoteRxLog.nexaLog where remote_id = '20071094' and button='1' order by ts desc LIMIT 1;"
        column: 'onOff'
      - name: Outside temperature
        query: "SELECT temp1 FROM RemoteRxLog.temp order by ts desc LIMIT 1;"
        column: 'temp1'
        unit_of_measurement: C

switch:
  - platform: rflink
    automatic_add: true

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