tchen

Note, this content came from reddit (https://www.reddit.com/r/homeautomation/comments/eul2au/did_amazon_finally_brick_my_repurposed_dash/).

Saved here for posterity.

---

I wanted to add a little bit to this tonight after messing around with the five buttons I purchased on eBay. I've ended up with three bricked buttons after 'taking one for the team' but here's what I've got.

The following sites are blocked in PiHole:

tchen

// How to set up a AWS SDK client using credentials coming from other than the regular AWS_ACCESS_KEY_ID
// e.g. if you have multiple sets of credentials for doing cross-account stuff
import (
	"os"

	"github.com/aws/aws-sdk-go-v2/aws"
	"github.com/aws/aws-sdk-go-v2/service/s3"
)

tchen

# When exporting excel spreadsheets with merged cells, only the first cell of the merged cell has a value
# This snippet allow you to take the value from the first cell for all the other cells within the merged range
# Tested with openpyxl 3.0.7 as of 2021-06-17
#
# References:
#   https://stackoverflow.com/questions/39574991/how-to-detect-merged-cells-in-excel-with-openpyxl
#   https://openpyxl.readthedocs.io/en/stable/api/openpyxl.worksheet.merge.html
import openpyxl

def parent_of_merged_cell(cell):

tchen

import datetime
from time import sleep
from bleson import get_provider, Observer

def c2f(val):
    return round(32 + 9*val/5, 2)

last = {}

def temp_hum(values, battery, address):

tchen

To use this, place the docker-compose.yaml file in a new directory. Then run:

docker-compose up

Once up, you can access http://localhost:8080 to administrate the db. Login with: postgres/example

Or run this from another terminal for command line access:

docker-compose exec db bash

tchen

# An example tornado request handler that handles both JSON POST request
# bodies and x-www-form-urlencoded POST bodies.
#
# The benefit of JSON request bodies are more complicated and potentially
# nested dict and list data types.
#
# One drawback to JSON request bodies is that arguments can come in
# different types, so handlers will need to perform additional checks.
# With x-www-form-urlencoded fields, all argument values are strings, if
# they exist.

tchen

# https://docs.python.org/3/library/venv.html

# Under Ubuntu Xenial64, install the following package before getting started

sudo apt-get install python3-venv

# Usage: python3 -m venv [directory]

python3 -m venv ~/env/web
. ~/env/web/bin/activate

tchen

import datetime
datetime.datetime.fromtimestamp(
    int("1284101485")
).isoformat()

tchen

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

tchen

/**
 *  Note: First, browser through all the images for the home. Then paste the following snippet into the console.
 *  Images will be saved to the download directory.
 */
var jq = document.createElement('script');
jq.src = "https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js";

document.getElementsByTagName('head')[0].appendChild(jq);

// ... give time for script to load, then type.