jaygooby

        RED="\[\033[0;31m\]"
     YELLOW="\[\033[0;33m\]"
 	  GREEN="\[\033[0;32m\]"
       BLUE="\[\033[0;34m\]"
  LIGHT_RED="\[\033[1;31m\]"
LIGHT_GREEN="\[\033[1;32m\]"
      WHITE="\[\033[1;37m\]"
 LIGHT_GRAY="\[\033[0;37m\]"
 COLOR_NONE="\[\e[0m\]"

jaygooby

select lea,  SUM(CASE WHEN school_type like '%primary%' THEN 1 ELSE 0 END) as `primary`, SUM(CASE WHEN school_type like '%secondary%' THEN 1 ELSE 0 END) as `secondary` from schools group by lea

jaygooby

#!/usr/bin/env bash

# Install using:
# bash < <(curl -s https://gist.githubusercontent.com/jaygooby/1248106/raw/6d8ef1c0c84a47a34a6890973c8d32d22466a736/os-x-ghostscript-imagemagick)

IM_TGZ=ImageMagick-x86_64-apple-darwin17.3.0.tar.gz
IM_URL=https://www.imagemagick.org/download/binaries/$IM_TGZ
IM_TMP_FILE=/tmp/$(basename $IM_URL)
IM_SUM="33849 17409"

jaygooby

// Jay Caines-Gooby, 2011
// @jaygooby on twitter
// jay@gooby.org
//
// Put this in your theme's functions.php file
// and any Youtube videos you embed by putting the 'watch' url on a line
// on it's own in a post or page won't get related videos shown at
// the end of the video.

// The 10 & 3 args here are the priority of the filter (10 is default)

jaygooby

# None of my own work. Munged from various other .screenrc recipes
#
# Don't use CTRL-A as the trigger because its stops the bash 
# cli navigation like CTRL-A for start of line to stop working
escape ^Gg

# We'd like to scroll in an xterm please
defscrollback 1024

# http://superuser.com/questions/126606/how-to-get-mac-os-x-terminal-app-and-screen-vim-scrolling-to-play-nice/316900#316900

jaygooby

function htmlreplace(a, b, element) {    
    if (!element) element = document.body;    
    var nodes = element.childNodes;
    for (var n=0; n<nodes.length; n++) {
        // MSIE doesn't have Node
        if (nodes[n].nodeType == 3) {
            var r = new RegExp(a, 'gi');

            // MSIE8 and less doesn't have textContent
            if (nodes[n].textContent) {

jaygooby

From: <Sebastian Coe> sebastiancoe389215@msn.com

Dear Sir/Madam
I am an Agent to London 2012 Olympics organising commitee (LOCOG). I play an intermediary role between local organizing committee (LOC) and any interested foreign company in any international competitive tender and my commission is usually 2% 
of the total contract value.

I wish to know if your company or you as an individual will be interested to participate in an international Tender for the supply of the following items:

1) T-shirt
2) Umbrellas/Tents,

jaygooby

gem 'apn_sender', :require => 'apn'
gem 'daemons'

jaygooby

We've received a report that your instance(s):

 Instance Id: i-9ab75ffa
 IP Address: 174.129.162.143



has been port scanning remote hosts on the Internet; check the information provided below by the abuse reporter.

This is specifically forbidden in our User Agreement: http://aws.amazon.com/agreement/

jaygooby

Overwrite untracked files in current branch from a remote branch

In a similar vein to git reset --hard feature/weavils you can just overwrite untracked working files (typically left over from branch experiments) which are part of the remote branch you're pulling like this:

git reset --hard origin/feature/weavils

Normally, if you tried git checkout feature/weavils you'd get warnings like untracked working tree files would be overwritten by merge, so hit them with the --hard hammer instead.

(Found via https://stackoverflow.com/q/17404316/391826 and one of the answers: https://stackoverflow.com/a/36824493/391826)