hassconfig/sensors.yaml

- platform: sql
  db_url: mysql://hassio:hassiopassword@192.168.1.110/RemoteRxLog
  queries:
    - 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'



- platform: mqtt
  name: Temperatur Hällby
  state_topic: "micke/outside/temperature"
  unit_of_measurement: "°C"

- platform: mqtt
  name: Lux Hällby
  state_topic: "micke/lux/lux_calibrated"
  unit_of_measurement: "Lux"

- platform: mqtt
  name: Lux outside the garage
  state_topic: "sensors/outside/lux"
  unit_of_measurement: "Lux"

- platform: mqtt
  name: SMHI Temperature
  state_topic: "sensors/outside/smhiTemperature"
  unit_of_measurement: C

- platform: mqtt
  name: Frank Temperature
  state_topic: "sensors/outside/frankTemperature"
  unit_of_measurement: C