Skip to content

Latest commit

 

History

History
406 lines (251 loc) · 10.9 KB

Changelog.rst

File metadata and controls

406 lines (251 loc) · 10.9 KB

0.8.14 (20-May-2022)

  • Support for PG 14

0.8.13 (18-May-2022)

  • Revert to 0.8.10 as 0.8.12 didn't really work.

0.8.12 (28-Dec-2020)

  • Same as 0.8.11 but reverting a commit that I'm not confident in that may or may not impact the sql query escaping

0.8.11 (23-Dec-2020)

  • Update indexes when predicates changes

0.8.10 (07-Oct-2020)

  • use pyyaml's C-based parser, which is an ~order of mag faster

0.8.9 (27-Aug-2020)

  • yaml should not unnecessarily quote column names indexes

    This bandaids over the issue where a reserved keyword as column name results in different yaml files, causing us to drop and recreate the index

    This fix is only for indexes so I presume we'll hit it with views or something else also

0.8.8 (10-Dec-2019)

Remove "Support renaming of tables"

  • It's a feature that we don't need and we're just trying to get Postgres 11 working
  • We never used 0.8.6 in production so while the changes are probably fine, I'm just trying to reduce the amount of change at the moment

0.8.7 (10-Dec-2019)

Postgres 11 Support

  • Cherry-picked the commit from upstream that added Postgres 11 support e082b0ad4aad8fdafb504bb20e9c0d95a2d3c92b

0.8.6 (09-July-2019)

Support renaming of tables

  • Setting oldname on a table will result in renaming of the table with correct column changes if needed
  • A view with the same name as an oldname table also works to support backwards compatible renames

0.8.5 (01-June-2019)

Pull in pgdbconn so we can fully replace Psycopg2 with Psycopg2-binary

  • pgdbconn requires psycopg which requires postgres-client rather than just needed psycopg-binary. Pyscopg requires postgres to be installed while the binary version doesn't so this simplifies our life a bit

    This is the reverse of dfa03cd, where pgdbconn was pulled out. It isn't actually isn't being used as a module elsewhere and okay with some code duplication even if it was

0.8.4 (05-June-2019)

Drop first before anything else

  • We now order DROP statements before other statements. Motivating case is a column type change where the column has an index that is only for a certain type. We should drop that index before changing the column type. Previously, drops happened last.

0.8.3 (04-June-2019)

Fix columns not changing types

  • Turns out that slight reorderings of the columns in a table would result in alter statements not being generated at all

0.8.2 (01-May-2019)

DevotedHealth fork

  • BREAKING CHANGE: You need to specify --dbname for yamltodb and dbtoyaml. This was to better clarify as yamltodb now allows you to compare two yaml files
  • yamltodb allows you to compare two yaml files. Instead of --dbname, pass the yaml that represents the databaes into --db-spec
  • Tests run in CircleCI to match our other repositories
  • Update dependency to psycopg2-binary to avoid deprecation message
  • Only map dependencies for functions that are explictly present
  • A bunch of other fixes that were merged into master at the time of fork

NOTE: I had cut a new branch off of master at the time and it resulted in some breaking changse for us. Instead, going to branch from release 0.8.0 which we've been using in production for a year now instead. If there are patches that we need from master or even the release 0.8 branch (which also had breaking changes for us), we can cherry-pick them over.

0.8.0 (12-Dec-2017)

Significant rearchitecture of methods to generate SQL.

  • An object dependency graph is built and traversed to generate SQL in correct order (#72, #86, #100)

Added support for Postgres 10, specifically:

  • Table partitioning syntax (#163)
  • Column specification GENERATED AS IDENTITY (#164)

Added support for other Postgres features:

  • Parallel safe functions and partial aggregation (#161)
  • RANGE types (#173)
  • ALTER TYPE ADD VALUE for changes to ENUM types (#87)

0.7.2 (23-Jan-2015)

Fixed various issues, including:

  • Do not error on tables whose names start with 'public' (#109)
  • Deal properly with inherited constraints in children tables (#102)
  • Handle external languages like plv8 correctly (#97)
  • Correct quoting of mixed case constraint names (#83)
  • Avoid problems with certain complex index definitions (#98)
  • Have dbtoyaml output correctly a table with an embedded period in the name and having an associated sequence (#79)
  • Use relative paths in database summary for --multiple-files (#93)
  • Support mapping of indexes on materialized views (#82)

0.7.1 (5-Dec-2013)

  • Moved config.yaml under pyrseas directory and use package_data to install (#77)
  • yamltodb output to a file is encoded using utf-8 (#78)

0.7.0 (25-Nov-2013)

  • Added support for:

    • Postgres 9.3, specifically
      • EVENT TRIGGER
      • MATERIALIZED VIEWS
    • CLUSTER
    • Partial indexes
    • Storage parameters in CREATE and ALTER TABLE
    • ALTER COLUMN SET STATISTICS
    • LEAKPROOF qualifier for FUNCTIONs
    • YAML multi-line string formatting for view definitions, function source text and object comments

  • Configuration files

    All Pyrseas utilities can now use YAML-formatted configuration files, in addition to command line options

  • Multiple-file input or output

    Spread database object information across a version control repository

  • Data export/import

    Load a database with static data in production or data subsets for testing

  • dbtoyaml/yamltodb

    • Added --quote-reserved option to yamltodb
    • Exclude arguments from sfunc and finalfunc attributes of aggregate functions (#54)
    • Correct generation of SQL for functions with DEFAULT arguments (#52)

  • Augmenter

    New utility (dbaugment) to consistently add objects to an existent database. This is currently an experimental feature and covers adding audit columns to tables.

  • TTM-inspired relational interface

    A new interface to Postgres, inspired by The Third Manifesto

0.6.1 (31-Jan-2013)

  • Add support for INSTEAD OF triggers on views (#50).
  • Eliminated yamltodb generation of spurious REVOKE/GRANT commands (#51).
  • Removed setuptools from setup.py install_requires.

0.6.0 (26-Oct-2012)

  • Added support for:
    • EXTENSIONs
    • COLLATIONs
    • OWNER information
    • Access privileges (GRANT and REVOKE)
    • TABLESPACEs for tables, primary keys and indexes
    • MATCH attributes for foreign keys (#34)
    • ALTER composite TYPE ADD/DROP/RENAME ATTRIBUTE
    • ENUMs with no labels (#31)
    • UNLOGGED tables (#45)
    • CREATE FUNCTION SET configuration_parameter (#46)
    • PostgreSQL 9.2
  • Correctly support index functions/expressions (#3, #44).
  • Schema-qualify composite types when dropping or renaming attributes (#47)
  • Fix DbConnection exception handling under Python 3 (#25).
  • dbtoyaml
    • Fix -t option to output sequences owned by table and the schema description.
    • Use pg_user_mappings view to allow usage by non-superusers.
  • yamltodb
    • Schema-qualify table when dropping columns (#26).
    • Correct column drop/add case in middle of table (#8).
    • Fix adding and dropping of columns in inherited tables (#33).
    • Enable renaming of indexes (#38).
    • Ignore all temp schemas (#37)
  • dbtoyaml/yamltodb
    • Give PGUSER precedence over USER environment variable.
  • Testing
    • Added support, via Tox, for testing against multiple PostgreSQL/Python combinations
    • Changes and documentation for testing on Microsoft Windows

0.5.0 (10-Mar-2012)

  • Added support for:
    • TEXTSEARCH parsers, dictionaries, configurations and templates
    • FOREIGN DATA WRAPPERs, SERVERs, USER MAPPINGs and FOREIGN TABLEs
    • ROWS clause in set-returning functions (issue #11)
    • Deferrable/deferred constraints (#13)
    • CATEGORY and PREFERRED clauses for TYPEs, SORTOP clause for AGGREGATEs HASHES and MERGES clauses for OPERATORs (#15)
    • Operator class qualifiers for INDEXes (#16)
    • Python 3.2 and later
  • Correct schema normalization for constraints (#9) and indexes.
  • Fix COMMENTs generated for constraints (#12).
  • Fix DEFAULT clause for OPERATOR CLASS.
  • dbtoyaml
    • When restricting to specific schemas or tables, include non-schema objects (e.g., languages).
  • yamltodb
    • Add -n/--schema option (#6).
    • Add -u/--update option to apply SQL statements to target database.
    • Exclude database-wide objects when -n/--schema is used (#21).
    • Allow YAML spec argument to be read from standard input.
  • dbtoyaml/yamltodb
    • Add -o/--output option
    • Add -W/--password option (#18)

0.4.1 (27-Oct-2011)

  • Make the initial SET search_path persistent.
  • Correct exclusion of PG internal schemas in various queries.
  • Fix generation of COMMENTs with single quotes in the text.
  • For inherited tables, only generate constraints that are defined locally.
  • Correct generation of ALTER TABLE ADD/DROP COLUMN when input columns are in different order than original.
  • Support PG 9.1 (add description for PL/pgSQL language).

0.4.0 (26-Sep-2011)

  • Added support for:
    • CASTs
    • CONSTRAINT TRIGGERs
    • CONVERSIONs
    • OPERATORs, OPERATOR CLASSes and OPERATOR FAMILies
    • Dynamically loaded C language functions
    • Composite and base TYPEs
  • Clean up and enhance documentation and redundant methods.
  • Use obj_description/col_description functions instead of querying pg_description directly.

0.3.1 (26-Aug-2011)

  • Added workaround for incorrect assumption that 'public' schema is always present (issue #4).
  • Added support for delimited (or quoted) identifiers, e.g., those with embedded spaces, upper case characters, etc. (except for SQL keywords) (issue #5).

0.3.0 (30-Jun-2011)

  • Added support for:
    • AGGREGATE functions
    • DOMAINs
    • ENUMerated TYPEs
    • Functions returning table row types
    • INDEXes on expressions (issue #3)
    • Rewrite RULEs
    • SECURITY DEFINER functions
    • TRIGGERs
  • Enhanced host/port defaults to use sockets, resulting in noticeable performance improvement.

0.2.1 (7-Jun-2011)

  • Fixed problem with mapping a FOREIGN KEY in a table with a dropped column (issue #2).

0.2.0 (19-May-2011)

  • Added support for:
    • COMMENTs on schemas, tables, columns and functions
    • FOREIGN KEY ON UPDATE and ON DELETE actions
    • ALTER TABLE RENAME COLUMN and enhanced support for other ALTER object RENAME statements.
    • VIEWs
    • INHERITed tables, and by extension, partitioned tables.
    • PROCEDURAL LANGUAGEs
    • FUNCTIONs.
  • Added files for release via PGXN.
  • Added support for testing against multiple PostgreSQL versions.
  • Fixed cross-schema REFERENCES failure in dbtoyaml (issue #1).

0.1.0 (5-Apr-2011)

  • Initial release
    • dbtoyaml and yamltodb support PostgreSQL schemas, tables, sequences, check constraints, primary keys, foreign keys, unique constraints and indexes.