v7.3.2

What's Changed

• fix: await db.close() in runner by @remidewitte in #1160
• release: 7.3.2 by @Shinigami92 in #1161

New Contributors

• @remidewitte made their first contribution in #1160

Full Changelog: v7.3.1...v7.3.2

v7.3.1

What's Changed

• fix: use union type in addConstraint by @pigulla in #1155
• release: 7.3.1 by @Shinigami92 in #1158

New Contributors

• @pigulla made their first contribution in #1155

Full Changelog: v7.3.0...v7.3.1

v7.3.0

New & Noteworthy

• This version fixes the ESM output so it can be used correctly, thx to @remidewitte 🙏
• runner is now also exported as named-export
  this might become the default strategy for importing runner in a later major

What's Changed

• chore(deps): downgrade eslint to v8 by @Shinigami92 in #1144
• chore: normalize package.json repository.url by @Shinigami92 in #1149
• chore(deps): update dependency @types/pg to v8.11.6 by @renovate in #1151
• chore(deps): update vitest to v1.6.0 by @renovate in #1152
• chore(deps): lock file maintenance by @renovate in #1153
• fix: fix esm by @Shinigami92 in #1148
• fix: export runner as named for better esm usage by @Shinigami92 in #1156
• release: 7.3.0 by @Shinigami92 in #1157

Full Changelog: v7.2.2...v7.3.0

v7.2.2

New & Noteworthy

• Comments are now generated with correct table schema when passed to constraints, thx for the report by @osdiab

What's Changed

• fix: correctly pass table with schema when using comment by @Shinigami92 in #1139
• chore(deps): update typescript-eslint to v7.8.0 by @renovate in #1140
• chore(deps): update vitest to v1.5.3 by @renovate in #1141
• chore(deps): lock file maintenance by @renovate in #1142
• release: 7.2.2 by @Shinigami92 in #1143

Full Changelog: v7.2.1...v7.2.2

v7.2.1

New & Noteworthy

• Restored a previously unofficial behavior that is now officially integration-tested by @jraoult 🙏
• A HUGE thanks to @brenoepics for starting rewriting the documentation to VitePress 🚀
  He got also invited to the salsita/node-pg-migrate with write access, to help further with the documentation ❤️

What's Changed

• chore(deps): upgrade eslint to v9 by @Shinigami92 in #1123
• chore(deps): upgrade dotenv-expand to v11 by @Shinigami92 in #1124
• chore(deps): update vitest to v1.5.2 by @renovate in #1125
• ci: fix coverage workflow by @Shinigami92 in #1126
• refactor(utils): extract toArray by @Shinigami92 in #1127
• chore: reduce statement return type by @Shinigami92 in #1128
• refactor: unify codestyle by @Shinigami92 in #1129
• refactor: unify codestyle by @Shinigami92 in #1130
• refactor: configure eslint unicorn by @Shinigami92 in #1131
• chore(deps): update actions/checkout action to v4.1.4 by @renovate in #1133
• chore(deps): lock file maintenance by @renovate in #1134
• fix: restore support url as an object in configuration by @jraoult in #1119
• docs: refactor docs to use VitePress by @brenoepics in #1132
• chore(deps): lock file maintenance by @Shinigami92 in #1135
• release: 7.2.1 by @Shinigami92 in #1136

New Contributors

• @jraoult made their first contribution in #1119
• @brenoepics made their first contribution in #1132

Full Changelog: v7.2.0...v7.2.1

v7.2.0

New & Noteworthy

• The feature for create and drop casts landed 🚀 thx @aschrab 🙏

What's Changed

• feat(casts): support create and drop cast by @aschrab in #942
• ci: update cockroach by @Shinigami92 in #1114
• chore(deps): update all non-major dependencies by @renovate in #1115
• chore(deps): update typescript-eslint to v7.7.1 by @renovate in #1116
• chore(deps): update vitest to v1.5.1 by @renovate in #1117
• release: 7.2.0 by @Shinigami92 in #1118

Full Changelog: v7.1.0...v7.2.0

v7.1.0

New & Noteworthy

• One of the most awaited features (and 2 year stale PR) is now available: grant and revoke 🎉

What's Changed

• feat(grants): support grant and revoke for roles, tables and schemas by @littlewhywhat in #865
• chore(deps): update all non-major dependencies by @renovate in #1109
• chore(deps): lock file maintenance by @renovate in #1110
• docs: add note/link to changelog by @Shinigami92 in #1111
• release: 7.1.0 by @Shinigami92 in #1113

Full Changelog: v7.0.0...v7.1.0

v7.0.0

New & Noteworthy

The core maintainer of this project moved to @Shinigami92 (also core maintainer of FakerJS and core member of Vite).
The project is and remains under the MIT license.

This version is a mostly compatible to v6.2.2, but (should) supports ESM in addition to CJS 🎉
If you found any bugs while moving from version v6.2.2 to version v7.0.0, please open an issue and report what was broken for you.
If you need to contact me somehow directly, you can do so on Mastodon @[email protected]

I (@Shinigami92) worked hard the last 1.5 month on refactoring node-pg-migrate and I plan to convert the source code to ESM in the next major version. However I will need to drop support for Node <18 and TS <5 for that. So the next major version could potentially be released "quickly".
The code base is now stable to ship new features and fix more known bugs.

Here are the most important changes

• This release fixes some whitespace issues (dropColumns, createMaterializedView) as well as an invalid swapped operation type #1024.
• The minimum supported Node version is v16.18 and the minimum supported TypeScript version is 4.8 #998
• Migration.create does not accept the deprecated params anymore #1002
  if you did not ignored the runtime warning, you should not be affected by this
• The CLI is now TypeScript checked and therefore also got some slightly rework #1066
  hopefully nothing broke
• The internal createSchemalize function now uses options instead of two boolean args #1058
  You should mostly not be affected by this, expect from extreme programmatic use-cases
• utils got restructured #1053
  this should not have changed anything from the usage
• The src folder got a bit restructure, so you should only be affected by breaking changes if you use node-pg-migrate progammatically (not CLI)
• When using ts-node, tsconfig.json's 'ts-node' override is now respected (thx to @BriungRi)
• The plain JS template now generates with JSDoc so you get improved autosuggestions (thx to @codermarcos)
• Remove dependencies to mkdirp #1102 and decamilized #1099
• Add JSDoc to pgm methods #1104
• Refactored some base files (renamed migration-builder to migrationBuilder) and used node:* imports #1101
• Throw error when using string expression and try infer drop constraint #1094

What's Changed

• infra: add codeowners file by @Shinigami92 in #958
• infra: add semantic pr validation by @Shinigami92 in #960
• infra: switch to pnpm by @Shinigami92 in #962
• infra: add ci pipeline by @Shinigami92 in #961
• infra: update license file by @Shinigami92 in #963
• infra: reorder package.json by @Shinigami92 in #964
• infra: reconfigure renovate by @Shinigami92 in #965
• infra: rename master to main by @Shinigami92 in #966
• infra: unit test via github action by @Shinigami92 in #967
• infra: integration test via github action by @Shinigami92 in #968
• infra: add clean and preflight scripts by @Shinigami92 in #969
• infra: remove lint-staged by @Shinigami92 in #970
• infra: remove codeql by @Shinigami92 in #971
• infra: upgrade prettier by @Shinigami92 in #972
• infra: upgrade eslint by @Shinigami92 in #973
• chore: organize pack output by @Shinigami92 in #974
• feat: support esm by @Shinigami92 in #975
• chore: enable consistent-type-imports by @Shinigami92 in #976
• chore: enable prefer-includes by @Shinigami92 in #977
• chore: enable no-confusing-void-expression by @Shinigami92 in #978
• infra: add publish workflow by @Shinigami92 in #979
• release: 7.0.0-alpha.0 by @Shinigami92 in #980
• chore: enable no-unnecessary-boolean-literal-compare by @Shinigami92 in #981
• chore: enable no-unnecessary-type-assertion by @Shinigami92 in #982
• chore: enable no-unused-vars by @Shinigami92 in #983
• chore: enable prefer-promise-reject-errors by @Shinigami92 in #984
• chore: enable require-await by @Shinigami92 in #985
• chore: enable no-implied-eval by @Shinigami92 in #986
• chore: enable throw-literal by @Shinigami92 in #987
• infra: add issue templates by @Shinigami92 in #988
• chore(deps): update devdependencies by @renovate in #989
• fix(deps): update dependency yargs to ~17.7.0 by @renovate in #991
• fix(deps): mark dependency @types/pg as optional peer dependency by @Shinigami92 in #996
• infra: add ts-check by @Shinigami92 in #997
• chore!: set min node to v16.18 and typescript to v4.8 by @Shinigami92 in #998
• chore: use export type by @Shinigami92 in #999
• infra: set editor configs by @Shinigami92 in #1000
• chore: manual formatting by @Shinigami92 in #1001
• refactor!: remove deprecated create params by @Shinigami92 in #1002
• refactor: use ts for bin by @Shinigami92 in #1003
• infra: remove specific tsconfig by @Shinigami92 in #1004
• test: switch to vitest by @Shinigami92 in #1005
• test: add domains unit tests by @Shinigami92 in #1007
• chore(deps): update dependency json5 to v2.2.3 by @Shinigami92 in #1008
• test: add extensions unit tests by @Shinigami92 in #1009
• test: indent domains tests by @Shinigami92 in #1010
• test: add functions unit tests by @Shinigami92 in #1011
• test: add indexes unit tests by @Shinigami92 in #1012
• infra: enable quotes by @Shinigami92 in #1013
• infra: add vitest coverage report by @Shinigami92 in #1015
• infra: use slugify-value by @Shinigami92 in #1016
• infra: use matrix.branch in report by @Shinigami92 in #1017
• infra: try sha for coverage by @Shinigami92 in #1018
• infra: try run-id for coverage by @Shinigami92 in #1019
• infra: file-coverage-mode all by @Shinigami92 in #1020
• test: add operators unit tests by @Shinigami92 in #1022
• test: add sql unit tests by @Shinigami92 in #1025
• test: add policies unit tests by @Shinigami92 in #1026
• chore(deps): update typescript-eslint to v7.1.1 by @renovate in #1028
• chore(deps): update dependency @types/node to v18.19.22 by @renovate in #1027
• chore(deps): lock file maintenance by @renovate in #995
• test: add roles unit tests by @Shinigami92 in https://github.com/salsita/node-...

v7.0.0-alpha.4

New & Noteworthy

• Remove dependencies to mkdirp #1102 and decamilized #1099
• Add JSDoc to pgm methods #1104
• Refactored some base files (renamed migration-builder to migrationBuilder) and used node:* imports #1101
• Throw error when using string expression and try infer drop constraint #1094

What's Changed

• chore(deps): update all non-major dependencies by @renovate in #1092
• chore(deps): update vitest to v1.5.0 by @renovate in #1093
• chore(deps): lock file maintenance by @renovate in #1071
• fix(constraint)!: throw error on string expression by @Shinigami92 in #1094
• chore(deps): update pnpm to v9 by @renovate in #1096
• chore(deps): update typescript-eslint to v7.7.0 by @renovate in #1097
• chore(deps): lock file maintenance by @renovate in #1098
• chore: add Reversible type by @Shinigami92 in #1095
• refactor(deps): inline decamelize dependency by @Shinigami92 in #1099
• chore(deps): update pnpm to v9.0.2 by @renovate in #1100
• refactor!: refactor base files by @Shinigami92 in #1101
• refactor: use native mkdir recursive by @Shinigami92 in #1102
• docs: update README.md by @Shinigami92 in #1103
• docs: add JSDoc for pgm by @Shinigami92 in #1104
• infra: configure package-manager-strict by @Shinigami92 in #1105
• release: 7.0.0-alpha.4 by @Shinigami92 in #1106

Full Changelog: v7.0.0-alpha.3...v7.0.0-alpha.4

v7.0.0-alpha.3

New & Noteworthy

• The src folder got a bit restructure, so you should only be affected by breaking changes if you use node-pg-migrate progammatically (not CLI)
• When using ts-node, tsconfig.json's 'ts-node' override is now respected (thx to @BriungRi)
• The plain JS template now generates with JSDoc so you get improved autosuggestions (thx to @codermarcos)

What's Changed

• docs(cli): document all possible migration languages by @daniel-digital-innovation in #953
• docs(template): add JSDoc to js migration template by @codermarcos in #1068
• chore(deps): update pnpm to v8.15.6 by @renovate in #1069
• chore(deps): update devdependencies by @renovate in #1070
• chore(deps): update typescript-eslint to v7.5.0 by @renovate in #1048
• refactor(domains): reorganize operations domains by @Shinigami92 in #1072
• refactor(extensions): reorganize operations extensions by @Shinigami92 in #1073
• refactor(functions): reorganize operations functions by @Shinigami92 in #1074
• refactor(indexes): reorganize operations indexes by @Shinigami92 in #1075
• refactor(policies): reorganize operations policies by @Shinigami92 in #1076
• refactor(operators): reorganize operations operators by @Shinigami92 in #1077
• refactor(sql): reorganize operations sql by @Shinigami92 in #1078
• refactor(roles): reorganize operations roles by @Shinigami92 in #1079
• refactor(schemas): reorganize operations schemas by @Shinigami92 in #1080
• refactor(sequences): reorganize operations sequences by @Shinigami92 in #1081
• refactor(tables): reorganize operations tables by @Shinigami92 in #1082
• refactor(triggers): reorganize operations triggers by @Shinigami92 in #1083
• refactor(types): reorganize operations types by @Shinigami92 in #1084
• refactor(views): reorganize operations views by @Shinigami92 in #1085
• refactor(mViews): reorganize operations materialized views by @Shinigami92 in #1086
• refactor(pgLiteral): reorganize utils PgLiteral by @Shinigami92 in #1087
• feat: accept ts-node tsconfig overrides by @BriungRi in #929
• chore(deps): update typescript-eslint to v7.6.0 by @renovate in #1089
• chore(deps): update devdependencies by @renovate in #1088
• release: 7.0.0-alpha.3 by @Shinigami92 in #1090

New Contributors

• @daniel-digital-innovation made their first contribution in #953
• @codermarcos made their first contribution in #1068
• @BriungRi made their first contribution in #929

Full Changelog: v7.0.0-alpha.2...v7.0.0-alpha.3