Skip to content

Instantly share code, notes, and snippets.

View mpneuried's full-sized avatar
🏠
Working from home

M. Peter mpneuried

🏠
Working from home
43 followers · 12 following
View GitHub Profile
@mpneuried
mpneuried / postgres_add_json_sub_array_unique.sql
Last active May 6, 2024 13:32
Add and remove elements unique to a Postgres jsonb sub key: Short a Set implemetation
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 *;
@mpneuried
mpneuried / Makefile
Last active May 4, 2024 13:46
Simple Makefile to build, run, tag and publish a docker containier to AWS-ECR
# 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)
@mpneuried
mpneuried / spideroctocats.coffee
Created March 25, 2013 09:42
Spider all octocats
fs = require( "fs" )
request = require( "request" )
async = require( "async" )
### call this in the octocats list:
list = []
$( "img" ).each ( i, el )->
#console.log arguments
_src = $( @ ).data( "src" )
@mpneuried
mpneuried / jquery-ajax-json-post.coffee
Created November 18, 2015 07:01
jQuery: How to post with a json body
_data =
foo: 23
bar: 42
bazz: null
$.ajax
url: _path
type: "POST"
data: JSON.stringify( _data )
contentType: "application/json; charset=utf-8"
@mpneuried
mpneuried / update-hosts.sh
Last active January 19, 2020 08:45 — forked from bzerangue/update-hosts.sh
A small shell script that will add and remove lines from the hosts file. Originally created by Claus Witt, http://clauswitt.com/319.html.
#! /bin/sh
# @author: Claus Witt
# http://clauswitt.com/319.html
# Adding or Removing Items to hosts file
# Use -h flag for help
DEFAULT_IP=127.0.0.1
IP=${3:-$DEFAULT_IP}
@mpneuried
mpneuried / README.md
Last active December 27, 2019 07:20
AWS SQS Message pump

AWS SQS Message pump

This script will pump AWS SQS Messages from one queue into another queue.

Usage

./pump_sqs.sh {profile} {source-sqs-url} {target-sqs-url} [{iterations}]
@mpneuried
mpneuried / publish_docs.sh
Created June 13, 2019 07:29
Script to generate and "publish/copy" a local doc folder to another folder taht could be synced via dropbox/onedrive/google-drive ... it write keep the latest folder and keep archived versions as zip
#!/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'
@mpneuried
mpneuried / update_ec2_security_ip.sh
Created December 20, 2018 11:19
AWS EC2 Security Groups: Revoke old and add new current ip to a list of rules based ob the description
#!/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
####################
@mpneuried
mpneuried / pow.yaml
Created May 11, 2019 18:27 — forked from frenck/pow.yaml
Sonoff POW R2 Washing Machine Sensor Example
esphomeyaml:
name: pow
platform: ESP8266
board: esp01_1m
board_flash_mode: dout
wifi:
ssid: 'Demo'
password: 'Livestream'
@mpneuried
mpneuried / cron.sh
Last active July 9, 2018 08:27
bash helpers
# CRON: crontab header to run node and grunt within a cron job
#!/bin/sh
SHELL=/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin