Michael Bylstra mbylstra

## gist:803de31188705dc658b0
git log branch_a ^branch_b --no-merges

## log uncaught exceptions.py
import logging
logger = logging.getLogger('some_logger')
def log_uncaught_exceptions(*exc_info):
    logger.critical('Unhandled Exception:', exc_info=exc_info)
sys.excepthook = log_uncaught_exceptions

## gist:8050451
pv sqlfile.sql | mysql dbname

## print Exception stack trace
import traceback
try:
    #some code
except Exception, e:
    print ''.join(traceback.format_exception(*sys.exc_info()))

## gist:7727307
killall -SIGKILL uwsgi

## mysql command line stuff
mysql> pager less;    # use less for paging
mysql> SELECT * FROM something \G      #one field per line (good for wide tables)

## create_utf8_mysql_db
CREATE DATABASE some_db DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

## disable_mysql_foreign_key_checks
SET foreign_key_checks = 0;
DELETE FROM users where id > 45;
SET foreign_key_checks = 1;

## py_datetime_to_mysql.py
from django.db import connection
from django.db.backends.mysql.base import DatabaseOperations

def py_datetime_to_mysql(d):
    db_ops = DatabaseOperations(connection)
    return db_ops.value_to_db_datetime(d)

#eg:
from django.db import connection
py_datetime_to_mysql(datetime.now())

## safe_print.py
#modified version off http://code.activestate.com/recipes/576602-safe-print/

def sprint(*args, **kwargs):
    """Safely print the given string.

    If you want to see the code points for unprintable characters then you
    can use `errors="xmlcharrefreplace"`.
    """

    errors = kwargs.get('errors', 'replace')
	import logging
	logger = logging.getLogger('some_logger')
	def log_uncaught_exceptions(*exc_info):
	logger.critical('Unhandled Exception:', exc_info=exc_info)
	sys.excepthook = log_uncaught_exceptions
	import traceback
	try:
	#some code
	except Exception, e:
	print ''.join(traceback.format_exception(*sys.exc_info()))
	mysql> pager less; # use less for paging
	mysql> SELECT * FROM something \G #one field per line (good for wide tables)
	SET foreign_key_checks = 0;
	DELETE FROM users where id > 45;
	SET foreign_key_checks = 1;
	from django.db import connection
	from django.db.backends.mysql.base import DatabaseOperations

	def py_datetime_to_mysql(d):
	db_ops = DatabaseOperations(connection)
	return db_ops.value_to_db_datetime(d)

	#eg:
	from django.db import connection
	py_datetime_to_mysql(datetime.now())
	#modified version off http://code.activestate.com/recipes/576602-safe-print/

	def sprint(args, *kwargs):
	"""Safely print the given string.

	If you want to see the code points for unprintable characters then you
	can use `errors="xmlcharrefreplace"`.
	"""

	errors = kwargs.get('errors', 'replace')