- ❌ Extend the
alter_column
operation to allow droppingNOT 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 topgroll
's internal schema representation (#241) - 994a1aa Add
UNIQUE
constraints topgroll
'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 removeNOT NULL
from a column (#258) - 9d25159 Add fields to
GROUP BY
clauses inread_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
DEFAULT
s 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 fromgo mod
version inbuid
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)