Please run this Python command to show me all the construction trades and categories that are currently in my database, along with their risk levels and requirements. This will help me update my registration form with the correct trade options that match my backend data:"
pythonpython -c "
from app import create_app
from app.extensions import db
from app.models import Category

app = create_app()
with app.app_context():
    print('🏗️ COMPLETE LIST OF ROLES & TRADES IN DATABASE')
    print('=' * 60)
    
    # Get all categories
    categories = Category.query.order_by(Category.whs_risk_level, Category.name).all()
    
    if not categories:
        print('❌ No categories found in database')
    else:
        # Group by risk level
        risk_groups = {
            'low': [],
            'medium': [],
            'high': [],
            'extreme': []
        }
        
        for category in categories:
            risk_groups[category.whs_risk_level].append(category)
        
        total_count = 0
        for risk_level in ['low', 'medium', 'high', 'extreme']:
            trades = risk_groups[risk_level]
            if trades:
                print(f'\n🟢 {risk_level.upper()} RISK ({len(trades)} trades):')
                print('-' * 40)
                for trade in trades:
                    license_text = '🔒 License' if trade.license_required else '📝 No License'
                    white_card_text = '⚠️ White Card' if trade.white_card_required else '✅ No White Card'
                    insurance_min = f'${trade.get_insurance_minimum():,}'
                    print(f'{trade.name:20} | {license_text} | {white_card_text} | Min Insurance: {insurance_min}')
                total_count += 1
        
        print(f'\n📊 SUMMARY:')
        print(f'Total Categories: {total_count}')
        for risk_level in ['low', 'medium', 'high', 'extreme']:
            count = len(risk_groups[risk_level])
            if count > 0:
                print(f'  {risk_level.capitalize()} Risk: {count} trades')