Pyrseas¶
Pyrseas provides utilities to describe a PostgreSQL database schema as YAML, to verify the schema against the same or a different database and to generate SQL that will modify the schema to match the YAML description.
Features¶
- Outputs a YAML/JSON description of a PostgreSQL database’s tables and other objects (metadata), suitable for storing in a version control repository
- Generates SQL statements to modify a database so that it willl match an input YAML/JSON specification
- Generates an augmented YAML description of a PostgreSQL database from its catalogs and an augmentation specification.
Requirements¶
- PostgreSQL 9.3 or higher
- Python 2.7 or higher
- Psycopg2 2.5 or higher
- PyYAML 3.10 or higher
- PgDbConn 0.8 or higher
Contents¶
API Reference¶
Currently, the only external APIs are the class
Database and the methods
to_map() and
diff_map() of the latter. Other
classes and methods are documented mainly for developer use.