Ever wanted to control your lights with some more logic than simple timers? The rescue is here! With [programname] you will control your lights with google calendar! Simple create an event in google calendar and the lights will power on when the event starts and off when the event ends. Want your light to power on every day? Create a recurring event!

To install the tellstick using debian/ubuntu, follow this guide: http://developer.telldus.com/wiki/TellStickInstallationUbuntu

To install the tellstick on Raspberry PI with Raspbian, follow the following instructions: http://www.telldus.com/forum/viewtopic.php?p=13857#p13857

First make sure services/gcal_fetcher.py and services/event_dispatcher.py is executeable (chmod +x file). Open crontab with:

$ crontab -e

Add theese two lines, make sure to change the path to the folder below: # Fetch modifications in google calender every day at 12:00 0 12 * * * /usr/bin/python /path_to/services/gcal_fetcher.py # Dispatch events every minute */1 * * * * /usr/bin/python /path_to/services/event_dispatcher.py # Poll sensor data every 10 minutes */10 * * * * /usr/bin/python /path_to/services/sensor_poller.py

TODO: Write about running services

• Python
• Flask
• Telldus tellstick
• Pytz
• google-api-python-client: https://developers.google.com/google-apps/calendar/setup

Linux: /etc/tellstick.conf Self-learning: tdtool --learn device

You also need to add the service to the sqlite database:

insert into devices(device_id, name, type) VALUES(id, name, type);

Run

$ python ui/app.py

To start a development server, go to the servers IP port 5000 in the browser (or smartphone).

sudo apt-get install nginx-full uwsgi uwsgi-plugin-python

File /etc/nginx/sites-enabled/default: server { listen 3000;

    root /path_to_project/ui;
    index index.html index.htm;

    server_name 0.0.0.0;
    access_log /var/log/nginx/default_access.log;
    error_log /var/log/nginx/default_error.log;

    location / {
            include uwsgi_params;

            uwsgi_pass unix://tmp/uwsgi_vhosts.sock;
            uwsgi_param UWSGI_CHDIR /path_to_project/ui;
            uwsgi_param UWSGI_PYHOME /path_to_project/ui;
            uwsgi_param UWSGI_SCRIPT code;
    }

    location /static {
            alias /path_to_project/ui/static;
    }

}

File /etc/uwsgi/apps-enabled/vhosts.ini [uwsgi] plugins = python gid = www-data uid = www-data vhost = true logdate socket = /tmp/uwsgi_vhosts.sock master = true processes = 1 harakiri = 20 limit-as = 128 memory-report no-orphans

Permissions:

• code.py should be executeable by www-data
• db/ and db/temp.db should be read and writeable by www-data

CREATE TABLE device_status(id integer primary key, device_id integer, status integer, last_update integer);

CREATE TABLE devices(device_id integer, name text, type integer);

CREATE TABLE events(id integer primary key, device_id integer, auto integer, type integer, fire_at integer);

CREATE TABLE sensor_data(id integer primary key, device_id integer, value text, timestamp integer, type integer);

• Show temperature graphs for logged temperature data

ALTER TABLE events ADD COLUMN sunrise integer; ALTER TABLE events ADD COLUMN sunset integer; ALTER TABLE events ADD COLUMN mo integer; ALTER TABLE events ADD COLUMN tu integer; ALTER TABLE events ADD COLUMN we integer; ALTER TABLE events ADD COLUMN th integer; ALTER TABLE events ADD COLUMN fr integer; ALTER TABLE events ADD COLUMN sa integer; ALTER TABLE events ADD COLUMN su integer;