import re

with open('C:/xampp/htdocs/pharmacy/database.sql') as f:
    sql = f.read()

db_perms = set(re.findall(r"VALUES\s*\('([\w_]+)'", sql))

model_perms_raw = """view_dashboard,view_medicines,create_medicines,edit_medicines,delete_medicines
view_categories,create_categories,edit_categories,delete_categories
view_suppliers,create_suppliers,edit_suppliers,delete_suppliers
view_customers,create_customers,edit_customers,delete_customers
view_sales,create_sales,delete_sales
view_purchases,create_purchases,edit_purchases,delete_purchases
view_daily_sales,view_monthly_sales,view_profit_loss,view_category_sales
view_stock_report,view_expired_report,view_account_report,view_account_statement
view_payment_methods,view_expense_report,view_customer_statement,view_supplier_statement
view_customer_due
view_expenses,create_expenses,edit_expenses,delete_expenses,approve_expenses
view_cash_deposits,create_cash_deposits,edit_cash_deposits,delete_cash_deposits,approve_cash_deposits
view_users,create_users,edit_users,delete_users
view_settings,edit_settings
view_payment_accounts,create_payment_accounts,edit_payment_accounts,delete_payment_accounts
manage_roles
view_quotations,create_quotations,delete_quotations
send_messages,view_messages
view_activity_logs
backup_database,restore_database
view_departments,create_departments,edit_departments,delete_departments
view_designations,create_designations,edit_designations,delete_designations
view_employees,create_employees,edit_employees,delete_employees
view_attendance,manage_attendance
view_leaves,create_leaves,approve_leaves
view_payslips,create_payslips,delete_payslips
view_salary_report,view_attendance_report,view_leave_report
view_leave_types,create_leave_types,edit_leave_types,delete_leave_types"""

model_perms = set(re.split(r'[,;\s]+', model_perms_raw))
model_perms.discard('')

missing = model_perms - db_perms
extra = db_perms - model_perms

if missing:
    print("MISSING from SQL seed:", sorted(missing))
else:
    print("All model permissions are in SQL seed.")
if extra:
    print("Extra in SQL seed (not in model):", sorted(extra))