Sillson

class CredFinder
  attr_accessor :cred_hsh
  def initialize(urn)
    puts "***** \nSapSucking Creds For -- \n#{urn} \n*****"
    @cms_urn = urn
    @cred_hsh = {'dbname'=>'','host'=>'','port'=>'','user'=>'', 'password'=>''}
    build_creds
  end

  def build_creds

Sillson

do
$$
declare
  l_rec record;
begin
  for l_rec in (select foreign_table_schema, foreign_table_name 
                from information_schema.foreign_tables) loop
     execute format('drop foreign table %I.%I cascade', l_rec.foreign_table_schema, l_rec.foreign_table_name);
  end loop;
end;

Sillson

do
$$
declare
  l_rec record;
begin
  for l_rec in (select foreign_table_schema, foreign_table_name 
                from information_schema.foreign_tables) loop
     execute format('drop foreign table %I.%I cascade', l_rec.foreign_table_schema, l_rec.foreign_table_name);
  end loop;
end;

Sillson

CREATE OR REPLACE VIEW public.active_locks AS 
 SELECT t.schemaname,
    t.relname,
    l.locktype,
    l.page,
    l.virtualtransaction,
    l.pid,
    l.mode,
    l.granted
   FROM pg_locks l

Sillson

CREATE SERVER [SERVER_NAME]
        FOREIGN DATA WRAPPER postgres_fdw
        OPTIONS (host '[YOUR_HOST]', port '[PORT]', dbname '[DB_NAME]', sslmode 'require');
CREATE USER MAPPING FOR [DB_USER]
        SERVER [SERVER_NAME]
        OPTIONS (user '[FOREIGN_USER]', password '[FOREIGN_PW]');

Sillson

install.packages( 
  lib  = lib <- .libPaths()[1],
  pkgs = as.data.frame(installed.packages(lib), stringsAsFactors=FALSE)$Package,
  type = 'source'
)

Sillson

echo "Downloading the latest backup from the Core Servers"
echo
curl --insecure -O https://wherever-bz2-backup-origin.sql

echo "Download complete"
echo
echo "Unzipping this beast, and plopping it right in the core db on AWS"
echo
bunzip2 < backup.sql.bz2 | mysql -u [USER] -pw[PW] --host [HOST] [DBNAME]

Sillson

</style><script>function insertAfter(referenceNode, newNode) {
   referenceNode.parentNode.insertBefore(newNode, referenceNode.nextSibling);
   console.log(referenceNode.parentNode);
}

var div = document.getElementsByClassName("row-grid");

var locationName = "[ENTER LOCATION NAME]";
var locationCity = "[ENTER LOCATION CITY]";
var locationState = "[ENTER LOCATION STATE]";

Sillson

class OrphanAnnie
  class << self
    def perform
      fake_orphan_locations = mom_is_that_you
      write_to_loggers("#{fake_orphan_locations}")
      rehome_fake_orphans
      write_to_loggers("There are #{Widget.orphans.count} orphans left.")
      Resque.enqueue(WidgetCleanupJob)
    end

Sillson

# How to find duplicate website objects in a CMS!

#map an array of all websites 'owner_id'
loc_ids = Website.all.map {|web| web.owner_id}

#returns the duplicates
loc_ids.select{ |id| loc_ids.count(id) > 1}.uniq