Pipeline CRM pre-commit hook for structure.sql protection

pre-commit

#!/bin/bash

# Pre-commit hook to warn about large changes to db/structure.sql

STRUCTURE_FILE="db/structure.sql"
THRESHOLD=200

# Check if structure.sql is staged for commit
if git diff --cached --name-only | grep -q "^${STRUCTURE_FILE}$"; then
    # Count the number of changed lines (additions + deletions)
    CHANGES=$(git diff --cached --numstat "$STRUCTURE_FILE" | awk '{print $1 + $2}')

    if [ "$CHANGES" -gt "$THRESHOLD" ]; then
        echo ""
        echo "⚠️  WARNING: Large changes detected in $STRUCTURE_FILE"
        echo "   $CHANGES lines changed (threshold: $THRESHOLD)"
        echo ""
        echo "   Remember: Pipeline CRM uses manual structure.sql maintenance."
        echo "   Make sure you're not committing auto-generated changes."
        echo ""

        # Check if we're in an interactive terminal
        if [ -t 0 ]; then
            read -p "Do you want to proceed with this commit? (y/N) " -n 1 -r
            echo ""
            if [[ ! $REPLY =~ ^[Yy]$ ]]; then
                echo "Commit aborted."
                exit 1
            fi
        else
            echo "   Non-interactive mode: Set SKIP_STRUCTURE_CHECK=1 to bypass."
            echo ""
            if [ "$SKIP_STRUCTURE_CHECK" != "1" ]; then
                echo "Commit aborted. Run with SKIP_STRUCTURE_CHECK=1 to bypass."
                exit 1
            fi
        fi
    fi
fi

exit 0