adlerweb

import datetime
import urllib.request
import json

weeknr = datetime.date.today().strftime("%V")
year = datetime.date.today().strftime("%Y")

url = "https://energy-charts.info/charts/power/data/de/week_"+year+"_"+weeknr+".json"
data = urllib.request.urlopen(url).read()
data = json.loads(data)

adlerweb

<?php
    $mysql_serv = 'localhost';
    $mysql_user = 'usblogger';
    $mysql_pass = 'usblogger';
    $mysql_datb = 'volkszaehler';

    $uuid_v = 1;
    $uuid_a = 2;
?>

adlerweb

#!/usr/bin/python

import redis
import pickle
import argparse


class RedisMigrate():

        def __init__(self, host, port, db):

adlerweb

#define BLINK_DELAY 100 //ms between blinks
#define BLINK_PAUSE 3 //3x DELAY for pause

void blinkDigit(byte digit) {
  for(byte i=0; i<digit; i++) {
    digitalWrite(LED_BUILTIN, HIGH);
    delay(BLINK_DELAY);
    digitalWrite(LED_BUILTIN, LOW);
    delay(BLINK_DELAY);
  }

adlerweb

/***************************************************************************
  IR Ferraris Reader
  2019 Adlerweb//Bitbastelei
  Florian Knodt - www.adlerweb.info

  Note: Just a few minutes of coding, not heavily tested, etc
 ***************************************************************************/

#include <Arduino.h>

adlerweb

<?php
/*
Usage:
  - platform: command_line
    name: foo
    command: "php -f /home/homeassistant/vzapi.php 1"
    unit_of_measurement: "W"

Todo:
  - Rewrite in Python

adlerweb

#include <LEDMatrixDriver.hpp>

extern "C" {
  #include "user_interface.h"
}

// This sketch draw marquee text on your LED matrix using the hardware SPI driver Library by Bartosz Bielawski.
// https://github.com/bartoszbielawski/LEDMatrixDriver
// Example written 16.06.2017 by Marko Oette, www.oette.info 

adlerweb

#include <Arduino.h>
#include <SPI.h>
#include <MCP23S17.h>
#include <Wire.h>
#include <LiquidCrystal_PCF8574.h>

extern "C" {
    #include "user_interface.h"
}

adlerweb

Using Channel-IDs (that's not UUID)

SELECT
  timestamp/1000 as time_sec, 
  data.value as value, 
  properties.value as metric
FROM data
  LEFT JOIN properties ON (properties.entity_id = data.channel_id)
  LEFT JOIN entities ON (entities.id = data.channel_id)

adlerweb

#include <ESP8266WiFi.h>
#include <ESP8266mDNS.h>
#include <PubSubClient.h>

const char* cfg_wifi_ssid = "freifunk-myk.de";
const char* cfg_wifi_pwd = "";

const char* mqtt_server = "deinserver.local";
const unsigned int mqtt_port = 1883;