Function test_connection_warn_close

tests/test_connection.py:219–251

(conn_cls, dsn, recwarn, gc_collect)

@pytest.mark.slow
def test_connection_warn_close(conn_cls, dsn, recwarn, gc_collect):
    class="cm"># First create all the connections to test, to avoid some to reuse the same
    class="cm"># address, resulting in an omitted warning.
    conn1 = conn_cls.connect(dsn)
    conn2 = conn_cls.connect(dsn)
    conn3 = conn_cls.connect(dsn)
    conn4 = conn_cls.connect(dsn)

    with conn_cls.connect(dsn) as conn5:
        pass
    del conn5
    assert not recwarn, [str(w.message) for w in recwarn.list]

    conn1.close()
    del conn1
    assert not recwarn, [str(w.message) for w in recwarn.list]

    del conn2
    gc_collect()
    assert conn_cls.__name__ in str(recwarn.pop(ResourceWarning).message)

    conn3.execute(class="st">"select 1")
    del conn3
    gc_collect()
    assert conn_cls.__name__ in str(recwarn.pop(ResourceWarning).message)

    try:
        conn4.execute(class="st">"select wat")
    except psycopg.ProgrammingError:
        pass
    del conn4
    gc_collect()
    assert conn_cls.__name__ in str(recwarn.pop(ResourceWarning).message)


@pytest.mark.usefixtures(class="st">"testctx")