Xata/pgroll: Release v0.5.0
- ❌ Extend the
alter_column operation to allow dropping NOT NULL constraints from columns [docs]
- 💬 Add support for adding comments to tables and columns at creation time [docs]
- 🔑 Correctly preserve column constraints when duplicating columns for backfilling [issue]
- 🐛 Ensure that the
drop_column operation works for tables and columns with reserved words as names
- 🦺 Update the JSON schema for migration operations to more accurately reflect required and optional fields
Changelog
- f1757f3 Add CI check for up-to-date type generation (#225)
- d00d804 Add JSON schema tests (#263)
- eed4e4e Add JSON schema validation tests for 'sql' operations (#266)
- 70a7c8e Add
CHECK constraints to pgroll's internal schema representation (#241)
- 994a1aa Add
UNIQUE constraints to pgroll's internal schema representation (#242)
- f798ba5 Add a CI check for unreachable code using
deadcode (#251)
- 73c2016 Add a way to set postgres role when executing migrations (#226)
- b9e7819 Add drop
NOT NULL operation to remove NOT NULL from a column (#258)
- 9d25159 Add fields to
GROUP BY clauses in read_schema function (#255)
- 025a38f Add missing comment to field (#229)
- 61cc53a Add support for creating tables and columns with comments (#224)
- dde27eb Add test: check column
DEFAULTs preserved on set NOT NULL (#235)
- 66ccf91 Add unique & FK constraints info to the schema (#218)
- 83b5d76 Allow to disable version schemas (#233)
- 4450862 Bump
actions/checkout to v4 (#272)
- 72cc155 Bump github.com/containerd/containerd from 1.7.3 to 1.7.11 (#217)
- c5a3dbd Bump github.com/opencontainers/runc from 1.1.5 to 1.1.12 (#260)
- 4b124b0 Change
Complete method signature (#231)
- 355ac20 Correctly quote table and column names in the
drop column operation (#254)
- 14e3d1b Ensure constraint existence as part of validation for the drop constraint operation (#252)
- 7e65cda Fix inferred migrations format (#259)
- c10dabf Fix pgroll migration definition (#216)
- bb79eec Fix raw SQL migrations spec in schema.json (#264)
- 7a38e1f Identify duplicated foreign key constraints by prefix (#245)
- b2e93a9 Improve
MustNotInsert test assertions (#243)
- 7b5fafd Improve constraint assertions (#240)
- 908485f Include key columns for an index in the internal schema representation (#248)
- c95bc78 Parameterize schema in which migration tests run via
PGROLL_TEST_SCHEMA env var (#276)
- 68c5fbf Preserve
CHECK constraints on duplication (#244)
- 7c1167a Preserve
NOT NULL attributes on column duplication (#246)
- 9e9eeaf Preserve
UNIQUE constraints on column duplication (#250)
- ddb91d1 Preserve column properties on add
CHECK constraint operation (#236)
- 4928cf1 Preserve column properties on add
FOREIGN KEY constraint operation (#238)
- 7b7caa0 Preserve column properties on add
UNIQUE constraint operation (#237)
- 04de471 Preserve column properties on drop constraint operation (#253)
- d803689 Preserve default on column duplication when changing column type (#234)
- b81c42c Preserve foreign key constraints on columns duplicated for backfilling (#230)
- fc7370f Preserve foreign key constraints when changing a column's type (#232)
- 4bee7ac Record index uniqueness in
pgroll's internal schema representation (#247)
- 7fd8c7c Remove
RAISE NOTICE statements (#256)
- 82b7937 Remove unused function (#228)
- 7404ddf Run
go-jsonschema container with --rm (#267)
- 889946b Run migration tests in a non-
public schema as part of CI (#279)
- 5686ddc Strengthen assertions for tests that check preservation of
UNIQUE constraints (#277)
- e906da7 Strip schema from index names in internal schema representation (#278)
- a5cf473 Take
go version from go mod version in buid workflow (#271)
- d06a0af Update JSON schema to specify that not all
Column fields are required (#265)
- 5a6a83a Update
schema.json to correctly describe the 'alter column' operation (#261)
- 9586b44 Update
state command to avoid returning nulls (#274)
- 0cc62c1 docs/readme: broken code syntax (#270)