Hi On Tue, Mar 30, 2021 at 3:36 PM Steve Chavez <st...@supabase.io> wrote:
> Hey all, > > In case anyone is interested, I've managed to enable a CLI mode for the > Schema Diff on this repo: > > https://github.com/steve-chavez/pgadmin4/blob/cli/web/cli.py > > 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. > > That's an interesting approach! Obviously the code is just a proof of concept at the moment (redirecting stdout is masking errors for example), but is this something you'd be interested in working on to become a more fully featured and production quality CLI? -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com
