Reset schema.rb from main

refresh_schema.sh

#!/bin/bash

# Fetch last changes from origin
git fetch

# Copy schema.rb from main
git checkout origin/main -- db/schema.rb

# Restore database with main state (erase all local data)
bundle exec rake db:schema:load

# Build list of new migrations
migrations_list=$(git diff --name-only origin/main..HEAD -- db/migrate | xargs -n 1 basename | cut -d "_" -f 1 | paste -s -d, - | sed "s/\([^,]*\)/'\1'/g")

# Mark new migration as "down" if needed
bundle exec rails runner "ActiveRecord::Base.connection.execute(\"DELETE FROM schema_migrations WHERE version IN (${migrations_list})\")"

# Run new migrations
bundle exec rake db:migrate