Peter Fiddes hawksight

Prereq:

apt-get install zsh
apt-get install git-core

Getting zsh to work in ubuntu is weird, since sh does not understand the source command. So, you do this to install zsh

wget https://github.com/robbyrussell/oh-my-zsh/raw/master/tools/install.sh -O - | zsh

Command Line Crash Course

Cheatsheets

Raspberry Pi

Related tutorial: http://raspberrypiguide.de/
Command Line Cheatsheet: https://gist.github.com/hofmannsven/8392477

Setup

Find all available devices arp -a

Locate Raspberry (b8:27:eb) in Network: Pi Finder

SSH

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

Ben's VirtualEnv Cheatsheet

This cheat sheet describes my usage/implementation of virtualenv with virtualenv wrapper and the bash foo that I added with the help of many blogs to make it all tick together in fun land.

Quick Reference

$ echo $WORKON_HOME
/Users/benjamin/.virtualenvs

$ echo $PROJECT_HOME

How to install redis-cli and psql client on your machine with Docker

Preparing docker images

We will use minimalistic Linux distribution called Alpine (5MB)

Dockerfile of redis-cli

FROM alpine:latest
RUN apk --update add redis

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

	---
	- name: Reboot a host and wait for it to return
	hosts: somehost
	remote_user: root
	tasks:
	# Send the reboot command
	- shell: shutdown -r now

	# This pause is mandatory, otherwise the existing control connection gets reused!
	- pause: seconds=30

	import collections

	def dict_merge(dct, merge_dct):
	""" Recursive dict merge. Inspired by :meth:``dict.update()``, instead of
	updating only top-level keys, dict_merge recurses down into dicts nested
	to an arbitrary depth, updating keys. The ``merge_dct`` is merged into
	``dct``.

	:param dct: dict onto which the merge is executed
	:param merge_dct: dct merged into dct

	#!/usr/bin/env python3

	from plumbum import local, cli, FG, BG, TF, ProcessExecutionError, colors
	from plumbum.cmd import tput, git
	from contextlib import contextmanager
	from functools import partial

	# This can be hard coded to a repo location, or cwd, etc.
	# REPOLOC = local.path(__file__) / '..'
	REPOLOC = local.env.home / 'git'