import numpy as np
from db_utils import get_db_connection

def normalize_data(data):
    return {
        k: v.item() if isinstance(v, (np.integer, np.floating)) else v
        for k, v in dict(data).items()
    }

def is_username_unique(username):
    """Returns True if username is available, False if already exists."""
    conn = get_db_connection()
    cursor = conn.cursor()
    try:
        sql = "SELECT COUNT(*) FROM tbUsers WHERE UserName = ?"
        cursor.execute(sql, (username,))
        count = cursor.fetchone()[0]
        return count == 0
    except:
        return False
    finally:
        conn.close()