Phil Vacca pvacca

Top 10 Examples of AWS CLI Query

List Volumes showing attachment using Dictionary Notation

$ aws ec2 describe-volumes \
  --query 'Volumes[*].{ID:VolumeId,InstanceId:Attachments[0].InstanceId,AZ:AvailabilityZone,Size:Size}'
[
    {
        "InstanceId": "i-a071c394",

AWS CLI JMESPath cheatsheet

Random query recipes of JMESPath for the AWS CLI tools that I might have written or stumbled upon.

Examples

This gist is an implementation of http://sirile.github.io/2015/05/18/using-haproxy-and-consul-for-dynamic-service-discovery-on-docker.html on top of Docker Machine and Docker Swarm.

	The following instructions will help you easily deploy out a SaltStack Master server with some basic settings.


	Step 1.
	Install docker on your machine where you want to run your SaltStack master. If you want to run this on Windows you could install virtualbox and deploy our a Linux VM that has docker installed on it. Additional network setup instructions are available upon request.

	https://docs.docker.com/engine/installation/

	Step 2.
	Confirm docker is installed and running correctly

	#!/usr/bin/env python

	import os
	import sys
	import glob
	import argparse

	from subprocess import Popen, PIPE, STDOUT

	try:

	/**
	* This Google Sheets script keeps data in the specified column sorted any time
	* the data changes.
	*
	* After much research, there wasn't an easy way to automatically keep a column
	* sorted in Google Sheets, and creating a second sheet to act as a "view" to
	* my primary one in order to achieve that was not an option. Instead, I
	* created a script that watches for when a cell is edited and triggers
	* an auto sort.
	*

	user nginx;
	worker_processes 4;
	error_log /var/log/nginx/error.log warn;
	pid /var/run/nginx.pid;
	events {
	worker_connections 1024;
	}
	http {
	include /etc/nginx/mime.types;
	default_type application/octet-stream;

	CREATE EXTENSION dblink;


	-- customize start
	CREATE SERVER pgbouncer FOREIGN DATA WRAPPER dblink_fdw OPTIONS (host 'localhost',
	port '6432',
	dbname 'pgbouncer');

	CREATE USER MAPPING FOR PUBLIC SERVER pgbouncer OPTIONS (user 'pgbouncer');
	-- customize stop

	\set csvon '\\f '','' \\t off \\timing off \\pset format unaligned \\pset border 0 \\pset footer off'
	\set csvoff '\\f ''\|'' \\t off \\timing on \\pset format aligned \\pset border 2 \\pset footer on'

	server {
	listen 127.0.0.1:9000;
	location / {
	proxy_pass http://unix:/var/run/docker.sock:/;
	}
	}