from app import create_app, db
from app.models.learning import VocationalContent

def check_vocational_videos():
    app = create_app('development')
    with app.app_context():
        results = db.session.query(
            VocationalContent.category, 
            db.func.count(VocationalContent.id)
        ).group_by(VocationalContent.category).all()
        
        for category, count in results:
            print(f"{category}: {count} skill items")

if __name__ == '__main__':
    check_vocational_videos()