import mysql.connector
import hashlib

def get_md5(val):
    return hashlib.md5(val.encode('utf-8')).hexdigest()

conn = mysql.connector.connect(
    host="85.215.144.168",
    port=3306,
    database="pastelerias",
    user="asesoft",
    password="Pantera1"
)
cursor = conn.cursor(dictionary=True)

cursor.execute("SELECT id, receta_id, nombre FROM ob_recetas_procesos;")
procs = cursor.fetchall()
print(f"Total processes in DB: {len(procs)}")

for p in procs:
    expected_md5 = get_md5(p['receta_id'])
    if p['id'] == expected_md5:
        print(f"Proc ID {p['id']} matches MD5 of receta_id {p['receta_id']}")
    else:
        print(f"Proc ID {p['id']} does NOT match MD5 of receta_id {p['receta_id']} (expected {expected_md5})")

cursor.close()
conn.close()