Pyrseas
Pyrseas copied to clipboard
Provides utilities for Postgres database schema versioning.
pg_pltemplate was [removed](https://www.postgresql.org/docs/13/release-13.html#id-1.11.6.7.5.14) in postgres 13 causing yamltodb to fail when [this statement](https://github.com/perseas/Pyrseas/blob/master/pyrseas/database.py#L524-L525) runs. My understanding (based on #39) is that Pyrseas needs a way to distinguish language extensions and...
I have Python 3.9 installed on my PC, but command dbtoyaml --multiple-files db_development produced output source: |2 and usual source: "\n... in the same call. Is it possible to setup...
Profiling my setup I noticed I was spending a lot of time in this deepcopy call. Looking at this: https://stackoverflow.com/questions/24756712/deepcopy-is-extremely-slow#answer-29385667 Using `pickle` to copy objects is simple approach to getting...
Initially reported by @alexitheodore in issue #226 starting from 2-Nov-2021. A sample traceback is as follows: ``` File "/usr/local/lib/python2.7/dist-packages/pyrseas/dbobject/trigger.py", line 156, in to_map dct = super(Trigger, self).to_map(db) File "/usr/local/lib/python2.7/dist-packages/pyrseas/dbobject/__init__.py", line...
Sequences processing doesn't skip schemas defined with '-N' option, as a result in the case the DB has restricted rights and I'm not interested in the restricted schemas the dbtoyaml...
Built a support tool to run Pyrseas in Docker, so that you don't have to set up a Python environment to run it. https://github.com/darrensapalo/dbtoyaml
OS - Linux Postgres - 12.7 Extensions - timescaledb dbtoyaml, yamltodb - v0.9.1 When creating change scripts using `yamltodb`, it generates `CREATE EXTENSION` statements in the script even though nothing...
I have a csv of data as follows: ```csv 1,APPAREL, 2,"BIOTECH, HEALTH CARE & PHARMA", 3,"FOOD, BEVERAGE & AGRICULTURE", ``` The this column is parentId, and its a self referencing...
Steps to reproduce: 1. test database with test table (plus primary key): 1.1 new database: ``` postgres=# create database a1; CREATE DATABASE ``` 1.2. new table: ``` a1=# create table...