#!/usr/bin/env python3
from app import app
from models import db, Case

with app.app_context():
    case_types = db.session.query(Case.case_type).distinct().filter(Case.case_type != None).all()
    print("Distinct case types in database:")
    for ct in case_types:
        print(f"  - {ct[0]}")