Skip to content

Instantly share code, notes, and snippets.

@sgraham785
sgraham785 / pgsql_upsert.sql
Created March 23, 2018 15:45
Examples of PostgreSQL Upsert
INSERT INTO users (id, level)
VALUES (1, 0)
ON CONFLICT (id) DO UPDATE
SET level = users.level + 1;
INSERT INTO users (id, email)
VALUES (1, [email protected])
ON CONFLICT (id) DO UPDATE
SET email = EXCLUDED.email;
@sgraham785
sgraham785 / auto-git-tag
Created May 24, 2018 16:54
auto-git-tag the npm version when publishing
{
"scripts": {
"postpublish" : "PACKAGE_VERSION=$(cat package.json | grep version | head -1 | awk -F: '{ print $2 }' | sed 's/[\",]//g' | tr -d '[[:space:]]') && git tag $PACKAGE_VERSION && git push --tags"
}
}
Where node binary is available:
PACKAGE_VERSION=$(node -p -e "require('./package.json').version")
#!/bin/bash
#
# USAGE: sh whois.sh /path/to/file.txt
# RESULT: domain.com ORG_NAME
for domain in `cat $1`
do
# str_domain=${domain#www.} # strip a leading www.