import pymysql

conn = pymysql.connect(
    host='85.215.144.168',
    user='asesoft',
    password='Pantera1',
    database='pastelerias',
    charset='utf8mb4'
)

with conn.cursor() as cur:
    for pattern in ['%trabajador%', '%festiv%', '%vacacion%', '%calendari%', '%ausenc%', '%horario%']:
        cur.execute(f"SHOW TABLES LIKE '{pattern}'")
        res = [r[0] for r in cur.fetchall()]
        print(f"Pattern {pattern}: {res}")

    print("\n--- Columns in ge_trabajadores_fichajes ---")
    cur.execute("DESCRIBE ge_trabajadores_fichajes")
    for row in cur.fetchall():
        print(row)

    print("\n--- Columns in ge_trabajadores_horario ---")
    cur.execute("DESCRIBE ge_trabajadores_horario")
    for row in cur.fetchall():
        print(row)

conn.close()