bplmp

def test_descriptions_in_dimensions():
    """All dimensions must have descriptions
    """
    errors = []
    for lkml_file in LKML_DIMENSIONS:
        dimensions_with_errors = []
        for dimension in lkml_file['dimensions']:
            if 'description' not in dimension:
                dimensions_with_errors.append(dimension['name'])
        if dimensions_with_errors:

bplmp

def test_views_in_views_folder():
    """All views must be in `views` folder
    """
    errors = []
    for lkml_file in LKML_VIEWS:
        if 'views' not in lkml_file['path_parent']:
            errors.append(lkml_file['path'])
    if errors:
        assert False, errors

bplmp

def test_avg_prefix_in_measures():
    """All average measures must be prefixed with avg_
    """
    errors = []
    for lkml_file in LKML_MEASURES:
        for measure in lkml_file['measures']:
            if measure['type'] == 'average' and measure['name'][:4] != 'avg_':
                errors.append(lkml_file['path'])
    if errors:
        assert False, errors

bplmp

# baixe os dados
curl http://dadosabertos.ibama.gov.br/dados/SIFISC/auto_infracao/auto_infracao/auto_infracao.html > autos.html

# gere csv
# (primeiro passo é quebrar as linhas, acelera o processamento)
cat autos.html \
  | sed -e 's|<\/tr>|\n|g' \
  | sed -e 's/.*<thead\sbgcolor\=\"\#808080\">//' \
        -e 's|\salign\=\"center\"||g' \
        -e 's|<\/th>|\|\|\||g' \

bplmp

Keybase proof

I hereby claim:

• I am bplmp on github.
• I am bplmp (https://keybase.io/bplmp) on keybase.
• I have a public key whose fingerprint is 2CB2 3C54 3AD2 ACED FAE4 53E5 041D 5EF8 ACB1 2946

To claim this, I am signing this object: