Check Django username conflict (case senstive)

check_username_conflict.py

"""Check conflicts in Django usernames

This script checks every username for a possible conflict, due to Django's default policy 
to accept `user` and `User` as different usernames.
"""

from django.contrib.auth import get_user_model
from tqdm import tqdm


User = get_user_model()
conflict_usernames = set()
for user in tqdm(User.objects.all(), total=User.objects.count()):
    if User.objects.filter(username=user.username).count() > 1:
        conflict_usernames.add(user.username.lower())

print(f"Total usernames in conflict: {len(conflict_usernames)}")
for username in sorted(conflict_usernames):
    print(f" - {username}")