32 lines
1.2 KiB
Python
32 lines
1.2 KiB
Python
#!/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")
|