rollback_one_database #47

	# This is a basic workflow to help you get started with Actions

	name: rollback_one_database

	# Controls when the action will run. Triggers the workflow on push or pull request
	# events but only for the main branch
	on:
	workflow_dispatch:
	# push:
	# branches: [ main ]
	# pull_request:
	# branches: [ main ]
	inputs:
	tag:
	description: 'Enter tag to rollback'
	required: true
	db:
	description: 'Database to rollback (DEV, TEST, PROD)'
	required: true

	env:
	LIQUIBASE_PRO_LICENSE_KEY: ${{ secrets.LIQUIBASE_PRO_LICENSE_KEY }}
	LIQUIBASE_COMMAND_URL: ${{ secrets.LIQUIBASE_COMMAND_URL }}
	LIQUIBASE_COMMAND_USERNAME: ${{ secrets.LIQUIBASE_COMMAND_USERNAME }}
	LIQUIBASE_COMMAND_PASSWORD: ${{ secrets.LIQUIBASE_COMMAND_PASSWORD }}
	LIQUIBASE_COMMAND_CHANGELOG_FILE: ${{ secrets.LIQUIBASE_COMMAND_CHANGELOG_FILE }}
	LIQUIBASE_COMMAND_TAG: ${{ github.event.inputs.tag }}
	DB_ENV: ${{ github.event.inputs.db }}

	jobs:

	Rollback_Job:
	runs-on: ubuntu-latest
	environment:
	name: ${{ github.event.inputs.db }}

	steps:
	- uses: actions/checkout@v3
	with:
	token: ${{ secrets.LB_GH_TOKEN }}

	- name: Rolling back changes
	uses: docker://liquibase/liquibase
	with:
	args: rollback

	- name: Running history command
	uses: docker://liquibase/liquibase
	with:
	args: liquibase history

	- name: Copy Snapshot back
	run: \|
	cp -r BASE/Snapshot*_${{ github.event.inputs.db }}.json .
	git config user.name github-actions
	git config user.email [email protected]
	git add .
	git commit -m "Restore snapshotfile"
	git push

Provide feedback