tym-xqo

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

import random
from AppKit import NSPasteboard, NSArray

def namer():
    adjectives = ("aliased",
        "angelic",
        "anonymous",

tym-xqo

#!/bin/bash
git clone [email protected]:OAODEV/k8s-resources.git
kubectl replace --force -f k8s-resources/warehouse/postgres.yaml

tym-xqo

#!/bin/bash
gcloud docker -a
docker pull us.gcr.io/lexical-cider-93918/oao-postgres:_build.72c78d4
docker run -id --name=oao-postgres-data us.gcr.io/lexical-cider-93918/oao-postgres:_build.72c78d4 tail -F /dev/null
sleep 20
docker run -d --name=oao-postgres-service --volumes-from=oao-postgres-data us.gcr.io/lexical-cider-93918/oao-postgres:_build.72c78d4
docker pull us.gcr.io/lexical-cider-93918/dbadmin:_build.f00437d
docker run -id --name=dbadmin-data us.gcr.io/lexical-cider-93918/dbadmin:_build.f00437d script tail -F /dev/null
sleep 20
docker run -d --name=dbadmin-service --volumes-from=dbadmin-data --link oao-postgres-service:postgres us.gcr.io/lexical-cider-93918/dbadmin:_build.f00437d

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

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

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

#!/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

#!/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

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

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)