Create a migration file by reading local changes made to db/create-tables.sql

generate-migration.sh

slugify='node_modules/.bin/slugify'

git show HEAD:db/create-tables.sql > db/tmporigin.sql
cp db/create-tables.sql db/tmpnew.sql

today="$(date -u +'%Y%m%d%H%M')"
file_name="db/migrations/$($slugify "$today $1").sql"

file_content=$(apgdiff --add-defaults db/tmporigin.sql db/tmpnew.sql)

if [[ -z "$file_content" ]]; then
  echo "⚠️ No migration detected"
else
  echo $file_content > $file_name
  echo "🖍 Created ${file_name}"
fi

rm db/tmpnew.sql db/tmporigin.sql

You need to install:

• apgdiff
• slugify-cli, installed in the folder's npm packages