Re: CLI for Schema Diff - Mailing list pgadmin-hackers

From Steve Chavez
Subject Re: CLI for Schema Diff
Date
Msg-id CAGRrpzYy=6=Hms6hhJ2co6cJbzt9_1zaOAi5xgZJCfFBDL9jOg@mail.gmail.com
Whole thread Raw
Responses Re: CLI for Schema Diff
List pgadmin-hackers
Hey all,

In case anyone is interested, I've managed to enable a CLI mode for the Schema Diff on this repo:


It basically works by using a Flask test client that interacts with the Schema Diff endpoints.
It's a single isolated file, I haven't patched any of the existing modules.

For a quickstart, there's also a docker image that can be used like:

docker run supabase/pgadmin-schema-diff \
'postgres://postgres@host/diff_source' \
'postgres://postgres@host/diff_target' \
> diff.sql ## the stderr output shows the same messages as the Schema Diff GUI:
Starting schema diff...
Comparision started......0%
Comparing FTS Dictionaries ...35%
Comparing Functions ...50%
Comparing Trigger Functions ...60%
Comparing Sequences ...70%
Comparing Tables ...80%
Comparing Views ...90%
Done.

On Wed, 10 Mar 2021 at 13:42, Steve Chavez <steve@supabase.io> wrote:
Hey all,

The Schema Diff tool is amazing, works much better than all the current OSS alternatives.

However, it's only possible to use it from the GUI and thus it cannot be used programmatically, which would be really useful for CI/CD environments(deployment automation).

Would you guys be open to make the Schema Diff work through a CLI?

Best regards,
Steve

pgadmin-hackers by date:

Previous
From: Khushboo Vashi
Date:
Subject: Re: OAuth error when logging in
Next
From: Akshay Joshi
Date:
Subject: pgAdmin 4 commit: Improve code coverage and API test cases for Server m