Will Munn willm

## gist:f79a254de74dafd7435e184af965d98e
redis-cli --raw keys "$PATTERN" | xargs redis-cli del

## gist:64dba1ffe7d60db4f5637d306b8e2b82
mysqldump --user=drupal --password=''--host='' --opt 'DB_NAME' > database.sql

## ip addresses.sh
ifconfig | grep -oE "\b([0-9]{1,3}\.){3}[0-9]{1,3}\b"

## clean.sh
docker rm $(docker ps -a -q)
docker rmi $(docker images -q)
docker volume rm $(docker volume ls |awk '{print $2}')
rm -rf ~/Library/Containers/com.docker.docker/Data/*

## postgres_cheat.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                willm
                / postgres_cheat.md
            
            
              Created
              January 23, 2018 10:28
            
              
                Postgres cheat sheet
              
          
    Kill all sessions for a db

select pg_terminate_backend(pid)
from pg_stat_activity
where datname = 'doomed_database'

  
## format.vim
:%!python -m json.tool

## time.sh
curl -s -w "%{time_total}\n" -o /dev/null http://www.google.com/

## app-engine.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                willm
                / app-engine.md
            
            
              Last active
              July 10, 2017 08:08
            
              
                App engine
              
          
    Querying google datasstore

const datastore = require('@google-cloud/datastore')({
      projectId: 'captureappprod',
      keyFilename: '/path/to/key.json' // key optained from App engine / IAM admin / service accounts
});
function deviceCount(start, count=0) {
    const batchSize = 300;
    const query = datastore.createQuery('Device') // Device is the 'kind'

  
## list-groups.ps1
(New-Object System.DirectoryServices.DirectorySearcher("(&(objectCategory=User)(samAccountName=$($env:username)))")).FindOne().GetDirectoryEntry().memberOf

## fix-clipboard.sh
# from  linux guest OS
killall VBoxClient
VBoxClient-all
	docker rm $(docker ps -a -q)
	docker rmi $(docker images -q)
	docker volume rm $(docker volume ls \|awk '{print $2}')
	rm -rf ~/Library/Containers/com.docker.docker/Data/*