| #!/bin/sh | |
| #colors | |
| COFF='\033[0m' | |
| CRED='\033[1;31m' | |
| CGREEN='\033[1;32m' | |
| CYELLOW='\033[0;33m' | |
| CCYAN='\033[1;36m' | |
| CBLUE='\033[1;34m' |
| esphomeyaml: | |
| name: pow | |
| platform: ESP8266 | |
| board: esp01_1m | |
| board_flash_mode: dout | |
| wifi: | |
| ssid: 'Demo' | |
| password: 'Livestream' |
| #!/bin/sh | |
| # This script will update your ec2 security group with the current ip of your connection. | |
| # To find the "old" rules the description is used | |
| # Requirements: | |
| # - aws-cli with configured profile: https://aws.amazon.com/de/cli/ | |
| # - jq: https://stedolan.github.io/jq/ | |
| # - curl | |
| #################### |
See http://randyzwitch.com/mapd-pjm-electricity-data/ for the data and pythons
script to create hourly_loads.csv (146MB) and
https://news.ycombinator.com/item?id=16458105 for discussion.
CREATE TABLE hourly_loads (
actual_date date,
zone_name text,
| // paste and execute it into the browser console. You can define ( GB, SSD [, index-of-box-content-class ] ) | |
| // https://www.apple.com/de/shop/browse/home/specialdeals/mac/macbook_pro | |
| // eventually there is a header then you can test the param index-of-box-content-class = 1 | |
| ((_gb, _ssd, content_idx) => { const _wrp = document.getElementsByClassName("box-content")[ content_idx || 0];Array.from(document.getElementsByClassName("specs")).forEach((el) =>{if (!(el.innerHTML.indexOf(_gb.toString() + " GB") > 0 && el.innerHTML.indexOf(_ssd.toString() + " GB") > 0)) {_wrp.removeChild(el.parentNode.parentNode.parentNode)}})})(16,512) |
| DAYMS = 1000 * 60 * 60 * 24 | |
| checkBirthday = ( now, bd, diff )-> | |
| # differ between next and last days (look back or forward) | |
| if diff > 0 | |
| start = new Date( now + " 00:00:00 +0000" ) | |
| end = new Date( start.valueOf() + ( DAYMS * diff ) ) | |
| year = new Date( end ).getFullYear() | |
| else | |
| end = new Date( now + " 00:00:00 +0000" ) |
| UPDATE public.mytable SET | |
| jsonfieldname = jsonb_set( jsonfieldname, '{json_obj_key}', array_to_json( | |
| ARRAY( | |
| SELECT DISTINCT( UNNEST( ARRAY( | |
| SELECT json_array_elements_text( COALESCE( jsonfieldname::json->'json_obj_key', '[]' ) ) | |
| ) || ARRAY['Element to add'] ) ) | |
| ) | |
| )::jsonb ) | |
| WHERE id = 23 | |
| RETURNING *; |
| querystring = require('querystring') | |
| crypto = require('crypto') | |
| parseRedisClients = ( raw, filter={} )-> | |
| clients = [] | |
| for line in raw.split( "\n" ) when line.length > 1 | |
| cl = querystring.parse( line, " ", "=" ) | |
| if Object.keys( filter ).length | |
| _match = true | |
| for _k, _v of filter when cl[ _k ] isnt _v |
| # import config. | |
| # You can change the default config with `make cnf="config_special.env" build` | |
| cnf ?= config.env | |
| include $(cnf) | |
| export $(shell sed 's/=.*//' $(cnf)) | |
| # import deploy config | |
| # You can change the default deploy config with `make cnf="deploy_special.env" release` | |
| dpl ?= deploy.env | |
| include $(dpl) |