legacy_spells_mover

legacy_spells_mover.py

import os
import re 
import shutil

# Get current dir       
dir_path = os.getcwd()

for root,dirs,files in os.walk(dir_path):

    for file in files:  
    
        # Check for .sql file          
        if file.endswith('.sql'):

            # Get full file path         
            full_path = os.path.join(root,file)

            with open(full_path) as f:
                content = f.read()
                
            pattern = r'alias\s*=\s*[\'"](\w+)[\'"]'
            result = re.sub(pattern, r"alias = alias('\1', legacy_model=True)", content)


            # Get the filename without extension     
            filename_noext = os.path.splitext(file)[0]

            # Rename file    
            os.rename(full_path, os.path.join(root, filename_noext+'_legacy.sql'))

            with open(os.path.join(root, filename_noext + '_legacy.sql'), 'w') as f:
                    f.write(result)