James Rutherford jimr

## keybase.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jimr
                / keybase.md
            
            
              Created
              September 27, 2016 08:11
            
          
    Keybase proof

I hereby claim:

I am jimr on github.
I am jimr (https://keybase.io/jimr) on keybase.
I have a public key whose fingerprint is 788D 1F2D A813 72EA 42A5  350A C19F 559A 4045 40D7

To claim this, I am signing this object:

  
## db_size_check.sql
SELECT
    CONCAT(table_schema, '.', table_name) as 'table',
    CONCAT(ROUND(table_rows / 1000000, 2), 'M') rows,
    CONCAT(ROUND(data_length / (1024 * 1024 * 1024), 2), 'G') data,
    CONCAT(ROUND(index_length / (1024 * 1024 * 1024), 2), 'G') idx,
    CONCAT(ROUND((data_length + index_length) / (1024 * 1024 * 1024), 2), 'G') total_size,
    ROUND(index_length / data_length, 2) idxfrac
FROM information_schema.TABLES
-- WHERE table_schema = 'some_db'
ORDER BY data_length + index_length DESC

## pagination.py
#!/usr/bin/env python
# -*- coding: utf-8 -*-

import flickr

flickr.API_KEY = '<your API key>'
flickr.API_SECRET = '<your API secret>'

page = 1
per_page = 10

## locations.py
#!/usr/bin/env python
# -*- coding: utf-8 -*-

import flickr

flickr.API_KEY = '<your API key>'
flickr.API_SECRET = '<your API secret>'

# get some photos
photos = flickr.photos_search(tags='manhattan', page='1', per_page='10')

## email_finder.py
import re

pattern = re.compile(
    r'(mailto:)?(?P<email>[^(\s|<|\[))]*@[^\s]*\.[^(\s|>|;|,|\])]*)'
)

test_data = '''
    This is a@b.com string with some Email Addresses
    <email@addresses.com> in it. There are also
    some mailto:test@example.com addresses in here too.

## coord_cleaner.py
def clean_point(point):
    # junk
    point = point.strip()
    junk = [u'\ufeff', ' ', u'\xa0', u'\u2013']  # [,  ,  , –]
    for symbol in junk:
        point = point.replace(symbol, '')

    point = point.lstrip('+')
    point = point.lstrip("'")  # leading quote chars to fool excel
    point = point.lstrip(',')

## find_a_ride.py
import datetime
import sys
import urllib2
import xml.etree.ElementTree as ET

url = "https://nextbike.net/maps/nextbike-live.xml"
stations = sys.argv[1:]

xml = urllib2.urlopen(url).read()
root = ET.fromstring(xml)

## fake_request.py
def fake_request(method=None, fake_user=False):
    '''Returns a fake `WSGIRequest` object that can be passed to viewss.

    If `fake_user` is `True`, we attach a random staff member to the request.
    Even if not set, you can still do this manually by setting the `user`
    attribute on the returned object.

    The `GET` and `POST` `QueryDict` objects are mutable::

        req = fake_request(mutable=True)

## count_the_hours.py
#!/usr/bin/env python
# -*- coding: utf-8 -*-

import itertools
import re
import sys

from datetime import datetime as dt

pattern = re.compile(r'.* \[([^]]*) \+[0-9]+\] .*')

## shape_merge.py
#!/usr/bin/env python
# -*- coding: utf-8 -*-
#
# Requires pyshp: https://pypi.python.org/pypi/pyshp
#

import os
import shapefile
import shutil
import tempfile
	SELECT
	CONCAT(table_schema, '.', table_name) as 'table',
	CONCAT(ROUND(table_rows / 1000000, 2), 'M') rows,
	CONCAT(ROUND(data_length / (1024 * 1024 * 1024), 2), 'G') data,
	CONCAT(ROUND(index_length / (1024 * 1024 * 1024), 2), 'G') idx,
	CONCAT(ROUND((data_length + index_length) / (1024 * 1024 * 1024), 2), 'G') total_size,
	ROUND(index_length / data_length, 2) idxfrac
	FROM information_schema.TABLES
	-- WHERE table_schema = 'some_db'
	ORDER BY data_length + index_length DESC
	#!/usr/bin/env python
	# -- coding: utf-8 --

	import flickr

	flickr.API_KEY = '<your API key>'
	flickr.API_SECRET = '<your API secret>'

	page = 1
	per_page = 10
	import re

	pattern = re.compile(
	r'(mailto:)?(?P<email>[^(\s\|<\|\[))]@[^\s]\.[^(\s\|>\|;\|,\|\])]*)'
	)

	test_data = '''
	This is a@b.com string with some Email Addresses
	<email@addresses.com> in it. There are also
	some mailto:test@example.com addresses in here too.
	def clean_point(point):
	# junk
	point = point.strip()
	junk = [u'\ufeff', ' ', u'\xa0', u'\u2013'] # [, , , –]
	for symbol in junk:
	point = point.replace(symbol, '')

	point = point.lstrip('+')
	point = point.lstrip("'") # leading quote chars to fool excel
	point = point.lstrip(',')
	import datetime
	import sys
	import urllib2
	import xml.etree.ElementTree as ET

	url = "https://nextbike.net/maps/nextbike-live.xml"
	stations = sys.argv[1:]

	xml = urllib2.urlopen(url).read()
	root = ET.fromstring(xml)
	def fake_request(method=None, fake_user=False):
	'''Returns a fake `WSGIRequest` object that can be passed to viewss.

	If `fake_user` is `True`, we attach a random staff member to the request.
	Even if not set, you can still do this manually by setting the `user`
	attribute on the returned object.

	The `GET` and `POST` `QueryDict` objects are mutable::

	req = fake_request(mutable=True)
	#!/usr/bin/env python
	# -- coding: utf-8 --

	import itertools
	import re
	import sys

	from datetime import datetime as dt

	pattern = re.compile(r'.* \[([^]]) \+[0-9]+\] .')
	#!/usr/bin/env python
	# -- coding: utf-8 --
	#
	# Requires pyshp: https://pypi.python.org/pypi/pyshp
	#

	import os
	import shapefile
	import shutil
	import tempfile