A shell function for diffing two arms of a migration file

[jonseymour]

diff-migration() { 
     local file=$1;
     ${DIFF_UTIL:-diff} \
       <(sed "1,/-- +goose Down/d" $file)  \
       <(sed -n "1, /-- +goose Down/p" $file | egrep -v "\\+goose (Up|Down)"); 
} 

diff-migration 00001-some-migration.sql

This is most useful when a stored procedure or view definition is being replaced by the roll-forward arm and being restored by the rollback arm.