MIME-Version: 1.0
References: <CAOYmi+kThkM9Z87u=R_Wi7fCor2i+UZKAyq0UCyprzCwTQvqgA@mail.gmail.com>
 <CAPpHfdu4iyE1pfybgHrD04VW82mmxUSnFcj4jBghxE_wG8s3dA@mail.gmail.com>
 <CAOYmi+nzKz_TwP20wYAQskms1t0mXLVK8ah6WppxY1_zX_6ZYg@mail.gmail.com> <CAPpHfdtdOC9cJrrRP44ixCtBxO-FUZQwpWOTaht+LiNGOvMS3Q@mail.gmail.com>
In-Reply-To: <CAPpHfdtdOC9cJrrRP44ixCtBxO-FUZQwpWOTaht+LiNGOvMS3Q@mail.gmail.com>
From: Alexander Korotkov <aekorotkov@gmail.com>
Date: Wed, 12 Jun 2024 15:00:54 +0300
Message-ID: <CAPpHfdtUMx39U_4369Qrov_tMzBm0GFcrdV_a1RT0DTcftPvdQ@mail.gmail.com>
Subject: Re: RFC: adding pytest as a supported test framework
To: Jacob Champion <jacob.champion@enterprisedb.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAPpHfdtUMx39U_4369Qrov_tMzBm0GFcrdV_a1RT0DTcftPvdQ%40mail.gmail.com>
Precedence: bulk

On Wed, Jun 12, 2024 at 2:48=E2=80=AFPM Alexander Korotkov <aekorotkov@gmai=
l.com> wrote:
> On Tue, Jun 11, 2024 at 5:31=E2=80=AFPM Jacob Champion
> <jacob.champion@enterprisedb.com> wrote:
> > On Mon, Jun 10, 2024 at 12:26=E2=80=AFPM Alexander Korotkov
> > <aekorotkov@gmail.com> wrote:
> > > Thank you for working on this.
> > > Do you think you could re-use something from testgres[1] package?
> >
> > Possibly? I think we're all coming at this with our own bags of tricks
> > and will need to carve off pieces to port, contribute, or reimplement.
> > Does testgres have something in particular you'd like to see the
> > Postgres tests support?
>
> Generally, testgres was initially designed as Python analogue of what
> we have in src/test/perl/PostgreSQL/Test.  In particular its
> testgres.PostgresNode is analogue of PostgreSQL::Test::Cluster.  It
> comes under PostgreSQL License.  So, I wonder if we could revise it
> and fetch most part of it into our source tree.

Plus testgres exists from 2016 and already have quite amount of use
cases.  This is what I quickly found on github.

https://github.com/adjust/pg_querylog
https://github.com/postgrespro/pg_pathman
https://github.com/lanterndata/lantern
https://github.com/orioledb/orioledb
https://github.com/cbandy/pgtwixt
https://github.com/OpenNTI/nti.testing
https://github.com/postgrespro/pg_probackup
https://github.com/postgrespro/rum

------
Regards,
Alexander Korotkov
Supabase