Feedback-ID: id4a34324:Fastmail
Date: Wed, 17 Dec 2025 11:10:01 -0500
From: Andres Freund <andres@anarazel.de>
To: Jelte Fennema-Nio <postgres@jeltef.nl>
Cc: Jacob Champion <jacob.champion@enterprisedb.com>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>,
 Robert Haas <robertmhaas@gmail.com>,
	Daniel Gustafsson <daniel@yesql.se>, Tom Lane <tgl@sss.pgh.pa.us>,
	Peter Eisentraut <peter@eisentraut.org>,
 Nazir Bilal Yavuz <byavuz81@gmail.com>
Subject: Re: RFC: adding pytest as a supported test framework
Message-ID: <g4gdtfedwwdgu5sbcopjt3djtqk6p2q7n5nymp7ppapfwukoyd@ev2v4jtsbure>
References: 
 <CAOYmi+moGFuBaaAHq=kixGk0YuOZan09Wn5O4WAzA-xLTEumaA@mail.gmail.com>
 <CA+TgmoY4DRMVEV7CVo1D8p==ExsN69W89rF7-Ax4V=M9HGWL7g@mail.gmail.com>
 <CA+TgmoZV8B35Mvx8DqHtJjHDQxscJhwOWzNWiPj+dsUhwaUfSg@mail.gmail.com>
 <2302192.1718380169@sss.pgh.pa.us>
 <CAOYmi+k214g1tgREvQkUcr=OCiVKyaTDu1ja+OGAygG1y=jhPQ@mail.gmail.com>
 <CAOYmi+nEqA2LmetcJKUDmctypPLLumkVwj3vQ3idYd8yAGza5Q@mail.gmail.com>
 <CAOYmi+kebAt6wSX7ee0c0kMzV7r0hp93bAt10V5a88yHHUKwog@mail.gmail.com>
 <CAOYmi+=CrBFBRX-foRRES2tx2wXBJJhbsJGjgFbWvPcmBJuK-Q@mail.gmail.com>
 <DDOUZE2TCU8O.89TN0AS4GLP7@jeltef.nl>
 <DE5BODEZ607Y.3LNII22O5N27O@jeltef.nl>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <DE5BODEZ607Y.3LNII22O5N27O@jeltef.nl>
Archived-At: 
 <https://www.postgresql.org/message-id/g4gdtfedwwdgu5sbcopjt3djtqk6p2q7n5nymp7ppapfwukoyd%40ev2v4jtsbure>
Precedence: bulk

On 2025-11-10 22:11:50 +0100, Jelte Fennema-Nio wrote:
> On Wed Oct 22, 2025 at 2:44 PM CEST, Jelte Fennema-Nio wrote:
> > So here's your patchset with an additional commit on top that does a
> > bunch of refactoring/renaming and adding features.
> 
> Rebased to fix conflicts.

I assume this intentionally doesn't pass CI:
https://cirrus-ci.com/github/postgresql-cfbot/postgresql/cf%2F6045


> From f6823405eb994d457f8123df0d417ca2340e4c71 Mon Sep 17 00:00:00 2001
> From: Jacob Champion <jacob.champion@enterprisedb.com>
> Date: Fri, 5 Sep 2025 16:39:08 -0700
> Subject: [PATCH v3 01/10] meson: Include TAP tests in the configuration
>  summary
> 
> ...to make it obvious when they've been enabled. prove is added to the
> executables list for good measure.
> 
> TODO: does Autoconf need something similar?

I agree with adding tap to the configuration summary, but I don't understand
the prove part, that just seems like a waste of vertical space.


> From 5a27976496db53d8e9b88ab59e6c71f0f42dedcd Mon Sep 17 00:00:00 2001
> From: Jacob Champion <jacob.champion@enterprisedb.com>
> Date: Wed, 13 Aug 2025 10:58:56 -0700
> Subject: [PATCH v3 02/10] Add support for pytest test suites
> 
> Specify --enable-pytest/-Dpytest=enabled at configure time. This
> contains no Postgres test logic -- it is just a "vanilla" pytest
> skeleton.
> 
> I've written a custom pgtap output plugin, used by the Meson mtest
> runner, to fully control what we see during CI test failures. The
> pytest-tap plugin would have been preferable, but it's now in
> maintenance mode, and it has problems with accidentally suppressing
> important collection failures.
> 
> test_something.py is intended to show a sample failure in the CI.
> 
> TODOs:
> - OpenBSD has an ANSI-related terminal bug, but I'm not sure if the bug
>   is in Cirrus, the image, pytest, Python, or readline. The TERM envvar
>   is unset to work around it. If this workaround is removed, a bad ANSI
>   escape is inserted into the pgtap output and mtest is unable to parse
>   it.
> - The Chocolatey CI setup is subpar. Need to find a way to bless the
>   dependencies in use rather than pulling from pip... or maybe that will
>   be done by the image baker.

Yes, that needs to be baked into the image. Chocolatey is catastrophically
slow and unreliable. It's also just bad form to hit any service with such
repeated downloads.

This is true for *all* of the platforms.


> +###############################################################
> +# Library: pytest
> +###############################################################
> +
> +pytest_enabled = false
> +pytest = not_found_dep
> +
> +pytestopt = get_option('pytest')
> +if not pytestopt.disabled()
> +  pytest = find_program(get_option('PYTEST'), native: true, required: pytestopt)
> +  if pytest.found()
> +    pytest_check = run_command(pytest,
> +                               '-c', 'pytest.ini',
> +                               '--confcutdir=config',
> +                               '--capture=no',
> +                               'config/check_pytest.py',
> +                               '--requirements', 'config/pytest-requirements.txt',
> +                               check: false)
> +    if pytest_check.returncode() != 0
> +      message(pytest_check.stderr())
> +      if pytestopt.enabled()
> +        error('Additional Python packages are required to run the pytest suites.')
> +      else
> +        warning('Additional Python packages are required to run the pytest suites.')
> +      endif
> +    else
> +      pytest_enabled = true
> +    endif
> +  endif
> +endif

Why do we need pytest the program at all?  Running the tests one-by-one with
pytest as a runner doesn't seem to make a whole lot of sense to me.


> diff --git a/src/test/Makefile b/src/test/Makefile
> index 511a72e6238..0be9771d71f 100644
> --- a/src/test/Makefile
> +++ b/src/test/Makefile
> @@ -12,7 +12,16 @@ subdir = src/test
>  top_builddir = ../..
>  include $(top_builddir)/src/Makefile.global
>  
> -SUBDIRS = perl postmaster regress isolation modules authentication recovery subscription
> +SUBDIRS = \
> +	authentication \
> +	isolation \
> +	modules \
> +	perl \
> +	postmaster \
> +	pytest \
> +	recovery \
> +	regress \
> +	subscription

I'm onboard with that, but we should do it separately and probably check for
other cases where we should do it at the same time.

I think it'd be a seriously bad idea to start with no central infrastructure,
we'd be force to duplicate that all over. Eventually we'll be forced to
introduce some central infrastructure, but we'll probably not go around and
carefully go through the existing tests for stuff that should now use the
common infrastructure.

Greetings,

Andres Freund