Updating `oclif` and adding unit tests

[jackall3n]

Hey @rap2hpoutre,

I've upgraded oclif to the latest version, now using @oclif/core which has better type safety and error handling. In addition to this I've added in unit tests (as it was listed as an enhancement #15).

pg-anonymizer changes

• --list has been renamed to --columns (-c) as it feels more obvious. I've added --list (-l) as an alias with a deprecation warning so that people can still use it if they want.
• --configFile has changed to --config as it was the only argument written as camelcase. I've added --configFile as an alias with a deprecation warning as well.
• --extension has changed to --transformer as I've created a new format that users are able to do to transform columns (and entire rows! #39). I've added --extension as an alias with a deprecation warning as well.
• --pgDumpOutputMemory has an official deprecated warning now.
• --verbose has been added which logs extra information out for debugging.
• --silent has been added to remove silence all logging from the cli
• When -o/--output is set to -, logs are prepended with -- so that the output can be treated as .sql and piped into other commands.

Error handling with CLIError

CLIError from @oclif/errors has been introduced to improve error handling in following scenarios:

• When the cli cannot find an --transformer file: --transformer ~/something/not/real
• When a replacement transformer referenced is not a function: --columns name:transformer.notAFunction
• When a faker replacement has been specified that does not exist: --columns name:faker.not.real
• When pg_dump returns an error.

Testing

Tests have been added using @oclif/test. They run against a local database referenced in the DATABASE_URL environment variable.

I've added prisma to the project. I've set it up to create the database schema and seed the database with values to test against. I've created a .github/workflows/test.yml that runs postgres, configures the database using yarn db:setup and runs yarn test.

At the moment the tests cover:

• --columns (with and without replacements)
• --skip
• --preserve-null
• --silent
• --output (partially)
• PGARGS

[jackall3n]

Solves #15 #16 #39 #43

[jackall3n]

Hey @rap2hpoutre, what are your thoughts on this?

[jackall3n]

@rap2hpoutre I've added another --silent option as it'll help with the output to stdout (-o -)

[jackall3n]

@rap2hpoutre If you get a chance to review this that would be great. If I don't hear from you in the next day or so, I'll just release this to a new package

[rap2hpoutre]

Thank you so much for your contribution 🎉 and sorry for the super late answer. I just reviewed it, I accept all your changes, and I will release it soon! (I have to remember how to release this package though !)

[github-actions[bot]]

:tada: This PR is included in version 0.8.0 :tada:

The release is available on:

• npm package (@latest dist-tag)
• GitHub release

Your semantic-release bot :package::rocket: