import re

file_path = 'attendr.sql'

with open(file_path, 'r', encoding='utf-8') as f:
    content = f.read()

# Replace "table_name" with `table_name` in INSERT INTO statements
# Regex looks for: INSERT INTO "word"
# Replaces with: INSERT INTO `word`
# Or I can just remove the quotes since table names are safe. Let's remove them to be safe across different modes if possible, but backticks are safer for MySQL.
# Let's use backticks.

def replace_quotes(match):
    return f'INSERT INTO `{match.group(1)}`'

new_content = re.sub(r'INSERT INTO "([^"]+)"', replace_quotes, content)

with open(file_path, 'w', encoding='utf-8') as f:
    f.write(new_content)

print("Fixed quotes in attendr.sql")