pytest Quick Start Guide

pytest-postgresql

This plugin allows you to test code that needs a running PostgreSQL database.

Here's a quick example of it in action:

def test_fetch_series(postgresql):    cur = postgresql.cursor()    cur.execute('SELECT * FROM comedy_series;')    assert len(cur.fetchall()) == 5    cur.close()

It provides two fixtures:

• postgresql: a client fixture that starts and closes connections to the running test database. At the end of the test, it drops the test database to ensure tests don't interfere with one another.
• postgresql_proc: a session-scoped fixture that starts the PostgreSQL process once per session and ensures that it stops at the end.

It also provides several configuration options on how to connect and configure the testing database.