aw-watcher-table

An Activity Watch watcher which monitors whether you have set your height-adjustable table to sitting or standing.

Also try my new utilization watcher: aw-watcher-utilization

Idea

Unfortunately my adjustable table doesn't have either an API or anything similar. Therefore I need an external device which measures the height of the table. This external device must have internet access and a distance sensor.

Implementation

Hardware

Electronics

I have used an ESP8266 micro controller. It has built-in Wi-Fi and GPIOs to control sensors. As a distance sensor I have used an HC-SR04 Ultrasonic Sensor, because I already had it on hand.

Case

I printed my case using the Prusa I3 MK3. As modeling software I used Fusion360. You can download the 3D model here (Thingiverse).

Price

Name	Price
ESP8266	€6.50
HC-SR04	€5.16
3D Printed Case	~€0.25
Total	€11.91

Definitely affordable.

Test

When the hardware is finished and powered on, it should be possible to get the table height via the curl command:

# curl http://192.168.2.4/measure
{"table_height":128}

Software

Install

1. Go to the config directory. Find the path for your OS here.
2. In the aw-qt directory find the aw-qt.ini file.
3. Add the aw-table-watcher to autostart_modules to enable auto-start. It should look like this:

[aw-qt]
autostart_modules = ["aw-server", "aw-watcher-afk", "aw-watcher-window", "aw-watcher-table"]

[aw-qt-testing]
autostart_modules = ["aw-server", "aw-watcher-afk", "aw-watcher-window", "aw-watcher-table"]

DEV setup

Install

virtualenv venv # create virtual environment
venv\Scripts\activate # activate virtual environment
poetry install # install required packages

Run

poetry run aw-watcher-table [--testing] [-v] [--verbose]

Build

pyinstaller --clean pyinstaller.spec

Test

1. Move the aw-watcher-table folder to the Activity Watch installation folder
2. Restart Activity Watch
3. Right click the Activity Watch tray icon. Under Modules find the aw-table-watcher. Check it to start the aw-watcher-table.