"""Audit the export of Neo4J Identity nodes."""

# Run in neo4j desktop:
# match(i:Identity) return i.id, i.auth0UserId
# Export to csv
# Clean up csv - replace """ with empty string

import csv
import sys
import uuid


def audit(input_csv_path):
    with open(input_csv_path, newline="") as csv_file:
        reader = csv.DictReader(csv_file)
        for row in reader:
            identity_id = row["id"]
            auth0_user_id = row["auth0UserId"]

            try:
                uuid.UUID(identity_id, version=4)
            except:
                print(f"{identity_id}, {auth0_user_id}")


def main():
    try:
        audit("./PP-435-neo4j-qa-export.csv")
    except ValueError as ve:
        return str(ve)

if __name__ == "__main__":
    sys.exit(main())