import pyodbc

db_path = r'c:\fuentes\proyectos delphi\RAUL_ASENCIO\GESTION\documentacion raul asencio\datos\contabilidad\0042026.accdb'
conn_str = f'DRIVER={{Microsoft Access Driver (*.mdb, *.accdb)}};DBQ={db_path};'
conn = pyodbc.connect(conn_str)
cursor = conn.cursor()

cursor.execute("SELECT COUNT(*) FROM F_MAE WHERE CODMAE LIKE '43%'")
print('F_MAE 43% count:', cursor.fetchone()[0])

cursor.execute("SELECT COUNT(*) FROM F_MAE WHERE CODMAE LIKE '40%' OR CODMAE LIKE '41%'")
print('F_MAE 40/41% count:', cursor.fetchone()[0])

cursor.execute("""
SELECT CODMAE, NOMMAE FROM F_MAE 
WHERE (CODMAE LIKE '43%') 
  AND LEN(CODMAE) >= 8
  AND CODMAE NOT IN (SELECT CODCLI FROM F_CLI)
""")
missing_cli = cursor.fetchall()
print('F_MAE 43% not in F_CLI:', len(missing_cli))
for m in missing_cli[:5]:
    print('Missing CLI in F_CLI:', m)

cursor.execute("""
SELECT CODMAE, NOMMAE FROM F_MAE 
WHERE (CODMAE LIKE '40%' OR CODMAE LIKE '41%') 
  AND LEN(CODMAE) >= 8
  AND CODMAE NOT IN (SELECT CODPRO FROM F_PRO)
""")
missing_pro = cursor.fetchall()
print('F_MAE 40/41% not in F_PRO:', len(missing_pro))
for m in missing_pro[:10]:
    print('Missing PRO in F_PRO:', m)
