#!/usr/bin/env python3
import re
f = '/homez.10002/nbazfnm/beta/app/Controllers/AuthController.php'
with open(f) as fh:
    c = fh.read()

# 1. Find auth vars
vv = set(re.findall(r'\$(\w+)\s*=\s*.*?getAuthConnection\(\)', c))
print('VARS:', vv)

# 2. Check lines
for i, line in enumerate(c.split('\n')):
    for v in vv:
        has_var = ('$' + v + '->' in line) or ('$' + v + ' ->' in line)
        if has_var and 'users' in line:
            print(f'MATCH L{i}: {line.strip()[:120]}')
            nl = re.sub(r'FROM users\b', 'FROM auth_users', line)
            nl = re.sub(r'UPDATE users\b', 'UPDATE auth_users', nl)
            nl = re.sub(r'INTO users\b', 'INTO auth_users', nl)
            changed = nl != line
            print(f'  CHANGED: {changed}')
            if changed:
                print(f'  NEW: {nl.strip()[:120]}')