Function test_function_notice_order

tests/test_pgexecute.py:677–705

(executor)

@dbtest
def test_function_notice_order(executor):
    run(
        executor,
        """
        CREATE OR REPLACE FUNCTION demo_order() RETURNS VOID AS
        $$
        BEGIN
            RAISE NOTICE 'first';
            RAISE NOTICE 'second';
            RAISE NOTICE 'third';
            RAISE NOTICE 'fourth';
            RAISE NOTICE 'fifth';
            RAISE NOTICE 'sixth';
        END;
        $$
        LANGUAGE plpgsql;
    """,
    )

    executor.function_definition("demo_order")

    result = run(executor, "select demo_order()")
    assert "first\nsecond\nthird\nfourth\nfifth\nsixth" in result[0]
    assert "+------------+" in result[1]
    assert "| demo_order |" in result[2]
    assert "|------------|" in result[3]
    assert "|            |" in result[4]
    assert "+------------+" in result[5]
    assert "SELECT 1" in result[6]


@dbtest