gpascale

WITH sz AS (
  SELECT nspname || '.' || relname AS "relation",
      pg_size_bytes(pg_size_pretty(pg_relation_size(C.oid))) / (1024.0 * 1024.0 * 1024.0) AS "size_gb",
      pg_size_pretty(pg_relation_size(C.oid)) AS "size"
  FROM pg_class C
  LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
  WHERE nspname NOT IN ('pg_catalog', 'information_schema')
  ORDER BY pg_relation_size(C.oid) DESC
  LIMIT 50
)

gpascale

connection = engine.connect()
trans = connection.begin()
try:
    connection.execute("DELETE * FROM blah")
    connection.execute("INSERT INTO blah VALUES ('blah')")
    trans.commit()
except:
    trans.rollback()
    raise

gpascale

"$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null 2>&1 && pwd )"

gpascale

const extractJWTPayload = (jwt) => {  
  const jwtComponents = jwt.split('.');
  // A JWT string is divided into 3 components, the second of which
  // contains the payload (user information) which is what we care about.
  if (jwtComponents.length !== 3)
    throw new Error('invalid jwt');
  // Base64 decode with urlsafe character set
  const decoded = atob(jwtComponents[1].replace(/_/g, '/').replace(/-/g, '+'));
  return JSON.parse(decoded).data;
}

gpascale

psql --host=mypostgresql.c6c8mwvfdgv0.us-west-2.rds.amazonaws.com --port=5432 --username=

gpascale

fetch('/myurl', {
  method: 'POST',
  credentials: 'include',
  headers: { 'Content-Type': 'application/json' },
  body: JSON.stringify({ foo, bar })
})

gpascale

# property validation
expect(result).to.all.have.property('propName');
expect(result).to.all.have.property('propName', 'propVal');
expect(obj).to.have.deep.property('field1.field2').that.is.oneOf([ 0, 1, 2 ])
expect(obj).to.have.deep.property('field1.field2').that.is.within(0, 2)

gpascale

-- Lowercase all files in a directory
for f in `ls`; do mv "$f" "`echo "$f" | awk '{print tolower($0)}'`"; done

gpascale

lsof -ti :<port> | xargs kill 

gpascale

PS1="\033[32m\u\033[m@\033[33m\h \033[34m\w\n\033[m$ "