How to Import Users from CSV into LDAP-like Dicts in Python

import csv
import io
from pathlib import Path


def mock_ldap_import(csv_path):
    """
    Reads a CSV file with user data and returns a list of LDAP-like user dicts.
    Adds standard LDAP attributes that would come from directory schema.
    """
    with open(csv_path, newline="", encoding="utf-8") as csvfile:
        reader = csv.DictReader(csvfile)
        users = []
        for row in reader:
            user = {
                "uid": row["username"],
                "cn": f"{row['first_name']} {row['last_name']}",
                "mail": row["email"],
                "givenName": row["first_name"],
                "sn": row["last_name"],
                "department": row.get("department", "unknown"),
                "objectClass": ["inetOrgPerson", "organizationalPerson"],
                "enabled": row.get("enabled", "TRUE").upper() == "TRUE",
            }
            users.append(user)
        return users


if __name__ == "__main__":
    sample_csv = """username,first_name,last_name,email,department,enabled
jdoe,John,Doe,jdoe@example.com,Engineering,TRUE
asmith,Alice,Smith,asmith@example.com,Sales,TRUE
bmarley,Bob,Marley,bmarley@example.com,,FALSE
"""
    p = Path("/tmp/mock_users.csv")
    p.write_text(sample_csv)

    imported_users = mock_ldap_import(p)
    for user in imported_users:
        print(user)