Daniel Miller millerdev

## sentry-events.py
#! /usr/bin/env python
"""Download events form Sentry as CSV

https://gist.github.com/millerdev/3d0a541f90b9817c3be5dd9bffed288e
"""
import sys
import csv
from argparse import ArgumentParser

import requests

## rm-future.py
#! /usr/bin/env python
"""Remove __future__ imports from Python files

Acts on *.py files in the current directory and all subdirectories.

Only removes lines in which all imported names are in KNOWN_FUTURES.

Public URL of this script:
https://gist.github.com/millerdev/f71648c1a9690cfca7c8b7c049867cfc
"""

## bucket_domains.py
#!/usr/bin/env python
# coding: utf-8
"""
Categorize CommCare HQ domains needing couch -> sql migration of forms and cases

This script requires a domains.csv file, which can be obtained by following
these steps:

1.  Download Excel file containing domains using CouchDB for forms and cases
    from https://www.commcarehq.org/hq/admin/domains/?es_use_sql_backend=F

## delete_gmail.py
#! /usr/bin/env python3
"""Permanently delete messages from Gmail

WARNING: THIS SCRIPT CAN DO GREAT DAMAGE TO YOUR GMAIL ACCOUNT.
USE AT YOUR OWN RISK!

Setup guide:

1.  Create and activate a new virtualenv with Python 3

## steps.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                millerdev
                / steps.md
            
            
              Last active Sep 10, 2018
            
              
                Update to new version of PostgreSQL in docker
              
          
      View steps.md
  
    
    Upgrade to new version of Postgres in Docker
This example upgrades PostgreSQL 9.4 to 9.6
See also https://github.com/docker-library/postgres/issues/37#issuecomment-277621597
Note: you will need compatible pg_dumpall and psql binaries in your path
(outside of docker), probably at least at the version you're migrating from.
If you don't have those on your local machine, you can use the one in the docker
container. Something like this

  
## generate-locations.py
#! /usr/bin/env python
"""Generate XLSX file containing CommCare locations

Requires: pip install openpyxl==2.2.5
https://gist.github.com/millerdev/57a5c1363773a92d9ee6332e79789cd3
"""
from __future__ import unicode_literals
from __future__ import print_function
from __future__ import division

## riak-vnode-check.py
#! /usr/bin/env python
"""
Check for replicas on distinct nodes within a riak cluster for a given n_val

https://gist.github.com/millerdev/b6f50640d5fc2519ae8c9c2de3c64af2
"""
import re
from argparse import ArgumentParser
from subprocess import check_output

## pglogslim.py
#! /usr/bin/env python3
# filter postgres logs to remove parameters of very large queries
#
# https://gist.github.com/millerdev/def20a42d78717174cd5722a9de2055a
import gzip
import re
import signal
import sys

# HACK prevent "BrokenPipeError: [Errno 32] Broken pipe" output on stderr

## git-flake8
#! /bin/bash
# Usage: git flake8 [refname]

BRANCH=${1:-origin/master}
CURRENT=$(git rev-parse --abbrev-ref HEAD)
echo "$BRANCH...$CURRENT"
git diff $BRANCH...$CURRENT | flake8 --diff 1>&2

## fix-virtualenv-readline.sh
# Problem: borked readline in virtualenv
#
# Sample python interactive session:
#
# $ python
# Python 3.5.1 (default, Dec 29 2015, 10:15:41)
# [GCC 4.2.1 Compatible Apple LLVM 7.0.2 (clang-700.1.81)] on darwin
# Type "help", "copyright", "credits" or "license" for more information.
# >>> "type an expression and press enter"
# >>> 'type an expression and press enter'