import mysql.connector

def get_connection_details():
    details = {}
    with open('setting.txt', 'r') as f:
        for line in f:
            key, value = line.strip().split(':', 1)
            details[key.strip()] = value.strip()
    return details

def check_plant_data_again():
    conn = None
    try:
        config = get_connection_details()
        conn = mysql.connector.connect(
            host=config.get('Host'),
            port=config.get('Port'),
            user=config.get('Username'),
            password=config.get('Password'),
            database=config.get('Database'),
            charset='utf8mb4' # Ensure consistent charset with DB table
        )
        cursor = conn.cursor(dictionary=True)

        cursor.execute("SELECT id, plant, department, name, extension FROM extension_data LIMIT 20")
        rows = cursor.fetchall()

        if not rows:
            print("extension_data table is empty. No data to check.")
            return

        print("First 20 rows of extension_data (checking 'plant' column):")
        all_plants_empty = True
        for row in rows:
            plant_value = row.get('plant')
            print(f"ID: {row.get('id')}, Plant: '{plant_value}', Department: {row.get('department')}, Name: {row.get('name')}, Extension: {row.get('extension')}")
            if plant_value is not None and plant_value != '':
                all_plants_empty = False
        
        if all_plants_empty:
            print("WARNING: All 'plant' values in the first 20 rows are empty or NULL.")
        else:
            print("'plant' column seems to contain data (not all empty/NULL).")

    except Exception as e:
        print(f"An error occurred: {e}")
    finally:
        if conn and conn.is_connected():
            conn.close()

if __name__ == "__main__":
    check_plant_data_again()