Run phinx migrations in a loop until they pass. This is useful if the phinx log is not in sync with the schema, which can happen through error or e.g. by taking a bare schema from one environment (without data) and importing it to another and then running migratiions.

gistfile1.sh

#!/bin/bash

re="[0-9]{14}" # migration ids are the datetime as a 14 digit number - find them
env=${1-development}
db="app"

if [[ $env != 'development' ]]; then
    db="app_test"
fi

phinx migrate -e $env
while [ $? -ne 0 ]; do
  output=`phinx migrate -e $env 2>/dev/null`
  if [[ $output =~ $re ]]; then
      mysql -e "insert into ${db}.phinxlog values('${BASH_REMATCH[0]}', now(), now());"

      echo ""
      echo "Skipping migration ${BASH_REMATCH[0]} restarting migrate..."
      echo ""

      phinx migrate -e $env
  else
    break
  fi  
done