# Changelog All notable changes to this project will be documented in this file. ## [0.2.23] - 2023-01-10 [7b8d729](7b8d729e0255905e785a711837b48896e5c4103d)...[2ae8ada](2ae8adafcf18e5fa4a2bd06cfc4f3cedb2b9b501) ### Features - Add rename to DeltaItem trait and support rename for column/constraints of the table ([07a00b8](07a00b85652b5080efbcc4f8054a8a512402110a) - 2023-01-10 by Tyr Chen) ## [0.2.22] - 2023-01-10 [18dbbd1](18dbbd18d075a8e18ea99e906e5ace38ebd29e09)...[7b8d729](7b8d729e0255905e785a711837b48896e5c4103d) ### Bug Fixes - Alter table level constraint should only drop/create that constraint. Also use ONLY for most of alter table migration. ([7b8d729](7b8d729e0255905e785a711837b48896e5c4103d) - 2023-01-10 by Tyr Chen) ## [0.2.21] - 2023-01-09 [352b977](352b977f51dc9636a2c40218d53a7f4ee5b0e8c1)...[18dbbd1](18dbbd18d075a8e18ea99e906e5ace38ebd29e09) ### Bug Fixes - Silly typo for the output of `renovate schema apply` ([951798f](951798fd772011c970aeefbbf62cf14c422915a9) - 2023-01-09 by Tyr Chen) ### Miscellaneous Tasks - Update Readme ([2646b9a](2646b9a9b10f3c63cb7512795997c20b159f8c16) - 2023-01-09 by Tyr Chen) ## [0.2.20] - 2023-01-09 [84b01f3](84b01f363459bffa67e795be6349b5b136c5d46a)...[352b977](352b977f51dc9636a2c40218d53a7f4ee5b0e8c1) ### Bug Fixes - Improve the commit message and shell output when applying the plan ([352b977](352b977f51dc9636a2c40218d53a7f4ee5b0e8c1) - 2023-01-09 by Tyr Chen) ## [0.2.19] - 2023-01-09 [81ea378](81ea37862b5a4224a46a94e599d1d25621ba1f8b)...[84b01f3](84b01f363459bffa67e795be6349b5b136c5d46a) ### Bug Fixes - Fix gh action issue ([ef16a60](ef16a60857276fc412b0004822606601f8404925) - 2023-01-09 by Tyr Chen) - Github action ([38e03a8](38e03a8e1e19cf5d59dbc272873d1a49dc72f702) - 2023-01-09 by Tyr Chen) - Fix pg version to 14 since ubuntu has pg_dump 14 ([c0d367b](c0d367b9e576c408a54fbe4d7634208e5e7203d0) - 2023-01-09 by Tyr Chen) - Commit the cwd for init.toml ([c6adc84](c6adc8402a452d42f1fa2c4b71556be5f3eced31) - 2023-01-09 by Tyr Chen) ### Miscellaneous Tasks - Remove unnecessary examples ([986c535](986c535d1eb8260e322134276e0d0023570efdf1) - 2023-01-09 by Tyr Chen) - Update document and prepare for open source ([84b01f3](84b01f363459bffa67e795be6349b5b136c5d46a) - 2023-01-09 by Tyr Chen) ## [0.2.18] - 2023-01-09 [5d33205](5d33205fa0add1e57e9dcd4e5bc8bf002f4270c6)...[81ea378](81ea37862b5a4224a46a94e599d1d25621ba1f8b) ### Bug Fixes - Fix alter column not null missing space issue and also update readme ([81ea378](81ea37862b5a4224a46a94e599d1d25621ba1f8b) - 2023-01-09 by Tyr Chen) ### Features - Support `renovate schema apply` to remote server and refactor git related code ([4839866](48398664df81227b647d43d2b12a3885b1a063b4) - 2023-01-08 by Tyr Chen) - Improve apply remote ([ff32b95](ff32b950ce005487f7f94ac87b8ec7808f36056d) - 2023-01-09 by Tyr Chen) ## [0.2.16] - 2023-01-08 [c4fb19f](c4fb19f0d1aa0cdeaea199af5accbd3263b4f22f)...[5d33205](5d33205fa0add1e57e9dcd4e5bc8bf002f4270c6) ### Bug Fixes - Fix cmd test cases ([5d33205](5d33205fa0add1e57e9dcd4e5bc8bf002f4270c6) - 2023-01-08 by Tyr Chen) ### Features - Support command test ([8973182](8973182f7fde65cf9a2381a61ed10b12888af2d9) - 2023-01-08 by Tyr Chen) - Add cmd tests for normalize and plan ([da6b1e3](da6b1e32bf3a83a8c96338ad4a9a29ac2d801412) - 2023-01-08 by Tyr Chen) ## [0.2.15] - 2023-01-08 [cb0b493](cb0b493048cfda4d51a101ecc76c625637f7e340)...[c4fb19f](c4fb19f0d1aa0cdeaea199af5accbd3263b4f22f) ### Features - Make function & trigger work ([c4fb19f](c4fb19f0d1aa0cdeaea199af5accbd3263b4f22f) - 2023-01-08 by Tyr Chen) ## [0.2.14] - 2023-01-08 [3bbe834](3bbe8341b490740e24a121771d306c23cf2389c9)...[cb0b493](cb0b493048cfda4d51a101ecc76c625637f7e340) ### Features - Support privilege (grant) ([cb0b493](cb0b493048cfda4d51a101ecc76c625637f7e340) - 2023-01-08 by Tyr Chen) ### Miscellaneous Tasks - Update prefix ([5044759](5044759fb2f7874dade8658a4c795051bfa27837) - 2023-01-08 by Tyr Chen) ## [0.2.13] - 2023-01-08 [c82e14e](c82e14e3595d92762867747052abc2d23d957d5e)...[3bbe834](3bbe8341b490740e24a121771d306c23cf2389c9) ### Bug Fixes - Multiple alter column cmds shall use "," to separate ([2bc7e6e](2bc7e6e307928155a8b50c17e3be67281283c977) - 2023-01-08 by Tyr Chen) ### Features - Support policy and rls ([3bbe834](3bbe8341b490740e24a121771d306c23cf2389c9) - 2023-01-08 by Tyr Chen) ### Miscellaneous Tasks - [skip ci] update docs ([4533608](453360841408dd0e0d04d19dc29aed92cefb62c4) - 2023-01-08 by Tyr Chen) ## [0.2.12] - 2023-01-08 [e2afc2c](e2afc2c882a86dc78928aad1a1226c9f9bd2e862)...[c82e14e](c82e14e3595d92762867747052abc2d23d957d5e) ### Features - Support array type ([c82e14e](c82e14e3595d92762867747052abc2d23d957d5e) - 2023-01-08 by Tyr Chen) ## [0.2.11] - 2023-01-08 [4b6bba7](4b6bba767aa9339e8a173e05000fe6653c1f0b5a)...[e2afc2c](e2afc2c882a86dc78928aad1a1226c9f9bd2e862) ### Features - Make typemod work and fix type related issues if using varchar() ([e2afc2c](e2afc2c882a86dc78928aad1a1226c9f9bd2e862) - 2023-01-08 by Tyr Chen) ## [0.2.10] - 2023-01-08 [77043a7](77043a72c3b3d0fe439937525a343ad5eb095bda)...[4b6bba7](4b6bba767aa9339e8a173e05000fe6653c1f0b5a) ### Bug Fixes - 1. normalize failed due to lack of `create schema`; 2. plan coloring 3. table sequence sql missing ([8dde39d](8dde39dcc58dec0740a175b4383343032f9f3c7e) - 2023-01-07 by Tyr Chen) - Fix issue on complex check constraint ([08a8bcf](08a8bcfa97248b31532bd68f7517645a081d14fa) - 2023-01-08 by Tyr Chen) ### Features - Refactor schema diff code and support rls/owner ([8a66e53](8a66e533283fb724380627f0f907a094814cacdc) - 2023-01-07 by Tyr Chen) - Support alter table add/drop constraints ([bbe1da0](bbe1da0347b2d6be4e5d78832ceafd6d47ccc1c8) - 2023-01-08 by Tyr Chen) - Support enum migration and fix constraint expr issue ([4b6bba7](4b6bba767aa9339e8a173e05000fe6653c1f0b5a) - 2023-01-08 by Tyr Chen) ## [0.2.9] - 2023-01-07 [31a68c5](31a68c575ee30010b83cbfae362112e98484d34a)...[77043a7](77043a72c3b3d0fe439937525a343ad5eb095bda) ### Features - Group sql when saving ([77043a7](77043a72c3b3d0fe439937525a343ad5eb095bda) - 2023-01-07 by Tyr Chen) ## [0.2.8] - 2023-01-07 [4658050](4658050defc8020003f74da8ff90bb878d84bd15)...[31a68c5](31a68c575ee30010b83cbfae362112e98484d34a) ### Features - Add `renovate schema normalize` ([0c00600](0c006000c6b23e02bc8619f8c1ab60b017ed86c5) - 2023-01-07 by Tyr Chen) - Make sequence diff work ([44c7695](44c769594b6525bb6c3770bb3b61dbaad39f02a5) - 2023-01-07 by Tyr Chen) - Support table level objects ([2a01a82](2a01a8274dbd23e6d34def39c1aa29aa8bae8d8e) - 2023-01-07 by Tyr Chen) - Support table sequence and fix loading order by adding prefix ([85bb819](85bb819befd58cad549b347076cbcc7aec8629f3) - 2023-01-07 by Tyr Chen) - Improve normalize CLI to remove all sql files and retrieve them from server ([31a68c5](31a68c575ee30010b83cbfae362112e98484d34a) - 2023-01-07 by Tyr Chen) ### Refactor - Replace most of the macros with functions ([fb2a7f2](fb2a7f2fcc0c14120d48940ce455a14a88261854) - 2023-01-07 by Tyr Chen) - Deprecate SchemaSaver. Use DatabaseSchema directly. ([b8d2564](b8d2564d4423d3b058c8fac3a579485e7814ef7c) - 2023-01-07 by Tyr Chen) ## [0.2.7] - 2023-01-07 [9a36034](9a360344c11fe77eb0c0a07337bc8656b24c5526)...[4658050](4658050defc8020003f74da8ff90bb878d84bd15) ### Features - Support default constraint ([4658050](4658050defc8020003f74da8ff90bb878d84bd15) - 2023-01-07 by Tyr Chen) ## [0.2.6] - 2023-01-06 [67bb303](67bb303518436845dbac8ab4ad321665e14501d5)...[9a36034](9a360344c11fe77eb0c0a07337bc8656b24c5526) ### Miscellaneous Tasks - Improve help ([9a36034](9a360344c11fe77eb0c0a07337bc8656b24c5526) - 2023-01-06 by Tyr Chen) ## [0.2.5] - 2023-01-06 [e124a66](e124a6613894449aa9ccb1e7d9d94812925458f8)...[67bb303](67bb303518436845dbac8ab4ad321665e14501d5) ### Bug Fixes - Add test for schema_diff and fix schema_id issue ([f3a9754](f3a9754399f22b1b402fb4b35e6c6aefabac7585) - 2023-01-06 by Tyr Chen) ### Refactor - Rename subcommand `pg` to `schema`. ([67bb303](67bb303518436845dbac8ab4ad321665e14501d5) - 2023-01-06 by Tyr Chen) ## [0.2.4] - 2023-01-06 [31b4ffd](31b4ffd386ccdaa32e73bc636c6381ad7223e5e2)...[e124a66](e124a6613894449aa9ccb1e7d9d94812925458f8) ### Refactor - Deprecate schema_diff macro, use function instead ([e124a66](e124a6613894449aa9ccb1e7d9d94812925458f8) - 2023-01-06 by Tyr Chen) ## [0.2.3] - 2023-01-06 [c81aa65](c81aa65505e7b54bc2a022b9d83a8342e6d4dd22)...[31b4ffd](31b4ffd386ccdaa32e73bc636c6381ad7223e5e2) ### Features - Add `renovate pg fetch` and `renovate generate completion`. ([31b4ffd](31b4ffd386ccdaa32e73bc636c6381ad7223e5e2) - 2023-01-06 by Tyr Chen) ## [0.2.2] - 2023-01-06 [65d2e13](65d2e132651a89d262895a9dd6da20c5e9b08550)...[c81aa65](c81aa65505e7b54bc2a022b9d83a8342e6d4dd22) ### Features - Support `renovate pg apply` command ([c81aa65](c81aa65505e7b54bc2a022b9d83a8342e6d4dd22) - 2023-01-06 by Tyr Chen) ## [0.2.1] - 2023-01-06 [257f82f](257f82f497f117946372fb5af432b3ab7e347c86)...[65d2e13](65d2e132651a89d262895a9dd6da20c5e9b08550) ### Bug Fixes - Improve error message for `renovate pg init` ([65d2e13](65d2e132651a89d262895a9dd6da20c5e9b08550) - 2023-01-06 by Tyr Chen) ## [0.2.0] - 2023-01-06 ### Features - Working on column migration (not finished) ([c7ca57e](c7ca57e95d27e12c7b649a32d057e4af6f0633c9) - 2022-12-04 by Tyr Chen) - Add init cli for pg ([acbae1a](acbae1a7601f2775a4918a3ec1094cb6c66b0553) - 2023-01-05 by Tyr Chen) - Support `renovate pg plan` ([257f82f](257f82f497f117946372fb5af432b3ab7e347c86) - 2023-01-06 by Tyr Chen) ### Miscellaneous Tasks - Improve column migration ([9864470](98644701788d42f65b34088c2cc1406d76188028) - 2023-01-05 by Tyr Chen) - Add makefile, changelog and update deps ([1bc5e51](1bc5e51b4d89f373962294f248f8a95c3b82c9e5) - 2023-01-05 by Tyr Chen)