#!/usr/bin/env python3
path = "/var/www/html/api/wevia-admin-crm-bridge-v68.php"
with open(path, "r", encoding="utf-8") as f:
    c = f.read()

# Replace bare "FROM deals" with "FROM crm.deals", "FROM companies" with "FROM crm.companies" but only in WEVAL CRM context
# Simpler: replace all FROM deals, FROM companies, JOIN companies with crm.* (careful: twenty queries use $TWENTY_WS.company)
replacements = [
    ("FROM deals ", "FROM crm.deals "),
    ("FROM deals;", "FROM crm.deals;"),
    ("FROM deals)", "FROM crm.deals)"),
    ("FROM deals\"", "FROM crm.deals\""),
    ("FROM deals WHERE", "FROM crm.deals WHERE"),
    ("FROM deals GROUP", "FROM crm.deals GROUP"),
    ("FROM deals ORDER", "FROM crm.deals ORDER"),
    ("LEFT JOIN companies ", "LEFT JOIN crm.companies "),
    ("FROM companies\"", "FROM crm.companies\""),
    ("FROM companies ", "FROM crm.companies "),
    ("FROM contacts\"", "FROM crm.contacts\""),
    ("FROM contacts ", "FROM crm.contacts "),
]
count = 0
for old, new in replacements:
    before = c.count(old)
    c = c.replace(old, new)
    count += before
print(f"Applied {count} replacements")

with open(path, "w", encoding="utf-8") as f:
    f.write(c)
print("OK")