** MYSQL Sensor App for Athom homey

** CHANGELOG

• 2.0.2

  • fixed name for sensor device

• 2.0.1

  • Added support for sensor device

• 2.0.0

  • Update to SDK 2
  • Added support for gas and weather device

• 1.0.0 First release

  • Icon changed

• 0.0.2

  • Small bugfixes.
  • powermult set during pairing became corrupt.
  • Default powermult removed
  • Version number changed

• USAGE

With this app you can create virtual devices that gather data from a mysql database into homey. The database can be on a NAS or on a seperate server.

• SETUP

• Install the app on your homey.
• Add a MySQL device.
• Fill the folowing fields
  • Name : Name of device
  • Host : Name of MYSQL server
  • User : User name used to contact MYSQL server
  • Password : Password
  • Query : Query used to retrieve data. Use the following fieldnames: Power device : power (current usage in watt) and meter (total use in KwH) gas device : meter (total use in m3) weather device : temp (current temperature in C) and humidity (Current humidity in %) sensor device : triggered (integer value greater then 0 is alarm triggered)
  • Energy Multiplier : Correction factor for energy value. P1 (smartmeter) logs for example output 10 watt as 0.010 so the correction factor is 1000
  • Polling rate :Number of seconds between MySQL server poll 10 - 10 seconds.

*FEATURES

• DEVICES

• MySQL POWER DEVICE
• MYSQL GAS DEVICE
• MYSQL WEATHER DEVICE
• MYSQL SENSOR DEVICE

Cards and flows are athoms default by these types of devices.