Function test_favorite_query_multiple_statement

test/pytests/test_sqlexecute.py:213–245

(executor, monkeypatch)

@dbtest
@pytest.mark.skipif(os.name == "nt", reason="Bug: fails on Windows, needs fixing, singleton of FQ not working right")
def test_favorite_query_multiple_statement(executor, monkeypatch):
    monkeypatch.setattr(iocommands.FavoriteQueries, 'instance', iocommands.favoritequeries, raising=False)
    set_expanded_output(False)
    run(executor, "create table test(a text)")
    run(executor, "insert into test values('abc')")
    run(executor, "insert into test values('def')")

    results = run(executor, "\\fs test-ad select * from test where a like 'a%'; select * from test where a like 'd%'")
    assert_result_equal(results, status="Saved.", status_plain="Saved.")

    results = run(executor, "\\f test-ad")
    expected = [
        {
            "preamble": "> select * from test where a like 'a%'",
            "header": ["a"],
            "rows": [("abc",)],
            "postamble": None,
            "status": None,
            "status_plain": None,
        },
        {
            "preamble": "> select * from test where a like 'd%'",
            "header": ["a"],
            "rows": [("def",)],
            "postamble": None,
            "status": None,
            "status_plain": None,
        },
    ]
    assert expected == results

    results = run(executor, "\\fd test-ad")
    assert_result_equal(results, status="test-ad: Deleted.", status_plain="test-ad: Deleted.")


@dbtest