kerin’s gists

kerin / gist:10155747

Created April 8, 2014 16:57

	default_errors = {
	'required': _('CANNOT_BE_BLANK'),
	'invalid': _('Enter a valid value'),
	}


	class YourProblemForm(CheckerWizardMixin, forms.Form):
	"""
	Gets the problem choices from the backend API.
	"""

kerin / gist:8705950

Last active August 29, 2015 13:55

	IntegrityError: (IntegrityError) duplicate key value violates unique constraint "panelists_pkey"

	DETAIL: Key (id)=(23845) already exists.

	'INSERT INTO panelists (panelist_id, pmxid, medium, facebook_id, twitter_id, twitter_screen_name, twitter_updated_at, twitter_leaders)
	VALUES (%(panelist_id)s, %(pmxid)s, %(medium)s, %(facebook_id)s, %(twitter_id)s, %(twitter_screen_name)s, %(twitter_updated_at)s, %(twitter_leaders)s)
	RETURNING panelists.id'
	{'medium': 'twitter', 'twitter_screen_name': u'ruthlovell', 'twitter_id': 90618500, 'pmxid': 431447, 'twitter_leaders': None, 'facebook_id': None, 'twitter_updated_at': None, 'panelist_id': None}

kerin / gist:8335474

Created January 9, 2014 15:05

	"""Gets list of panel members referenced in interaction json documents in
	specified date range, parse and add to redis.

	Usage:
	get_panel_members.py START_DATE END_DATE

	Arguments:
	START_DATE ISO format: YYYY-MM-DD
	END_DATE ISO format: YYYY-MM-DD

kerin / gist:8218072

Created January 2, 2014 11:44

	{547831: [{'demographics': {'bixdemo_television': '6',
	'profile_gender': '1',
	'profile_gross_household': '12'},
	'end_date': datetime.date(2011, 4, 24),
	'start_date': datetime.date(2009, 9, 3)},
	{'demographics': {'bixdemo_television': '6',
	'profile_gender': '1',
	'profile_gross_household': '13'},
	'end_date': datetime.date(2012, 1, 3),
	'start_date': datetime.date(2011, 4, 24)},

kerin / gist:8096502

Created December 23, 2013 12:43

	[datetime.date(2013, 6, 27), datetime.date(2013, 6, 28)]
	[datetime.date(2013, 7, 1), datetime.date(2013, 7, 2)]
	[datetime.date(2013, 7, 4), datetime.date(2013, 7, 5)]
	[datetime.date(2013, 7, 10), datetime.date(2013, 7, 11), datetime.date(2013, 7, 12), datetime.date(2013, 7, 13)]
	[datetime.date(2013, 7, 16)]
	[datetime.date(2013, 7, 19)]
	[datetime.date(2013, 7, 26)]
	[datetime.date(2013, 7, 30)]
	[datetime.date(2013, 8, 1)]
	[datetime.date(2013, 8, 6)]

kerin / gist:8096494

Created December 23, 2013 12:42

kerin / gist:8026010

Last active December 31, 2015 18:22

	import cPickle
	import gzip
	import redis
	from datetime import datetime

	rds = redis.StrictRedis(host='localhost', port=6379, db=0)

	panelist_dates = {int(p): {datetime.strptime(d, '%Y-%m-%d').date()
	for d in rds.smembers('panelists:%s:dates' % p)
	}

kerin / gist:8021118

Created December 18, 2013 11:55

	try:
	for i, row in enumerate(islice(reader, start, end)):
	writer.writerow(row)
	except csv.Error:
	print 'ERROR'
	for c in row:
	print len(c), c
	raise

kerin / gist:8004119

Created December 17, 2013 12:23

	In [26]: f = gzip.open('2013-10-04-pdl_answers.csv.gz', 'rb')

	In [27]: csvreader = csv.reader(f)

	In [28]: print csvreader.next()
	['23842', 'marginal_eligible', '1', '2009-09-11 22:59:45.942899']

	In [29]: f = gzip.open('2013-10-04-pdl_answers.csv.gz', 'rb')

	In [30]: csvreader = csv.reader(f)

kerin / gist:8003615

Created December 17, 2013 11:36

Kerin Cosford kerin