Function test_history_trim_cli

tests/test_history.py:518–543

`ipython history trim/clear` must replace the database file. All sqlite connections to the old database have to be closed before it is unlinked, otherwise this fails on Windows and leaves a stray ``history.sqlite.new`` file behind (gh-15241).

(tmp_path, subcommand, kept)

    ],
)
def test_history_trim_cli(tmp_path, subcommand, kept):
    """`ipython history trim/clear` must replace the database file.

    All sqlite connections to the old database have to be closed before it is
    unlinked, otherwise this fails on Windows and leaves a stray
    ``history.sqlite.new`` file behind (gh-15241).
    """
    profile_dir = tmp_path / "profile_default"
    profile_dir.mkdir()
    hist_file = profile_dir / "history.sqlite"
    _make_history_db(hist_file, 5)

    env = os.environ.copy()
    env["IPYTHONDIR"] = str(tmp_path)
    proc = subprocess.run(
        [sys.executable, "-m", "IPython", "history"] + subcommand,
        capture_output=True,
        text=True,
        env=env,
        check=False,
    )
    assert proc.returncode == 0, proc.stderr
    assert list(profile_dir.glob("history.sqlite.new*")) == []
    with closing(sqlite3.connect(hist_file)) as con:
        rows = list(con.execute("SELECT source FROM history"))
    assert len(rows) == kept