emailrhoads

import code; code.interact(local=dict(globals(), **locals()))

emailrhoads

cd <path_to_dir_where_symlinks_should_be>
ln -s ../../../../../delorean/*.dl .

ln -s ../../../../../delorean/freddie_bubd*.dl .

emailrhoads

SELECT 
  nspname AS schemaname,relname,reltuples
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE 
  nspname NOT IN ('pg_catalog', 'information_schema') AND
  relkind='r' 
ORDER BY reltuples DESC;

emailrhoads

1. Confirm some SSL cert is busted

domain_name = "fmsso.fanniemae.com"
uri = URI::HTTPS.build(host: domain_name)
response = Net::HTTP.start(uri.host, uri.port, { 
  :use_ssl => true, 
  # :verify_mode => OpenSSL::SSL::VERIFY_NONE,
})
cert = response.peer_cert

emailrhoads

sudo apt purge postgresql-12

emailrhoads

git log -p -- Gemfile

emailrhoads

1. sudo su - postgres
2. createuser --interactive --pwprompt -p 5434 where 5434 is the port of your PG cluster

sudo su - postgres
psql
CREATE USER railsuser WITH PASSWORD 'railsuser' SUPERUSER CREATEDB;

emailrhoads

Version 9.6: sudo apt-get install postgresql-9.6 postgresql-contrib

emailrhoads

git for-each-ref --sort='-committerdate:iso8601' --format=' %(committerdate:iso8601)%09%(refname)' refs/heads

emailrhoads

select n.nspname as enum_schema,  
       t.typname as enum_name,  
       e.enumlabel as enum_value
from pg_type t 
   join pg_enum e on t.oid = e.enumtypid  
   join pg_catalog.pg_namespace n ON n.oid = t.typnamespace