"""Génère les UPDATE SQL pour marquer is_enemy_skill=1 sur les skills ciblés par \asid."""
import sys, csv, re
sys.stdout.reconfigure(encoding="utf-8")
from pathlib import Path

D = Path(r"c:\wamp64\www\csi-world\csv_data\csi-forever")
pat = re.compile(r"\\asid\[(\d+)\]", re.IGNORECASE)

with (D / "Weapons.csv").open(encoding="utf-8-sig") as f:
    rows = list(csv.DictReader(f, delimiter=";"))

ids = set()
for r in rows:
    text = (r.get("description", "") or "") + " " + (r.get("note", "") or "")
    for m in pat.finditer(text):
        ids.add(int(m.group(1)))

# Format : UPDATE skill SET is_enemy_skill=1 WHERE game_id=0 AND original_id IN (list)
id_list = ",".join(str(i) for i in sorted(ids))
print(f"UPDATE skill SET is_enemy_skill=1 WHERE game_id=0 AND original_id IN ({id_list})")