Function _make_history_db

tests/test_history.py:482–508

Create a history database with the standard schema and some entries.

(hist_file: Path, n_entries: int)

def _make_history_db(hist_file: Path, n_entries: int) -> None:
    """Create a history database with the standard schema and some entries."""
    with closing(sqlite3.connect(hist_file)) as con:
        con.execute(
            """CREATE TABLE sessions (session integer
                primary key autoincrement, start timestamp,
                end timestamp, num_cmds integer, remark text)"""
        )
        con.execute(
            """CREATE TABLE history
                (session integer, line integer, source text, source_raw text,
                PRIMARY KEY (session, line))"""
        )
        con.execute(
            """CREATE TABLE output_history
                (session integer, line integer, output text,
                PRIMARY KEY (session, line))"""
        )
        now = datetime.now().isoformat(sep=" ")
        con.execute(
            "INSERT INTO sessions VALUES (1, ?, ?, ?, '')", (now, now, n_entries)
        )
        con.executemany(
            "INSERT INTO history VALUES (1, ?, ?, ?)",
            [(i, "code %d" % i, "code %d" % i) for i in range(n_entries)],
        )
        con.commit()


@pytest.mark.parametrize(