eigenein / my-iot

Yet another home automation

My IoT

The repo is archived in favour of my-iot-rs.

Yet another home automation. Documentation: https://eigenein.github.io/my-iot

my-iot's Issues

Database size channel

It would be nice to monitor IFTTTie database through IFTTTie itself.

iftttie.sqlite3> SELECT page_count * page_size as size FROM pragma_page_count(), pragma_page_size();
+-----------+
| size      |
+-----------+
| 218079232 |
+-----------+
1 row in set
Time: 0.613s

Engine version channel

Yield IFTTTie version itself at startup.

Telegram bot client

Packaging without Docker

Docker startup takes too much time on boards like Pi Zero. Look at other options to deploy without Docker.

As a side effect we'll get ability to restart host from the UI.

Channel page

Template: channel.html
Handler: iftttie.web.channel

It was done one day, but since the database and all the structures have been refactored, this functionality was removed and now needs to be re-written.

Denormalise database

Make latest table contain everything needed to render the dashboard.

Use latest pickle protocol

See also #51

Charts on the channel page

• Keep in mind long-running SQL queries
• Perhaps make a separate endpoint for charts and load it asynchronously

Proper schema migrations

Event expiry timestamp

Makes sense for example for the Nest image URLs or Bluetooth received signal strength.

`IFTTTie` channel

For events like:

• (Re-)starting
• Stopping
• Reloading

Review timeouts for all external requests except for Nest API

They're all probably set to 5 minutes, which is too much.

Local SMA inverter channel

https://gist.github.com/hdo/6027504

Night theme

Could be maybe activated based on sunrise and sunset times? Possible implementations:

• Specify keys for sunrise and sunset channel in the configuration
• Have an action to activate and deactivate night theme – more flexible

Large picture in the channel page for `IMAGE_URL`

UDP broadcast listener channel

Perhaps, requires --net host and network_mode: 'host'.

Unit system

Come up with a generic numerical unit system instead of existing enumeration with all the possibilities.

Look at these two packages or come up with an own one:

• https://github.com/hgrecco/pint
• https://github.com/sbyrnes321/numericalunits

Vacuum database

The database should be periodically vacuumed.

Pass previous value to `on_event`

Use separate client sessions

If #35 is resolved by using a separate session, then this will be to use a separate ClientSession instance for each channel.

Dark Sky channel

https://darksky.net/dev

Under Travis CI run unit tests in Docker

This will be needed once I start installing custom apt packages, for instance for the Bluetooth channel.

Remember to pull all the parent images beforehand.

Documentation

README.md gets outdated too fast, automatically generated docs from sources is really needed.

Need to look what is the best solution.

Improve database schema

The database takes too much space:

• Delete migrations
• Rename the latest table into channels
• Add integer auto-increment primary ID to the channels table
• Make the history table refer by channel ID instead of the key

ESPHome native API

• https://esphome.io/components/api
• https://github.com/eigenein/protobuf
• https://github.com/esphome/esphome-core/blob/dev/src/esphome/api/api.proto

Display loaded configuration

Like a file viewer maybe?

See also #55

Custom 500 page

ARP sniffer channel

Can potentially be used to passively scan for devices in local network.

• https://stackoverflow.com/a/24416136/359730
• https://stackoverflow.com/a/36356783/359730
• http://blog.cornbeast.com/2015/06/how-i-currently-set-up-a-raspberry-pi-to-run-a-node-js-application/

User sessions

Avoid checking username and password for each request. Use session IDs instead.

Asynchronous `on_event`

Don't wait for the handler completion. Rather run it as a task.

Add small auto-refresh script

psutil channels

https://github.com/giampaolo/psutil

• system stats
• current process stats

Provide display name in `Update`

Rename to channels and events

After some time I've got an idea that "service" and "update" are not really good names. Perhaps, "channel" and "event" are more descriptive.

Also, rename on_update to on_event.

Logs in the web interface

Restart or reload via the web interface

`ValueKind` becomes `Unit`

The field should rather contain unit, not a kind of value. E.g. "meters per second" instead of "speed". Review and refactor existing kinds.

Homepage link on the channel page

Bluetooth channel

The channel should at least scan for devices and send RSSI's.

https://github.com/zsdonghao/pybluez/blob/master/README.md

Ping host channel

https://github.com/stellarbit/aioping

Webhook channel

Web interface user authentication

Telegram bot channel

Bot is supposed to listen to a chat and yield corresponding events with the message texts. Thus,My IoT could be controlled via e.g. Voicy bot in the same group chat.

Set up unit testing

Add `id_` to `Update`

The primary key for Update will be (key, id_).

Nest channel stops after a connection error

• The channel doesn't restart automatically
• The error description is missing, whilst supposed to be there
• Perhaps not related to this specific channel, should be a bug in the core

Jan 25 23:14:01 (iftttie.channels.nest:36) [E] Connection error:
Jan 25 23:14:01 (iftttie.core:28) [I] Stopped channel Nest(token="c.Am…xoGd").

Use existing package for Server-sent events

Add Telegram `send_message` method

Try PyInstaller

https://www.pyinstaller.org/

Add Buienradar weather description channel

Key: weatherdescription
Unit: perhaps a new unit for plain text