#!/bin/bash

# Script to update adm_ table prefixes to career_ prefixes in PHP files
# Version 2 - Improved to handle more patterns 

# Directory containing PHP files
SOURCE_DIR="/var/www/html/linways/career-api/src"

# Find all PHP files and replace adm_ with career_
find "$SOURCE_DIR" -name "*.php" -print0 | while IFS= read -r -d '' file; do
    echo "Processing file: $file"
    
    # Replace all instances of adm_ with career_ in SQL statements
    sed -i 's/adm_/career_/g' "$file"
    
    # Additionally look for these special cases
    sed -i 's/FROM \`adm/FROM \`career/g' "$file"
    sed -i 's/INTO \`adm/INTO \`career/g' "$file"
    sed -i 's/UPDATE \`adm/UPDATE \`career/g' "$file"
    sed -i 's/JOIN \`adm/JOIN \`career/g' "$file"
    sed -i 's/FROM adm/FROM career/g' "$file"
    sed -i 's/INTO adm/INTO career/g' "$file"
    sed -i 's/UPDATE adm/UPDATE career/g' "$file"
    sed -i 's/JOIN adm/JOIN career/g' "$file"
    sed -i 's/LEFT JOIN adm/LEFT JOIN career/g' "$file"
    sed -i 's/INNER JOIN adm/INNER JOIN career/g' "$file"
    sed -i 's/RIGHT JOIN adm/RIGHT JOIN career/g' "$file"
    sed -i 's/ adm_/ career_/g' "$file"
    sed -i 's/\.adm_/\.career_/g' "$file"
done

echo "Table name replacement completed!"