snippets with tag 'MySQL'

# inspired from old django code
# mimics MySQLdb.cursors.DictCursor behaviour

def dictfetchall(cursor): 
    "Returns all rows from a cursor as a dict" 
    desc = cursor.description 
    return [dict(zip([col[0] for col in desc], row))   for row in cursor.fetchall()]

ALTER DATABASE `mydbname` DEFAULT CHARACTER SET utf8 COLLATE 'utf8_unicode_ci';