Releases
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 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 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 )
You canβt perform that action at this time.