Format and escape SQL for insertion into a Postgres text[] column

format_migration.py

#!/usr/bin/env python3

import sys

def format_migration_as_text_array(filename):
    """Format a migration file as PostgreSQL text[] array literal"""
    try:
        with open(filename, 'r') as f:
            lines = f.read().splitlines()
        
        # Escape double quotes in each line
        escaped = [line.replace('"', '\\"') for line in lines]
        
        # Format as PostgreSQL array literal
        result = '{"' + '","'.join(escaped) + '"}'
        print(result)
        
    except FileNotFoundError:
        print(f"Error: File '{filename}' not found", file=sys.stderr)
        sys.exit(1)
    except Exception as e:
        print(f"Error: {e}", file=sys.stderr)
        sys.exit(1)

if __name__ == "__main__":
    if len(sys.argv) != 2:
        print("Usage: python3 format_migration.py <migration_file>", file=sys.stderr)
        sys.exit(1)
    
    format_migration_as_text_array(sys.argv[1])