jimr

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:

jimr

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

jimr

#!/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

jimr

#!/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')

jimr

import re

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

test_data = '''
    This is [email protected] string with some Email Addresses 
    <[email protected]> in it. There are also
    some mailto:[email protected] addresses in here too.

jimr

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(',')

jimr

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)

jimr

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)

jimr

#!/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]+\] .*')

jimr

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

import os
import shapefile
import shutil
import tempfile