# import uuid
# import random
# import string
# from sqlalchemy.orm import Session
# from sqlalchemy import select

# from app.models.main.student import TblStudent

# def generate_unique_student_id(session: Session):
#     """Generates a unique 6-character student ID."""
#     while True:
#         new_id = ''.join(random.choices(string.ascii_uppercase + string.digits, k=6))
#         # Check if ID already exists
#         exists = session.scalar(
#             select(TblStudent).where(TblStudent.student_unique_id == new_id).exists()
#         )
#         if not exists:
#             return new_id