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)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env python3 | |
# Free Open Source Software released under GPLv2 | |
# see http://www.gnu.org/licenses/gpl-2.0 | |
# Author: Florian Knodt <git@adlerweb.info> | |
# Original Author: Tilman Schmidt <tilman@imap.cc> | |
# Contributor: Peter Pawn @ IP Phone Forum | |
# inspired by http://www.administrator.de/contentid/214598 | |
# Requirements (for example via pip): graypy, requests |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#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; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import sys | |
import json | |
import base64 | |
import argparse | |
from binascii import Error as BinasciiError | |
from urllib.parse import urlparse, parse_qs, urlencode, urlunparse, parse_qsl | |
version = "0.1" | |
def urlsafe_base64_decode(s): |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#Maintainer: Matthias Mailänder <matthias at mailaender dot name> | |
#Contributor NiNjA <heinep at gmail dot com> | |
#Contributor float <flo.at at gmx dot de> | |
#Contributor adlerweb <aur at adlerweb dot info> | |
pkgname=s25rttr | |
pkgver=0.9.5 | |
pkgrel=3 | |
pkgdesc="Return to the Roots is a reimplementation of Settlers II (Die Siedler II) by BlueByte Software GmbH. Put the files from the original game in the folder (/usr/share/s25rttr/S2/)" | |
arch=('i686' 'x86_64') |
When updating a venv to a newer python version you need to reinstall all locally install pip packages. This script can be pointed at the previous versions site-packages directory and output a string containing all previously installed packages, suitable to pass to pip install.
(Search-foo: Might help if you are running HomeAssistant inside a venv and, after upgrading python, integrations are not loaded)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/usr/bin/env python3 | |
# pip install pyyaml pyyaml-include | |
import yaml | |
from yamlinclude import YamlIncludeConstructor | |
import os | |
import sys | |
base_dir = os.path.expanduser('~') + '/.homeassistant/' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
pkgbase = zfs-linux-rc | |
pkgver = 2.2.0_rc3_6.4.7.arch1.2 | |
pkgrel = 1 | |
url = https://zfsonlinux.org/ | |
arch = x86_64 | |
license = CDDL | |
makedepends = linux-headers=6.4.7.arch1-2 | |
depends = kmod | |
depends = zfs-utils-rc=2.2.0_rc3 | |
depends = linux=6.4.7.arch1-2 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
pkgbase = zfs-utils-rc | |
pkgdesc = Kernel module support files for the Zettabyte File System. | |
pkgver = 2.2.0_rc3 | |
pkgrel = 1 | |
url = http://zfsonlinux.org/ | |
install = zfs-utils.install | |
arch = x86_64 | |
groups = archzfs-linux-rc | |
license = CDDL | |
makedepends = python |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
curl -u apikey:<API KEY FROM DASHBOARD API TAB> --include \ | |
--request POST \ | |
--header "Content-Type: application/json" \ | |
--data-binary "{ | |
\"deviceid\": <DEVICE ID LISTED ON DEVICE PAGE>, | |
\"body\": \"Hello world\" | |
}" \ | |
'https://dashboard.hologram.io/api/1/sms/incoming' |
NewerOlder