tym-xqo

# Create this file and save in your home directory
# chmod 600 ~/my.safety (won't protect it from root, but better than nothing)

[client]
user=$USER
password=$PASSWD

# put your actual MySQL username and password in place of $USER and $PASSWD above.

tym-xqo

#!/bin/bash

# Stop boot2docker processes
boot2docker stop
boot2docker delete

# Remove boot2docker executable
sudo rm /usr/local/bin/boot2docker

# Remove boot2docker ISO and socket files

tym-xqo

.pyc

# Virtualenv stuffs
.Python
[Bb]in
[Ii]nclude
[Ll]ib
[Ss]cripts
pyvenv.cfg
pip-selfcheck.json

tym-xqo

Same query EXPLAIN plan run from my local machine vs. from shell on qa.iadops.com

My laptop:

oao_trial=> explain analyze insert into test values (7418880);
                                         QUERY PLAN
--------------------------------------------------------------------------------------------
 Insert on test  (cost=0.00..0.01 rows=1 width=0) (actual time=0.280..0.280 rows=0 loops=1)
   ->  Result  (cost=0.00..0.01 rows=1 width=0) (actual time=0.002..0.004 rows=1 loops=1)

tym-xqo

BEGIN;

CREATE EXTENSION pgcrypto;

CREATE OR REPLACE FUNCTION sha1(text)
RETURNS character varying AS
$BODY$
BEGIN
RETURN ENCODE(public.DIGEST($1, 'sha1'), 'hex');
END;

tym-xqo

#!/bin/bash

# Add add a line for the Postgres repository
echo "deb http://apt.postgresql.org/pub/repos/apt/ trusty-pgdg main" >> /etc/apt/sources.list.d/pgdg.list
# Import the repository signing key
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | \
  sudo apt-key add -
  
# Update the package lists, and install psql client  
sudo apt-get update && apt-get install postgresql-client-9.4

tym-xqo

#!/usr/bin/env python
# coding: utf-8

import os
import forecastio
import json
from time import strftime

# Get an API key at https://developer.forecast.io
#  and add to your local environment

tym-xqo

psql -h qa.iadops.com -p 5433 -U<username> \
-c "select row_to_json(<table>) from <table>;" \
-d oao_trial -At > <table>.json

tym-xqo

#!/bin/bash

# Standard `docker exec -t` doesn't create a full tty, and has no $TERM set.
# This creates problems for me sometimes (I like the `clear` command, and
    # psql complains a bit if the client is not a functional terminal).
# I do the command below enough that I made this script.
# Pass it the name or ID of a running container, and Bob's your uncle.


while true;

tym-xqo

#!/bin/bash

# Use this in Dockerfile ENTRYPOINT directive to source variables from /secret/env and export to the P1 environment

if [ -f /secret/env ]; then
    set -a
    . /secret/env
# Below keeps this idempotent if deployed to non-k8s environment (assuming the same env file is passed via --env-file at runtime)
else
    mkdir -p /secret