gamesbook

# -*- coding: utf-8 -*-
"""
Purpose: Import data from a MySQL database to an Excel file
Created: 2019-05-25
Authors: Derek Hohls <gamesbook@gmail.com>
"""
import getpass
# require pip install:
import MySQLdb
from xlsxwriter.workbook import Workbook

gamesbook

def compare(a, b, *, key=None, **kwargs):
    """Assumption here is that you only want to handle kwargs x, y or z"""
    print(a, b, key, kwargs)
    if list(set(kwargs.keys()).difference(['x','y','z'])):
        inv = ','.join(list(set(kwargs.keys()).difference(['x','y','z'])))
        raise ValueError('Unexpected arg(s) {} in kwargs'.format(inv))

'''
>>> compare(1,2,key=4,x=2)
1 2 4 {'x': 2}

gamesbook

# -*- coding: utf-8 -*-
from __future__ import print_function
import csv
# via https://github.com/lcosmin/boardgamegeek
from boardgamegeek import BoardGameGeek
import logging

logging.basicConfig()

GAMES = """Monopoly

gamesbook

"""
https://stackoverflow.com/questions/33454739/distribution-of-dice-rolls
&
https://stackoverflow.com/questions/20335617/unlimited-sides-to-dice-in-simulator/
"""
from collections import Counter
import sys
from random import randint

# Python 2/3 compatibility

gamesbook

# -*- coding: utf-8 -*-
""" Purpose: Convert imperial units (feet, inches) to metres

Created: 2017-10-17
Author:  dhohls@csir.co.za

Notes:
    This is quite useful if you have a house plan where all the units are
    Imperial (typically American or old European plans) and you need to 
    compare against modern plans.

gamesbook

# -*- coding: utf-8 -*-
""" Purpose: Use lxml to validate an XML file against a Schema (XSD)

Created: 2017-09-27
Author:  dhohls@csir.co.za

Requires::

    pip install lxml

gamesbook

# -*- coding: utf-8 -*-
""" Purpose: Extract and print directives from a software project.

Created: 2017-09-24
Contact: gamesbook@gmail.com

Usage::
    python extract_directives.py
    python extract_directives.py -d=/path/to/ -i=FIXME -e=js
    

gamesbook

# -*- coding: utf-8 -*-
"""Purpose: Capture shell script output via Python logging to Sentry.io.

Setup:

First export the SENTRY_DSN value in your .bashrc file. Then::

    pip install raven --upgrade
    pip install autoenv
    echo "source bin/activate" > .env

gamesbook

# -*- coding: utf-8 -*-
""" Purpose: Use Python schema module to validate JSON files vs a schema.

Created: 2017-09-05
Author:  dhohls@csir.co.za

Usage::

    python json_schema_validator.py --json=ajsonfile.json --schema=aschemafile.json
"""

gamesbook

# -*- coding: utf-8 -*-
"""Purpose: Show creating XML from nested JSON with optional elements.

Created: 2017-09-03
Author:  dhohls@csir.co.za
"""
from __future__ import print_function
from jinja2 import Template

xml_template = """<?xml version="1.0" encoding="UTF-8"?>