Reveal and document pgm.enableReverseMode()

[osdiab]

Internally, this library appears to use an enableReverseMode() function to reverse the commands of a migration when inferring a down() migration.

At my company when we revert a change we want to just make a new migration that does the inverse of what a reverted migration does. For migrations with a down() migration, this is easy - just call it in the up() migration.

But for migrations where it is inferred, it is not obvious how you would call the automatic down() migration for a given up() migration. But! Internally this library's enableReverseMode() function would do the trick, just call it first before calling the up() migration.

But, the TypeScript interface doesn't say it exists, nor is it mentioned in the docs. But I'm pretty sure this should generally work.

So my suggestion is to not hide this and actually make it be a documented part of this library. Even further, it would potentially make sense to even have a CLI command to generate a "revert" migration for a given migration.

[lorefnon]

@osdiab You can consider using @lorefnon/ts-pg-migrate where I have exposed this. I maintain that fork because I needed some features from a few PRs here that haven't received any attention in many months.

It is backward compatible - nothing other than package name needs to be changed.

[Shinigami92]

@lorefnon do you still have the fork? Would you like to work with me together on node-pg-migrate? I got repo-admin rights (not org-admin).

---

Beside that, I need to have a look into what enableReverseMode is actually doing, and/or if this is outdated.

[lorefnon]

Hi yeah, good to see this repo maintained once more.

I have a few minor features in my fork. I use this in production. I'll send separate PRs for them over the next few days.