def excel_to_sqlite(excel_path: Path, conn: sqlite3.Connection,
                    table_name: str) -> tuple[bool, int, str]:
    suffix = excel_path.suffix.lower()
    if suffix not in (".xls", ".xlsx"):
        return False, 0, f"Extensión Excel no soportada: {suffix}"
    try:
        engine = "xlrd" if suffix == ".xls" else "openpyxl"
        df = pd.read_excel(excel_path, engine=engine)
    except Exception as exc:
        return False, 0, f"No se pudo leer Excel: {exc}"

    cleaned = [sanitize_column(c) for c in df.columns.tolist()]
    df.columns = make_unique_columns(cleaned)
    conn.execute(f'DROP TABLE IF EXISTS "{table_name}"')
    df.to_sql(table_name, conn, if_exists="replace", index=False)
    return True, int(len(df)), "Tabla creada/reemplazada."

def sanitize_column(name: Any) -> str:
    return slugify_ascii("" if name is None else str(name)) or "columna"


def slugify_ascii(name: str) -> str:
    normalized = unicodedata.normalize("NFKD", name)
    ascii_only = normalized.encode("ascii", "ignore").decode("ascii")
    collapsed  = re.sub(r"[\s\-/]+", "_", ascii_only.lower())
    cleaned    = re.sub(r"[^a-z0-9_]", "", collapsed)
    cleaned    = re.sub(r"_+", "_", cleaned).strip("_")
    return cleaned or "sin_nombre"

def make_unique_columns(columns: list[str]) -> list[str]:
    used:   dict[str, int] = {}
    unique: list[str]      = []
    for col in columns:
        base  = col or "columna"
        count = used.get(base, 0) + 1
        used[base] = count
        unique.append(base if count == 1 else f"{base}_{count}")
    return unique

def process_folder(folder_path: Path, md_dir: Path, conn: sqlite3.Connection,
                   errors: list[str], results: list[FolderResult],
                   convert_doc: bool) -> None:
    folder_name = folder_path.name
    slug        = slugify_ascii(folder_name)
    # ...
    if len(excel_files) == 1:
        ok, rows, msg = excel_to_sqlite(excel_files[0], conn, slug)

DEFAULT_DB = Path("/opt/siaa/institucional.db")  # Base de datos SQLite

# In main processing:
with sqlite3.connect(db_path) as conn:
    for folder in subfolders:
        process_folder(folder, dest_md, conn, errors, results, convert_doc)
    conn.commit()

def process_folder(folder_path: Path, md_dir: Path, conn: sqlite3.Connection,
                   errors: list[str], results: list[FolderResult],
                   convert_doc: bool) -> None:
    folder_name = folder_path.name
    slug        = slugify_ascii(folder_name)
    md_path     = md_dir / f"{slug}.md"
    result      = FolderResult(folder_name=folder_name, slug=slug, md_path=md_path)

    files       = [p for p in folder_path.iterdir() if p.is_file()]
    word_files  = [p for p in files if p.suffix.lower() in (".doc", ".docx")]
    pdf_files   = [p for p in files if p.suffix.lower() == ".pdf"]
    excel_files = [p for p in files if p.suffix.lower() in (".xls", ".xlsx")]

    # ... Word/PDF processing ...

    # Excel → SQLite
    if len(excel_files) != 1:
        msg = f"Se esperaba 1 Excel y se encontraron {len(excel_files)}."
        result.sql_ok, result.sql_msg = False, msg
        result.errors.append(msg)
    else:
        try:
            ok, rows, msg = excel_to_sqlite(excel_files[0], conn, slug)
            result.sql_ok, result.sql_rows, result.sql_msg = ok, rows, msg
            if not ok:
                result.errors.append(msg)
        except Exception as exc:
            msg = f"Fallo Excel→SQLite: {exc}"
            result.sql_ok, result.sql_msg = False, msg
            result.errors.append(msg)

def print_verification(md_dir: Path, conn: sqlite3.Connection,
                        results: list[FolderResult], errors: list[str]) -> None:
    print("\n=== Tablas SQLite ===")
    for r in [r for r in results if r.sql_ok]:
        count = conn.execute(f'SELECT COUNT(*) FROM "{r.slug}"').fetchone()[0]
        print(f"  {r.slug}: {count} filas")

    total   = len(results)
    sql_ok  = sum(1 for r in results if r.sql_ok)
    print(f"\n=== Resumen ===")
    print(f"  Excel   → SQLite    : {sql_ok} ✅  {total - sql_ok} ❌")