Feature request: Create update-reference command

[TymofiiKritsak]

Search first

• I searched and no similar issues were found

Description

Feature request

Similar to snapshot-reference command, it will be useful to have update-reference command to deploy to the reference database connection.

Having this command will remove the need of modifying --url, --username, --password values to match the reference database connection values in order to deploy to reference db.

Commands to consider:
update-reference
update-reference-sql
update-reference-count
update-reference-count-sql
update-reference-one-changeset
update-reference-one-changeset-sql
update-reference-sql
update-reference-testing-rollback
update-reference-to-tag
update-reference-to-tag-sql

OR, these can be named vise-versa:
reference-update
reference-update-sql
reference-update-count
reference-update-count-sql
reference-update-one-changeset
reference-update-one-changeset-sql
reference-update-sql
reference-update-testing-rollback
reference-update-to-tag
reference-update-to-tag-sql

Steps To Reproduce

Setup

• GIVEN I have the liquibase.properties configured with both target and reference databases:

url: jdbc:postgresql://localhost:5433/mydb
username: user
password: password

referenceUrl: jdbc:postgresql://localhost:5434/mydb
referenceUsername: user
referencePassword: password

• WHEN I want to deploy changes to the reference database
• THEN I need to modify the --url, --username, --password to match reference values in order to deploy to reference database

Expected/Desired Behavior

Desired Behavior

Since I already have the reference database configuration in place (liquibase.properties), I want to run update-reference command to deploy chages to the reference connection.

Liquibase Version

4.20

Database Vendor & Version

ALL

Liquibase Integration

NONE

Liquibase Extensions

NONE

OS and/or Infrastructure Type/Provider

ALL

Additional Context

No response

Are you willing to submit a PR?

• I'm willing to submit a PR (Thank you!)

[nvoxland]

An alternative to creating all the duplicate commands would be to have an additional parameter like --connection=[standard|reference] or something that gets added to the existing commands and controls whether the --url etc arguments or the --reference-url etc arguments get used.