ghickman

WITH ethnicities AS (
          SELECT
            Patient_ID,
            date,
            ethnicity_code,
            ROW_NUMBER() OVER (
                PARTITION BY Patient_ID ORDER BY date DESC
            ) AS row_num
          FROM (
            SELECT

ghickman

#!/usr/local/bin/bash

# use bash 4 from homebrew

set -e
shopt -s globstar

FORMAT="%Y-%m-%d_%H-%M-%S"

# Video files

ghickman

### Keybase proof

I hereby claim:

  * I am ghickman on github.
  * I am ghickman (https://keybase.io/ghickman) on keybase.
  * I have a public key whose fingerprint is D05C 5A1C 502A 3734 9698  2B15 EEC6 7845 093B 01FD

To claim this, I am signing this object:

ghickman

https://www.python.org/download/releases/3.3.4/ <- Python 3.4 released

ghickman

AUTHENTICATION_BACKENDS = (
    'social_auth.backends.google.GoogleOAuth2Backend',
    'django.contrib.auth.backends.ModelBackend',
)
LOGIN_REDIRECT_URL = '/'

GOOGLE_OAUTH2_CLIENT_ID = os.environ['GOOGLE_OAUTH2_CLIENT_ID']
GOOGLE_OAUTH2_CLIENT_SECRET = os.environ['GOOGLE_OAUTH2_CLIENT_SECRET']
GOOGLE_WHITE_LISTED_DOMAINS = ['incuna.com']
SOCIAL_AUTH_USER_MODEL = 'auth.User'

ghickman

from django.template.defaultfilters import slugify

def generate_slug(cls, value):
    count = 1
    slug = slugify(value)
    if not isinstance(cls, type):
        cls = cls.__class__

    def _get_query(cls, **kwargs):
        if cls.objects.filter(**kwargs).count():

ghickman

[trove]
username=me
password=secret
url=http://trove.example.com

ghickman

#!/usr/bin/env python
"""
midwich_image_fix.py

Created by Lee Perry on 2011-10-30.
Copyright (c) 2011 iCode Solutions Ltd. All rights reserved.
"""

import sys
import csv

ghickman

<advancedsettings>
    <moviestacking action="append">
        <regexp>(.+)\(([0-9])\)()(\.[^.]+)$</regexp>
    </moviestacking>
</advancedsettings>

ghickman

" Remember last location in file
if has("autocmd")
  au BufReadPost * if line("'\"") > 0 && line("'\"") <= line("$")
    \| exe "normal g'\"" | endif
endif