#!/usr/bin/env python3
"""Apply Batch 4 updates - 6 facilities"""
import csv
import json
import shutil
from datetime import datetime

# Backup
timestamp = datetime.now().strftime("%Y%m%d-%H%M%S")
shutil.copy('verified-scored-facilities.csv', f'verified-scored-facilities-BACKUP-{timestamp}.csv')

# Read CSV
with open('verified-scored-facilities.csv', 'r', encoding='utf-8') as f:
    reader = csv.DictReader(f)
    rows = list(reader)
    fieldnames = reader.fieldnames

# Load batch 4 updates
with open('batch4_updates.json', 'r') as f:
    data = json.load(f)
    updates = data['batch_4_facilities']

# Apply updates
update_count = 0
for row in rows:
    company = row['Company']
    if company in updates:
        for key, value in updates[company].items():
            row[key] = value
        update_count += 1
        print(f"✓ Updated: {company}")

# Write updated CSV
with open('verified-scored-facilities.csv', 'w', encoding='utf-8', newline='') as f:
    writer = csv.DictWriter(f, fieldnames=fieldnames)
    writer.writeheader()
    writer.writerows(rows)

print(f"\n✅ Applied {update_count} updates")
print(f"📊 Progress: {69 + update_count}/1,390 verified ({((69 + update_count)/1390*100):.1f}%)")
print(f"\n🎯 BATCH 4 COMPLETE!")
print(f"\n📈 Tonight's Progress: {update_count + 13} facilities verified in this session")