import pymysql

conn = pymysql.connect(host='85.215.144.168', user='asesoft', password='Pantera1', database='pastelerias', charset='utf8mb4')
with conn.cursor() as cur:
    cur.execute("DESCRIBE ge_articulos;")
    for r in cur.fetchall():
        if any(term in r[0].lower() for term in ['desc', 'ingred', 'etiq', 'nombre', 'obs']):
            print(r)
    print("\n--- ge_clientes_articulos ---")
    cur.execute("DESCRIBE ge_clientes_articulos;")
    for r in cur.fetchall():
        print(r)
conn.close()
