Count the number of migrations per repo that modify existing schema structure

count-disruptive-migrations.sh

# make a temp directory for each repo to examine
mkdir doximity doc-news activities

# copy in migrations from 2019
for dir in *; do cp ~/work/$dir/db/migrate/2019* $dir/; done

# remove migration reversal code to exclude from search
sed -i'' -re '/def down/,$d' */*

# count unique migration files per repo that modify existing schema structure (tables, columns)
# depends on ag silver searcher but could be modified to use grep
ag -l -i '(remove|drop|rename|alter|change)[ _](?!(foreign_key|index|column_(null|default)))' |cut -d/ -f1 |sort |uniq -c