Pyrseas

Pyrseas copied to clipboard

Error Using dbtoyaml With Supabase Schema

67

I am wanting to use Pyrseas with [Supabase](https://supabase.com/) (basically pre-configured [Postgrest](https://postgrest.org/en/stable/)). I get the following error: ```python3 $ dbtoyaml -H db.nynstytcyprpinthzhos.supabase.co -U postgres --password postgres Password: Traceback (most recent call...

benjamin-kirkbride

Replace Travis-CI for continuous integration by GitHub Actions.

jmafc

dbtoyaml Fails When PG Password Has Spaces (Improper Escaping)

1

How to reproduce: 1. Create PD DB with role with a password with spaces 2. Try to connect Example: ``` $ python -m pdb -c continue .venv/bin/dbtoyaml -H db.REDACTED.supabase.co -U...

benjamin-kirkbride

Fails to Install: Error: pg_config executable not found

5

Is it possible to use `psycopg2-binary` instead? ``` $ pip install pyrseas Collecting pyrseas Downloading Pyrseas-0.9.1-py2.py3-none-any.whl (113 kB) ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 113.4/113.4 kB 2.6 MB/s eta 0:00:00 Collecting psycopg2>=2.5 Using cached psycopg2-2.9.3.tar.gz...

benjamin-kirkbride

Support --revert for tables

4

I want to generate up & down migrations for my database. I use yamltodb to generate the SQL. I saw the --revert flag was experimental, not for tables. What's the...

stijntratsaertit

Support columns GENERATED AS (x) STORED

2

Hi, Seems having a generated column make `dbtoyaml` crash due to a self reference of `Table` in `depends_on`: Simple test case to reproduce the bug: ``` $ psql -tAc 'show...

philpep