fhgbaguidi

SELECT pid, pg_blocking_pids(pid) AS blocked_by, query AS blocked_query, backend_start
FROM pg_stat_activity
WHERE pg_blocking_pids(pid)::TEXT != '{}';

fhgbaguidi

# Install GH cli
https://github.com/cli/cli#installation

# set GH_TOKEN env var
export GH_TOKEN=<<your_PAT_with_repo_access>>



# delete releases
$ gh release list | sed 's/|/ /' | awk '{print $1, $8}' | while read -r line; do gh release delete -y "$line"; done

fhgbaguidi

[alias]
        co = checkout
        b = branch
        cob = checkout -b
        cm = commit -m
        s = status -sb
        todo = ! git grep --extended-regexp -I --line-number --break --heading --color=auto 'TODO|FIXME'
        p = push
        ll = log --oneline
        last = log -1 HEAD --stat

fhgbaguidi

FROM python:2.7
RUN addgroup --gid 1002 --system app
RUN adduser -uid 1002 --system --gid 1002 app
USER app
ENTRYPOINT ["python", "-m", "SimpleHTTPServer", "8080"]

fhgbaguidi

curl -s "https://github.com/api/v3/orgs//repos?access_token=&per_page=200" | jq ".[].ssh_url" | xargs -n 1 git clone --recursive

fhgbaguidi

#bin/bash

find . -type d -depth 1 -exec git --git-dir={}/.git --work-tree=$PWD/{} pull origin master \;

#https://stackoverflow.com/questions/3497123/run-git-pull-over-all-subdirectories