import sqlite3
from pathlib import Path


def main() -> None:
    db_path = Path("demo/data/videos.db")
    conn = sqlite3.connect(db_path)
    cur = conn.cursor()

    # Borrar filas con video_name 'une_ad' o 'une_ad.mp4'
    cur.execute(
        "DELETE FROM videos WHERE video_name IN (?, ?)",
        ("une_ad", "une_ad.mp4"),
    )
    conn.commit()

    # Contar registros restantes
    cur.execute("SELECT COUNT(*) FROM videos")
    count = cur.fetchone()[0]
    print("REMAINING_COUNT:", count)

    conn.close()


if __name__ == "__main__":
    main()